Purchase Order with JPY Currency

[Former Member]

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

[Former Member]

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

[JL23]

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).

[JL23]

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.

[Former Member]

Use tcode - OB08 and check the conversion rate.

[Former Member]

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.

[former_member187989]

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

[Former Member]

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

Regards

GK.

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