1To create a mapping, click Data Integration > New > Mappings. Select Mapping and click Create.
2Enter a name and description for the mapping, and click OK.
You can use alphanumeric characters and underscores (_) in the mapping name.
3To configure a source, on the Transformation palette, click Source.
4In the Properties panel, on the General tab, enter a name and description.
5Click the Source tab and configure source details.
6Specify the source type. You can choose one of the following options:
- - Select Single Object to select a single SAP object.
- - Select Parameter to configure the source objects in a mapping task associated with this mapping.
7Click Query Options in the Source tab to specify any filter for the SAP ADSO object.
8Click Advanced to specify the advanced source properties.
Note: You cannot add or remove source fields or edit the field metadata.
9To add a transformation, on the Transformation palette, click the transformation name. Or, drag the transformation onto the mapping canvas.
- aOn the General tab, you can enter a name and description for the transformation.
- bDraw a link to connect the previous transformation to the transformation.
When you link transformations, the downstream transformation inherits the incoming fields from the previous transformation.
For a Joiner transformation, draw a master link and a detail link.
- cTo preview fields, configure the field rules, or rename fields, click Incoming Fields.
- dConfigure additional transformation properties, as needed.
The properties that you configure vary based on the type of transformation you create.
- eTo add another transformation, repeat these steps.
10To add an ODSO object to the Target transformation, on the Transformation palette, click Target.
- aOn the General tab, you can enter a name and description.
- bDraw a link to connect the previous transformation to the Target transformation.
- cClick the Target tab, configure the target details. Specify the target type:
- ▪ Select Single Object to select an ADSO object.
- ▪ Select Parameter to configure the target objects in a mapping task associated with this mapping.
- ▪ Select Operation as Insert.
- ▪ Click Advanced and specify the advanced target properties.
- dClick Field Mapping and map the fields that you want to write to the target.
- eTo add another Target transformation, repeat these steps.
11Click the Field Mapping to map the Source and Target fields.
You can use the Automatic option if the fields are similar between the source and target.
12Save and run the mapping or save and create a mapping task.