SAP table DGTMD (DG: Dangerous Goods Master)

SAP table DGTMD has 3 primary key fields being MANDT,RECN,ACTN.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

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

DGTMD foreign key relationships

Table Field Check Table Check Field
0 DGTMD AENNR AENR Change Master AENNR
1 DGTMD COWE TDG15 Water Pollution Classes MANDT
1 DGTMD COWE TDG15 Water Pollution Classes COWE
0 DGTMD DGCL THM009 Dangerous Goods Classes MANDT
0 DGTMD DGCL THM009 Dangerous Goods Classes LWDG
1 DGTMD DGNHM THM159 DG: Not Dangerous Goods Full/Empty Transport MANDT
0 DGTMD DGWOS THM039 DG: Processing Status for Dangerous Goods Basic Data MANDT
0 DGTMD DGWOS THM039 DG: Processing Status for Dangerous Goods Basic Data DGWOS
1 DGTMD HNU THM031 DG: Hazard Identification Numbers MANDT
1 DGTMD HNU THM031 DG: Hazard Identification Numbers LWDG
1 DGTMD HNU THM031 DG: Hazard Identification Numbers HNU
0 DGTMD HPN1 THM017 DG Danger Label MANDT
0 DGTMD HPN1 THM017 DG Danger Label LWDG
0 DGTMD HPN1 THM017 DG Danger Label HPN
1 DGTMD HPN2 THM017 DG Danger Label MANDT
1 DGTMD HPN2 THM017 DG Danger Label LWDG
1 DGTMD HPN2 THM017 DG Danger Label HPN
0 DGTMD HPN3 THM017 DG Danger Label MANDT
0 DGTMD HPN3 THM017 DG Danger Label LWDG
0 DGTMD HPN3 THM017 DG Danger Label HPN
1 DGTMD HPN4 THM017 DG Danger Label MANDT
1 DGTMD HPN4 THM017 DG Danger Label LWDG
1 DGTMD HPN4 THM017 DG Danger Label HPN
0 DGTMD HPN5 THM017 DG Danger Label MANDT
0 DGTMD HPN5 THM017 DG Danger Label LWDG
0 DGTMD HPN5 THM017 DG Danger Label HPN
1 DGTMD HPN6 THM017 DG Danger Label MANDT
1 DGTMD HPN6 THM017 DG Danger Label LWDG
1 DGTMD HPN6 THM017 DG Danger Label HPN
0 DGTMD HPN7 THM017 DG Danger Label MANDT
0 DGTMD HPN7 THM017 DG Danger Label LWDG
0 DGTMD HPN7 THM017 DG Danger Label HPN
1 DGTMD HQTUN T006 Units of Measurement MANDT
0 DGTMD LAB1 TDG29 DG: Labels for Printing MANDT
1 DGTMD LAB10 TDG29 DG: Labels for Printing MANDT
0 DGTMD LAB2 TDG29 DG: Labels for Printing MANDT
1 DGTMD LAB3 TDG29 DG: Labels for Printing MANDT
0 DGTMD LAB4 TDG29 DG: Labels for Printing MANDT
1 DGTMD LAB5 TDG29 DG: Labels for Printing MANDT
0 DGTMD LAB6 TDG29 DG: Labels for Printing MANDT
1 DGTMD LAB7 TDG29 DG: Labels for Printing MANDT
0 DGTMD LAB8 TDG29 DG: Labels for Printing MANDT
1 DGTMD LAB9 TDG29 DG: Labels for Printing MANDT
0 DGTMD LDBC THM011 Classification Code MANDT
0 DGTMD LDBC THM011 Classification Code LWDG
0 DGTMD LDBC THM011 Classification Code DGCL
1 DGTMD LWDG THM063 DG: Dangerous Goods Regulation MANDT
1 DGTMD LWDG THM063 DG: Dangerous Goods Regulation LWDG
0 DGTMD MANDT T000 Clients MANDT
1 DGTMD MAPOL TDG109 DG: Marine Pollutant/Environmentally Hazardous MANDT
1 DGTMD MAPOL TDG109 DG: Marine Pollutant/Environmentally Hazardous MAPOL_ENVHAZ
0 DGTMD MAXU T006 Units of Measurement MANDT
1 DGTMD MINU T006 Units of Measurement MANDT
0 DGTMD MOS1 THM003 DG: Specify Transport Type MANDT
0 DGTMD MOS1 THM003 DG: Specify Transport Type LWDG
1 DGTMD MOS2 THM003 DG: Specify Transport Type MANDT
1 DGTMD MOS2 THM003 DG: Specify Transport Type LWDG
0 DGTMD MOS3 THM003 DG: Specify Transport Type MANDT
0 DGTMD MOS3 THM003 DG: Specify Transport Type LWDG
1 DGTMD MOS4 THM003 DG: Specify Transport Type MANDT
1 DGTMD MOS4 THM003 DG: Specify Transport Type LWDG
0 DGTMD MOS5 THM003 DG: Specify Transport Type MANDT
0 DGTMD MOS5 THM003 DG: Specify Transport Type LWDG
1 DGTMD MOS6 THM003 DG: Specify Transport Type MANDT
1 DGTMD MOS6 THM003 DG: Specify Transport Type LWDG
0 DGTMD MOS7 THM003 DG: Specify Transport Type MANDT
0 DGTMD MOS7 THM003 DG: Specify Transport Type LWDG
1 DGTMD MOS8 THM003 DG: Specify Transport Type MANDT
1 DGTMD MOS8 THM003 DG: Specify Transport Type LWDG
0 DGTMD MOS9 THM003 DG: Specify Transport Type MANDT
0 DGTMD MOS9 THM003 DG: Specify Transport Type LWDG
1 DGTMD MOSA THM003 DG: Specify Transport Type MANDT
1 DGTMD MOSA THM003 DG: Specify Transport Type LWDG
0 DGTMD NHME THM159 DG: Not Dangerous Goods Full/Empty Transport MANDT
1 DGTMD PAIU T006 Units of Measurement MANDT
1 DGTMD PAIU T006 Units of Measurement MSEHI
0 DGTMD PAOU T006 Units of Measurement MANDT
0 DGTMD PAOU T006 Units of Measurement MSEHI
1 DGTMD PIN THM075 DG: Packaging Regulation MANDT
1 DGTMD PIN THM075 DG: Packaging Regulation LWDG
0 DGTMD PINLQ THM075 DG: Packaging Regulation MANDT
0 DGTMD PINLQ THM075 DG: Packaging Regulation LWDG
1 DGTMD RELU T006 Units of Measurement MANDT
1 DGTMD RELU T006 Units of Measurement MSEHI
0 DGTMD RQU T006 Units of Measurement MANDT
1 DGTMD RVLID TCG91 EHS: Validity Area MANDT
1 DGTMD RVLID TCG91 EHS: Validity Area RVLID
0 DGTMD SDCL TDG37 DG: Dangerous Goods Storage Class MANDT
0 DGTMD SDCL TDG37 DG: Dangerous Goods Storage Class SDCL
1 DGTMD SRSID TCG56 EHS: Data Origin MANDT
1 DGTMD SRSID TCG56 EHS: Data Origin SRSID
0 DGTMD TKUI TDG73 DG: Identification Number Type MANDT
1 DGTMD TPCUN T006 Units of Measurement MANDT
0 DGTMD TPEUN T006 Units of Measurement MANDT
1 DGTMD TPFUN T006 Units of Measurement MANDT
0 DGTMD TPSHU T006 Units of Measurement MANDT
1 DGTMD TPSLU T006 Units of Measurement MANDT
0 DGTMD UBOPO T006 Units of Measurement MANDT
1 DGTMD UBUDE T006 Units of Measurement MANDT
0 DGTMD UCOOE T006 Units of Measurement MANDT
1 DGTMD UDENFE T006 Units of Measurement MANDT
0 DGTMD UDENFI T006 Units of Measurement MANDT
1 DGTMD UDENTW T006 Units of Measurement MANDT
0 DGTMD UMEPO T006 Units of Measurement MANDT
1 DGTMD UMTMP T006 Units of Measurement MANDT
0 DGTMD UPAGW T006 Units of Measurement MANDT
0 DGTMD UPAGW T006 Units of Measurement MSEHI
1 DGTMD UPASI T006 Units of Measurement MANDT
1 DGTMD UPASI T006 Units of Measurement MSEHI
0 DGTMD USOOW T006 Units of Measurement MANDT
1 DGTMD USTPRE T006 Units of Measurement MANDT
0 DGTMD UVISC T006 Units of Measurement MANDT
1 DGTMD VBFC TDG35 DG: VbF Classes MANDT
1 DGTMD VBFC TDG35 DG: VbF Classes VBFC