Amount format in SAP Scripts

[Former Member]

Hi Experts,

I need to print the amount in 1,000,000.50(Thousands seperator using comma) format.

But  I am getting in 1.000.000,50 format.

Please let me know, how to change the amount into the first format..?

Thanks & Regards,

Harikrishna

[venkateswaran_k]

Dear Hari

But it is recommended to set it in User Level.
This format setting is done in user profile: SU01 - Defaults tab.

However, In the scripts if you want to do that explicitly you can use the command: /: SET COUNTRY 'SG' .
By setting the Country, the Amount format thousand separator automatically changes.

Regards,

Venkat

[former_member213851]

Hi Harikrishna,

In order to change the format of Amount field, you just need to change User profile for Decimal Notation.

On menu bar ,Go to System->User Profile ->Own data.

Now go to Defaults tab and select Decimal Notation as per requirement.

Similarly you can change Date and Time format.

If this doesn't solve your issue, use SPLIT and CONCATENATE  commands to convert date in suitable format inside script.

Best Regards,

Sachin

[former_member209818]

Hi Hari,

Its getting printed like that because of your User Formats. But if you always want to print the amount using a fixed format, then transform the amount using Write statement with Edit mask. and then pass this transformed value to script..