SAP table TCY30 (Overall profile for capacity leveling)
SAP table TCY30 has 2 primary key fields being MANDT,PROFILE_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 | |
| PROFILE_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 |
TCY30 foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 TCY30 | ANPRO_ID | TCY34 | Evaluation profile for capacity leveling | MANDT |
| 0 TCY30 | ANPRO_ID | TCY34 | Evaluation profile for capacity leveling | ANPRO_ID |
| 1 TCY30 | COPRO_ID | TCY49 | Control profile for capacity leveling | MANDT |
| 1 TCY30 | COPRO_ID | TCY49 | Control profile for capacity leveling | COPRO_ID |
| 0 TCY30 | LIPRO_ID | TCY60 | List profile for capacity leveling | MANDT |
| 0 TCY30 | LIPRO_ID | TCY60 | List profile for capacity leveling | LIPRO_ID |
| 1 TCY30 | PEPRO_ID | TCY35 | Period profile for capacity leveling | MANDT |
| 1 TCY30 | PEPRO_ID | TCY35 | Period profile for capacity leveling | PEPRO_ID |
| 0 TCY30 | PLTPROF_ID | TCY48 | Profile for the planning table | MANDT |
| 0 TCY30 | PLTPROF_ID | TCY48 | Profile for the planning table | PLTPROF_ID |
| 1 TCY30 | SEPRO_ID | TCY32 | Selection profile for capacity leveling | MANDT |
| 1 TCY30 | SEPRO_ID | TCY32 | Selection profile for capacity leveling | SEPRO_ID |
| 0 TCY30 | STPRO_ID | TCY37 | Strategy profile for capacity leveling | MANDT |
| 0 TCY30 | STPRO_ID | TCY37 | Strategy profile for capacity leveling | STPRO_ID |
| 1 TCY30 | TIPRO_ID | TCY33 | Time profile for capacity leveling | MANDT |
| 1 TCY30 | TIPRO_ID | TCY33 | Time profile for capacity leveling | TIPRO_ID |
| 0 TCY30 | TPPRO_ID | TCY56 | Profile for planning table (tabular form) in cap. leveling | MANDT |
| 0 TCY30 | TPPRO_ID | TCY56 | Profile for planning table (tabular form) in cap. leveling | TPPRO_ID |