SAP table TCY08 (Option profiles)

SAP table TCY08 has 2 primary key fields being MANDT,DARPROF_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
DARPROF_ID ID of a user-spec. profile in the table for option profiles CHAR 10 0 DARPROF_ID
HIEVER Cumulate capacity requirements using work center hierarchy CHAR 1 0 HIEVER
HIEAUF Explode hierarchy CHAR 1 0 HIEAUF
KUMUL Indicator, whether cumulated display is desired CHAR 1 0 KUMULD
MINBEL Minimum load that will be displayed DEC 3 0 MINBELA
MAXBEL Maximum load that will be displayed DEC 3 0 MAXBELA
RUECKDAT Offset (in days) of dispatch date for backlog to curr. date DEC 5 0 RDATUM_CNT
PEINHEIT Unit in which the period duration is specified (day, week..) CHAR 1 0 DAPER
A Day
B Factory calendar day
C Week
D Month
E Posting period
F Calendar year
G Fiscal year
H Shift
I Planning Calendar
PDAUER Duration of a period (units as specified in period type) DEC 3 0 DAPED
LIBART Requirements category (scheduled or remaining) CHAR 1 0 CY_SBART
1 Planned requirements
2 Rem.reqmts
ZAPER Type of date specification CHAR 1 0 CY_ZAPER
A Calendar day
B Factory calendar day
C Calendar week
D Calendar month
E Posting period
F Calendar year
G Number of calendar days
H Number of factory calendar days
I Number of calendar weeks
J Number of calendar months
K Number of posting periods
L Number of calendar years
LIDAVCNT Offset (in days) of start date for lists to current date DEC 5 0 CY_DCNTV
LIDABCNT Offset (in days) of end date for lists to current date DEC 5 0 CY_DCNTB
LIEINH 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
HNAME Name of Hierarchy CHAR 10 0 CR_HNAME
HWERKS Plant CHAR 4 0 T001W WERKS_D
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
POOLKAP Indicator: Cumulated view of the rqmts of pooled capacity CHAR 1 0 CY_POOLKAP
TT_FAUFT Indicator: Branch to production order - change or display CHAR 1 0 CY_TTFAUFT
TT_PAUFT Indicator: Branch to planned order display or maintenance CHAR 1 0 CY_TTPAUFT
TT_ARBPL Switch: Branch to work center - change or display CHAR 1 0 CY_TTARBPL
ANVER Cumulate available capacity using work center hierarchy CHAR 1 0 CY_ANVER
static available capacity cumulation
X dynamic available capacity cumulation
DATEFROM Start date for output of capacity evaluations CHAR 10 0 CY_DATEF
DATETO Finish date for output of capacity evaluations CHAR 10 0 CY_DATET
RDATE_TYPE Type of date specification CHAR 1 0 CY_RDATETY
RDATE Date of backlog dispatching CHAR 10 0 CY_RDATE
MRPP PPC Planning Calendar CHAR 3 0 T439G MRPPP
UNITSOURCE Origin of unit of measure for available cap. and cap.reqmts CHAR 1 0 CY_UNITSRC
PPSWERK Plant CHAR 4 0 T001W WERKS_D

TCY08 foreign key relationships

Table Field Check Table Check Field
0 TCY08 HWERKS T001W Plants/Branches WERKS
1 TCY08 LIEINH T006 Units of Measurement MANDT
0 TCY08 MRPP T439G PP Planning periods: header table MANDT
0 TCY08 MRPP T439G PP Planning periods: header table WERKS
1 TCY08 PPSWERK T001W Plants/Branches WERKS
0 TCY08 VERTL1 TC29 Distribution key for capacity load MANDT
1 TCY08 VERTLN TC29 Distribution key for capacity load MANDT