Show TOC
Define Currency
Translation Keys
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 value columns. These translation keys are
valid for all operating concerns and therefore can be used for all reports in
Profitability Analysis.
Activities
Define your currency translation keys by
carrying out the following:
1. Enter a
descriptive text
2. Specify the
currency translation key (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:
a) If the
target currency is to be fixed, the next screen will present
you with the possibility of entering a fixed target currency. However, it is
recommended to leave this field empty in most cases. In drilldown reporting,
you usually wish 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.
b) 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, specify the table with the country data (T005) and the field
for the country key (LAND1). To do so, the country key must be defined as a
characteristic in the operating concern.
4. 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.
a) 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.
b) 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 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.
5. 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.
6. Save your
currency translation keys.
Example of a
currency translation key with inverse exchange rate
You have maintained the following
rates:
DEM USD 1.60
USD DEM 0.63
When translating from USD to DEM with an
inverse rate, the system uses the rate 1/1.60 = 0.625 instead of
0.63.
Further
Notes
The column "Specific translation key" is not
used in Profitability Analysis.
The translation keys do not affect currency
translation during actual data transfers.