You can create a synchronization task to read data from multiple SAP objects and write the data to a flat file object.
You can read General Ledger Accounting line items from the BKPF and BSEG tables in SAP. BSEG is an SAP Cluster table that is used to store Accounting Document Segment information. BKPF is a Transparent SAP Table that is used to store Accounting Document Header information. In this example, you can join the BKPF and BSEG tables and map the source object to a flat file target object.
In this example to write the accounting document details to a flat file object, perform the following steps:
1Define the synchronization task.
2To configure the SAP Table sources, select an SAP Table connection, and select the BKPF transparent table and the BSEG cluster table as the source objects. Create join conditions between the source BKPF table and the related BSEG table.
3To configure a flat file target for the task, select a flat file connection and specify a flat file object.
4Configure the field mappings to define the data that the synchronization task writes to the target.
5Save and run the synchronization task.
Step 1: Define the synchronization task
1To create a synchronization task, click Data Integration > New > Tasks. Select Synchronization Task and click Create.
2Enter a name for the synchronization task.
3Enter a description for the synchronization task.
4Select the insert task operation for the target.
The following image shows the task definition page:
5Click Next.
Step 2: Configure the SAP Table source
1Select an SAP Table connection.
2Select Multipleas the source type.
3Click Add to specify the SAP source object.
The Select Source Object dialog box appears. Select the BKPF transparent table.
4Click Select.
5Click Add to select the BSEG cluster table.
The following image shows the Select Source Object dialog box:
6 Create relationships between the SAP tables.
aSelect the BKPF SAP object and click Create Relationshipto create the join conditions between the source BKPF table and the related BSEG table.
The Create Relationship dialog box appears.
bSpecify the key field in the source SAP object, the type of join, the join operator, the related SAP object, and the key field in the related object.
cClick OK to create the relationship.
dRepeat the previous steps to create multiple relationships.
The following image shows the Create Relationship dialog box:
7Select a source object to preview the data. The Data Preview area displays the first 10 rows of the first five columns in the SAP object. You can also view the total number of columns in the object. To preview all source columns in a file, click Preview All Columns.
8To display technical names instead of business names, select Display technical field names instead of labels.
9To display source fields in alphabetic order, click Display source fields in alphabetical order.
By default, fields appear in the order returned by the source system.
The following image shows the join conditions for multiple SAP objects in the task source details page:
10Click Next.
Step 3: Configure the flat file target
1Select a flat file connection and select a flat file object.
2Select a target flat file object and click OK.
The following image shows a flat file object in the task target details page:
3Click Next to specify any data filters or sort fields.
4Click Next.
Step 4: Configure the field mapping
1Map the source and target fields.
You can select all source objects or one of the source objects to map with the target fields.
2Click Next to configure a schedule and advanced options.
