SAP table TKA03 (Statistical key figures)
SAP table TKA03 has 3 primary key fields being MANDT,KOKRS,STAGR.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
Field
Description
Data Type
Length
Decimals
Checktable
Data Element
Client
CLNT
3
0
T000
MANDT
Controlling Area
CHAR
4
0
TKA01
KOKRS
Statistical key figure
CHAR
6
0
STAGR
MSEHI
Unit for Statistical Key Figure
UNIT
3
0
T006
SEINH
GRTYP
Statistical Key Figure Category
CHAR
1
0
GRTYP
Possible values
1
Fixed values
2
Totals values
HKTYP
Flag if indicator is derived from LIS or set manually
CHAR
1
0
HKTYP
Possible values
Stat.key figure entered manually
A
Stat.key figure determined automatically
STRUCT
Generated DDIC table for LIS, conditions, messages
CHAR
30
0
*
GSTRU
KENNZ
Key Figure from LIS
CHAR
30
0
*
K_FIELD
W_FLAG
Indicator if statistical ratio describes a currency
CHAR
1
0
W_FLAG
Possible values
Statistical base relates to quantity
X
Statistical base relates to currencies
M_PLAN
Process planned values
CHAR
1
0
M_PLAN
Possible values
0
Existing Values Are Overwritten
1
Calculated Values Are Added to Existing Values
M_IST
Actual value processing
CHAR
1
0
M_IST
Possible values
0
Existing Values Are Overwritten
1
Calculated Values Are Added to Existing Values
TKA03 foreign key relationships
Table
Field
Check Table
Check Field
0 TKA03
KOKRS
TKA01 Controlling Areas
MANDT
1 TKA03
MSEHI
T006 Units of Measurement
MANDT