topic Re: Function Module for Amount Format in Application Development and Automation Discussions

Function Module for Amount Format

Former Member — Mon, 25 Jul 2005 14:50:15 GMT

Hi,

I am sending data from SAP to some other system. Could any let me know the amount format ( e.g if currency is usd then format should be 100.00 and if the currency is DNK then the format should be 100,00 ).

If we display it (after change user logon setting) it shows perfect format during the execution of the report but I have to sent the data to some other systm where user logon setting does not convert the amount in the require format.

It will be great if some body could advise some functional module which can help me to change the amount format.

Thanks

Re: Function Module for Amount Format

Former Member — Mon, 25 Jul 2005 15:05:33 GMT

Hi,

You can write the amount field using currency Key.

E.g.

Write itab-num1 to itab-num1 currency 'DNK'.

and then export the file.

Regards,

Gagan

Re: Function Module for Amount Format

Former Member — Mon, 25 Jul 2005 17:32:19 GMT

well ! using currency option of WRITE will only format value from internal SAP format to display format as per user setting. If you can somehow set the correct country using SET COUNTRY then you have a clean solution.

Cheers,

Sanjeev