SAP ABAP Table DGTEXCCNTRIES (Exceptions to Dangerous Goods Regulations: Countries)

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	DGTEXCCNTRIES	Table Relationship Diagram
Short Description	Exceptions to Dangerous Goods Regulations: Countries

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	EXCEPT_CNTRY	☑	ADGE_EXCEPT_CNTRY	LAND1	CHAR	3	0	Country	T005
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	EXC_CNTRY_VALFR	☐	ADGE_EXC_CNTRY_VALFR	DATUM	DATS	8	0	Valid From Date for Exception
13	EXC_CNTRY_VALTO	☐	ADGE_EXC_CNTRY_VALTO	DATUM	DATS	8	0	Valid To Date for Exception
14	EXC_PRINT_SUPPRF	☐	ADGE_EXC_PRINT_SUPPRFLG	ESDFLAG	CHAR	1	0	Do Not Print Exception Text

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	DGTEXCCNTRIES	EXCEPTID	DGTEXCEPT	LWDG
2	DGTEXCCNTRIES	EXCEPT_CNTRY	T005	LAND1		1	CN
3	DGTEXCCNTRIES	MANDT	T000	MANDT		1	CN
4	DGTEXCCNTRIES	VERSION	DGTEXCEPT	EXCEPTID

History

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