topic Re: Function Module to convert currency in Application Development and Automation Discussions

Function Module to convert currency

Former Member — Tue, 26 Jun 2007 04:48:44 GMT

Hi all,

I need to convert all currency to 'EURO'.Could you please anybody help me in this regard.whather is there any function module?.

Regards.

Reddy Prasad.

Re: Function Module to convert currency

Former Member — Tue, 26 Jun 2007 04:51:58 GMT

Hi,

You can use

FM <b>CURRENCY_CONVERT</b>

Thanks and Regards,

Kunjal Patel

Re: Function Module to convert currency

Former Member — Tue, 26 Jun 2007 04:52:10 GMT

Hi,

you can use the function module CONVERT_TO_LOCAL_CURRENCY

Thanks

Naren

Re: Function Module to convert currency

Former Member — Tue, 26 Jun 2007 04:52:11 GMT

Check these FMs

CONVERT_TO_LOCAL_CURRENCY

CONVERT_TO_FOREIGN_CURRENCY

For more choices, type convertcurrency* and do an F4

~ Laxmi

Reward all helpful answers

Re: Function Module to convert currency

Former Member — Tue, 26 Jun 2007 04:54:01 GMT

HI,

Please try this .

FWOS_CURRENCY_DECIMALS_READ :All the currency amounts are stored in SAP tables as CURR(n,2) (the same as DEC(n,2)). So before any arithmetic operation value should be adjusted using the real decimals number for the given currency (stored in TCURX).

Conversion Rates by type and date are stored in TCURR (+factors). Standard type is M. Date is stored in inverted format (the most recent date has the numerically smallest value). ABAP code to convert dates:

convert date p_date into inverted-date w_date.

convert inverted-date w_date into date p_date.

CONVERT_TO_LOCAL_CURRENCY :the only difference between CONVERT_TO_LOCAL_CURRENCY and CONVERT_TO_FOREIGN_CURRENCY seems to be the following:

Foreign currency is TCURR-FCURR (From Currency)

Local Currency is TCURR-TCURR (To Currency)

So result will be slightly different for the both functions (two rates stored in the TCURR: e.g. JPY->USD rate is 0.00880, USD->JPY rate is 122.00000). Better to use CONVERT_TO_LOCAL_CURRENCY, because multiplication is more exact operation than division.

CONVERT_TO_FOREIGN_CURRENCY :Both conversion functions can return also selected rate and factors

reward all helpfull answers,

regards .

Jay