SAP ABAP Table DGTEXCEPT (Exceptions to DG Regulations - Header Table)

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	DGTEXCEPT	Table Relationship Diagram
Short Description	Exceptions to DG Regulations - Header Table

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	THM063
4	EXCEPTID	☑	ADGE_EXCEPTID	ADGD_EXCEPTID	CHAR	18	0	Exception to Dangerous Goods Regulations	*
5	VERSION	☑	ADGE_EXCEPT_VERSION	ADGD_EXCEPT_VERSION	NUMC	3	0	Version of Exception to Dangerous Goods Regulations	*
6	DELFLG	☐	ADGE_DELFLG	ESDFLAG	CHAR	1	0	Deletion Indicator
7	BLOCKEDFLG	☐	ADGE_BLOCKEDFLG	ESDFLAG	CHAR	1	0	Block Indicator for Exception to Dangerous Goods Regulations
8	DISTRIBFLG	☐	ADGE_DISTRIBFLG	ESDFLAG	CHAR	1	0	Exception Was Distributed
9	.INCLUDE	☐				0	0	EHS: Administrative Data for Exceptions to DG Regulations
10	CRDAT	☐	ESECRDAT	DATUM	DATS	8	0	Created On
11	CRNAM	☐	ESECRNAM	USNAM	CHAR	12	0	Created By
12	UPDDAT	☐	ESEUPDDAT	DATUM	DATS	8	0	Changed On
13	UPDNAM	☐	ESEUPDNAM	USNAM	CHAR	12	0	Last Changed By
14	EXCEPT_VALFR	☐	ADGE_EXCEPT_VALFR	DATUM	DATS	8	0	Valid From Date for Exception
15	EXCEPT_VALTO	☐	ADGE_EXCEPT_VALTO	DATUM	DATS	8	0	Valid To Date for Exception
16	ENTPR_SPECFLG	☐	ADGE_ENTPR_SPECFLG	ESDFLAG	CHAR	1	0	Exception is Company Specific
17	UNNO_SPECFLG	☐	ADGE_UNNO_SPECFLG	ESDFLAG	CHAR	1	0	Exception is UN Number Specific
18	CNTRY_SPECFLG	☐	ADGE_CNTRY_SPECFLG	ESDFLAG	CHAR	1	0	Exception Is Country Specific
19	EXCEPTPROFILE	☐	ADGE_EXCEPTPROFILE	ADGD_EXCEPTPROFILE	NUMC	2	0	Assignment Profile for Exception to DG Regulations	TDG85

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	DGTEXCEPT	EXCEPTPROFILE	TDG85	EXCEPTPROFILE		1	CN
2	DGTEXCEPT	LWDG	THM063	LWDG		1	CN
3	DGTEXCEPT	MANDT	T000	MANDT		1	CN

History

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