topic Re: Separator for thousands in Application Development and Automation Discussions

Separator for thousands

Former Member — Tue, 25 Jan 2005 12:47:22 GMT

Hi,

is there a way to add Separator for thousands in sap

script???

the variable that i want to print is not from the dictionary this is a calculated variable ,

now it's print on the form 1234

and i want 1,234.

hope you can help on this.

10X Gil.

Re: Separator for thousands

Former Member — Tue, 25 Jan 2005 13:17:10 GMT

Hello,

I hope this SAP online doc. helps you.

I would suggest you to define the variable in your program referring to the curr/quan field.

Regards, Murugesh AS

SAP Online Doc:

Omitting the Separator for ‘Thousands’

Symbols of the DEC, CURR, INT, and QUAN data types are normally formatted with the a ‘thousands’ separator character. The T option allows you to omit this separator character.

Syntax:

&symbol(T)&

The EKPO-MENGE field contains the value 1234.56. The Dictionary definition specifies 3 decimal places and an output length of 17.

&EKPO-MENGE& -> 1,234.560

&EKPO-MENGE(T)& -> 1234.560

Re: Separator for thousands

Former Member — Tue, 25 Jan 2005 13:18:02 GMT

I believe that the thousands separater comes from the user profile. Check the Decimal Notation on the Defaults tab of your user profile. You can override this setting in the sapscript by using the SET COUNTRY command. The values for this command are in table T005X. So the command would be SET COUNTRY 'US' for the United States. I think the field you are printing also has to be a numeric field.

Brian

Re: Separator for thousands

Former Member — Tue, 25 Jan 2005 13:49:09 GMT

Hello,

I see the star is appearing with blue colour in the list of questions.

But No points have been given to Brian Daws nor to me. Is there any problem with the system or let me know whether my understanding of point system is wrong?

-Murugesh AS