Retrieving data from a data connection by using a mapped expression

Retrieving data from a database by using mapped keys
A mapped key is used to retrieve one or more rows from a data connection for a business object field, based on the value of one or more defined mapped keys. The event runtime generates the appropriate SQL based on defined mapped keys and selected non-mapped key fields. A business object instance is created for each retrieved row.

Retrieving data from a data connection by using a mapped condition
A mapped condition is used to retrieve one or more rows from a data connection for a business object field, based on explicit SQL syntax used as a condition. The condition is any part of an SQL statement that is found to the right of the FROM clause. The condition is typically a WHERE clause and can contain any valid SQL syntax, including GROUP BY, HAVING, and sub-queries.

Retrieving data from a data connection by using a mapped query
A mapped query is used to retrieve one or more rows from a data connection for a business object field, based on a complete SQL SELECT query or stored procedure call.

Creating mappings from tables in the Outline view
You can create a business object by using a database table that is displayed in the Outline view as a model. The new business object has a field mapped to each column in the database table and can also be used to retrieve data from the database.

Changing field mappings and mapping groups
When you have defined your database mappings, you might want to add more fields to the mapping group, edit a field within a mapping group, edit a mapping group expression, change the enrichment type for the mapping group, or remove a field from a mapping group.

Retrieving data from a data connection by using a mapped expression

About this task