Defining Source Filter Options for SAP Cost Center Source System

Before executing a data load rule using a SAP source adapter, you are required to have generated the Import Format’s ODI Scenario. Once 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:

  1. In Activity Type, select Yes to load activity type quantities, or No to load monetary balances.

    When the Activity Type is set to YES, the Currency Type should be set to blank and Quantity should be set to NO.

  2. Select the Amount Type.

    Specify PTD for Period to Date, or YTD for Year to Date balances.

  3. Select the Controlling Area.

    Specify the controlling area in four characters or less using alphanumeric characters.

  4. Select the Currency Type.

    Specify 20 for the Controlling Area currency, 00 for Transaction currency, or 90 for Cost Center currency.

  5. In Flow Check, specify External to load external balances, or Internal to load internal allocations.

    When Flow Check is set to EXTERNAL , the Activity Type and Quantity parameters should be set to NO.

  6. 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 as follow:

    • “0101” for cost Center Group

    • “0102” for Account group

    • blank if no grouping is required

    If the Flow Check is set to “INTERNAL”, then valid group codes are as follows:

    • “0101” for Cost Center Group

    • “0102” for Account Group

    • “0104” for Statistical Key Figure Group

    • “0105” for Activity Type Group

  7. In Include Cost Element Description, select Yes to include the cost element description. Otherwise, select No.

  8. Select the Language.

    Specify the language in two characters or less, using uppercase characters. For example, specify “EN” for English.

  9. Select the Ledger.

    Specify the ledger in two characters or less using alphanumeric characters. For example, you might enter 8A in this field.

  10. Select the Quantity

    Specify “Yes” or “No”. If this value is set to “Yes”, then the Currency Type is set to blank. For all other conditions, set this value to “No”.

  11. In Value Type, select the type of value.

    Planned values can be taken from the COSP table if the value type is set to ‘1’. Actual values can be taken from the COSP table if the value type is set to ‘4’.

  12. Click Save.