DGTMD

DG: Dangerous Goods Master | #masterdata | Component: Environment, Health and Safety: Master Data
Column Name Description
MANDT FK Client
RECN Sequential Number of Data Record
ACTN Sequential Number of the Change State
Column Name Description
Column Name Description
📏 Temperature Unit (Control) (TPCUN):
COTMP Control Temperature
📏 Temperature Unit (Emergency) (TPEUN):
EMTMP Emergency Temperature
📏 Temperature Unit (Flame) (TPFUN):
FLTMP Flash Point
📏 Unit for temperature sensitivity (lower limit) (TPSLU):
TPSNL Temperature Sensitivity (Lower Limit)
📏 Temperature Unit (Sensitivity - Upper Limit) (TPSHU):
TPSNH Temperature sensitivity (upper limit)
📏 Maximum Quantity Unit (HQTUN):
HQTU Maximum Quantity per Transport Unit
📏 Unit of Meas. for Limited Quantity (LQ) Inner Packaging (PAIU):
PAI Limited Quantity (LQ) Inner Packaging
📏 Unit of Meas. for Limited Quantity (LQ) Outer Packaging (PAOU):
PAO Limited Quantity (LQ) Outer Packaging
📏 Unit of measure for reportable quantities (RQU):
RQA Reportable Quantity
📏 Unit of Measurement Minimum Quantity (Listed Goods) (MINU):
MINQ Minimum Quantity for Listed Goods
📏 Unit of Measurement Maximum Quantity (Listed Goods) (MAXU):
MAXQ Maximum Quantity for Listed Goods
📏 Unit of Measure Quantity Limit (RELU):
RELQ Exemption (ADR 1.1.3.6)
📏 Unit for solubility of water (USOOW):
SOOWA Solubility of water
📏 Unit for density I (UDENFE):
DENFEE Density I
📏 Unit for density II (UDENTW):
DENTWE Density II
📏 Unit for density III (UDENFI):
DENFIF Density III
📏 Unit for Bulk Density (UBUDE):
BUDEN Bulk Density
📏 Unit for Boiling Point (UBOPO):
BOPOI Boiling Point
📏 Unit for Viscosity (UVISC):
VISCO Viscosity
📏 Unit for vapor pressure (USTPRE):
STPRES Vapor Pressure
📏 Unit for Melting Point (UMEPO):
MEPOI Melting Point
📏 Unit for Coefficient of Expansion (UCOOE):
COOEX Coefficient of Expansion
📏 Unit for medium filling temperature (UMTMP):
MTMPF Medium Temperature of Liquid During Filling
📏 Unit of Measurement for Single Packaging (UPASI):
PASI Maximum Quantity per Package
📏 Unit of Measurement for Limited Quantity (LQ) Gross (UPAGW):
PAGW Limited Quantity (LQ) Gross Weight
Column Name Description
VALFR Valid-From Date
VALTO Valid-To Date
CRDAT Created On
UPDDAT Last Changed On
Column Name Description
DELFLG Deletion Indicator Show values
PARKFLG Data Record Is Inactive Show values
DGCAO Only Cargo Air Transport Permitted Show values
PBI Poisonous by Inhalation Show values
RCHEM Notification Status (Law on Control of Toxic Substances) Show values
DGPTA Shipping by Mail Permitted Show values
DGTNA Transport Not Permitted Show values
SCASE Special Case (Packing Check) Show values
COLNO Collective Number Show values
Column Name Description Domain name
CRNAM Created By USNAM
UPDNAM Last Changed By USNAM
RECNROOT Sequential Number of Data Record ESDRECN
DGNU Identification Number CHAR4
DGRES1 Hazard-Inducing Substance CHAR12
DGRES2 Hazard-Inducing Substance CHAR12
DGSC Dangerous Goods Subclass CHAR6
SDBC Hazard Item Number NUMC4
SLBE Hazard Item Number (Empty Transport) NUMC4
STOSU Aggregate State for Transport CHAR1
DAIN1 Hazard Note CHAR4
DAIN2 Hazard Note CHAR4
DAIN3 Hazard Note CHAR4
DAIN4 Hazard Note CHAR4
DAIN5 Hazard Note CHAR4
DAIN6 Hazard Note CHAR4
DAIN7 Hazard Note CHAR4
DAIN8 Hazard Note CHAR4
DAIN9 Hazard Note CHAR4
DAIN10 Hazard Note CHAR4
EINU Tremcard Number CHAR7
EICN Replacement Tremcard Number CHAR7
EMSN1 EmS/ERG Number 1 CHAR7
EMSN2 EmS/ERG Number 2 CHAR7
MFAG1 MFAG Number 1 CHAR4
MFAG2 MFAG Number 2 CHAR4
PGRO Packing Group CHAR3
KDGVS Text Key Highly Viscous Substances TDOBNAME
KDGNS Text Key Exemption for Named Substances TDOBNAME
KDGMP Text Key Marine Pollutant TDOBNAME
KDGEX Text Key Exceptions TDOBNAME
KDGHI Text key handling data TDOBNAME
KDGF1 User-Defined Text Key 1 TDOBNAME
KDGF2 User-Defined Text Key 2 TDOBNAME
KDGF3 User-Defined Text Key 3 TDOBNAME
KDGF4 User-Defined Text Key 4 TDOBNAME
KDGF5 User-Defined Text Key 5 TDOBNAME
KDGF6 User-Defined Text Key 6 TDOBNAME
KDGF7 User-Defined Text Key 7 TDOBNAME
KDGF8 User-Defined Text Key 8 TDOBNAME
KDGF9 User-Defined Text Key 9 TDOBNAME
KDGF10 User-Defined Text Key 10 TDOBNAME
MULRQ Multiplication Factor Exemption (ADR 1.1.3.6) NUMC4
DGSHE Schedule of Class 7 CHAR4
PIMDG Note on Regulation CHAR10
HYGRO Hygroscopicity CHAR1
STOPA Packaging Mark CHAR1
SPPRO Special Provision CHAR5
EXCEP Exception and Agreement Number CHAR40
DGRES3 Hazard-Inducing Substance CHAR12
DGREMP Hazard-inducing substance (marine pollutant) CHAR12
DGRERQ Hazard-inducing substance (reportable quantity) CHAR12
EIMDG Regulation Edition CHAR4
Master Data Relations Join Conditions
Change Number
  • Change Number
  • Client
  • DGTMD.AENNR == AENR.AENNR
  • DGTMD.MANDT == AENR.MANDT
