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

Increase in no of decimal places

Hi,

We had a requirment to have the currecy values up to 5 decimal places. Which is 2 in SAP standard. For that we went for the USDN currecy type of SAP which is already 5 decimal places.

In the application etc we can see its comming 5 decimal. But when we try to create some non-std report or try to fetch in some data by user queries it picks up just two.

Like the net prize is 12.12345.

in table it gets stored as 12123.45. (as netprize dataelement is wertv6) (2 decimal)

in non standard reports and SAP User Queries we get 12,123.45.

whereas we want that even in the NON standrad reports and user queries it should pick up the value as 12.12345.

Please let me know some way by which i can change the no of decimal places in SAP Tables also to 5 decimals. or some setting by which every where in output it shows 5 decimals.

This is really very very urgent.

Thanks,

NC

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Apr 05, 2005 at 07:57 PM

    Hi NC,

    The solution involves the formatting of the data in the output and not the data stored in SAP tables.

    When writing the output of the currency data, you should always use the write statement using the option currency 'USDN' (or variable WA_CURR). Check SAP help on the write statement options for details.

    With the ALV, you must have a currency field in the field category for it to automatically display correctly.

    For interfaces, you can use function module BAPI_CURRENCY_CONV_TO_EXTERN_9.

    I hope this helps.

    Mike Vondran

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Christian Wohlfahrt

      Slight correction (hope I am not offending Christian), BWKEY (Valuation Area) is related to the plant T001W-WERKS and not company code T001-BUKRS.

      the correct link is to go thru T001K (mbew-bwkey eq t001k-bwkey) to T001 (t001-bukrs eq t001k-bukrs) to get T001-WAERS for MBEW, but you are right that MBEW-BWKEY, 9 out of 10 times is the plant code (not company code, seems like company code if the company code and the plant code are the same)

      Now getting back to the query, if the above join from MBEW to T001K to T001 is done and T001-WAERS selected in your query, the value will come out with the USDN format, provided the currency for the company is USDN

      Phew!

      Rishi

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.