SAP ABAP Table TCY08 (Option profiles)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ CY (Package) R/3 Application development: Capacity Planning

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	TCY08	Table Relationship Diagram
Short Description	Option profiles

Delivery and Maintenance

Pool/cluster
Delivery Class	E	Control table, SAP and customer have separate key areas
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	DARPROF_ID	☑	DARPROF_ID	DARPROF_ID	CHAR	10	0	ID of a user-spec. profile in the table for option profiles
3	HIEVER	☐	HIEVER	KREUZ	CHAR	1	0	Cumulate capacity requirements using work center hierarchy
4	HIEAUF	☐	HIEAUF	KREUZ	CHAR	1	0	Explode hierarchy
5	KUMUL	☐	KUMULD	KREUZ	CHAR	1	0	Indicator, whether cumulated display is desired
6	MINBEL	☐	MINBELA	BELAST	DEC	3	0	Minimum load that will be displayed
7	MAXBEL	☐	MAXBELA	BELAST	DEC	3	0	Maximum load that will be displayed
8	RUECKDAT	☐	RDATUM_CNT	DAYCNT	DEC	5	0	Offset (in days) of dispatch date for backlog to curr. date
9	PEINHEIT	☐	DAPER	DAPER	CHAR	1	0	Unit in which the period duration is specified (day, week..)
10	PDAUER	☐	DAPED	CY_DAPED	DEC	3	0	Duration of a period (units as specified in period type)
11	LIBART	☐	CY_SBART	CY_SBART	CHAR	1	0	Requirements category (scheduled or remaining)
12	ZAPER	☐	CY_ZAPER	CY_ZAPER	CHAR	1	0	Type of date specification
13	LIDAVCNT	☐	CY_DCNTV	DAYCNT	DEC	5	0	Offset (in days) of start date for lists to current date
14	LIDABCNT	☐	CY_DCNTB	DAYCNT	DEC	5	0	Offset (in days) of end date for lists to current date
15	LIEINH	☐	CY_KEINH	MEINS	UNIT	3	0	Unit of of measure for displaying capacity requirements	T006
16	DAVAP	☐	DAVAP	XFELD	CHAR	1	0	Distribution according to key in work center or operation
17	HNAME	☐	CR_HNAME	CHAR10	CHAR	10	0	Name of hierarchy
18	HWERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
19	VERTL1	☐	CR_VERTL	CR_VERTL	CHAR	8	0	Distribution of capacity requirements (Planned/prod.order)	TC29
20	VERTLN	☐	CR_VERTLN	CR_VERTL	CHAR	8	0	Distr.cap.reqmts (plant maint.,process order, network)	TC29
21	POOLKAP	☐	CY_POOLKAP	KREUZ	CHAR	1	0	Indicator: Cumulated view of the rqmts of pooled capacity
22	TT_FAUFT	☐	CY_TTFAUFT	CY_TRANSTY	CHAR	1	0	Indicator: Branch to production order - change or display
23	TT_PAUFT	☐	CY_TTPAUFT	CY_TRANSTY	CHAR	1	0	Indicator: Branch to planned order display or maintenance
24	TT_ARBPL	☐	CY_TTARBPL	CY_TRANSTY	CHAR	1	0	Switch: Branch to work center - change or display
25	ANVER	☐	CY_ANVER	CY_ANVER	CHAR	1	0	Cumulate available capacity using work center hierarchy
26	DATEFROM	☐	CY_DATEF	CHAR10	CHAR	10	0	Start date for output of capacity evaluations
27	DATETO	☐	CY_DATET	CHAR10	CHAR	10	0	Finish date for output of capacity evaluations
28	RDATE_TYPE	☐	CY_RDATETY	CY_ZAPER	CHAR	1	0	Type of date specification
29	RDATE	☐	CY_RDATE	CHAR10	CHAR	10	0	Date of backlog dispatching
30	MRPP	☐	MRPPP	MRPPP	CHAR	3	0	PPC planning calendar	T439G
31	UNITSOURCE	☐	CY_UNITSRC	KREUZ	CHAR	1	0	Origin of unit of measure for available cap. and cap.reqmts
32	PPSWERK	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	TCY08	HWERKS	T001W	WERKS	KEY	1	CN
2	TCY08	LIEINH	T006	MSEHI	KEY	1	CN
3	TCY08	MANDT	T000	MANDT	KEY	1	CN
4	TCY08	MRPP	T439G	MRPPP	REF	1	CN
5	TCY08	PPSWERK	T001W	WERKS	REF	1	CN
6	TCY08	VERTL1	TC29	VERTL	KEY	1	CN
7	TCY08	VERTLN	TC29	VERTL	KEY	1	CN

History

Last changed by/on	SAP	20050411
SAP Release Created in