DG-MAT: DGTMD-COWE
  • Water Pollution Class
  • Client
  • DGTMD.COWE == TDG15.COWE
  • DGTMD.MANDT == TDG15.MANDT
Dangerous Goods Class
  • Dangerous Goods Class
  • Dangerous Goods Regulation
  • Client
DGTMD: Non-DG Full Transport
  • Non-Dangerous Goods Full Transport
  • Client
DG-MAT: DGTMD - DGWOS
Hazard identification number
  • Hazard Identification Number
  • Client
  • Dangerous Goods Regulation
Danger Label Number 1
  • Dangerous Goods Regulation
  • Danger Label Number 1
Danger Label Number 2
  • Dangerous Goods Regulation
  • Danger Label Number 2
Danger Label Number 3
  • Dangerous Goods Regulation
  • Danger Label Number 3
Danger Label Number 4
  • Dangerous Goods Regulation
  • Danger Label Number 4
Danger Label Number 5
  • Dangerous Goods Regulation
  • Danger Label Number 5
Danger Label Number 6
  • Dangerous Goods Regulation
  • Danger Label Number 6
Danger Label Number 7
  • Dangerous Goods Regulation
  • Danger Label Number 7
DG-MAT: DGTMD-HQTUN
  • DGTMD.MANDT == T006.MANDT
  • DGTMD.HQTUN == T006.MSEHI
DG-MAT: DGTMD - LAB1
  • DGTMD.MANDT == TDG29.MANDT
  • DGTMD.LAB1 == TDG29.LAB
