The DGTEXCTEXTS table in SAP ERP or S/4HANA stores Exceptions to DG Regulations: Texts and Documents data. There are total 19 fields in DGTEXCTEXTS table. The Exceptions to DG Regulations: Texts and Documents table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of DGTEXCTEXTS table. It is in EH&S: Interface Objects (CBEHS) ABAP package and is part of the Environment, Health and Safety (EHS) module.
SAP DGTEXCTEXTS Table Fields
Following is the list of fields that are available in SAP DGTEXCTEXTS table. The primary key fields of the table are MANDT (Client), LWDG (Dangerous Goods Regulation), EXCEPTID (Exception to Dangerous Goods Regulations), VERSION (Version of Exception to Dangerous Goods Regulations), LANGU (Document Language).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT (3) |
| LWDG | Dangerous Goods Regulation | THME_LWDG | DGTEXCEPT | CHAR (12) |
| EXCEPTID | Exception to Dangerous Goods Regulations | ADGE_EXCEPTID | DGTEXCEPT | CHAR (18) |
| VERSION | Version of Exception to Dangerous Goods Regulations | ADGE_EXCEPT_VERSION | DGTEXCEPT | NUMC (3) |
| LANGU | Document Language | ADGE_DOC_LANGU | T002 | LANG (1) |
| CRDAT | Created On | ESECRDAT | DATS (8) | |
| CRNAM | Created By | ESECRNAM | CHAR (12) | |
| UPDDAT | Last Changed On | ESEUPDDAT | DATS (8) | |
| UPDNAM | Last Changed By | ESEUPDNAM | CHAR (12) | |
| EXCEPTIDD | Description of Exception to Dangerous Goods Regulations | ADGE_EXCEPTIDD | CHAR (132) | |
| DOKAR | Document Type | DOKAR | TDWA | CHAR (3) |
| DOKNR | Document number | DOKNR | DRAW | CHAR (25) |
| DOKVR | Document Version | DOKVR | DRAW | CHAR (2) |
| DOKTL | Document Part | DOKTL_D | DRAW | CHAR (3) |
| RECN | Sequential Number of Data Record | ESERECN | NUMC (20) | |
| HEAD_LTXT_FLG | Long Text Exists for Header Text | ADGE_HEAD_LTXT_FLG | CHAR (1) | |
| POS_LTXT_FLG | Long Text Exists for Item Text | ADGE_POS_LTXT_FLG | CHAR (1) | |
| HEADER_TEXT | Header Text | ADGE_HEADER_TEXT | CHAR (132) | |
| POS_TEXT | Item Text | ADGE_POS_TEXT | CHAR (132) |
