Currency fields in SAP® - 4
This has tremendous impact on analytics that run on SAP® Downloads, because in certain circumstances there could be values differently stored than displayed with data browser of SE16. Especially currency fields may, but do not have to be affected. But what could be the reason then, and how do these cases differ?
The answer is that SAP® ALWAYS stores amounts with 2 decimals in the database. This works fine for the Euro, as Euro has Cents and are stored with 2 decimals. If the amount is 5 Euros, then 5,00 is stored, 5 Euros and 10 Cents -> 5,10, or 5 Euros and 11 Cents (5,11) etc.
But then there are currencies, as the Japanese Yen from the example, which have no decimals at all. Other currencies maybe have 3 or 4 decimals but in the database only 2 decimals are stored.
For this reason SAP® introduced a separate table named TCURX, where the number of decimals per currency can be found, and provides the factor by which an amount must be multiplied to be properly displayed.