Solution : https://service.sap.com/sap/support/notes/155837 (SAP Service marketplace login required)
Summary :
This SAP Note discusses the behavior of decimal places in SAP worksheets when interfacing with Excel. It outlines the prioritization of settings affecting the presentation of decimals, emphasizing different layers where these settings can be applied—from spreadsheet configurations to InfoObject defaults and generic settings for different data types like quantities in T006 and currencies in TCURR. When settings are changed, it may require a log-off or a system refresh to reflect updates. The note identifies issues with decimal display in Transaction RSRT and advises on handling settings changes within infrequently updated areas like T006 or InfoObject tables.
Key words :
excel additional key words bw, special sap default applies, calculated key figure, restricted key figure, special sap default, business information warehouse, generic default applies, 2 decimal places quantity, 3 decimal places price, 2 decimal places counter
Related Notes :
| 1240163 | Amount too high by factor of 100 for HUF, JPY currencies |
| 377847 | Display of only rounded quantities |
| 339476 | Tips & tricks for variables part III |
| 144699 | Decimal places of key figures |