Amount Format

[Former Member]

Hi All,

Is there any FM to convert the amount to its currency specific external format(Commas). For e.g.

If the Currency is USD, the amount should be 100,000,000.00

For the Currency INR, the amount should be 10,00,00,000.00

Thanks in Advance.

Jai

[Former Member]

try this function module

'SD_CONVERT_CURRENCY_FORMAT'

pass currency

and amount.

Ramesh.

[Former Member]

suppose if u r writing lik this

write:/ wa_vfkp-NETWR currecny wa_vfkp-WAERS.

write currecy field also.

Regards,

Ramesh.

[Former Member]

Thanks for ur Reply,

The FM SD_CONVERT_CURRENCY_FORMAT is giving the amount 100000000 as 100,000,000.00 for INR also.

But i need the amount as 10,00,00,000.00.

Even the Write statement is also giving the same format.

Is there any other way to do this?

Thanks

[Former Member]

Hi,

Try these function modules:

<b>CONVERT_TO_FOREIGN_CURRENCY</b>

Convert local currency to foreign currency.

<b>CONVERT_TO_LOCAL_CURRENCY</b>

Convert from foreign currency to local currency

Hope it helps.

Reward if helpful.

Regards,

Sipra

[Former Member]

Try using Set Country command .

e.g.: SET COUNTRY 'US'.

( from table T005X )

Reward if helpful

[Pawan_Kesari]

dear you don't need any FM for this ... mere WRITE statement with CURRENCY clause will do the formatting...

use

WRITE amount CURRENCY cur.

[Former Member]

WRITE amount CURRENCY cur.