Before you create a processing mapping, start the listener workflow. When you create the processing mapping, you can send a test request file to SAP. For SAP to return data to the PowerCenter Integration Service, the listener workflow must be running.
Create processing mappings in the same development folder that you created in Step 2. Import and Configure PowerCenter Objects. The relational target definitions created when you create a processing mapping use a default database type that may not match the database type. If you use the Designer to change the database type once in the development folder, you can copy processing mappings with relational target definitions to multiple production folders without having to change the database type again.
Complete the following steps to create a processing mapping:
Connect to SAP and select a DataSource.
Use Step 1 of the Generate Mapping for BCI Wizard to connect to SAP and select a DataSource.
Select a transfer mode and activate the ABAP program in SAP.
Use Step 2 of the wizard to select a transfer mode and activate the ABAP extraction program in SAP.
Configure the request file and data extraction parameters.
Use Step 3 of the wizard to create, revert, or test the request file and select data extraction parameters.
Name and generate the processing mapping.
Use Step 4 of the wizard to name, describe, and generate the processing mapping.
Override the SQL query in the Source Qualifier
. If you use Oracle or IBM DB2 and the DataSource is not a hierarchy, update the SQL query in the Source Qualifier.
After you create the processing mapping, create the relational tables for the relational target definitions.