topic Re: currency conversion in Application Development and Automation Discussions

currency conversion

Former Member — Thu, 20 Mar 2008 05:59:41 GMT

Hi all,

I need to convert the currency using exchange rate which i m taking from vbrp-kurrf filed. Pls suggest me if any function module is available for conversion.

I hv tried FM 'CONVERT_TO_LOCAL_CURRENCY' but i think it doen't convert currency according to exchange rate which we supplying.

Shital.

Re: currency conversion

Former Member — Thu, 20 Mar 2008 06:05:55 GMT

Use this FM

CONVERT_CURRENCY_BY_RATE

to get the factor make use of TCURR table

Regards

Shiva

Re: currency conversion

Former Member — Thu, 20 Mar 2008 06:11:22 GMT

Hi,

Check out this thread.

Reward if helpful.

Regards,

Ramya

Re: currency conversion

Former Member — Thu, 20 Mar 2008 06:20:03 GMT

I am trying the same FM but since i m exporting FROM_FACTOR & TO_FACTOR from table TCURR.the value for these field is 0. so it is going in dump.

SELECT SINGLE * FROM tcurr WHERE

fcurr = g_r_vbrk-waerk

AND tcurr = t001-waers.

CALL FUNCTION 'CONVERT_CURRENCY_BY_RATE'

EXPORTING

from_amount = l_f_foreign

from_currency = g_r_vbrk-waerk

from_factor = tcurr-ffact

rate = g_f_kurrf

to_currency = t001-waers

to_factor = tcurr-tfact

IMPORTING

to_amount = l_f_local

EXCEPTIONS

no_rate_found = 1

OTHERS = 2.

Re: currency conversion

former_member253577 — Thu, 20 Mar 2008 06:21:06 GMT

Hi Shital,

FM 'CONVERT_TO_LOCAL_CURRENCY' will convert the currency according to exchange rate we provide. But u need to pas the correct import parameters for this functionality.

along with the rate, u need to send the Type of rate M=Average rate

G=Bank buying rate

B=bank selling rate

Please check if u r passing this also.

Regards,

Sree.

Re: currency conversion

Former Member — Thu, 20 Mar 2008 06:46:32 GMT

Hi,

I am importing the type_of_rate as 'M' and READ_TCURR = ' '.

But the o/p for both the cases is same.

1> without exporting rate

2> with exporting rate