Wednesday, November 11, 2015

Japanese Currency Issue

In SAP, amounts (data type CURR) are always stored with two decimals in the database.
It does not matter how many decimals are actually allowed for that currency.
Currencies like JPY, KRW, CLP, etc. do not have any decimals.

In those cases, SAP both on ECC and BW divides the amount for those currencies by the decimal factor maintained in TCURX table and multiplies by the same factor on the report.

For example, 30,000 will be stored as 30,000/100 (because the TCURX table has 0 decimal).

For zero decimals, 
SAP divides by 100. If we are loading the flat file data , we should make sure that this division occurs. After the division, 30,000 will be stored as 300.
In the BW report, 300 will be multiplied by 100 and shown as 30,000.
This division and multiplication occurs for all the exception currencies maintained in TCURX.

If the above division is not happening, the report will multiply by 100 by default and that will be an overstated amount by a factor of 100.

There are specific settings for flat file as stated in OSS Note 1176399 for special currency loads to work correctly. 





No comments:

Post a Comment