unit separator for numbers in SAP scripts

[Former Member]

Hi all,

How can I get the following thing done?

The currency format is not correct it should actually have u2018,u2019 as unit separator and u2018.u2019 as decimal separator. E.g.: 1,234,567.89

[Former Member · Accepted solution]

Hi

Use following code before printing

/: SET COUNTRY ' '

Refer following for details -

Country-Dependent Formatting

Certain fields are formatted specific to a particular country. These include fields for displaying a date and numeric fields containing either a decimal point or a u2018thousandsu2019 separator character. The formatting applied is usually determined by the definitions contained in the user master record. You can use the SET COUNTRY control command to choose a different formatting operation. The various country-dependent formatting options are stored in table T005X.

Syntax

/: SET COUNTRY country_key

You can specify this country key either by quoting it directly enclosed in inverted commas or by using a symbol.

/: SET COUNTRY 'CAN'

/: SET COUNTRY &KNA1-LAND1&

You can revert to the settings of the user master record by using the SET COUNTRY control command again with an empty country name.

/: SET COUNTRY ' '

When SAPscript encounters this command it calls the corresponding ABAP command internally. The effect of the SAPscript command is thus identical with that of the ABAP command.

Regards

Harshada

[Former Member]

Hi,

change you user setting as below

system-> user profile-> own data--> under default tab the amount shoud be 1,234,567.89 format.