Currency translation from EUR to USD

[Former Member]

Dear all,

Our local currency is TWD and we need to convert document currency in sales order from EUR to the third currency (e.g. USD) when executing BW query in BEx Analyzer. Currently we only have exchange rates for all currencies to TWD in exchange rate table. Except for defining exchange rate of EUR to USD in exchange rate table, is it possible to convert EUR to USD (e.g. convert EUR to TWD first and then convert TWD to USD)?

[Former Member · Accepted solution]

define two currency translation . 1st EUR > TWD 2nd TWD> USD.

kf1 ( key figure in the cube ) , use 1 st translation.

kf2 ( calculated key figure , = kf1) use, 2 nd translation .

Hope helps.

Derya

[yasemin_kilinc]

Hi Eric,

For this aim you can add an extra key figure to your infocube and write an ABAP code in update rule. You can use the standart ABAP functions such as

convert_foreign_to_foreign_cur.

I think this function does exactly what you need to do.

Hope it helps...

Yasemin

[Former Member]

We need to convert EUR to USD using exchange rate at query run time. So I can't precalculate it and save in Infocube.

[Former Member]

You can do it at querry level also.... U have currency conversion option in Bex.. Just right click on ur KF and select properties u will find the option....

Hope this will helps..

Khaja

[Former Member]

The problem IS that we have only exchange rate for EUR->TWD or USD->TWD instead of EUR->USD in the exchange rate table.

[Former Member]

Check the table TCURR in SE11...

This table will maintain the exchange rates..

Assign points if it helps

Khaja

[former_member345199]

Hi,

This info may be of help for you.

Check these tables Exchange rates are maintained here.

Table TCURR - Exchange rates

Table TCURF

Table TCURV - Exchange rate types for currency translation

Table TCUR*

Table TCURC - Currency Codes

The update of exchange rates is updating tables TCURR and TCURV. If you run at the same place the transfer of global settings, the tables TCURF, TCURS, TCURT, TCURV, TCURW, TCURX, TCURC and TCURN are updated.

For details check the programs RSIMPCUST (global settings) vs. RSIMPCURR (exchange rates).

You can maintain exchange rate factors in TCURF table via RSA1>source system>context menu (transfer global settings check only currencies)/transfer exchange rates, this updates TCURF table but also updates all currency related tables. You need to check what all tables you need to update. Also you can look into standard program RSIMPCUST to know what all currency tables will be updated.

If you want to maintain them directly in BW then go to SPRO > Genral settings and Currencies (SPRO -> Global Settings -> Currencies).

OB08 maintains the enties for currency conversion, here you can check whether the exchange rate is maintained to convert the currency from one curr to other.

Thanks,

JituK

[Former Member]

Hi,

Did you transfer exchange rate from your source system?

If so, then check your Tcurr table.They should exist in that table.Also if you are using bi 7.0 run rscur transaction there you can define your currency conversion which is needed for Bex.Please take a look at the blog.

/people/rasim.manavoglu/blog/2007/04/30/currency-currency-currency

Regards.