Monday, July 6, 2015

Japanese Currency

Here is my input to this 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 from HFM, 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.
For HFM, I am assuming it is a flat file load. There are specific settings for flat file as stated in OSS Note 1176399 for special currency loads to work correctly. May be we had correct settings and it was working correctly and those settings recently somehow got changed.

No comments:

Post a Comment