SAP Table
TCY30 Overall profile for capacity leveling
SAP table TCY30 has 2 primary key fields being MANDT,PROFILE_ID.
If you are only analysing data from a single SAP instance you may omit field MANDT in your relationships as it will be the same across the entire dataset. On the other hand, if you are combining data from multiple SAP instances you need to take MANDT into account.
/ Fields
TCY30 columns.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| KeyMANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |
| KeyPROFILE_ID | Overall profile for capacity leveling | CHAR | 10 | 0 | CY_GESPROF | ||
| SEPRO_ID | Selection profile for capacity leveling/extended evaluation | CHAR | 10 | 0 | TCY32 | CY_SEPRO | |
| TIPRO_ID | Time profile for capacity leveling/extended evaluation | CHAR | 10 | 0 | TCY33 | CY_TIPRO | |
| ANPRO_ID | Evaluation profile for capacity leveling/extended evaluation | CHAR | 10 | 0 | TCY34 | CY_ANPRO | |
| PEPRO_ID | Period profile for capacity leveling/extended evaluation | CHAR | 10 | 0 | TCY35 | CY_PEPRO | |
| PLTPROF_ID | Profile for the planning table | CHAR | 10 | 0 | TCY48 | PLT_PROF | |
| STPRO_ID | Strategy profile for capacity leveling | CHAR | 10 | 0 | TCY37 | CY_STPRO | |
| COPRO_ID | Control profile for capacity leveling/extended evaluation | CHAR | 10 | 0 | TCY49 | CY_COPRO | |
| TPPRO_ID | Profile for planning table (tabular form) in cap. leveling | CHAR | 10 | 0 | TCY56 | CY_TPPRO | |
| LIPRO_ID | List profile | CHAR | 10 | 0 | TCY60 | CY_LIPRO |
/ Relationships
TCY30 foreign keys.
| Table | Field | Check Table | Description | Check Field |
|---|---|---|---|---|
| TCY30 | ANPRO_ID | TCY34 | Evaluation profile for capacity leveling | MANDT |
| TCY30 | ANPRO_ID | TCY34 | Evaluation profile for capacity leveling | ANPRO_ID |
| TCY30 | COPRO_ID | TCY49 | Control profile for capacity leveling | MANDT |
| TCY30 | COPRO_ID | TCY49 | Control profile for capacity leveling | COPRO_ID |
| TCY30 | LIPRO_ID | TCY60 | List profile for capacity leveling | MANDT |
| TCY30 | LIPRO_ID | TCY60 | List profile for capacity leveling | LIPRO_ID |
| TCY30 | PEPRO_ID | TCY35 | Period profile for capacity leveling | MANDT |
| TCY30 | PEPRO_ID | TCY35 | Period profile for capacity leveling | PEPRO_ID |
| TCY30 | PLTPROF_ID | TCY48 | Profile for the planning table | MANDT |
| TCY30 | PLTPROF_ID | TCY48 | Profile for the planning table | PLTPROF_ID |
| TCY30 | SEPRO_ID | TCY32 | Selection profile for capacity leveling | MANDT |
| TCY30 | SEPRO_ID | TCY32 | Selection profile for capacity leveling | SEPRO_ID |
| TCY30 | STPRO_ID | TCY37 | Strategy profile for capacity leveling | MANDT |
| TCY30 | STPRO_ID | TCY37 | Strategy profile for capacity leveling | STPRO_ID |
| TCY30 | TIPRO_ID | TCY33 | Time profile for capacity leveling | MANDT |
| TCY30 | TIPRO_ID | TCY33 | Time profile for capacity leveling | TIPRO_ID |
| TCY30 | TPPRO_ID | TCY56 | Profile for planning table (tabular form) in cap. leveling | MANDT |
| TCY30 | TPPRO_ID | TCY56 | Profile for planning table (tabular form) in cap. leveling | TPPRO_ID |