Currency conversion via routine in transformation BI 7.0

[Former Member]

Hi,

for an international data model we want to translate currencies via data load using a routine in the transformations. We are thinking about creating 2 key figures for local currency and group currency. Group currency is always EUR. We found to function modules but we are not sure about the differences and if we can us them at all: CONVERT_TO_LOCAL_CURRENCY and RSW_CURRENCY_TRANSLATION

Does anyone of you implemented currency conversion in a transformation before using a routine. And does anyone have experience with those function modules and can explain the differences? Thanks a lot in advance! Any help is appreciated!

Aline

[Former Member]

Hi Aline,

Go to the specific FM in SE37 and when you display, there you can see FM documentation where it will be explained how the FM works.

for FM's which do not have documentation, you can test the FM to see what it returns by giving it some test values.

[yogesh8984]

Hi,

You can use the readily available functionality to convert the amounts from one currency to other.

Use transaction RSCUR (maintain currency translation types) to create the currency translation type nad use it directly in the transformations.

Regards,

Yogesh

[udayabhanupattabhiram_cha]

I used this one :CONVERT_TO_LOCAL_CURRENCY

its very straight forward and selfexplanatory and the results are right for us. Just make sure you use the right type of exchange as most systems have multiple rate types.

Uday-Ram Chamarthy