Show TOC

Creating Currency Translation TypesLocate this document in the navigation structure


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


  1. On the SAP Easy Access screen for SAP NetWeaver Business Intelligence, choose Start of the navigation path SAP Menu Next navigation step Modeling Next navigation step Object Maintenance Next navigation step Currency Translation Types End of the navigation path.
  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 Create. The Edit Currency Translation Type screen appears.
  3. Enter a description.
  4. Exchange Rate Tab Page:

    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.

  5. 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.
  6. Choose Dynamic Exchange Rate Determination or enter an InfoObject (key figure) to calculate the exchange rate. The latter is only supported with updates.
  7. 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.
  8. Currency Tab Page

    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

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


      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.

  10. Time Reference Tab Page
    • 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:



























    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.

  11. Save your entries.


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