SAP script amount format error

[Former Member]

Hi Gurus,

I am working on a SAP script for printing the check but it's coming up with an error, the amount it's showing is not in a desired format. Instead of $1,432.79 it's printing $1.432,79 and this problem is coming only when I am using the foreign address only and not with the US address. So can you please tell me what exactly is going wrong and how to get rid of this.

THanks,

Rajeev !!!

[Former Member · Accepted solution]

Hi Rajeev,

This is the european format of writing the amounts. As in India we write it as 1,000.50, they write it as 1.000,50. You need to write a subroutine and use the replace command and change ' . ' to ' , ' and ' , ' to ' . '

Thanks & Regards

Nayan

<REMOVED BY MODERATOR>

Edited by: Alvaro Tejada Galindo on Apr 10, 2008 10:38 AM

[Former Member · Accepted solution]

Thanks for the reply Nayan,

but can you help me in writing the subroutine you are talking about and where do I need to write this , as I am new to ABAP I don't know how should I proceed with this.

<REMOVED BY MODERATOR>

Thanks,

Rajeev !!!

Edited by: Alvaro Tejada Galindo on Apr 10, 2008 10:38 AM

[Former Member]

Hi,

This is not an error, this is how the system is designed to work. If you're sending the cheque to a certain country you need to use the prefered format of that country, the system does this for you automatically. Check the settings in table T005X to find which settings are prefered for each country.

Regards,

Nick