TCGES_ATTRIBUTES SAP table for – EHS: Search Form – Enterprise Search – Attributes

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

SAP TCGES_ATTRIBUTES table

Table TCGES_ATTRIBUTES technical data

TableTCGES_ATTRIBUTES
Data storingEHS: Search Form – Enterprise Search – Attributes
ModuleEHS
Sub ModuleEHS-SAF
SAP PackageCBUI
Delivery ClassL – Table for storing temporary data
ComponentEA-APPL
Table CategoryTRANSP

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

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • QUERY_ID : Sequential Number of Data Record
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 20
  • ATTR_TYPE_ID : Character field, length 32
    Its a key field. Its data type is CHAR (Character String) with field length 32
  • ATTRIBUTE_VALUE : Char255
    Its data type is CHAR (Character String) with field length 255
  • SORT : Natural number
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10