Ansicht
Dokumentation

SIMG_CFMENUOLPSCJEC - Define Currency Translation Keys

PERFORM Short Reference   Addresses (Business Address Services)  
This documentation is copyright by SAP AG.

When you execute a drilldown report, you can display value columns in another currency using the function Settings -> Currency. In this step, you maintain the currency translation keys to be used for translating currency columns. These translation keys are valid for all operating concerns and therefore can be used for all reports in Profitability Analysis.

Define your currency translation keys by carrying out the following:

1. Enter a descriptive text.
2. Specify the exchange rate type (historic rate, average rate, and so on).
3. Specify whether the target currency should be fixed or variable.

Your choice will influence the next screen in the following way:

1. If the target currency is to be fixed, the next screen allows you to enter a fixed target currency. However, it is recommended to leave this field empty in most cases. In drilldown reporting, you often want to use the same currency translation key to calculate currency-independent values. This means that only currency translation keys without a specified target currency are appropriate.
2. If you opt for variable at this stage, the next screen will allow you to set up a link to a characteristic by entering a table name and a field name. If, for example, you would like the target currency to be selected depending on the country/region, specify the table with the country/region data (T005) and the field for the country/region key (LAND1). To do so, the country/region key must be defined as a characteristic in the operating concern.

Specify whether the currency translation key should use a fixed or a variable translation date.

The query appearing on a further screen will depend on your selection at this stage.

1. A fixed translation date is either a prespecified date or the day on which you execute the program. The date fixed here, together with the exchange rate type, determines the rate used later for the currency translation.
2. For variable translation dates, the date selected in the information system (period or fiscal year) determines the rate for each data record. Here you need to specify the time reference (beginning of period or end of year, for example). This enables you, for example, to translate each record with the rate that was valid at the beginning of the corresponding period.
   Note that, with variable translation, all columns linked arithmetically to the column to be translated are automatically translated as well.
   Note: You cannot create a date field as a characteristic in Profitability Analysis. Consequently, the option "Time base to the day" is not available here.

Specify whether the rate is an inverse exchange rate.

A translation key with an inverse rate is useful when the amounts have already been converted and need to be returned to the original values.

1. Save your currency translation keys.

You have maintained the following rates:

EUR USD 1.13

USD EUR 0.89

When translating from USD to EUR with an inverse rate, the system uses the rate 1/1.13 = 0.884 instead of 0.89.

The column "Specific translation key" is not used in Profitability Analysis.

The translation keys do not affect currency translation during actual data transfers.

Addresses (Business Address Services)   BAL Application Log Documentation  
This documentation is copyright by SAP AG.

Length: 3790 Date: 20240523 Time: 192233     sap01-206 ( 78 ms )