Before executing a data load rule using a SAP source adapter, you are required to have generated the Import Format’s ODI Scenario. When the ODI Scenario exists in the Execution Repository, you can execute the data load rule any number of times.
To define the source filter options for a SAP source adapter:
On the Workflow tab, under Data Load, select Data Load Rule.
When the Activity Type is set to YES, the Currency Type should be set to blank, and Quantity should be set to NO.
Specify the Activity Type Description.
Specify YES to include the activity type description. Otherwise, specify “NO”.
Specify PTD for Period to Date, or YTD for Year to Date balances.
Specify the controlling area in four characters or less using alphanumeric characters.
Specify 20 for the Controlling Area currency, 00 for Transaction currency, or 90 for Cost Center currency.
Leave the field blank when the Quantity filter is Yes or the Activity Type filter is Yes.
In Flow Check, specify External to load external balances, or Internal to load internal allocations.
In Group Code, select the applicable group code based on the Flow Check value.
If the Flow Check is set to “EXTERNAL,” then valid group codes are:
“0101” for cost Center Group
“0102” for Account group
If the Flow Check is set to “INTERNAL,” then valid group codes are:
“0101” for Cost Center Group
“0102” for Account Group
“0104” for Statistical Key Figure Group
“0105” for Activity Type Group
If no grouping is required, set to blank.
In Include Cost Element Description, select Yes to include the cost element description. Otherwise, select No.
Specify the language in two characters or less, using uppercase characters. For example, specify “EN” for English.
Specify the ledger in two characters or less using alphanumeric characters. For example, enter 8A in this field.
Specify Yes or No. If this value is set to “Yes,” then the Currency Type is blank. For all other conditions, set this value to “No.”
In Value Type, select the type of value.
Specify 04 for Actual, or 01 for Plan.