SAP Table TCYD
Profile for detailed capacity list
TCYD (Profile for detailed capacity list) 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 TCYD to other SAP tables.
TCYD table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |||||||
|
TABNAME
Table Name
|
TABNAME | TCYE |
CHAR
|
30 | 0 | |||||||
|
PROFID_LIS
Profile for a list version
|
PROFID_LIS |
CHAR
|
12 | 0 | ||||||||
|
SELSET_FLT
Variant for general filter
|
SELSET_FLT |
CHAR
|
14 | 0 | ||||||||
|
PROF_FD
Profile for fields displayed
|
PROF_FD | TCYF |
CHAR
|
12 | 0 | |||||||
|
PROF_SR
Profile for sort criteria
|
PROF_SR | TCYS |
CHAR
|
12 | 0 | |||||||
|
PROF_GP
Profile for grouping criteria
|
PROF_GP | TCYP |
CHAR
|
12 | 0 | |||||||
|
FLG_GRP
Indicator: Grouping will be displayed
|
PS_FLG_GRP |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
FLG_PWT
Indicator: numerical, summable fields as percentage values
|
PS_FLG_PWT |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
FLG_SRA
Indicator: sort in descending order
|
PS_FLG_SRA |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
FLG_ORG
Indicator: original column width
|
PS_FLG_ORG |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
WRT_OBJ
Width of the object column
|
PS_WRT_OBJ |
NUMC
|
2 | 0 | ||||||||
|
WRT_FLD
Width of the field columns
|
PS_WRT_FLD |
NUMC
|
2 | 0 | ||||||||
|
SELSET_BFT
Variants for user-defined filters
|
SELSET_BFT |
CHAR
|
14 | 0 | ||||||||
|
AENAM
Last changed by
|
PS_AENAM |
CHAR
|
12 | 0 | ||||||||
|
PROTECT
Indicator: Protected entry
|
PS_PROTECT |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
CUSTOM
Indicator: Maintenance only allowed from initial menu
|
PS_CUSTOM |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
TCYD foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| TCYD | MANDT | TCYD | MANDT |
T000
Clients
|
MANDT |
| TCYD | PROF_FD | TCYD | MANDT |
TCYF
Profile detailed list: Displayed fields
|
MANDT |
| TCYD | PROF_FD | TCYD | TABNAME |
TCYF
Profile detailed list: Displayed fields
|
TABNAME |
| TCYD | PROF_FD | TCYD | PROF_FD |
TCYF
Profile detailed list: Displayed fields
|
PROFID |
| TCYD | PROF_FD | '001' |
TCYF
Profile detailed list: Displayed fields
|
KENNI | |
| TCYD | PROF_GP | TCYD | MANDT |
TCYP
Profile detailed list: Criteria grouping
|
MANDT |
| TCYD | PROF_GP | TCYD | TABNAME |
TCYP
Profile detailed list: Criteria grouping
|
TABNAME |
| TCYD | PROF_GP | TCYD | PROF_GP |
TCYP
Profile detailed list: Criteria grouping
|
PROFID |
| TCYD | PROF_GP | '001' |
TCYP
Profile detailed list: Criteria grouping
|
KENNI | |
| TCYD | PROF_SR | TCYD | TABNAME |
TCYS
Profile detailed list: Sort criteria
|
TABNAME |
| TCYD | PROF_SR | TCYD | PROF_SR |
TCYS
Profile detailed list: Sort criteria
|
PROFID |
| TCYD | PROF_SR | '001' |
TCYS
Profile detailed list: Sort criteria
|
KENNI | |
| TCYD | PROF_SR | TCYD | MANDT |
TCYS
Profile detailed list: Sort criteria
|
MANDT |
| TCYD | TABNAME | TCYD | TABNAME |
TCYE
Capacity planning: Object type table for detailed cap. list
|
TABNAME |