Child pages
  • Key Figures of data Type QUAN 'Quantity Field'
Skip to end of metadata
Go to start of metadata

The corresponding ABAP domain of a quantity key figure has 3 decimal places (see note 460652). Please note that for or a quantity key figure(and an amount key figure), you can only change the number of characters(if required) before the decimal point but not the number of decimal places (see note 460652). Hence, the number specified for the fields ANDEC and DECAN of table T006(see below) has to be smaller or equal to 3.

In case a query uses unit conversion and it is necessary to get more than 3 decimal places displayed for this converted key figure, you need create a formula where you e.g. just multiply the key figure by 1. The reason why this 'trick' works is that, in general, formulas can be displayed with the maximum of 9 decimal places.

See also OLAP: Decimal Places & Rounding.


The rounding that is to be used for specific units(in a query) can be defined in the customizing (Table T006, field ANDEC).

Unit KG
Transaction  SPRO -> SAP NetWeaver -> General Settings -> Check Units of Measurement -> select dimension "Mass" -> click on button "Units of measurement" -> Double click on unit KG
-> Setting for "Decimal pl- rounding"
=> Here you can define up to how many decimal places unit KG shall be rounded.

  • E.g. ANDEC=0; DECAN=3
    • Value in Provider(on database): KFQ = 1.123 KG
    • query: KFQ = 1.000 KG
  • E.g. ANDEC=2; DECAN=3
    • Value in Provider(on database): KFQ = 4.567 KG
    • query: KFQ = 4.570 KG
  • E.g. ANDEC=2; DECAN=1 
    • Value in Provider(on database): KFQ = 4.567 KG
    • query: KFQ = 4.6 KG

In this example it is assumed that the query only uses the basis key figure(no formula) and that the query setting regarding the number of decimal places is set to 'default'(see e.g. note 2313517).

Alternatively, you can also completely ignore the ANDEC settings for units by setting the RSADMIN parameter 'IGNORE_T006_ANDEC = X' (see note 866505).

See also note 2313517.

Number of Decimal Places

Table T006 has also the field DECAN. This parameter determines the number of decimal places with which this measurement unit is displayed in a query(see example above). This setting can be overwritten by corresponding settings of the key figure and query, see note 2313517 for further details.

SAP Consulting Notes  

  • 2895368 - BW Queries: Rounding of Quantity Key Figures
  • 2448651 - BW750 - Boolean operators with mixed units/currencies
  • 2313517 - Currency or Unit Dependent Decimal in a BW Query
  • 866505   - Unwanted rounding of units T006-ANDEC
  • 667288   - Unit or currency for key figures with value 0
  • 460652   - Extending key figures in BW
  • No labels