DG-MAT: DGTMD - LABA
  • DGTMD.MANDT == TDG29.MANDT
  • DGTMD.LAB10 == TDG29.LAB
DG-MAT: DGTMD - LAB2
  • DGTMD.MANDT == TDG29.MANDT
  • DGTMD.LAB2 == TDG29.LAB
DG-MAT: DGTMD - LAB3
  • DGTMD.MANDT == TDG29.MANDT
  • DGTMD.LAB3 == TDG29.LAB
DG-MAT: DGTMD - LAB4
  • DGTMD.MANDT == TDG29.MANDT
  • DGTMD.LAB4 == TDG29.LAB
DG-MAT: DGTMD - LAB5
  • DGTMD.MANDT == TDG29.MANDT
  • DGTMD.LAB5 == TDG29.LAB
DG-MAT: DGTMD - LAB6
  • DGTMD.MANDT == TDG29.MANDT
  • DGTMD.LAB6 == TDG29.LAB
DG-MAT: DGTMD - LAB7
  • DGTMD.MANDT == TDG29.MANDT
  • DGTMD.LAB7 == TDG29.LAB
DG-MAT: DGTMD - LAB8
  • DGTMD.MANDT == TDG29.MANDT
  • DGTMD.LAB8 == TDG29.LAB
DG-MAT: DGTMD - LAB9
  • DGTMD.MANDT == TDG29.MANDT
  • DGTMD.LAB9 == TDG29.LAB
Dangerous goods letter
  • Dangerous Goods Class
  • Classification Code
  • Client
  • Dangerous Goods Regulation
DG-MAT: DGTMD - LWDG
Client DGTMD.MANDT == T000.MANDT
Marine Pollutant
  • DGTMD.MANDT == TDG109.MANDT
  • DGTMD.MAPOL == TDG109.MAPOL_ENVHAZ
DG-MAT: DGTMD-MAXU
  • DGTMD.MANDT == T006.MANDT
  • DGTMD.MAXU == T006.MSEHI
DG-MAT: DGTMD-MINU
  • DGTMD.MANDT == T006.MANDT
  • DGTMD.MINU == T006.MSEHI
DG-MAT: DGTMD-MOS1
  • Dangerous Goods Transport Type
  • Client
  • Dangerous Goods Regulation
DG-MAT: DGTMD-MOS
  • Dangerous Goods Transport Type
  • Client
  • Dangerous Goods Regulation
DG-MAT: DGTMD-MOS3
  • Dangerous Goods Transport Type
  • Client
  • Dangerous Goods Regulation
DG-MAT: DGTMD-MOS4
  • Dangerous Goods Transport Type
  • Client
  • Dangerous Goods Regulation
DG-MAT: DGTMD-MOS5
  • Dangerous Goods Transport Type
  • Client
  • Dangerous Goods Regulation
DG-MAT: DGTMD-MOS6
  • Dangerous Goods Transport Type
  • Client
  • Dangerous Goods Regulation
DG-MAT: DGTMD-MOS7
  • Dangerous Goods Transport Type
  • Client
  • Dangerous Goods Regulation
DG-MAT: DGTMD-MOS8
  • Dangerous Goods Transport Type
  • Client
  • Dangerous Goods Regulation
DG-MAT: DGTMD-MOS9
  • Dangerous Goods Transport Type
  • Client
  • Dangerous Goods Regulation
DG-MAT: DGTMD-MOSA
  • Dangerous Goods Transport Type
  • Client
  • Dangerous Goods Regulation
DG: Mode-of-Transport Category
DGTMD: Non-DG Empty Transport
  • Non-Dangerous Goods Empty Transport
  • Client
DG-MAT: DGTMD-PAIU
  • DGTMD.MANDT == T006.MANDT
  • DGTMD.PAIU == T006.MSEHI
DG-MAT: DGTMD-PAOU
  • DGTMD.MANDT == T006.MANDT
  • DGTMD.PAOU == T006.MSEHI
Dangerous goods regulation
  • Dangerous Goods Regulation
  • Packing Instruction Number
Dangerous goods regulation
  • Dangerous Goods Regulation
  • Packing Instruction Number for Limited Quantity (LQ)
