Solution : https://service.sap.com/sap/support/notes/1176399 (SAP Service marketplace login required)
Summary :
In the context of loading currency amounts into an SAP BW system, discrepancies such as incorrect size or misplaced decimal points can occur. This typically results from improper configuration of the DataSource and misunderstandings about currency display in SAP. Amounts in SAP, of data type CURR, are stored in the database with two decimal places irrespective of the currency's standard decimal configuration, which is regulated in the TCURX table. Correct customizing of the DataSource involves setting data type CURR for amount fields and associating it with a currency field or specifying a fixed currency. It's crucial to match the formatting of original data with SAP's internal format requirements—either "internal" if it has two decimal places and no thousand separators or "external" to align with the TCURX table settings. Additionally, users should be aware of the location of decimal and thousand separators, which can be manually adjusted in user settings for precision in data representation.
Key words :
single quotation marks, correct result accidentally, data type curr, solution sap format, bw background user, correctthe external format, decimal separatorin addition, thousand period setting, internal sap format, examplethe currencies jpy
Related Notes :
| 1240163 | Amount too high by factor of 100 for HUF, JPY currencies |