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

SAP table TCY07 has 2 primary key fields being MANDT,SETPROF_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
SETPROF_ID ID of a user-spec. profile in the tab. for selectn. profiles CHAR 10 0 SETPROF_ID
SETTAB Table for set CHAR 30 0 * SETTABLE
ARBPL_SET Name of the work center set CHAR 24 0 SETHEADER ARBPL_SET
AUFTR_SET Name of the order set CHAR 24 0 SETHEADER AUFTR_SET
KAPAR_SET Name of the capacity category set CHAR 24 0 SETHEADER KAPAR_SET
ANFNG_SET Name of the work center-set for the initial screen CHAR 24 0 SETHEADER ANFNG_SET
BDATUM Offset (in days) of start date to current date DEC 5 0 BDATUM_CNT
SDATUM Offset (in days) of end date to current date DEC 5 0 SDATUM_CNT
DATE_TYPE Type of date specification CHAR 1 0 CY_DBDATY
DBDATEFROM Start date for data base selection CHAR 10 0 CY_DBDATEF
DBDATETO End Date for Database Selection CHAR 10 0 CY_DBDATET
TERMLEVEL Scheduling level CHAR 1 0 SCHED_TYPE
1 Detailed Planning
SHOPORDER Capacity requirements of work orders are read CHAR 1 0 CY_SHOPORD
PLANORDER Capacity requirements from planned orders are read CHAR 1 0 CY_PLANORD
SOPORDER Capacity requirements from SOP orders are read CHAR 1 0 CY_SOPORD
AVAICAPVER Version of available capacity NUMC 2 0 TC36 CY_CAPVER

TCY07 foreign key relationships

Table Field Check Table Check Field
0 TCY07 ANFNG_SET SETHEADER Set Header and Directory MANDT
0 TCY07 ANFNG_SET SETHEADER Set Header and Directory SETCLASS
0 TCY07 ANFNG_SET SETHEADER Set Header and Directory SETNAME
1 TCY07 ARBPL_SET SETHEADER Set Header and Directory MANDT
1 TCY07 ARBPL_SET SETHEADER Set Header and Directory SETCLASS
1 TCY07 ARBPL_SET SETHEADER Set Header and Directory SETNAME
0 TCY07 AUFTR_SET SETHEADER Set Header and Directory MANDT
0 TCY07 AUFTR_SET SETHEADER Set Header and Directory SETCLASS
0 TCY07 AUFTR_SET SETHEADER Set Header and Directory SETNAME
1 TCY07 AVAICAPVER TC36 Available capacity version MANDT
1 TCY07 AVAICAPVER TC36 Available capacity version VERSN
0 TCY07 KAPAR_SET SETHEADER Set Header and Directory MANDT
0 TCY07 KAPAR_SET SETHEADER Set Header and Directory SETCLASS
0 TCY07 KAPAR_SET SETHEADER Set Header and Directory SETNAME