DG-MAT: DGTMD-RELU
  • DGTMD.MANDT == T006.MANDT
  • DGTMD.RELU == T006.MSEHI
DG-MAT: DGTMD-RQU
  • DGTMD.MANDT == T006.MANDT
  • DGTMD.RQU == T006.MSEHI
DG-MAT: DGTMD-RVLID
  • DGTMD.MANDT == TCG91.MANDT
  • DGTMD.RVLID == TCG91.RVLID
DG-MAT: DGTMD - SDCL
  • Storage Hazard Class
  • Client
  • DGTMD.SDCL == TDG37.SDCL
  • DGTMD.MANDT == TDG37.MANDT
EHS: Foreign Key for Substance Authorization Group
  • DGTMD.MANDT == TCG56.MANDT
  • DGTMD.SRSID == TCG56.SRSID
DGTMD - TKUI
  • Identification Number Type
  • Client
  • DGTMD.TKUI == TDG73.TKUI
  • DGTMD.MANDT == TDG73.MANDT
DG-MAT: DGTMD-TPCUN
  • DGTMD.MANDT == T006.MANDT
  • DGTMD.TPCUN == T006.MSEHI
DG-MAT: DGTMD-TPEUN
  • DGTMD.MANDT == T006.MANDT
  • DGTMD.TPEUN == T006.MSEHI
DG-MAT: DGTMD-TPFUN
  • DGTMD.MANDT == T006.MANDT
  • DGTMD.TPFUN == T006.MSEHI
DG-MAT: DGTMD-TPSHU
  • DGTMD.MANDT == T006.MANDT
  • DGTMD.TPSHU == T006.MSEHI
DG-MAT: DGTMD-TPSLU
  • DGTMD.MANDT == T006.MANDT
  • DGTMD.TPSLU == T006.MSEHI
DG-MAT: DGTMD - UBOPO
  • DGTMD.MANDT == T006.MANDT
  • DGTMD.UBOPO == T006.MSEHI
DG-MAT: DGTMD - UBUDE
  • DGTMD.MANDT == T006.MANDT
  • DGTMD.UBUDE == T006.MSEHI
DG-MAT: DGTMD - UCOOE
  • DGTMD.MANDT == T006.MANDT
  • DGTMD.UCOOE == T006.MSEHI
DG-MAT: DGTMD - UDENFE
  • DGTMD.MANDT == T006.MANDT
  • DGTMD.UDENFE == T006.MSEHI
DG-MAT: DGTMD - UDENFI
  • DGTMD.MANDT == T006.MANDT
  • DGTMD.UDENFI == T006.MSEHI
DG-MAT: DGTMD - UDENTW
  • DGTMD.MANDT == T006.MANDT
  • DGTMD.UDENTW == T006.MSEHI
DG-MAT: DGTMD - UMEPO
  • DGTMD.MANDT == T006.MANDT
  • DGTMD.UMEPO == T006.MSEHI
DG-MAT: DGTMD - UMTMP
  • DGTMD.MANDT == T006.MANDT
  • DGTMD.UMTMP == T006.MSEHI
DG-MAT: DGTMD - UPAGW
  • DGTMD.MANDT == T006.MANDT
  • DGTMD.UPAGW == T006.MSEHI
DG-MAT: DGTMD - UPASI
  • DGTMD.MANDT == T006.MANDT
  • DGTMD.UPASI == T006.MSEHI
DG-MAT: DGTMD - USOOW
  • DGTMD.MANDT == T006.MANDT
  • DGTMD.USOOW == T006.MSEHI
DG-MAT: DGTMD - USTPRE
  • DGTMD.MANDT == T006.MANDT
  • DGTMD.USTPRE == T006.MSEHI
DG-MAT: DGTMD - UVISC
  • DGTMD.MANDT == T006.MANDT
  • DGTMD.UVISC == T006.MSEHI
DG-MAT: DGTMD - VBFC
  • DGTMD.MANDT == TDG35.MANDT
  • DGTMD.VBFC == TDG35.VBFC