Currency Translation in the Update (SAP Library

Currency Translation in the Update

Use

Currency translation in the update provides the option of translating data records from the source currency of the InfoSource into a target currency in the data target. If the currency of the data records to be transferred is the same as the currency of the target key figure/data field of the InfoCube/ODS object, then no currency translation has to take place.

The currency translation in the update usually takes place using translation types previously defined in the Administrator Workbench. It can take place using user-defined subprograms (formulas and routines), if necessary. For ODS objects it is currently not possible to execute the currency translation by using predefined translation keys. Instead, you have to revert to routines.

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

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

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

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

An InfoObject is referred to with a variable currency (in this case, ODOC_CURRCY, for example).

See also:

Creating InfoObjects: Key Figures

Functions

With the update of key figures, there are basically two different cases:

For every key figure of an InfoCube (target key figure) there is a corresponding key figure in the InfoSource (source key figure). No currency translation takes place.
There is no corresponding source key figure in the InfoSource for the target key figure of the InfoCube.

A source key figure of the same type can be assigned to the target key figure (for example, sales revenue instead of sales quantity revenue).

If the currencies of both of the key figures are the same, then no currency translation takes place.
If the currencies are different, then a translation can take place either using a currency translation type or by the simple assignment of a currency.

The following table provides an overview of possible combinations with different currencies in the source and target key figures:

Source key figure currency	Target key figure currency	Currency translation (CT)
fix	variable	No CT
fix	fix	CT
variable	fix	CT
variable	variable	CT possible, but also simple assignment

If there is no corresponding source key figure of the same type, then you have to fill the key figure for the InfoCube from a routine.

If the target key figure has a fixed currency, then no currency translation is carried out. This means that you have to execute a required translation where necessary in the routine.

If the target key figure has a variable currency, you have to also assign a variable source currency to the routine. Using the F4 Help, you can select a currency from the variable currencies in the communication structure. You then have two options:

– You can assign the selected variable currency

– You select a currency translation type and a currency, into which you wish to translate (‘To’ currency)

The ‘To’ currency is, by default, the target currency if it appears in the communication structure.

See also:

Currency Translation Type