SAP table TCY34 (Evaluation profile for capacity leveling)
SAP table TCY34 has 2 primary key fields being MANDT,ANPRO_ID.
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
MANDT
Client
CLNT
3
0
T000
MANDT
ANPRO_ID
Evaluation profile for capacity leveling/extended evaluation
CHAR
10
0
CY_ANPRO
HIEAUF
Explode hierarchy
CHAR
1
0
HIEAUF
HIEVER
Cumulate capacity requirements using work center hierarchy
CHAR
1
0
HIEVER
ANVER
Cumulate available capacity using work center hierarchy
CHAR
1
0
CY_ANVER
Possible values
static available capacity cumulation
X
dynamic available capacity cumulation
HNAME
Name of Hierarchy
CHAR
10
0
CR_HNAME
HWERKS
Plant
CHAR
4
0
T001W
WERKS_D
POOLKAP
Indicator: Cumulated view of the rqmts of pooled capacity
CHAR
1
0
CY_POOLKAP
MINBEL
Minimum load that will be displayed
DEC
3
0
MINBELA
MAXBEL
Maximum load that will be displayed
DEC
3
0
MAXBELA
CAPUNIT
Unit of Measure for Capacity Requirements
UNIT
3
0
T006
CY_KEINH
DAVAP
Distribution according to key in work center or operation
CHAR
1
0
DAVAP
VERTL1
Distribution of Capacity Requirements (Planned/Prodn Order)
CHAR
8
0
TC29
CR_VERTL
VERTLN
Distr.cap.reqmts (plant maint.,process order, network)
CHAR
8
0
TC29
CR_VERTLN
UNITSOURCE
Origin of unit of measure for available cap. and cap.reqmts
CHAR
1
0
CY_UNITSRC
INDCUMCAP
Indicator: Cumulation of available caps. via indiv. caps.
CHAR
1
0
CY_INDCUMC
INDCUMREQ
Indicator: Rqmts. cumulation via individual capacities
CHAR
1
0
CY_INDCUMR
TCY34 foreign key relationships
Table
Field
Check Table
Check Field
0 TCY34
CAPUNIT
T006
Units of Measurement
MANDT
0 TCY34
CAPUNIT
T006
Units of Measurement
MSEHI
1 TCY34
HWERKS
T001W
Plants/Branches
WERKS
0 TCY34
VERTL1
TC29
Distribution key for capacity load
MANDT
1 TCY34
VERTLN
TC29
Distribution key for capacity load
MANDT