You can maintain formatting settings for the numerical display of key figures (such as decimal places, scaling factors, highlighting, local calculations and formula collisions) in various places in the system.
You are already able to change formatting such as decimal places and scaling factors in theInfoObject Maintenance (underTab Page: Additional Properties). In the Query Designer, you can make changes to the formatting settings in the Properties of Structure Elements. You can override these settings during the Analysis in Web or in theBEx Analyzer.
The system functions so that always the last made setting is displayed. In addition to the setting, the system also saves the order in which the settings were made and displays the last made setting.
Settings for the Properties of Structure Elements
Collisions may arise with settings for the properties of structure elements in the Query Designer when two structures are involved.
When a structure element of the row structure gets a scaling factor of 1000 and a structure element of the column structure gets a scaling factor of 10, a cell results in which the two settings collide. In this cell, the system has to decide which of the two scaling factors, for the row (1000) or the column (10) is displayed.
The priority rule - that the last changed setting is the one used - as described above is also valid here.
Unanticipated display results can arise when using reusable structures, since the settings sequence is saved for each query and the sequence information in the other queries in which the structure is used is not fully available.
For more information, see SAP note 568630 under point 3.
Decimal Places
The settings for decimal places have the following priority:
The following applies if you have not made a setting:
The following applies if you have not made a setting:
The following applies if you have not made a setting:
This generic standard stands for currencies in table TCURR, for amounts in table T006. The standard settings are moved for the counter and quotient, the currency settings are moved for price (calculation accuracy takes up several positions.)
The generic standard is set as follows:
Amount: 2 decimal places
Amount: 3 decimal places
Price: 2 decimal places
Counter: 0 decimal places
Quotient: 4 decimal places
Float: 7 decimal places
Others: 5 decimal places
Note the following when displaying decimal places: