SAP Table TCOAD
Object profile - detail list - order information system
TCOAD (Object profile - detail list - order information system) 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 TCOAD to other SAP tables.
TCOAD table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||
| TABNAME | Table Name | TABNAME | TCOAO | CHAR | 30 | 0 | ||||||
| PROFID | Object profile - Order Information System | CO_PROF_DT | CHAR | 6 | 0 | |||||||
| PRF_ORIGIN | Profile origin | PRF_ORIGIN | CHAR | 1 | 0 |
Possible values
|
||||||
| PROF_FD_ST | Profile for field selection on object overview | PROF_FD_ST | TCOP | CHAR | 6 | 0 | ||||||
| PROF_FD_DT | Profile for field selection on object detail list | PROF_FD_DT | TCOP | CHAR | 6 | 0 | ||||||
| PROF_SR_ST | Profile for sort criteria on object overview | PROF_SR_ST | TCOP | CHAR | 6 | 0 | ||||||
| PROF_SR_DT | Profile for sort criteria on object detail list | PROF_SR_DT | TCOP | CHAR | 6 | 0 | ||||||
| PROF_GP_ST | Profile for grouping criteria on object overview | PROF_GP_ST | TCOP | CHAR | 6 | 0 | ||||||
| PROF_GP_DT | Profile for grouping criteria on object detail list | PROF_GP_DT | TCOP | CHAR | 6 | 0 | ||||||
| FLG_OTX | Indicator: Object is displayed by its short text | MP_FLG_OTX | CHAR | 1 | 0 |
Possible values
|
||||||
| FLG_GRP | Indicator: Grouping will be displayed | PS_FLG_GRP | CHAR | 1 | 0 |
Possible values
|
||||||
| FLG_PWT | Indicator: numerical, summable fields as percentage values | PS_FLG_PWT | CHAR | 1 | 0 |
Possible values
|
||||||
| FLG_SRA | Indicator: sort in descending order | PS_FLG_SRA | CHAR | 1 | 0 |
Possible values
|
||||||
| FLG_ORG | Indicator: original column width | PS_FLG_ORG | CHAR | 1 | 0 |
Possible values
|
||||||
| WRT_OBJ | Width of the object column | MP_WRT_OBJ | NUMC | 2 | 0 | |||||||
| WRT_FLD | Width of the field columns | MP_WRT_FLD | NUMC | 2 | 0 | |||||||
| SELSET_BFT | Variant for User Filter | MP_SEL_BFT | CHAR | 14 | 0 | |||||||
| SELID | Selection ID | SELID | TJ48 | CHAR | 7 | 0 | ||||||
| AENAM | Last changed by | PS_AENAM | CHAR | 12 | 0 | |||||||
| PROTECT | Indicator: Protected entry | MP_PROTECT | CHAR | 1 | 0 |
Possible values
|
||||||
TCOAD foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| TCOAD | MANDT | TCOAD | MANDT | T000 | Clients | MANDT |
| TCOAD | PROF_FD_DT | TCOAD | MANDT | TCOP | Field selection profile | MANDT |
| TCOAD | PROF_FD_DT | TCOAD | TABNAME | TCOP | Field selection profile | TABNAME |
| TCOAD | PROF_FD_DT | 'RF' | TCOP | Field selection profile | ANWENDUNG | |
| TCOAD | PROF_FD_DT | TCOAD | PROF_FD_DT | TCOP | Field selection profile | PROFID |
| TCOAD | PROF_FD_ST | TCOAD | MANDT | TCOP | Field selection profile | MANDT |
| TCOAD | PROF_FD_ST | TCOAD | TABNAME | TCOP | Field selection profile | TABNAME |
| TCOAD | PROF_FD_ST | 'HF' | TCOP | Field selection profile | ANWENDUNG | |
| TCOAD | PROF_FD_ST | TCOAD | PROF_FD_ST | TCOP | Field selection profile | PROFID |
| TCOAD | PROF_GP_DT | TCOAD | TABNAME | TCOP | Field selection profile | TABNAME |
| TCOAD | PROF_GP_DT | 'RG' | TCOP | Field selection profile | ANWENDUNG | |
| TCOAD | PROF_GP_DT | TCOAD | PROF_GP_DT | TCOP | Field selection profile | PROFID |
| TCOAD | PROF_GP_DT | TCOAD | MANDT | TCOP | Field selection profile | MANDT |
| TCOAD | PROF_GP_ST | 'HG' | TCOP | Field selection profile | ANWENDUNG | |
| TCOAD | PROF_GP_ST | TCOAD | PROF_GP_ST | TCOP | Field selection profile | PROFID |
| TCOAD | PROF_GP_ST | TCOAD | MANDT | TCOP | Field selection profile | MANDT |
| TCOAD | PROF_GP_ST | TCOAD | TABNAME | TCOP | Field selection profile | TABNAME |
| TCOAD | PROF_SR_DT | TCOAD | MANDT | TCOP | Field selection profile | MANDT |
| TCOAD | PROF_SR_DT | TCOAD | TABNAME | TCOP | Field selection profile | TABNAME |
| TCOAD | PROF_SR_DT | 'RS' | TCOP | Field selection profile | ANWENDUNG | |
| TCOAD | PROF_SR_DT | TCOAD | PROF_SR_DT | TCOP | Field selection profile | PROFID |
| TCOAD | PROF_SR_ST | TCOAD | MANDT | TCOP | Field selection profile | MANDT |
| TCOAD | PROF_SR_ST | TCOAD | TABNAME | TCOP | Field selection profile | TABNAME |
| TCOAD | PROF_SR_ST | 'HS' | TCOP | Field selection profile | ANWENDUNG | |
| TCOAD | PROF_SR_ST | TCOAD | PROF_SR_ST | TCOP | Field selection profile | PROFID |
| TCOAD | SELID | TCOAD | SELID | TJ48 | Check Table for Selection IDs | SELID |
| TCOAD | SELID | TCOAD | MANDT | TJ48 | Check Table for Selection IDs | MANDT |
| TCOAD | TABNAME | TCOAD | TABNAME | TCOAO | Order info system: Object type table reporting structures | TABNAME |
