DGTMD - DG: Dangerous Goods Master

DG: Dangerous Goods Master information is stored in SAP table DGTMD.
It is part of development package CBEHS_DGP in software component CA-GTF-EHS. This development package consists of objects that can be grouped under "Dangerous Goods Master Data".

Fields for table DGTMD

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
.INCLUDE		X		RCGUKEY	0
MANDT	Client	X	MANDT	CLNT	6	T000
RECN	Sequential Number of Data Record	X	ESERECN	NUMC	40
ACTN	Sequential Number of the Change State	X	ESEACTN	NUMC	40
.INCLUDE				RDGUADM	0
VALFR	Valid-From Date		ESEVALFR	DATS	16
VALTO	Valid-To Date		ESEVALTO	DATS	16
AENNR	Change Number		ESEAENNR	CHAR	24	AENR
DELFLG	Deletion Indicator		ADGE_DELFLG	CHAR	2
PARKFLG	Data Record Is Inactive		ESEPARKFLG	CHAR	2
CRDAT	Created On		ESECRDAT	DATS	16
CRNAM	Created By		ESECRNAM	CHAR	24
UPDDAT	Last Changed On		ESEUPDDAT	DATS	16
UPDNAM	Last Changed By		ESEUPDNAM	CHAR	24
SRSID	Source of Data		ESESRSID	CHAR	20	TCG56
OWNID	Data Provider		ESEVENDRID	CHAR	20	*
RECNROOT	Sequential Number of Data Record		ESERECN	NUMC	40
.INCLUDE				RDGDBKEY	0
MATNR	Material or Product (Internal Key)		BASE_MATID	CHAR	80	*
MOT	Dangerous Goods - Mode-of-Transport Category		THME_MOT	NUMC	4	THM151
RVLID	Validity Area		ESERVLID	CHAR	20	TCG91
.INCLUDE				RDGMDAPPDATA	0
DGNHM	Non-Dangerous Goods Full Transport		THME_NHM	CHAR	2	THM159
DGCAO	Only Cargo Air Transport Permitted		ADGE_DGCAO	CHAR	2
TKUI	Identification Number Type		THME_TKUI	CHAR	6	TDG73
DGNU	Identification Number		THME_DGNU	CHAR	8
DGRES1	Hazard-Inducing Substance		ADGE_RES	CHAR	24
DGRES2	Hazard-Inducing Substance		ADGE_RES	CHAR	24
DGCL	Dangerous Goods Class		THME_DGCL	CHAR	6	THM009
DGSC	Dangerous Goods Subclass		ADGE_DGSC	CHAR	12
SDBC	Hazard Item Number		ADGE_SDBC	NUMC	8
SLBE	Hazard Item Number (Empty Transport)		THME_SLBE	NUMC	8
LDBC	Classification Code		THME_LDBC	CHAR	10	THM011
LWDG	Dangerous Goods Regulation		THME_LWDG	CHAR	24	THM063
STOSU	Aggregate State for Transport		ADGE_STOSU	CHAR	2
COTMP	Control Temperature		ADGE_COTMP	QUAN	5
TPCUN	Temperature Unit (Control)		ADGE_TPCUN	UNIT	6	T006
EMTMP	Emergency Temperature		ADGE_EMTMP	QUAN	5
TPEUN	Temperature Unit (Emergency)		ADGE_TPEUN	UNIT	6	T006
FLTMP	Flash Point		ADGE_FLTMP	QUAN	5
TPFUN	Temperature Unit (Flame)		ADGE_TPFUN	UNIT	6	T006
TPSNL	Temperature Sensitivity (Lower Limit)		ADGE_TPSNL	QUAN	5
TPSLU	Unit for temperature sensitivity (lower limit)		ADGE_TPSLU	UNIT	6	T006
TPSNH	Temperature sensitivity (upper limit)		ADGE_TPSNH	QUAN	5
TPSHU	Temperature Unit (Sensitivity - Upper Limit)		ADGE_TPSHU	UNIT	6	T006
DAIN1	Hazard Note		ADGE_DAIN	CHAR	8
DAIN2	Hazard Note		ADGE_DAIN	CHAR	8
DAIN3	Hazard Note		ADGE_DAIN	CHAR	8
DAIN4	Hazard Note		ADGE_DAIN	CHAR	8
DAIN5	Hazard Note		ADGE_DAIN	CHAR	8
DAIN6	Hazard Note		ADGE_DAIN	CHAR	8
DAIN7	Hazard Note		ADGE_DAIN	CHAR	8
DAIN8	Hazard Note		ADGE_DAIN	CHAR	8
DAIN9	Hazard Note		ADGE_DAIN	CHAR	8
DAIN10	Hazard Note		ADGE_DAIN	CHAR	8
COWE	Water Pollution Class		ADGE_COWE	CHAR	2	TDG15
VBFC	VbF Class		ADGE_VBFC	CHAR	8	TDG35
SDCL	Storage Hazard Class		ADGE_SDCL	CHAR	8	TDG37
EINU	Tremcard Number		ADGE_EINU	CHAR	14
EICN	Replacement Tremcard Number		ADGE_EICN	CHAR	14
EMSN1	EmS/ERG Number 1		ADGE_EMSN1	CHAR	14
EMSN2	EmS/ERG Number 2		ADGE_EMSN2	CHAR	14
MFAG1	MFAG Number 1		ADGE_MFAG1	CHAR	8
MFAG2	MFAG Number 2		ADGE_MFAG2	CHAR	8
MOS1	Dangerous Goods Transport Type		THME_MOS	NUMC	6	THM003
MOS2	Dangerous Goods Transport Type		THME_MOS	NUMC	6	THM003
MOS3	Dangerous Goods Transport Type		THME_MOS	NUMC	6	THM003
MOS4	Dangerous Goods Transport Type		THME_MOS	NUMC	6	THM003
MOS5	Dangerous Goods Transport Type		THME_MOS	NUMC	6	THM003
MOS6	Dangerous Goods Transport Type		THME_MOS	NUMC	6	THM003
MOS7	Dangerous Goods Transport Type		THME_MOS	NUMC	6	THM003
MOS8	Dangerous Goods Transport Type		THME_MOS	NUMC	6	THM003
MOS9	Dangerous Goods Transport Type		THME_MOS	NUMC	6	THM003
MOSA	Dangerous Goods Transport Type		THME_MOS	NUMC	6	THM003
HQTU	Maximum Quantity per Transport Unit		ADGE_HQTU	QUAN	5
HQTUN	Maximum Quantity Unit		ADGE_HQTUN	UNIT	6	T006
PIN	Packing Instruction Number		THME_PIN	CHAR	50	THM075
PGRO	Packing Group		THME_PGRO	CHAR	6
HNU	Hazard Identification Number		THME_HNU	CHAR	8	THM031
HPN1	Danger Label Number 1		THME_HPN1	CHAR	20	THM017
HPN2	Danger Label Number 2		THME_HPN2	CHAR	20	THM017
HPN3	Danger Label Number 3		THME_HPN3	CHAR	20	THM017
HPN4	Danger Label Number 4		THME_HPN4	CHAR	20	THM017
HPN5	Danger Label Number 5		THME_HPN5	CHAR	20	THM017
HPN6	Danger Label Number 6		THME_HPN6	CHAR	20	THM017
HPN7	Danger Label Number 7		THME_HPN7	CHAR	20	THM017
LAB1	Label Number 1		ADGE_LAB1	CHAR	14	TDG29
LAB2	Label Number 2		ADGE_LAB2	CHAR	14	TDG29
LAB3	Label Number 3		ADGE_LAB3	CHAR	14	TDG29
LAB4	Label Number 4		ADGE_LAB4	CHAR	14	TDG29
LAB5	Label Number 5		ADGE_LAB5	CHAR	14	TDG29
LAB6	Label Number 6		ADGE_LAB6	CHAR	14	TDG29
LAB7	Label Number 7		ADGE_LAB7	CHAR	14	TDG29
LAB8	Label Number 8		ADGE_LAB8	CHAR	14	TDG29
LAB9	Label Number 9		ADGE_LAB9	CHAR	14	TDG29
LAB10	Label Number 10		ADGE_LABA	CHAR	14	TDG29
KDGVS	Text Key Highly Viscous Substances		ADGE_KDGVS	CHAR	140
KDGNS	Text Key Exemption for Named Substances		ADGE_KDGNS	CHAR	140
KDGMP	Text Key Marine Pollutant		ADGE_KDGMP	CHAR	140
KDGEX	Text Key Exceptions		ADGE_KDGEX	CHAR	140
KDGHI	Text key handling data		ADGE_KDGHI	CHAR	140
KDGF1	User-Defined Text Key 1		ADGE_KDGF1	CHAR	140
KDGF2	User-Defined Text Key 2		ADGE_KDGF2	CHAR	140
KDGF3	User-Defined Text Key 3		ADGE_KDGF3	CHAR	140
KDGF4	User-Defined Text Key 4		ADGE_KDGF4	CHAR	140
KDGF5	User-Defined Text Key 5		ADGE_KDGF5	CHAR	140
KDGF6	User-Defined Text Key 6		ADGE_KDGF6	CHAR	140
KDGF7	User-Defined Text Key 7		ADGE_KDGF7	CHAR	140
KDGF8	User-Defined Text Key 8		ADGE_KDGF8	CHAR	140
KDGF9	User-Defined Text Key 9		ADGE_KDGF9	CHAR	140
KDGF10	User-Defined Text Key 10		ADGE_KDGFA	CHAR	140
PAI	Limited Quantity (LQ) Inner Packaging		THME_PAI	QUAN	5
PAIU	Unit of Meas. for Limited Quantity (LQ) Inner Packaging		THME_PAIU	UNIT	6	T006
PAO	Limited Quantity (LQ) Outer Packaging		THME_PAO	QUAN	5
PAOU	Unit of Meas. for Limited Quantity (LQ) Outer Packaging		THME_PAOU	UNIT	6	T006
RQA	Reportable Quantity		ADGE_RQA	QUAN	5
RQU	Unit of measure for reportable quantities		ADGE_RQU	UNIT	6	T006
PBI	Poisonous by Inhalation		ADGE_PBI	CHAR	2
MINQ	Minimum Quantity for Listed Goods		ADGE_MINQ	QUAN	5
MINU	Unit of Measurement Minimum Quantity (Listed Goods)		ADGE_MINU	UNIT	6	T006
MAXQ	Maximum Quantity for Listed Goods		ADGE_MAXQ	QUAN	5
MAXU	Unit of Measurement Maximum Quantity (Listed Goods)		ADGE_MAXU	UNIT	6	T006
RELQ	Exemption (ADR 1.1.3.6)		THME_RELQ	QUAN	5
RELU	Unit of Measure Quantity Limit		THME_RELU	UNIT	6	T006
MULRQ	Multiplication Factor Exemption (ADR 1.1.3.6)		THME_MULRQ	NUMC	8
RCHEM	Notification Status (Law on Control of Toxic Substances)		ADGE_RCHEM	CHAR	2
DGPTA	Shipping by Mail Permitted		ADGE_DGPTA	CHAR	2
DGTNA	Transport Not Permitted		ADGE_DGTNA	CHAR	2
DGWOS	Processing Status for Basic Data and Master Data		THME_WOS	CHAR	4	THM039
NHME	Non-Dangerous Goods Empty Transport		THME_NHME	CHAR	2	THM159
DGSHE	Schedule of Class 7		ADGE_DGSHE	CHAR	8
PIMDG	Note on Regulation		ADGE_PIMDG	CHAR	20
SOOWA	Solubility of water		ADGE_SOOWA	QUAN	7
USOOW	Unit for solubility of water		ADGE_USOOW	UNIT	6	T006
DENFEE	Density I		ADGE_DENFE	QUAN	6
UDENFE	Unit for density I		ADGE_UDENF	UNIT	6	T006
DENTWE	Density II		ADGE_DENTW	QUAN	6
UDENTW	Unit for density II		ADGE_UDENT	UNIT	6	T006
DENFIF	Density III		ADGE_DENFI	QUAN	6
UDENFI	Unit for density III		ADGE_UDEFI	UNIT	6	T006
BUDEN	Bulk Density		ADGE_BUDEN	QUAN	6
UBUDE	Unit for Bulk Density		ADGE_UBUDE	UNIT	6	T006
BOPOI	Boiling Point		ADGE_BOPOI	QUAN	5
UBOPO	Unit for Boiling Point		ADGE_UBOPO	UNIT	6	T006
VISCO	Viscosity		ADGE_VISCO	QUAN	5
UVISC	Unit for Viscosity		ADGE_UVISC	UNIT	6	T006
STPRES	Vapor Pressure		ADGE_STPRE	QUAN	6
USTPRE	Unit for vapor pressure		ADGE_USTPR	UNIT	6	T006
HYGRO	Hygroscopicity		ADGE_HYGRO	CHAR	2
MEPOI	Melting Point		ADGE_MEPOI	QUAN	5
UMEPO	Unit for Melting Point		ADGE_UMEPO	UNIT	6	T006
COOEX	Coefficient of Expansion		ADGE_COOEX	QUAN	5
UCOOE	Unit for Coefficient of Expansion		ADGE_UCOOE	UNIT	6	T006
MTMPF	Medium Temperature of Liquid During Filling		ADGE_MTMPF	QUAN	5
UMTMP	Unit for medium filling temperature		ADGE_UMTMP	UNIT	6	T006
STOPA	Packaging Mark		THME_STOPA	CHAR	2
SPPRO	Special Provision		THME_SPPRO	CHAR	10
MAPOL	Marine Pollutant		ADGE_MAPOL	CHAR	4	TDG109
PINLQ	Packing Instruction Number for Limited Quantity (LQ)		THME_PINLQ	CHAR	50	THM075
PASI	Maximum Quantity per Package		THME_PASI	QUAN	5
UPASI	Unit of Measurement for Single Packaging		THME_UPASI	UNIT	6	T006
PAGW	Limited Quantity (LQ) Gross Weight		THME_PAGW	QUAN	5
UPAGW	Unit of Measurement for Limited Quantity (LQ) Gross		THME_UPAGW	UNIT	6	T006
EXCEP	Exception and Agreement Number		ADGE_EXCEP	CHAR	80
SCASE	Special Case (Packing Check)		ADGE_SCASE	CHAR	2
COLNO	Collective Number		ADGE_COLNO	CHAR	2
DGRES3	Hazard-Inducing Substance		ADGE_RES	CHAR	24
DGREMP	Hazard-inducing substance (marine pollutant)		ADGE_REMP	CHAR	24
DGRERQ	Hazard-inducing substance (reportable quantity)		ADGE_RERQ	CHAR	24
EIMDG	Regulation Edition		ADGE_EIMDG	CHAR	8