SAP table T237A (Display control for T237)
SAP table T237A has 4 primary key fields being MANDT,ERKRS,BERVA,ZEILE.
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
Operating concern
CHAR
4
0
TKEB
ERKRS
Key figure scheme
CHAR
2
0
T239
RKE_BERVA
Formula of a Key Figure Scheme
NUMC
4
0
RKE_ZEILE
WERTDAR
Display Factor
CHAR
1
0
RKE_WRTDAR
Possible values
Undefined
0
No factor
1
Display in 10s
2
Display in 100s
3
Display in 1,000s
4
Display in 10,000s
5
Display in 100,000s
6
Display in 1,000,000s
7
Display in 10,000,000s
8
Display in 100,000,000s
9
Display in 1,000,000,000s
DEZDAR
Number format
CHAR
1
0
RKE_DEZDAR
Possible values
Undefined
0
No decimal places
1
Display in the form 0.0
2
Display in the form 0.00
3
Display in the form 0.000
4
Display in the form 0.0000
5
Display in the form 0.00000
SUMKZ
Total indicator
CHAR
1
0
RKE_SUMKZ
MWKZ
Quantity/value flag
CHAR
1
0
RKE_MWKZ
Possible values
M
Quantity field
P
Prices
W
Value field
AGGTM
Aggregation based on time
CHAR
3
0
RKE_AGGTM
Possible values
AVG
Average
FIR
First value
LAS
Last value
MAX
Maximum
MIN
Minimum
NOP
No aggregation
SC+
Summation if > 0
SC-
Summation if < 0
SUM
Summation
AGGFI
Reference Field for Time-Based Aggregation
CHAR
30
0
*
CGSAGGFI
T237A foreign key relationships
Table
Field
Check Table
Check Field
0 T237A
BERVA
T239 Report version table
MANDT
0 T237A
BERVA
T239 Report version table
ERKRS
1 T237A
ERKRS
TKEB Management for Operating Concerns (Client-Specific)
MANDT
1 T237A
ERKRS
TKEB Management for Operating Concerns (Client-Specific)
ERKRS
0 T237A
MANDT
T000 Clients
MANDT