SAP Table TCY60
List profile for capacity leveling
TCY60 (List profile for capacity leveling) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link TCY60 to other SAP tables.
TCY60 table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |||||||
|
LIPRO_ID
List profile
|
CY_LIPRO |
CHAR
|
10 | 0 | ||||||||
|
TABNAME
Table Name
|
TABNAME | TCYE |
CHAR
|
30 | 0 | |||||||
|
PROFID_LIS
Profile for a list version
|
PROFID_LIS | TCYD |
CHAR
|
12 | 0 | |||||||
|
TABNAMESTA
Table Name
|
TABNAME | TCYE |
CHAR
|
30 | 0 | |||||||
|
TABNAMEDET
Table Name
|
TABNAME | TCYE |
CHAR
|
30 | 0 | |||||||
|
PROFID_STA
Profile for list version of standard overview
|
PROFID_STA | TCYD |
CHAR
|
12 | 0 | |||||||
|
PROFID_DET
Profile for list version of detailed capacity list
|
PROFID_DET | TCYD |
CHAR
|
12 | 0 | |||||||
|
DEFLISTE
Default list for evaluation from leveling
|
CY_DEFLISE |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
TCY60 foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| TCY60 | MANDT | TCY60 | MANDT |
T000
Clients
|
MANDT |
| TCY60 | PROFID_DET | SYST | MANDT |
TCYD
Profile for detailed capacity list
|
MANDT |
| TCY60 | PROFID_DET | 'CYDETAIL' |
TCYD
Profile for detailed capacity list
|
TABNAME | |
| TCY60 | PROFID_DET | TCY60 | PROFID_DET |
TCYD
Profile for detailed capacity list
|
PROFID_LIS |
| TCY60 | PROFID_LIS | TCY60 | PROFID_LIS |
TCYD
Profile for detailed capacity list
|
PROFID_LIS |
| TCY60 | PROFID_LIS | SYST | MANDT |
TCYD
Profile for detailed capacity list
|
MANDT |
| TCY60 | PROFID_LIS | TCY60 | TABNAME |
TCYD
Profile for detailed capacity list
|
TABNAME |
| TCY60 | PROFID_STA | SYST | MANDT |
TCYD
Profile for detailed capacity list
|
MANDT |
| TCY60 | PROFID_STA | 'CYSTANDA' |
TCYD
Profile for detailed capacity list
|
TABNAME | |
| TCY60 | PROFID_STA | TCY60 | PROFID_STA |
TCYD
Profile for detailed capacity list
|
PROFID_LIS |
| TCY60 | TABNAME | TCY60 | TABNAME |
TCYE
Capacity planning: Object type table for detailed cap. list
|
TABNAME |
| TCY60 | TABNAMEDET | TCY60 | TABNAMEDET |
TCYE
Capacity planning: Object type table for detailed cap. list
|
TABNAME |
| TCY60 | TABNAMESTA | TCY60 | TABNAMESTA |
TCYE
Capacity planning: Object type table for detailed cap. list
|
TABNAME |