topic Re: Amount Format in Application Development and Automation Discussions

Amount Format

Former Member — Wed, 08 Nov 2006 05:39:37 GMT

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

Re: Amount Format

Former Member — Wed, 08 Nov 2006 05:43:53 GMT

try this function module

'SD_CONVERT_CURRENCY_FORMAT'

pass currency

and amount.

Ramesh.

Re: Amount Format

Former Member — Wed, 08 Nov 2006 05:47:22 GMT

suppose if u r writing lik this

write:/ wa_vfkp-NETWR currecny wa_vfkp-WAERS.

write currecy field also.

Regards,

Ramesh.

Re: Amount Format

Former Member — Wed, 08 Nov 2006 06:21:31 GMT

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

Re: Amount Format

Former Member — Wed, 08 Nov 2006 06:32:22 GMT

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

Re: Amount Format

Former Member — Thu, 26 Jul 2007 12:15:26 GMT

Try using Set Country command .

e.g.: SET COUNTRY 'US'.

( from table T005X )

Reward if helpful

Re: Amount Format

Pawan_Kesari — Thu, 26 Jul 2007 12:40:47 GMT

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

use

WRITE amount CURRENCY cur.

Re: Amount Format

Former Member — Fri, 27 Jul 2007 09:01:04 GMT

WRITE amount CURRENCY cur.