Key Figure Type
Specify the Type. Amounts and quantities need unit fields.
Data Type
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.