1. Home
  2. Resources
  3. SAP Tables
  4. TCY08 - Option profiles

SAP Table TCY08

Option profiles

TCY08 (Option profiles) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link TCY08 to other SAP tables.

TCY08 table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
DARPROF_ID ID of a user-spec. profile in the table for option profiles DARPROF_ID CHAR 10 0
HIEVER Cumulate capacity requirements using work center hierarchy HIEVER CHAR 1 0
X
NULL
HIEAUF Explode hierarchy HIEAUF CHAR 1 0
X
NULL
KUMUL Indicator, whether cumulated display is desired KUMULD CHAR 1 0
X
NULL
MINBEL Minimum load that will be displayed MINBELA DEC 3 0
MAXBEL Maximum load that will be displayed MAXBELA DEC 3 0
RUECKDAT Offset (in days) of dispatch date for backlog to curr. date RDATUM_CNT DEC 5 0
PEINHEIT Unit in which the period duration is specified (day, week..) DAPER CHAR 1 0
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) DAPED DEC 3 0
LIBART Requirements category (scheduled or remaining) CY_SBART CHAR 1 0
1 Planned requirements
2 Rem.reqmts
ZAPER Type of date specification CY_ZAPER CHAR 1 0
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 CY_DCNTV DEC 5 0
LIDABCNT Offset (in days) of end date for lists to current date CY_DCNTB DEC 5 0
LIEINH Unit of of measure for displaying capacity requirements CY_KEINH T006 UNIT 3 0
DAVAP Distribution according to key in work center or operation DAVAP CHAR 1 0
X Yes
NULL No
HNAME Name of hierarchy CR_HNAME CHAR 10 0
HWERKS Plant WERKS_D T001W CHAR 4 0
VERTL1 Distribution of capacity requirements (Planned/prod.order) CR_VERTL TC29 CHAR 8 0
VERTLN Distr.cap.reqmts (plant maint.,process order, network) CR_VERTLN TC29 CHAR 8 0
POOLKAP Indicator: Cumulated view of the rqmts of pooled capacity CY_POOLKAP CHAR 1 0
X
NULL
TT_FAUFT Indicator: Branch to production order - change or display CY_TTFAUFT CHAR 1 0
1 Change
2 Display
TT_PAUFT Indicator: Branch to planned order display or maintenance CY_TTPAUFT CHAR 1 0
1 Change
2 Display
TT_ARBPL Switch: Branch to work center - change or display CY_TTARBPL CHAR 1 0
1 Change
2 Display
ANVER Cumulate available capacity using work center hierarchy CY_ANVER CHAR 1 0
NULL static available capacity cumulation
X dynamic available capacity cumulation
DATEFROM Start date for output of capacity evaluations CY_DATEF CHAR 10 0
DATETO Finish date for output of capacity evaluations CY_DATET CHAR 10 0
RDATE_TYPE Type of date specification CY_RDATETY CHAR 1 0
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
RDATE Date of backlog dispatching CY_RDATE CHAR 10 0
MRPP PPC planning calendar MRPPP T439G CHAR 3 0
UNITSOURCE Origin of unit of measure for available cap. and cap.reqmts CY_UNITSRC CHAR 1 0
X
NULL
PPSWERK Plant WERKS_D T001W CHAR 4 0

TCY08 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
TCY08 HWERKS TCY08 MANDT T001W Plants/Branches MANDT
TCY08 HWERKS TCY08 HWERKS T001W Plants/Branches WERKS
TCY08 LIEINH TCY08 LIEINH T006 Units of Measurement MSEHI
TCY08 LIEINH TCY08 MANDT T006 Units of Measurement MANDT
TCY08 MANDT TCY08 MANDT T000 Clients MANDT
TCY08 MRPP TCY08 MANDT T439G PPplanning periods: header table MANDT
TCY08 MRPP TCY08 PPSWERK T439G PPplanning periods: header table WERKS
TCY08 MRPP TCY08 MRPP T439G PPplanning periods: header table MRPPP
TCY08 PPSWERK TCY08 MANDT T001W Plants/Branches MANDT
TCY08 PPSWERK TCY08 PPSWERK T001W Plants/Branches WERKS
TCY08 VERTL1 TCY08 VERTL1 TC29 Distribution key for capacity load VERTL
TCY08 VERTL1 TCY08 MANDT TC29 Distribution key for capacity load MANDT
TCY08 VERTLN TCY08 MANDT TC29 Distribution key for capacity load MANDT
TCY08 VERTLN TCY08 VERTLN TC29 Distribution key for capacity load VERTL