TCG01 SAP (EHS: Specification Value Assignment Category (System Table)) Table details
Description: EHS: Specification Value Assignment Category (System Table)
Table field list including key, data, relationships and ABAP select examples
TCG01 is a standard SAP Table which is used to store EHS: Specification Value Assignment Category (System Table) data and is available within R/3 SAP systems depending on the version and release level.
The TCG01 table consists of various fields, each holding specific information or linking keys about EHS: Specification Value Assignment Category (System Table) data available in SAP. These include CLSCAT (Class Type), EPMNFLG (Can Be Used in Property Tree), EPRGFLG (Available in Input Help for Report Template in WWI), EPCLFLG (Editing of Value Assignment).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: S - System table, maint. only by SAP, change = modificationDisplay/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified
Text table = TCG02
SAP TCG01 table fields - Full list of fields found in SAP data dictionary
| Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
| ESTTYPE | Value Assignment Category | ESEESTTYPE | CHAR | 10 | ESDESTTYPE | ||||
| CLSCAT | Class Type | KLASSENART | CHAR | 3 | TCLA | KLASSENART | KAR | ||
| EPMNFLG | Can Be Used in Property Tree | ESEEPMNFLG | CHAR | 1 | ESDFLAG | ||||
| EPRGFLG | Available in Input Help for Report Template in WWI | ESEEPRGFLG | CHAR | 1 | ESDFLAG | ||||
| EPCLFLG | Editing of Value Assignment | ESEEPCLFLG | CHAR | 1 | ESDFLAG | ||||
| EPCPFLG | Editing of Listing | ESEEPCPFLG | CHAR | 1 | ESDFLAG | ||||
| EPVAFLG | Editing the Composition | ESEEPVAFLG | CHAR | 1 | ESDFLAG | ||||
| TCFLG | Editing of Transport Classification Data Permitted | ESE0TCFLG | CHAR | 1 | ESDFLAG | ||||
| DGFLG | Editing of Dangerous Goods Additional Data Permitted | ESE0DGFLG | CHAR | 1 | ESDFLAG | ||||
| EPDFFLG | Editing User-Defined Text Permitted | ESEEPDFFLG | CHAR | 1 | FLAG | ||||
| EPDRFLG | Editing the Assessment Permitted | ESEEPDRFLG | CHAR | 1 | FLAG | ||||
| EPDUFLG | Editing the Usage Permitted | ESEEPDUFLG | CHAR | 1 | FLAG | ||||
| EPDSFLG | Editing the Source Permitted | ESEEPDSFLG | CHAR | 1 | FLAG | ||||
| HIFLG | Maintenance of Hazard-Inducing Substances Permitted | ESE0HIFLG | CHAR | 1 | ESDFLAG |
| Key field | Non-key field |
How do I retrieve data from SAP table TCG01 using ABAP code
The following ABAP code Example will allow you to do a basic selection on TCG01 to SELECT all data from the tableDATA: WA_TCG01 TYPE TCG01.
SELECT SINGLE *
FROM TCG01
INTO CORRESPONDING FIELDS OF WA_TCG01
WHERE...
How to access SAP table TCG01
Within an ECC or HANA version of SAP you can also view further information about TCG01 and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects