Skip to main content

Celonis Product Documentation

Currency Conversion Tables

The Accounts Receivable App makes use of the SAP Currency Conversion feature. This allows you to define the ‘target currency’ that the app should be displayed in on the fly inside of the app by making use of the Run-time variables. The power here is that you can provide all regions of your business with their local currency whilst only having to process this in the data model once.

To configure this correctly in the data pool, you will need to do the following:

  1. Ensure that you have defined these data pool parameters:

    1. exchangeRateType

      This parameter should store the exchange rate type that you use for currency conversion. Most of the time the value “M” or in some cases it’s “EURX”.

    2. currency

      This parameter should store the target currency that you wish to convert to in the data transformations. Note: you will still need to define the package variables in the app setup. Specifically, the package variable ‘group-currency’ should equal the data pool parameter ‘currency’, and the package variable ‘exchange-rate-type’ should equal the data pool parameter ‘exchangeRateType’.

  2. Create the currency tables TCURR_CC, TCURF_CC, and TCURX in the local data job/s (already provided by default in the jobs)

  3. Create views of the currency tables (TCURR_CC, TCURF_CC and TCURX) in the Global AR jobs (already provided by default)

    1. If you used multiple source systems in your local jobs, you should also union the tables together and add a source system ID, as explained in Multiple SAP Source Systems.

  4. Ensure that the three global views are available in the data model, with the aliases defined such that they’re named: TCURR, TCURX, and TCURF