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

Purchase Order with JPY Currency

Hi Friends,

While raising PO with currency JPY, there is an unusual issue noticed in all POs. The netprice is getting truncated by 02 zeros in the end always.

For ex, if a PO with JPY currency is raised with netprice as 98000.00 (Ninety Eight thousand), table EKPO is getting updated with Netprice as 980.00 (Nine hundred eighty) only. This is happening for all POs raised with currency as JPY. But this is not the case for POs with INR, USD or EUR currency. This issue is happening for all POs with currency with JPY.

Can you pl proivde your expertise as to why this is happening?

Regards

Amitava

Add a comment
10|10000 characters needed characters exceeded

Related questions

6 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Oct 27, 2010 at 10:45 AM

    Hi,

    Plz chk the decimal setting for JPY in txn. OY04.

    Please consult your FI person regarding this. since JPY wont have any decimal places

    Have a look at here How NETPR field behaves for JPY currency in PO screen

    Regards

    GK.

    Edited by: Gnana Kumar on Oct 27, 2010 12:48 PM

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 27, 2010 at 10:55 AM

    Japan currency exchange rate will be maintained for ratios 100 JPY <=> 1 INR in t.code OB08.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 27, 2010 at 10:58 AM

    Dear Amitava Choudhury

    Certain currencies does not have decimal places like JPY, KRW. Please do not change the settings for these currencies.

    Please search threds about the same.

    IF you on ECC6.0 , please refer SAP note 1455122.

    warm regards

    Ramakrishna.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 27, 2010 at 11:25 AM

    Use tcode - OB08 and check the conversion rate.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 27, 2010 at 11:40 AM

    this is not unusual, this is design.

    Value fields have 2 decimals, but your currency has no decimals, hence SAP has to store the value differently in the tables.

    The SAP function module do everything right, as you can see when displaying the order with ME23N.

    Just SE16 or queries do not use this function modules, hence it looks strange, but thats way it is.

    dont change any setting as some unexperienced users recommend here.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 27, 2010 at 11:45 AM

    Hi Amitava ,

    Did you change the Currecncy decimal places in OY04 after making PO? . If So , decimal places will jump like this way only..

    It is not advisable to do the changes in decimal places after using Currencies. So , you better change the JPY Currency rate as it is and go to every PO and make changes manually as per original rate.

    With Regards

    S.Siva

    Add a comment
    10|10000 characters needed characters exceeded

    • from OSS note 1176399:

      SAP format for amounts

      In an SAP system, amounts (data type CURR) are always stored in the database using exactly two decimal places. It does not matter how many decimal places are actually allowed for the relevant currency.

      However, amounts are displayed on screens as converted in accordance with their number of decimal places. The number of decimal places, and therefore the shift of the decimal point, is stored in the table TCURX.

      Example

      The currencies JPY (Japanese Yen) and TWD (Taiwanese Dollar) do not have any decimal places. An amount of 123456 JPY is stored on the database as 1234.56 JPY; however, on the screen (for example, in the PSA maintenance, in the query or in the LISTCUBE) it is displayed as 123,456 JPY (when using the comma as the thousand separator).

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.