Currency Translation in the Update 

Use

Currency translation in the update allows you to translate data records from the source currency of the InfoSource into a target currency in the data target. This function is only available if key figures with currency fields exist in the source system in various currencies. Currency translation is not available if the currency of the data records to be transferred is the same as the currency of the target key figure in the InfoCube.

Currency translation in the update is normally performed using previously defined translation types. See also Currency Translation Types

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 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).

A variable currency refers to an InfoObject (for example, ODOC_CURRCY).

See also:

Creating InfoObjects: Key Figures

Features

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

...

       1.      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.

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

...

                            a.      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, 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 with different currencies 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, then you have to fill the key figure for the data target from a routine.

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

§         If the target key figure has a variable currency, you also have to 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 have two options:

–    You can select a variable currency and assign it.

–    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 is included in the communication structure.

Creating a Routine for Currency Translation:

If you want to translate currencies in the update even though the currency translation is not available for one of the above reasons, you can create a routine. Choose Routine, set the Unit Calculation in the Routine and choose  Create Routine. In the routine editor you get the additional return parameter UNIT, the value of which is used to determine the target currency.

See also:

Currency Translation