topic Re: Convert amount in Application Development and Automation Discussions

Convert amount

Former Member — Wed, 14 Mar 2007 15:08:35 GMT

Hello,

I have to write (in a form) an amount in the format : 1,000,000.00

The currency and the initial format of the amount is variable.

Do you know a function module to convert an amount to this format?

Thanks in advance,

Bertrand

Re: Convert amount

Former Member — Wed, 14 Mar 2007 15:12:00 GMT

HI,

Use Function module :

BAPI_CURRENCY_CONV_TO_INTERNAL

call function 'BAPI_CURRENCY_CONV_TO_INTERNAL'

exporting

currency = 'USD'

amount_external = input

max_number_of_digits = 20

importing

amount_internal = output

RETURN =

Regards

Sudheer

Message was edited by:

Sudheer Junnuthula

Re: Convert amount

Former Member — Wed, 14 Mar 2007 15:13:04 GMT

Hello,

Do like this:

Data: LV_amount(16).
write: amount to lv_amount

Regards,

Vasanth

Re: Convert amount

Former Member — Wed, 14 Mar 2007 15:21:20 GMT

Hello,

This method doesn't work if I have not the right parameters in SU3.

Maybe, you know how to always obtain the good format.

Best regards,

Bertrand.

Re: Convert amount

Former Member — Wed, 14 Mar 2007 15:29:11 GMT

hi,

Check out this way ..

data : v_temp like coep-wkgbtr value '10000.00'.
     
data: v_result(18).

 write : v_temp to v_result.

Regards,

Santosh

Re: Convert amount

RaymondGiuseppi — Wed, 14 Mar 2007 15:31:08 GMT

Use

SET COUNTRY f.

to insure the output format.

Regards.

Re: Convert amount

former_member187255 — Wed, 14 Mar 2007 15:33:23 GMT

ur trying to format the amount ...

try this...

write: amt USING EDIT MASK 'RR___,___,___.__'.

LL for left justified.

Hope this helps..

Rgds.

Re: Convert amount

Former Member — Wed, 14 Mar 2007 15:35:46 GMT

Hello,

Try with the FM

<b>SD_CONVERT_CURRENCY_FORMAT</b>

REgards,

Vasanth

Re: Convert amount

Former Member — Wed, 14 Mar 2007 15:38:54 GMT

Hello,

This method doesn't fil the ',' for thousand separators.

Any other solution ?

Thanks in advance,

Bertrand

Re: Convert amount

Former Member — Wed, 14 Mar 2007 15:42:55 GMT

did u try my solution ???

Regards,

Santosh