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

Swaping From Decimal point to Thousand separetar In Script

Hi,

I am generating a Customer Statement In Script.The problem is for some customers the amount field value is displayed as 6.537,29 and others the amount field value is displayed as 6,537.29. i.e., some numbers commas and decimal points are swapped around. It should always be commas for 000 separator and dot as a decimal point. This should be made uniform.

Can anybody please help me out.

regards,

Rajeshwar.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

6 Answers

  • Posted on Sep 13, 2006 at 10:42 AM
    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 13, 2006 at 10:43 AM

    Hello Raj,

    Try with the formatting opitons,

    Use this one.

    <b>

    Syntax

    &symbol(.N)&

    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(.1) -> 1,234.6

    &EKPO-MENGE&(.4) -> 1,234.5600

    &EKPO-MENGE&(.0) -> 1,235</b>

    If useful reward.

    Vasanth

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 13, 2006 at 10:44 AM

    U can resolve the same by changing your print program to write it using edit mask

    if you are printing the variable lnum

    just write the data using the below to lnum as

    write data to lnum using edit mask 'RR___,____.__'.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 13, 2006 at 10:46 AM

    In your SAP menu, Go to Sytem -> User profile -> Own Data

    This will take you to your user settings.

    Go to the tab "Defaults" and set the Decimal Notation field.

    You can also update it in the database table USR01.

    In case of SAPScripts, you can use the format

    &symbol(.N)&

    Regards

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 13, 2006 at 10:47 AM

    Hello,

    In ur program where u are fetching the data,declare varible as packdecimals with 2 or 3 decimals points upon ur requirement.And pass the value to that varible and print this varible in the form.

    regards

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      This question is very old, but maybe it's a good place to put my experience - I had a similar problem recently: a page that started off with sums represented European-fashion (1.234,56) suddenly switched to (1,234.56). I discovered that before the program started printing it checked the country listed in the data, and called 'SET COUNTRY (country-code)'. Then, before printing the totals, the program called function SD_PRINT_TERMS_OF_PAYMENT - which ends with the command SET COUNTRY SPACE. Thus the totals at the bottom of the page appeared with a different format, until I added an extra SET COUNTRY ... after the call to the function. My printout was Smartform, but I imagine that the same would be true for any type of printing.

  • Posted on Oct 15, 2010 at 07:19 AM

    Hi,

    I think you have this swapping problem for some particular country,

    you can set the country wise setting in OY01 tcode. or

    if it is happen for particular user id then u can set decimal point format in SU01 for that user id.

    I hope this resolve your problem.

    Regards,

    Arpit

    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.