TCGTPLREL SAP table for – EHS: Inheritance Relationships

Here we would like to draw your attention to TCGTPLREL 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). TCGTPLREL is a SAP standard transp table used for storing EHS: Inheritance Relationships related data in SAP. It comes under the package CBUI.

SAP TCGTPLREL table

Table TCGTPLREL technical data

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

SAP TCGTPLREL 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 TCGTPLREL table.

  • .INCLUDE : EHS: Structure for key info of master data
    Its a key field.
  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • RECN : Sequential Number of Data Record
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 20
  • ACTN : Sequential Number of the Change State
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 20
  • .INCLUDE : EHS: Structure for General Administration Information
  • VALFR : Valid-From Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • VALTO : Valid-To Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • AENNR : Change Number
    Its data type is CHAR (Character String) with field length 12
  • DELFLG : Deletion Indicator
    Its data type is CHAR (Character String) with field length 1
  • PARKFLG : Data Record Is Inactive
    Its data type is CHAR (Character String) with field length 1
  • 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
  • SRSID : Source of Data
    Its data type is CHAR (Character String) with field length 10
  • OWNID : Data Provider
    Its data type is CHAR (Character String) with field length 10
  • RECNROOT : Sequential Number of Data Record
    Its data type is NUMC (Character String with Digits Only) with field length 20
  • FLG_SRCDEST_REQ : Request from Currently Called Specification
    Its data type is CHAR (Character String) with field length 1
  • APPRV_STAT : Approval Status of an Inheritance Request
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • CONS_STAT : Status of an Inheritance Relationship
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • FLG_INH : Inheritance Relationship Is Inactive
    Its data type is CHAR (Character String) with field length 1
  • JOB_REQ_TIM : Current Time of an Inheritance Request
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • JOB_REQ_DAT : Date of an Inheritance Request
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • FLG_SUBCPY : Relationship Is Not Relevant for Inheritance
    Its data type is CHAR (Character String) with field length 1
  • RECNROOT_SRC : Sequential Number of Data Record
    Its data type is NUMC (Character String with Digits Only) with field length 20
  • RECNROOT_DST : Sequential Number of Data Record
    Its data type is NUMC (Character String with Digits Only) with field length 20
  • RECN_TPLH : Sequential Number of Data Record
    Its data type is NUMC (Character String with Digits Only) with field length 20
  • ESNTFLG : Relevant Change Has Been Made
    Its data type is CHAR (Character String) with field length 1