Here we would like to draw your attention to TCGES_QUERY 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_QUERY is a SAP standard transp table used for storing EHS: Search Form Enterprise Search related data in SAP. It comes under the package CBUI.
Table TCGES_QUERY technical data
| Table | TCGES_QUERY |
| Data storing | EHS: Search Form Enterprise Search |
| Module | EHS |
| Sub Module | EHS-SAF |
| SAP Package | CBUI |
| Delivery Class | L – Table for storing temporary data |
| Component | EA-APPL |
| Table Category | TRANSP |
SAP TCGES_QUERY 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_QUERY table.
Its a key field. Its data type is CLNT (Character with length 3) with field length 3
Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 20
Its a key field. Its data type is CHAR (Character String) with field length 40
Its a key field. Its data type is CHAR (Character String) with field length 12
Its a key field. Its data type is CHAR (Character String) with field length 10
Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
Its data type is CHAR (Character String) with field length 20
Its data type is STRG (Character String of Variable Length) with field length 0
Its data type is CHAR (Character String) with field length 1
Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
Its data type is TIMS (Time (Time: HHMMSS)) with field length 6