SAP table TCOAD (Object profile - detail list - order information system)

SAP table TCOAD has 4 primary key fields being MANDT,TABNAME,PROFID,PRF_ORIGIN.

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
TABNAME Table Name CHAR 30 0 TCOAO TABNAME
PROFID Object profile - Order Information System CHAR 6 0 CO_PROF_DT
PRF_ORIGIN Profile origin CHAR 1 0 PRF_ORIGIN
Order information system
K Pick list
PROF_FD_ST Profile for field selection on object overview CHAR 6 0 TCOP PROF_FD_ST
PROF_FD_DT Profile for field selection on object detail list CHAR 6 0 TCOP PROF_FD_DT
PROF_SR_ST Profile for sort criteria on object overview CHAR 6 0 TCOP PROF_SR_ST
PROF_SR_DT Profile for sort criteria on object detail list CHAR 6 0 TCOP PROF_SR_DT
PROF_GP_ST Profile for grouping criteria on object overview CHAR 6 0 TCOP PROF_GP_ST
PROF_GP_DT Profile for grouping criteria on object detail list CHAR 6 0 TCOP PROF_GP_DT
FLG_OTX Indicator: Object is displayed by its short text CHAR 1 0 MP_FLG_OTX
FLG_GRP Indicator: Grouping will be displayed CHAR 1 0 PS_FLG_GRP
FLG_PWT Indicator: numerical, summable fields as percentage values CHAR 1 0 PS_FLG_PWT
FLG_SRA Indicator: sort in descending order CHAR 1 0 PS_FLG_SRA
FLG_ORG Indicator: original column width CHAR 1 0 PS_FLG_ORG
WRT_OBJ Width of the object column NUMC 2 0 MP_WRT_OBJ
WRT_FLD Width of the field columns NUMC 2 0 MP_WRT_FLD
SELSET_BFT Variant for User Filter CHAR 14 0 MP_SEL_BFT
SELID Selection ID CHAR 7 0 TJ48 SELID
AENAM Last changed by CHAR 12 0 PS_AENAM
PROTECT Indicator: Protected entry CHAR 1 0 MP_PROTECT

TCOAD foreign key relationships

Table Field Check Table Check Field
0 TCOAD PROF_FD_DT TCOP Field selection profile MANDT
0 TCOAD PROF_FD_DT TCOP Field selection profile TABNAME
0 TCOAD PROF_FD_DT TCOP Field selection profile PROFID
1 TCOAD PROF_FD_ST TCOP Field selection profile MANDT
1 TCOAD PROF_FD_ST TCOP Field selection profile TABNAME
1 TCOAD PROF_FD_ST TCOP Field selection profile PROFID
0 TCOAD PROF_GP_DT TCOP Field selection profile MANDT
0 TCOAD PROF_GP_DT TCOP Field selection profile TABNAME
0 TCOAD PROF_GP_DT TCOP Field selection profile PROFID
1 TCOAD PROF_GP_ST TCOP Field selection profile MANDT
1 TCOAD PROF_GP_ST TCOP Field selection profile TABNAME
1 TCOAD PROF_GP_ST TCOP Field selection profile PROFID
0 TCOAD PROF_SR_DT TCOP Field selection profile MANDT
0 TCOAD PROF_SR_DT TCOP Field selection profile TABNAME
0 TCOAD PROF_SR_DT TCOP Field selection profile PROFID
1 TCOAD PROF_SR_ST TCOP Field selection profile MANDT
1 TCOAD PROF_SR_ST TCOP Field selection profile TABNAME
1 TCOAD PROF_SR_ST TCOP Field selection profile PROFID
0 TCOAD TABNAME TCOAO Order info system: Object type table reporting structures TABNAME