Specification of the Target Currency from an InfoObject 

If you want the target currency to be determined from an InfoObject for currency translation, 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 translation exchange rates must have been maintained.

       2.      In characteristic maintenance, define the currency for the InfoObject from which the target currency is to be determined.

       3.      Define a currency translation type in which the target currency from this InfoObject is to be determined.

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

or

Use the currency translation type for currency translation in BEx.

Example

You want to load data using a file in csv format and update it into an InfoCube. The InfoCube has two key figures (kyf1 and kyf2) of type Amount with differing unit InfoObject.

Segment of a csv file:

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 supplied from the source key figure kyf1. Then currency translation is performed with currency translation type WUA01. In WUA01 you 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

A prerequisite for being able to update the key figure kyf2 for the InfoCube including currency translation, is that Z_COUNTRY contain specifications ‘D’ and ‘CH’. Furthermore, 0CURRENCY must contain valid currency units and the corresponding translation exchange rates must also have been maintained.

Result:

Characteristic bearing master data, Z_COUNTRY:

Characteristic: Z_COUNTRY	Currency Attribute: 0CURRENCY	…
D	EUR	...
CH	CHF	...
...	...	...

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