SAP ABAP Table DGTEXCUNNO (Exceptions to DG Regulations: UN Numbers)

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	DGTEXCUNNO	Table Relationship Diagram
Short Description	Exceptions to DG Regulations: UN Numbers

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	TKUI	☑	THME_TKUI	HMD_TKUI	CHAR	3	0	Identification Number Type	TDG73
7	DGNU	☑	THME_DGNU	CHAR4	CHAR	4	0	Identification Number
8	.INCLUDE	☐				0	0	EHS: Administrative Data for Exceptions to DG Regulations
9	CRDAT	☐	ESECRDAT	DATUM	DATS	8	0	Created On
10	CRNAM	☐	ESECRNAM	USNAM	CHAR	12	0	Created By
11	UPDDAT	☐	ESEUPDDAT	DATUM	DATS	8	0	Changed On
12	UPDNAM	☐	ESEUPDNAM	USNAM	CHAR	12	0	Last Changed By
13	PGRP1_PERMFLG	☐	ADGE_PGRP1_PERMFLG	ESDFLAG	CHAR	1	0	Packing Group I Permitted
14	PGRP2_PERMFLG	☐	ADGE_PGRP2_PERMFLG	ESDFLAG	CHAR	1	0	Packing Group II Permitted
15	PGRP3_PERMFLG	☐	ADGE_PGRP3_PERMFLG	ESDFLAG	CHAR	1	0	Packing Group III Permitted

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	DGTEXCUNNO	EXCEPTID	DGTEXCEPT	LWDG
2	DGTEXCUNNO	MANDT	T000	MANDT		1	CN
3	DGTEXCUNNO	TKUI	TDG73	TKUI		1	CN
4	DGTEXCUNNO	VERSION	DGTEXCEPT	EXCEPTID

History

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