Currency Translation 

Use

You use the Currency Translation function type to convert currencies of key figures into other key figures.

In the Key Figures and Currency Translation Types table, you can specify multiple translations. For each translation, you have to select a currency translation type as well as a source and target key figure. The value in the target key figure is overwritten. This also applies when the source key figure is empty. The value of the source key figure is not changed during currency translation. In this way the function can be executed more than once without the results changing. There is a special logic to ensure that this is the case when the source key figure and target figure are identical and the source unit of the data record is used: If there is already a value in the target unit, it is ignored if there are values in the source unit that do not have the target unit. Otherwise the value in the target unit is used.

The currency translation converts the key figure Amount with the source currency in the data record into the fixed target currency EURO. The key date 01.01.2001 was selected as time reference. There are two data records for different companies. Company 4711 is planned in CHF. Company 0815 is already planned in EUR.

Values before the conversion

Amount	Currency Key	Company
10	CHF	4711
4	EUR	0815

Values after the conversion

Amount	Currency Key	Company
10	CHF	4711
6.3	EUR	4711
4	EUR	0815

A new data record is created.

Manual change of the value in Euro

Amount	Currency Key	Company
10	CHF	4711
6	EUR	4711
9	EUR	0815

Repeated execution of the planning function

Amount	Currency Key	Company
10	CHF	4711
6.3	EUR	4711
9	EUR	0815

The value for company 4711 is overwritten by the currency translation.

Within the planning functions, some of the time references of the currency translation types are not supported. Selection upon Translation and Query Key Date are not supported. You can use variables in place of these time references. You can use the variable 0PLANDAT for the query key date. If you want to enter the date when you execute the planning function, use the input variable.

The changed characteristics can be those characteristics that contain the currency key. By default, all the characteristics that contain the currency key are selected. You can usually use this setting.

Note of the following remarks about modeling:

If you want to enter plan data in different currencies, you can use key figures with their own fields for the currency key for each purpose. Examples for such purposes are Entry of Original Amounts in Company Currency and Consolidation of Amounts in Group Currency. With characteristic relationships you can make sure that only one suitable currency key can be entered for a company. The aggregation levels can be easily modeled so that you work with different sets of data for each purpose. 

Only those key figures that are used are included in the aggregation level. If you use a key figure for different purposes, you must define the data with selections in filters.