SAP ABAP Table TCY07 (Sel. profiles (Sets for sel. screens & interv. for display))

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	TCY07	Table Relationship Diagram
Short Description	Sel. profiles (Sets for sel. screens & interv. for display)

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	SETPROF_ID	☑	SETPROF_ID	SETPROF_ID	CHAR	10	0	ID of a user-spec. profile in the tab. for selectn. profiles
3	SETTAB	☐	SETTABLE	AS4TAB	CHAR	30	0	Table for set	*
4	ARBPL_SET	☐	ARBPL_SET	SETNAME	CHAR	24	0	Name of the work center set	SETHEADER
5	AUFTR_SET	☐	AUFTR_SET	SETNAME	CHAR	24	0	Name of the order set	SETHEADER
6	KAPAR_SET	☐	KAPAR_SET	SETNAME	CHAR	24	0	Name of the capacity category set	SETHEADER
7	ANFNG_SET	☐	ANFNG_SET	SETNAME	CHAR	24	0	Name of the work center-set for the initial screen	SETHEADER
8	BDATUM	☐	BDATUM_CNT	DAYCNT	DEC	5	0	Offset (in days) of start date to current date
9	SDATUM	☐	SDATUM_CNT	DAYCNT	DEC	5	0	Offset (in days) of end date to current date
10	DATE_TYPE	☐	CY_DBDATY	CY_ZAPER	CHAR	1	0	Type of date specification
11	DBDATEFROM	☐	CY_DBDATEF	CHAR10	CHAR	10	0	Start date for data base selection
12	DBDATETO	☐	CY_DBDATET	CHAR10	CHAR	10	0	Finish date for data base selection
13	TERMLEVEL	☐	SCHED_TYPE	SCHED_TYPE	CHAR	1	0	Scheduling level
14	SHOPORDER	☐	CY_SHOPORD	KREUZ	CHAR	1	0	Capacity requirements of work orders are read
15	PLANORDER	☐	CY_PLANORD	KREUZ	CHAR	1	0	Capacity requirements from planned orders are read
16	SOPORDER	☐	CY_SOPORD	KREUZ	CHAR	1	0	Capacity requirements from SOP orders are read
17	AVAICAPVER	☐	CY_CAPVER	KAPVERSION	NUMC	2	0	Version of available capacity	TC36

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	TCY07	ANFNG_SET	SETHEADER	SETNAME	REF	1	1
2	TCY07	ARBPL_SET	SETHEADER	SETNAME	REF	1	1
3	TCY07	AUFTR_SET	SETHEADER	SETNAME	REF	1	1
4	TCY07	AVAICAPVER	TC36	VERSN	KEY	1	CN
5	TCY07	KAPAR_SET	SETHEADER	SETNAME	REF	1	1
6	TCY07	MANDT	T000	MANDT	KEY	1	CN

History

Last changed by/on	SAP	20050411
SAP Release Created in