TCGTPLH SAP table for – EHS: Inheritance Template Header

Here we would like to draw your attention to TCGTPLH table in SAP. As we know it is being mainly used with the SAP EHS-SAF (Product Safety in EHS) component which is coming under EHS module (Environment, Health and Safety). TCGTPLH is a SAP standard transp table used for storing EHS: Inheritance Template Header related data in SAP. It comes under the package CBUI.

SAP TCGTPLH table

Table TCGTPLH technical data

TableTCGTPLH
Data storingEHS: Inheritance Template Header
ModuleEHS
Sub ModuleEHS-SAF
SAP PackageCBUI
Delivery ClassA – Application table (master and transaction data)
ComponentEA-APPL
Table CategoryTRANSP

SAP TCGTPLH Table Fields

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

  • .INCLUDE : EHS: General object key for group objects
    Its a key field.
  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • RECN_GRP : Sequential Number of Data Record
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 20
  • .INCLUDE : EHS: Administration Fields for Group Objects
  • AENNR : Change Number
    Its data type is CHAR (Character String) with field length 12
  • SEARCHMODE : Search mode to find historical data
    Its data type is CHAR (Character String) with field length 1
  • VALDAT : Key Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • .INCLUDE : EHS: Struct. for searching via time frame (historical data)
  • VALFR : From-Date for Specification Search Over Time Period
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • VALTO : To-Date for Specification Search Over Time Period
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CRDAT : Created On
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CRNAM : Created By
    Its data type is CHAR (Character String) with field length 12
  • UPDDAT : Changed On
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • UPDNAM : Last Changed By
    Its data type is CHAR (Character String) with field length 12
  • OBJID : Group Entry
    Its data type is CHAR (Character String) with field length 10
  • GRPID : Group
    Its data type is CHAR (Character String) with field length 10
  • ORD : Sort Sequence
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • FLG_DST_CHNG : Changes to Target Specifications Permitted
    Its data type is CHAR (Character String) with field length 1
  • FLG_INH_DSBL : Deactivation of Inheritance Relationship Permitted
    Its data type is CHAR (Character String) with field length 1
  • FLG_INH_EXCL : Data Record may be Excluded from Inheritance
    Its data type is CHAR (Character String) with field length 1
  • FLG_ALL_PROP : All Value Assignment Types Contained in Inheritance Template
    Its data type is CHAR (Character String) with field length 1
  • FLG_ALL_IDENT : All Source Identifiers Contained in Inheritance Template
    Its data type is CHAR (Character String) with field length 1
  • FLG_ALL_USAGES : All Usages Contained in Inheritance Template
    Its data type is CHAR (Character String) with field length 1