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