To make a new attribute-to-field mapping

  1. Go to Data Sources.
  2. Right-click on the data source and select Mappings.
  3. Double-click on a business object mapping.

    The Attributes to Fields window appears.

  4. Click Add.
  5. Select a business object set from the Set drop-down list. If you wish to map to an attribute from the primary set, then select the <main> entry.
  6. From the Attribute drop-down list, select the name of the attribute you want to map. This drop-down list includes all of the attributes available for your selected Set.
  7. Select a database table or join from the Table/Join drop-down list. Joins are identified as follows:

    JoinedTable1(Alias1):NestedJoin1(Alias2):NestedJoin2(Alias3):...

    Beyond this naming convention, you will map fields from joins exactly as though they were actual tables in the database.

  8. From the Field drop-down list, select the name of the field you want to map. This drop-down list includes all of the attributes available for the table or join you selected for Table.
  9. Click OK.