If you want to use variables in the currency translation type, you have to create them beforehand. See Creating Variables for Currency Translation Types.
You use the Exchange Rate Determination Using FI Module indicator to specify that the exchange rate is determined using the currency translation mechanisms used in ERP or the services offered in the enterprise service-oriented architecture.
Under Source Currency, choose whether the source currency is:
Determined using the data record
Based on a fixed source currency
Determined using an InfoObject. Specify the InfoObject you want to use to determine the source currency. For more information, see the example under Defining Target Currency from InfoObjects.
Determined using a variable
If you are determining the target currency upon translation, you can either specify a fixed target currency in the Query Designer (as a property of a key figure of type Amount) or specify a variable to be used to determine the target currency. See Setting Variable Target Currencies in the Query Designer.
If the target currency is to be determined in the translation type, choose either
A fixed target currency
A target currency from a variable; you can use input help to select any variable that has been created for 0CURRENCY
Alternatively, an InfoObject from which the target currency is to be determined
Note that with InfoSets, the InfoObject can occur several times within the InfoSet and therefore may not be unique. In this case, you have to specify the unique field alias name of the InfoObject in the InfoSet. The field alias name consists of: <InfoSet name><three underscores><field alias>. You can display the field alias in the InfoSet Builder using Switch Technical Name On/Off.
Example: In the InfoSet ISTEST, characteristic 0CURR occurs twice. The field alias names are ISTEST___F00009 and ISTEST___F00023.
Select a fixed or a variable time base for the currency translation.
With a fixed time reference, you can choose between:
Selection upon translation
Current date
Fixed key date
Time reference using a variable (variable for 0DATE)
Query key date. In this case, the time reference is the key date that is set in the query properties in the Query Designer.
With a variable time reference, you can make the following settings:
The time of the translation precisely for the start or end of a fiscal year, period, calendar year, calendar year/quarter, month, week or day.
Set the indicator Standard InfoObject. The standard time characteristic is set by the system to correspond to the time of the translation (e.g. 0FISCYEAR for Start Fiscal Year, 0CALYEAR for Start Calendar Year).
Or choose a special InfoObject. This special InfoObject has to have the same properties as the standard InfoObject or reference the standard InfoObject. The aforementioned notes on using InfoSets also apply here.
In the Time Shift field, you can specify whole numbers with the +/- sign.
For a variable time reference To the Exact Day, 0CALDAY and a time shift of -3 would, for example, 04.11.2006 would be used for the translation instead of 07.11.2006
In the Time Shift from Variable field, you can specify formula variables (1FORMULA).
Regardless of whether it is fixed or variable, the time shift is always based on the InfoObject specified under Variable Time Reference.
You can define the handling of period 0 if you selected Start or End Period as the variable time reference (0FISCPER ). If the value 000.2002 is now entered at runtime for the value of 0FISCPER, there are different ways to determine a start and end date. Period 0 controls how the first day (FIRSTDAY) and last day (LASTDAY) of period 0 are determined. This day is then used as the key date for the currency translation. The following variants are available:
Variant |
Period |
FIRSTDAY |
LASTDAY |
Days |
---|---|---|---|---|
(Default) |
000.2002 |
31.12.2001 |
31.12.2001 |
1 |
A |
000.2002 |
01.01.2002 |
01.01.2002 |
1 |
B |
000.2002 |
01.01.2002 |
31.12.2002 |
365 |
C |
000.2002 |
31.12.2001 |
01.01.2002 |
2 |
End Period and standard InfoObject 0FISCPER were selected as time reference. The value of 0FISCPER is specified as 000.2002. Period 0 is handled according to variant B, that is the date 31.12.2002 is determined at runtime. This date is used for currency translation.
Start Period and standard InfoObject 0FISCPER were selected as time reference. The value of 0FISCPER is specified as 000.2002. Period 0 is handled according to variant A, that is the date 01.01.2002 is determined at runtime. This date is used for currency translation.
The currency translation type is available for translating currencies when you perform a transformation for InfoCubes and when you analyze data in the Business Explorer.
See also: