TCOA SAP table for – Overall profile for order information system

Here we would like to draw your attention to TCOA table in SAP. As we know it is being mainly used with the SAP PP-SFC (Production Orders – PP) component which is coming under PP module (Production Planning). TCOA is a SAP standard transparent table used for storing Overall profile for order information system related data in SAP. It comes under the package COIS.

SAP TCOA table

Table TCOA technical data

TableTCOA
Data storingOverall profile for order information system
ModulePP
ComponentPP-SFC
SAP PackageCOIS
Delivery ClassG – Customer table, SAP may insert new data records but may not overwrite or delete existing ones
Table CategoryTRANSPARENT

SAP TCOA Table Fields

Here is the details of each fields in this table.You can find the discription, data type and assigned lenth of each of the fields in TCOA table.

  • MANDT : Client
    Its a key field. Its data type is C (Character String) with field length 3
  • HEADER_ANZ
    Its data type is C (Character String) with field length 1
  • SOSCCF_SEL
    Its data type is C (Character String) with field length 1
  • SOSCCF_ANZ
    Its data type is C (Character String) with field length 1
  • SOSCCF_AFL
    Its data type is C (Character String) with field length 1
  • MAMO_SEL
    Its data type is C (Character String) with field length 1
  • MAMO_ANZ
    Its data type is C (Character String) with field length 1
  • OPPREQ_SEL
    Its data type is C (Character String) with field length 1
  • OPPREQ_AFL
    Its data type is C (Character String) with field length 1
  • PROFID_DI
    Its data type is C (Character String) with field length 6
  • OPPORD_ANZ
    Its data type is C (Character String) with field length 1
  • OPPORD_AFL
    Its data type is C (Character String) with field length 1
  • SOPREQ_SEL
    Its data type is C (Character String) with field length 1
  • SOPREQ_ANZ
    Its data type is C (Character String) with field length 1
  • PROFID_BA
    Its data type is C (Character String) with field length 6
  • PROFID_EG
    Its data type is C (Character String) with field length 6
  • SOPORD_ANZ
    Its data type is C (Character String) with field length 1
  • SOPORD_AFL
    Its data type is C (Character String) with field length 1
  • OPDOCL_SEL
    Its data type is C (Character String) with field length 1
  • OPDOCL_ANZ
    Its data type is C (Character String) with field length 1
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
    Its include structure/component is is TCOA_DAG
  • AEDAT : (8-character) Date for SYST
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • ITEM_SEL
    Its data type is C (Character String) with field length 1
  • LAYOUTID_AA
    Its data type is C (Character String) with field length 12
  • LAYOUTID_BB
    Its data type is C (Character String) with field length 12
  • LAYOUTID_BC
    Its data type is C (Character String) with field length 12
  • LAYOUTID_BD
    Its data type is C (Character String) with field length 12
  • LAYOUTID_CA
    Its data type is C (Character String) with field length 12
  • LAYOUTID_CB
    Its data type is C (Character String) with field length 12
  • LAYOUTID_DA
    Its data type is C (Character String) with field length 12
  • LAYOUTID_DC
    Its data type is C (Character String) with field length 12
  • LAYOUTID_DE
    Its data type is C (Character String) with field length 12
  • LAYOUTID_DH
    Its data type is C (Character String) with field length 12
  • LAYOUTID_DI
    Its data type is C (Character String) with field length 12
  • LAYOUTID_EA
    Its data type is C (Character String) with field length 12
  • ITEM_AFL
    Its data type is C (Character String) with field length 1
  • LAYOUTID_EB
    Its data type is C (Character String) with field length 12
  • LAYOUTID_ED
    Its data type is C (Character String) with field length 12
  • LAYOUTID_EE
    Its data type is C (Character String) with field length 12
  • LAYOUTID_EG
    Its data type is C (Character String) with field length 12
  • LAYOUTID_FA
    Its data type is C (Character String) with field length 12
  • LAYOUTID_FB
    Its data type is C (Character String) with field length 12
  • LAYOUTID_FC
    Its data type is C (Character String) with field length 12
  • PROFID_BB
    Its data type is C (Character String) with field length 6
  • LAYOUTID_GA
    Its data type is C (Character String) with field length 12
  • HEADER_POS
    Its data type is N (Character String with Digits Only) with field length 2
  • ITEM_POS
    Its data type is N (Character String with Digits Only) with field length 2
  • MAMO_POS
    Its data type is N (Character String with Digits Only) with field length 2
  • DOCL_POS
    Its data type is N (Character String with Digits Only) with field length 2
  • OPER_POS
    Its data type is N (Character String with Digits Only) with field length 2
  • GMER_POS
    Its data type is N (Character String with Digits Only) with field length 2
  • OPCAP_POS
    Its data type is N (Character String with Digits Only) with field length 2
  • OPCOMP_POS
    Its data type is N (Character String with Digits Only) with field length 2
  • OPMST_POS
    Its data type is N (Character String with Digits Only) with field length 2
  • OPPRT_POS
    Its data type is N (Character String with Digits Only) with field length 2
  • OPPREQ_POS
    Its data type is N (Character String with Digits Only) with field length 2
  • SOPER_POS
    Its data type is N (Character String with Digits Only) with field length 2
  • SEQUEN_ANZ
    Its data type is C (Character String) with field length 1
  • OPGMER_POS
    Its data type is N (Character String with Digits Only) with field length 2
  • OPGOMO_POS
    Its data type is N (Character String with Digits Only) with field length 2
  • SOCONF_POS
    Its data type is N (Character String with Digits Only) with field length 2
  • SOSCAP_POS
    Its data type is N (Character String with Digits Only) with field length 2
  • SOPORD_POS
    Its data type is N (Character String with Digits Only) with field length 2
  • SOGMER_POS
    Its data type is N (Character String with Digits Only) with field length 2
  • SEQUEN_AFL
    Its data type is C (Character String) with field length 1
  • SOSCCF_POS
    Its data type is N (Character String with Digits Only) with field length 2
  • PRODLIST_SEL
    Its data type is C (Character String) with field length 1
  • MATVER_SEL
    Its data type is C (Character String) with field length 1
  • MATVER_LAY
    Its data type is C (Character String) with field length 12
  • CONF_SEL
    Its data type is C (Character String) with field length 1
  • CONF_ANZ
    Its data type is C (Character String) with field length 1
  • PROFID_BE
    Its data type is C (Character String) with field length 6
  • DOCL_ANZ
    Its data type is C (Character String) with field length 1
  • PROFID_CA
    Its data type is C (Character String) with field length 6
  • AENAM : Name of Person Who Changed Object
    Its data type is C (Character String) with field length 12
  • OPER_AFL
    Its data type is C (Character String) with field length 1
  • PROFID_CB
    Its data type is C (Character String) with field length 6
  • GMER_ANZ
    Its data type is C (Character String) with field length 1
  • GMER_AFL
    Its data type is C (Character String) with field length 1
  • GOMO_SEL
    Its data type is C (Character String) with field length 1
  • GOMO_ANZ
    Its data type is C (Character String) with field length 1
  • PROFID_DA
    Its data type is C (Character String) with field length 6
  • OPCAP_SEL
    Its data type is C (Character String) with field length 1
  • OPCAP_AFL
    Its data type is C (Character String) with field length 1
  • PROFID_DB
    Its data type is C (Character String) with field length 6
  • SOPER_ANZ
    Its data type is C (Character String) with field length 1
  • PROFID_DC
    Its data type is C (Character String) with field length 6
  • OPMST_SEL
    Its data type is C (Character String) with field length 1
  • VARIANTE : Filter: Variant
    Its data type is C (Character String) with field length 14
  • OPMST_AFL
    Its data type is C (Character String) with field length 1
  • OPCOMP_AFL
    Its data type is C (Character String) with field length 1
  • PROFID_DF
    Its data type is C (Character String) with field length 6
  • OPPRT_ANZ
    Its data type is C (Character String) with field length 1
  • OPPRT_AFL
    Its data type is C (Character String) with field length 1
  • OPCONF_SEL
    Its data type is C (Character String) with field length 1
  • OPCONF_ANZ
    Its data type is C (Character String) with field length 1
  • PROFID_EA
    Its data type is C (Character String) with field length 6
  • OPSCAP_SEL
    Its data type is C (Character String) with field length 1
  • OPSCAP_AFL
    Its data type is C (Character String) with field length 1
  • FLG_MSTUF
    Its data type is C (Character String) with field length 1
  • SOCAP_ANZ
    Its data type is C (Character String) with field length 1
  • PROFID_EC
    Its data type is C (Character String) with field length 6
  • SOCONF_ANZ
    Its data type is C (Character String) with field length 1
  • PROFID_ED
    Its data type is C (Character String) with field length 6
  • OPGMER_AFL
    Its data type is C (Character String) with field length 1
  • PROFID_AA
    Its data type is C (Character String) with field length 6
  • PROFID_EE
    Its data type is C (Character String) with field length 6
  • OPGOMO_ANZ
    Its data type is C (Character String) with field length 1
  • OPGOMO_AFL
    Its data type is C (Character String) with field length 1
  • PROFID_FA
    Its data type is C (Character String) with field length 6
  • SOSCAP_SEL
    Its data type is C (Character String) with field length 1
  • SOSCAP_ANZ
    Its data type is C (Character String) with field length 1
  • SOSCAP_AFL
    Its data type is C (Character String) with field length 1
  • SOGMER_SEL
    Its data type is C (Character String) with field length 1
  • SOGMER_AFL
    Its data type is C (Character String) with field length 1
  • PROFID_FC
    Its data type is C (Character String) with field length 6
  • OPSCCF_SEL
    Its data type is C (Character String) with field length 1
  • OPSCCF_ANZ
    Its data type is C (Character String) with field length 1
  • OPSCCF_AFL
    Its data type is C (Character String) with field length 1
  • SOGOMO_SEL
    Its data type is C (Character String) with field length 1
  • SOGOMO_AFL
    Its data type is C (Character String) with field length 1