SAP table TCY32 (Selection profile for capacity leveling)

SAP table TCY32 has 2 primary key fields being MANDT,SEPRO_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
SEPRO_ID Selection profile for capacity leveling/extended evaluation CHAR 10 0 CY_SEPRO
SETTAB Table for set CHAR 30 0 * SETTABLE
OBJ_SET Set for selection of objects CHAR 24 0 SETHEADER CY_OBJ_SET
FIL_SET Set for filtering objects CHAR 24 0 SETHEADER CY_FIL_SET
BEDGRU Requirements grouping CHAR 10 0 TCY31 CY_BEDGRU
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
HIERRES Explode hierarchy CHAR 1 0 HIEAUF
INDCAPRES Planning to individual capacities CHAR 1 0 CY_EINZELK
AVAICAPVER Version of available capacity NUMC 2 0 TC36 CY_CAPVER
MARK_KEY Selection key for selection objects on planning table CHAR 10 0 TCY38_M CYMARK_KEY
SOLLBED Display planned capacity requirements in extended evaluation CHAR 1 0 CY_SBEDKZ
RESTBED Display remaining capacity reqmts in extended evaluation CHAR 1 0 CY_RBEDKZ
ISTBED Display actual capacity requirements in extended evaluation CHAR 1 0 CY_IBEDKZ

TCY32 foreign key relationships

Table Field Check Table Check Field
0 TCY32 AVAICAPVER TC36 Available capacity version MANDT
0 TCY32 AVAICAPVER TC36 Available capacity version VERSN
1 TCY32 BEDGRU TCY31 Standard requirements groupings for resource planning MANDT
1 TCY32 BEDGRU TCY31 Standard requirements groupings for resource planning BEDGRU
0 TCY32 FIL_SET SETHEADER Set Header and Directory MANDT
0 TCY32 FIL_SET SETHEADER Set Header and Directory SETCLASS
0 TCY32 FIL_SET SETHEADER Set Header and Directory SETNAME
1 TCY32 MARK_KEY TCY38_M Sort key for the planning table MANDT
1 TCY32 MARK_KEY TCY38_M Sort key for the planning table SORT_KEY
0 TCY32 OBJ_SET SETHEADER Set Header and Directory MANDT
0 TCY32 OBJ_SET SETHEADER Set Header and Directory SETCLASS
0 TCY32 OBJ_SET SETHEADER Set Header and Directory SETNAME