SAP table TCY60 (List profile for capacity leveling)

SAP table TCY60 has 2 primary key fields being MANDT,LIPRO_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
LIPRO_ID List profile CHAR 10 0 CY_LIPRO
TABNAME Table Name CHAR 30 0 TCYE TABNAME
PROFID_LIS Profile for a list version CHAR 12 0 TCYD PROFID_LIS
TABNAMESTA Table Name CHAR 30 0 TCYE TABNAME
TABNAMEDET Table Name CHAR 30 0 TCYE TABNAME
PROFID_STA Profile for list version of standard overview CHAR 12 0 TCYD PROFID_STA
PROFID_DET Profile for list version of detailed capacity list CHAR 12 0 TCYD PROFID_DET
DEFLISTE Default list for evaluation from leveling CHAR 1 0 CY_DEFLISE
0 Standard overview
1 Detailed capacity list

TCY60 foreign key relationships

Table Field Check Table Check Field
0 TCY60 PROFID_DET TCYD Profile for detailed capacity list MANDT
0 TCY60 PROFID_DET TCYD Profile for detailed capacity list TABNAME
0 TCY60 PROFID_DET TCYD Profile for detailed capacity list PROFID_LIS
1 TCY60 PROFID_LIS TCYD Profile for detailed capacity list MANDT
1 TCY60 PROFID_LIS TCYD Profile for detailed capacity list TABNAME
1 TCY60 PROFID_LIS TCYD Profile for detailed capacity list PROFID_LIS
0 TCY60 PROFID_STA TCYD Profile for detailed capacity list MANDT
0 TCY60 PROFID_STA TCYD Profile for detailed capacity list TABNAME
0 TCY60 PROFID_STA TCYD Profile for detailed capacity list PROFID_LIS
1 TCY60 TABNAME TCYE Capacity planning: Object type table for detailed cap. list TABNAME
0 TCY60 TABNAMEDET TCYE Capacity planning: Object type table for detailed cap. list TABNAME
1 TCY60 TABNAMESTA TCYE Capacity planning: Object type table for detailed cap. list TABNAME