SAP Table
TCY60 List profile for capacity leveling
SAP table TCY60 has 2 primary key fields being MANDT,LIPRO_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
TCY60 columns.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| KeyMANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |||||
| KeyLIPRO_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 | ||||||
|
|||||||||||
/ Relationships
TCY60 foreign keys.
| Table | Field | Check Table | Description | Check Field |
|---|---|---|---|---|
| TCY60 | PROFID_DET | TCYD | Profile for detailed capacity list | MANDT |
| TCY60 | PROFID_DET | TCYD | Profile for detailed capacity list | TABNAME |
| TCY60 | PROFID_DET | TCYD | Profile for detailed capacity list | PROFID_LIS |
| TCY60 | PROFID_LIS | TCYD | Profile for detailed capacity list | MANDT |
| TCY60 | PROFID_LIS | TCYD | Profile for detailed capacity list | TABNAME |
| TCY60 | PROFID_LIS | TCYD | Profile for detailed capacity list | PROFID_LIS |
| TCY60 | PROFID_STA | TCYD | Profile for detailed capacity list | MANDT |
| TCY60 | PROFID_STA | TCYD | Profile for detailed capacity list | TABNAME |
| TCY60 | PROFID_STA | TCYD | Profile for detailed capacity list | PROFID_LIS |
| TCY60 | TABNAME | TCYE | Capacity planning: Object type table for detailed cap. list | TABNAME |
| TCY60 | TABNAMEDET | TCYE | Capacity planning: Object type table for detailed cap. list | TABNAME |
| TCY60 | TABNAMESTA | TCYE | Capacity planning: Object type table for detailed cap. list | TABNAME |