Start of Content Area

 Procedure documentation Creating Currency Translation Types  Locate the document in its SAP Library structure

Prerequisites

If you want to use variables in the currency translation type, you have to create them beforehand. See Creating Variables for Currency Translation Types.

Procedure

...

       1.      On the SAP Easy Access screen for SAP NetWeaver Business Intelligence, choose SAP Menu → Modeling → Object Maintenance  → Currency Translation Types.

       2.      Enter a technical name for the translation type. The name must be between three and ten characters long and begin with a letter. Choose This graphic is explained in the accompanying text Create. The Edit Currency Translation Type screen appears.

       3.      Enter a description.

Exchange Rate Tab Page:

       4.      Choose Exchange Rate Type or Ex. Rate Type from Var. to determine the exchange rate dynamically. With Ex. Rate Type from Var. you can select any variable that has been created for 0RTYPE using input help.

       5.      Choose Dynamic Exchange Rate Determination or enter an InfoObject (key figure) to be used to determine the exchange rate. The latter is only supported with updates.

       6.      Determine whether you want to perform the currency translation with the inverse exchange rate. In this case, the required translation from one currency to another is performed using the reverse exchange rate. This can be useful, for example, when values have already been translated and you need to restore the original values.

Currency Tab Page

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

○       Determined using a variable

       8.      Under Target Currency, choose whether you want to determine the target currency when translation is performed or in the translation type.

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

Caution

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.

Time Reference Tab Page

       9.      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 choose:

■       Standard InfoObject (standard time characteristic: 0FISCYEAR, 0FISCPER, 0CALYEAR, 0CALQUARTER, 0CALMONTH, 0CALWEEK or 0CALDAY), which is used to determine the time of the translation

■       Special InfoObject. This special InfoObject has to have the same properties as the standard InfoObject or it has to reference the standard InfoObject. The aforementioned notes on using InfoSets also apply here.

■       In the Time Adjustment field, whole numbers with +/- sign

■       In the Time Adjustment from Variable field, you can specify formula variables (1FORMULA) 

The time adjustment (regardless of whether it is fixed or variable) is always related to the InfoObject specified under Variable Time Reference.

   10.      Save your entries.

Result

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:

Currency Translation Type

 

 

 

End of Content Area