Show TOC

Defining Target Currencies Using InfoObjectsLocate this document in the navigation structure

Use

If you want to determine the target currency for currency translation using an InfoObject, proceed as follows:

  1. You need a characteristic that can be defined as an attribute for this InfoObject. This characteristic, for example 0CURRENCY, must contain valid currency units and the corresponding exchange rates have to be maintained.

  2. In characteristic maintenance, set the currency attribute for the InfoObject which you are using to determine the target currency.

  3. Define a currency translation type in which the target currency will be determined using this InfoObject.

  4. In the transformation rules for your InfoCube, specify that the values for the corresponding key figures are to be translated in the transformation and enter the previously defined translation type.

    or

    Use the currency translation type for currency translation in BEx.

Example

You want to load data from a CSV file and update it into an InfoCube. The InfoCube has two key figures (kyf1 and kyf2) of type Amount with different unit InfoObjects.

CSV file extract:

Z_COUNTRY

kyf1

kyf_unit1

D

1

USD

CH

2

USD

In the update rules, specify that kyf1 be updated to the InfoCube without changes. kyf2 is filled from the source key figure kyf1 and currency translation is performed with currency translation type WUA01. In WUA01 you have specified that the source currency be determined from the data record and that InfoObject Z_COUNTRY be used to determine the target currency.

You already defined a currency attribute for the InfoObject Z_COUNTRY in InfoObject maintenance on the Business Explorer tab page - for example, 0CURRENCY. See also Tab Page: Business Explorer

In order that key figure kyf2 of the InfoCube is updated with the currency conversion, Z_COUNTRY must contain the attributes 'D' and 'CH'. Furthermore, 0CURRENCY has to contain valid currency units and corresponding exchange rates have to have been maintained.

Result:

Characteristic bearing master data, Z_COUNTRY:

Characteristic: Z_COUNTRY

Currency Attribute: 0CURRENCY

...

D

EUR

...

CH

CHF

...

...

...

...

In the transformation rules, 1 USD was translated into EUR and 2 USD into CHF.