Currency Translation During Transformation 

Use

Currency translation during the transformation enables you to convert data records from the source currency into a currency of the target of the transformation.

Currency translation in the transformation is generally performed using previously defined translation types. For more information, see Currency Translation Types.

Where required, you can perform currency translation with user-defined subprograms (formulas and routines). It is not currently possible to execute currency translation for DataStore objects using predefined translation types. You have to use routines instead.

Depending on the type of currency, there are two different types of key figures:

...

       1.      Key figures with a fixed currency (for example, DEM, USD)

With a fixed currency, the currency is fixed for the amount. The key figure refers specifically to the currency (for example DM, US$), so the currency does not have to be entered again in the data record.

       2.      Key figures with a variable currency (for example, foreign currency).

With a variable currency, the currency is determined by an InfoObject, (ODOC_CURRCY) for example.

For more information, see Creating InfoObjects: Key Figures.

Features

Transformations can be performed for key figures in two ways:

...

       1.      Every key figure in an InfoCube (target key figure) has a corresponding key figure in the source (source key figure). No currency translation takes place.

       2.      There is no corresponding source key figure in the InfoSource for the target key figure in the InfoCube.

                            a.      You can assign a source key figure of the same type to the target key figure (sales revenue instead of sales quantity revenue, for example).

§         If the currencies of both of the key figures are the same, no currency translation can take place.

§         If the currencies are different, a translation can take place either using a currency translation type or by simply assigning a currency.

The following table provides an overview of possible combinations where the currency is not the same in the source and target key figures:

Source key figure currency	Target key figure currency	Currency translation (CT)
fixed	variable	No CT
fixed	fixed	CT
variable	fixed	CT
variable	variable	CT or assignment possible

 

                            b.      If there is no corresponding source key figure of the same type, you have to fill the key figure of the target using a routine.

§         If the currency of the target key figure is fixed, currency translation is not performed. This means that if translation is required, you have to execute it in a routine.

§         If the currency of the target key figure is variable, you also have to assign a variable source currency to the routine. You can use input help to select a currency from the variable currencies that exist for the target. You have two options:

·         You can select a variable currency and assign it.

·         You can select a currency translation type and a currency into which you wish to translate (‘to’ currency).

By default, the ‘to’ currency is the target currency if it is included in the target.

Creating a routine for currency translation:

If you want to translate currencies during the transformation but currency translation is not available for one of the reasons stated above, you can create a routine. In transformation rule definition, choose Routine with Unit. You get an additional return parameter UNIT in the routine editor and the target currency is determined using the value of this parameter.

For more information, see Routines in Transformations.