SAP ABAP Table DGTEXCTEXTS (Exceptions to DG Regulations: Texts and Documents)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ EHS (Application Component) Environment, Health and Safety
     ⤷ CBEHS (Package) EH&S: Interface Objects

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	DGTEXCTEXTS	Table Relationship Diagram
Short Description	Exceptions to DG Regulations: Texts and Documents

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	.INCLUDE	☑				0	0	EHS: Logical Key for Exceptions to DG Regulations
3	LWDG	☑	THME_LWDG	HMD_LWDG	CHAR	12	0	Dangerous Goods Regulation	DGTEXCEPT
4	EXCEPTID	☑	ADGE_EXCEPTID	ADGD_EXCEPTID	CHAR	18	0	Exception to Dangerous Goods Regulations	DGTEXCEPT
5	VERSION	☑	ADGE_EXCEPT_VERSION	ADGD_EXCEPT_VERSION	NUMC	3	0	Version of Exception to Dangerous Goods Regulations	DGTEXCEPT
6	LANGU	☑	ADGE_DOC_LANGU	SPRAS	LANG	1	0	Document Language	T002
7	.INCLUDE	☐				0	0	EHS: Administrative Data for Exceptions to DG Regulations
8	CRDAT	☐	ESECRDAT	DATUM	DATS	8	0	Created On
9	CRNAM	☐	ESECRNAM	USNAM	CHAR	12	0	Created By
10	UPDDAT	☐	ESEUPDDAT	DATUM	DATS	8	0	Changed On
11	UPDNAM	☐	ESEUPDNAM	USNAM	CHAR	12	0	Last Changed By
12	EXCEPTIDD	☐	ADGE_EXCEPTIDD	HMD_STXT	CHAR	132	0	Description of Exception to Dangerous Goods Regulations
13	DOKAR	☐	DOKAR	DOKAR	CHAR	3	0	Document Type	TDWA
14	DOKNR	☐	DOKNR	DOKNR	CHAR	25	0	Document number	DRAW
15	DOKVR	☐	DOKVR	DOKVR	CHAR	2	0	Document version	DRAW
16	DOKTL	☐	DOKTL_D	DOKTL	CHAR	3	0	Document part	DRAW
17	RECN	☐	ESERECN	ESDRECN	NUMC	20	0	Sequential Number of Data Record
18	HEAD_LTXT_FLG	☐	ADGE_HEAD_LTXT_FLG	ESDFLAG	CHAR	1	0	Long Text Exists for Header Text
19	POS_LTXT_FLG	☐	ADGE_POS_LTXT_FLG	ESDFLAG	CHAR	1	0	Long Text Exists for Item Text
20	HEADER_TEXT	☐	ADGE_HEADER_TEXT	HMD_STXT	CHAR	132	0	Header Text
21	POS_TEXT	☐	ADGE_POS_TEXT	HMD_STXT	CHAR	132	0	Item Text

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	DGTEXCTEXTS	DOKAR	TDWA	DOKAR		1	CN
2	DGTEXCTEXTS	DOKNR	DRAW	DOKNR		1	CN
3	DGTEXCTEXTS	DOKTL	DRAW	DOKTL		1	CN
4	DGTEXCTEXTS	DOKVR	DRAW	DOKVR		1	CN
5	DGTEXCTEXTS	EXCEPTID	DGTEXCEPT	LWDG		1	CN
6	DGTEXCTEXTS	LANGU	T002	SPRAS		1	CN
7	DGTEXCTEXTS	MANDT	T000	MANDT		1	CN
8	DGTEXCTEXTS	VERSION	DGTEXCEPT	EXCEPTID		1	CN

History

Last changed by/on	SAP	20100310
SAP Release Created in	600