Show TOC

Tab Page: Type/UnitLocate this document in the navigation structure

Key Figure Type

Specify the Type. Amounts and quantities need unit fields.

Data Type

Specify the Data Type. For the amount, quantity, and number, you can choose either decimal numbers or floating point numbers. For the key figures date and time, you can choose the decimal display to apply to the fields.
Note Using floating point numbers results in unavoidable rounding errors in all arithmetical operations. We therefore advise against using floating point numbers for amounts and quantities which exact results are required for. SAP Note 2798 Information published on SAP site describes this problem and illustrates it with the help of a few examples.

The following combinations of key figure and data type are possible:

Key Figure Type

Data Type

AMO Amount

CURR: Currency field, created as DEC

FLTP: Floating point number with 8 byte precision

QUA Quantity

QUAN: Quantity field, created as DEC

FLTP: Floating point number with 8 byte precision

NUM Number

DEC: Calculation field or amount field with decimal point and sign

FLTP: Floating point number with 8 byte precision

INT integer

INT4: 4 byte integer, whole number with +/- sign

DAT Date

DATS: Date field (YYYYMMDD), created as char(8)

DEC: Calculation field or amount field with decimal point and +/- sign

TIM Time

TIMS: Time field (hhmmss), created as CHAR(6)

DEC: Calculation field or amount field with decimal point and +/- sign

Currency/Quantity Unit

You can assign a Fixed Currency to the key figure. If this field is filled, the key figure bears this currency throughout BW.

You can also assign a variable currency to the key figure. In the Unit/Currency field, you determine which InfoObject bears the key figure unit. For quantities or amount key figures, either this field must be filled or you have to enter a fixed currency or amount unit.