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