TCGQUESTEP SAP table for – EHS: Query steps

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

SAP TCGQUESTEP table

Table TCGQUESTEP technical data

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

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

  • .INCLUDE : EHS: General object keys for query steps
    Its a key field.
  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • RECN_QUE : Sequential Number of Data Record
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 20
  • STEP : Sort Sequence
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 4
  • .INCLUDE : EHS: Administrative fields for query steps
  • 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
  • STEPID : Query step
    Its data type is CHAR (Character String) with field length 10
  • .INCLUDE : EHS: Data structure for selection type
  • SELTYP : Selection Category
    Its data type is CHAR (Character String) with field length 1
  • REFFLG : Referencing
    Its data type is CHAR (Character String) with field length 1
  • HITLFLG : Set of hits loaded
    Its data type is CHAR (Character String) with field length 1
  • RECN_GRP : Sequential Number of Data Record
    Its data type is NUMC (Character String with Digits Only) with field length 20
  • INTFLG : Flag for Internal Use
    Its data type is CHAR (Character String) with field length 1
  • LEVL : Node level
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • OBJTYPE : Specification Category
    Its data type is CHAR (Character String) with field length 10