Skip to Content
author's profile photo Former Member
0
Former Member

Separator for thousands

Posted on Jan 25, 2005 at 12:47 PM 56 Views

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.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • author's profile photo Murugesh Arcot
    Murugesh Arcot
    Posted on Jan 25, 2005 at 01:17 PM
    0

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 25, 2005 at 01:18 PM
    0

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Murugesh Arcot
    Murugesh Arcot
    Posted on Jan 25, 2005 at 01:49 PM
    0

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.