Defining Source Filter Options for SAP GL Adapter (For Release 11.1.2.3)

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 GL adapter:

  1. On the Workflow tab, under Data Load, select Data Load Rule.

  2. In Data Load Rule, select a data load rule or click Add.

  3. Select the Source Options tab.

  4. Specify the Amount Type.

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

  5. Specify the Company Code.

    Specify the company code in four characters or less using alphanumeric characters.

  6. Specify the Currency Type.

    Select 00 for transaction currency, 10 for the company code currency, 30 for group currency, 40 for hard currency, 50 for index based currency, and 60 for Global Company currency).

  7. Select the Include Account Description option.

    Select Yes to include the GL Account description. Select No for all other conditions.

  8. Specify the Language.

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

    Refer to the SAP documentation for the language code.

  9. Specify the Ledger.

    Specify the ledger in two characters or less using alphanumeric characters.

  10. Specify the Record Type.

    Specify 0 for Actual, or 1 for Plan.

  11. Click Save.