Question Re: Currency Conversion in Technology Q&A

Currency Conversion

Former Member — Tue, 05 Oct 2010 08:23:54 GMT

Hi,

I have a requirement for currency conversion. I am getting the Exchange rate from source system. I would like to Calculate the local currency using Function Module Convert_To_Local Currency. I am supplying the required parameters like Source currency, Targer currency and Foreign amount. And i amalso passing the Exchange Rate as Input. I need the FM to take the rate i am supplying for conversion. But the FM is looking up TCURR table for exchange rates.

Is there someway i could make it take the exchange rate supplied as part of Input Parameters. We can jus directly calculate the local currency directly by mulitplying the foreign amount with exchange rate. But my client insists me to use the FM since it would make the solution generic.

Thanks,

Praveen

Re: Currency Conversion

Former Member — Tue, 05 Oct 2010 08:36:58 GMT

Hi Pravenn,

I don't think, that FM Convert_To_Local Currency will solve your requirement without modifications.

Why don't you schedule transfer of exchsnge rates from source to BW periodically as often as necesary?

Regards

Joe

Re: Currency Conversion

maxilopez — Mon, 08 Nov 2010 02:14:07 GMT

Hi Praveen,

You can use RSCUR transaction to define your custom currency translation method.

In the "Exchange rate" tab, through the option "Exchange rate from InfoObject", you can select wich InfoObject holds the exchange rate to be used.

Then, you have to change the transformation so that Currency conversion is performed using the routine you defined in RSCUR.

If you are taking data from a datasource, you may try to use the "InfoObject Assignment" field in the Source Fields of Rule area, in order to map R3 field to the InfoObject defined for the translation in RSCUR transaction.

I hope it helps you.

Regards,

Maximiliano

Re: Currency Conversion

maxilopez — Sun, 14 Nov 2010 05:48:21 GMT

Hi Praveen,

I wanted to ask you if your concern was resolved.

Please, let me know if you need further help.

Regards,

Maximiliano

Re: Currency Conversion

Former Member — Mon, 27 Dec 2010 13:49:21 GMT

Hi, what happend with your problem?