Skip to main content

Celonis Product Documentation

1.6 Currency Conversion

The Accounts Receivable App makes use of the SAP Currency Conversion feature. This feature allows you to define the ‘target currency’ in which the app is displayed by making use of Celonis' run-time variables. The benefit to this feature is that you can provide all regions of your business with their local currency, while only having to process the data model once.

In order to configure this conversion correctly in the data pool, you need to do the following:

  1. Ensure that you have defined the following data pool parameters:

    1. exchangeRateType

      This parameter should store the exchange rate type that you use for currency conversion. Typically this value is “M”, but in some cases it is “EURX”.

    2. currency

      This parameter stores the currency into which you are converting your data during the data transformations.

    Note

    You will still need to define the package variables in the app set up. Specifically, the package variable ‘group-currency’ must be equal to the data pool parameter ‘currency’ and the package variable ‘exchange-rate-type’ must be equal to 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 these new 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 using the names: TCURR, TCURX and TCURF.