DGMSD

DG: Dangerous Goods Document Table DGMSD | #transactional | Component: Environment, Health, and Safety / Product Compliance
Column Name Description
MANDT FK Client
VBELN Sales and Distribution Document Number
POSNR Sales Document Item
LFDNR Counter used to differentiate between data base entries
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
📏 Unit for Miscibility with Water (UMIOW):
MIOWA Miscibility with Water
📏 Unit of measure for reportable quantities (RQU2):
RQA2 Reportable Quantity
📏 Unit for Net Explosive Substance Mass (EXPL_NET_U):
EXPL_NET Net Explosive Substance Mass
📏 Unit of Maximum Activity (ACTVTY_MAX_U):
ACTVTY_MAX Maximum Activity
📏 Unit of Relative Maximum Activity (ACTVTY_MAX_REL_U):
ACTVTY_MAX_REL Relative Maximum Activity
Column Name Description
_DATAAGING Data Filter Value for Data Aging
Column Name Description
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
DAOR Data Origin (Filling and Distribution) Show values
LTSK Air Transport Safety Code Show values
EMV Electromagnetic Compatibility Show values
FSAK Parachute Drop Code Show values
SFK Thrust Code Show values
FLG_EMSN1_U EmS Number 1 Underlined Show values
FLG_EMSN2_U EmS Number 2 Underlined Show values
FLG_PAI Value Entered for Limited Quantity (LQ) Inner Packaging Show values
FLG_PAO Value Entered for Limited Quantity (LQ) Outer Packaging Show values
FLG_PASI Value Entered for Maximum Quantity per Package Show values
FLG_PAGW Value Entered for Limited Quantity (LQ) Gross Weight Show values
FLG_RELQ Value Entered for Exemption Show values
FLG_MULRQ Value Entered for Multiplication Factor Show values
FLG_RELQ_UNLIMIT Unlimited Set for Exemption Show values
FLG_MULRQ_FORBID Prohibited Set for Multiplication Factor Show values
Column Name Description Domain name
DGNU Identification Number CHAR4
DGSC Dangerous Goods Subclass CHAR6
SDBC Hazard Item Number NUMC4
SLBE Hazard Item Number (Empty Transport) NUMC4
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
MULRQ Multiplication Factor Exemption (ADR 1.1.3.6) NUMC4
DGSHE Schedule of Class 7 CHAR4
PIMDG Note on Regulation CHAR10
STOPA Packaging Mark CHAR1
SPPRO Special Provision CHAR5
MAPOL Marine Pollutant ADGD_MAPOL
EXCEP Exception and Agreement Number CHAR40
EIMDG Regulation Edition CHAR4
PDGNUD Dangerous Goods Description CHAR21
PRES1 Hazard-Inducing Substance CHAR21
PRES2 Hazard-Inducing Substance CHAR21
PRES3 Hazard-Inducing Substance CHAR21
PREMP1 Hazard-inducing substance (marine pollutant) CHAR21
PRERQ1 Hazard-inducing substance (reportable quantity) CHAR21
PRERQ2 Hazard-inducing substance (reportable quantity) CHAR21
PSTOSU Aggregate State for Transport CHAR21
PDAIN1 Hazard Note 1 CHAR21
PDAIN2 Hazard Note 2 CHAR21
PDAIN3 Hazard Note 3 CHAR21
PDAIN4 Hazard Note 4 CHAR21
PDAIN5 Hazard Note 5 CHAR21
PDAIN6 Hazard Note 6 CHAR21
PDAIN7 Hazard Note 7 CHAR21
PDAIN8 Hazard Note 8 CHAR21
PDAIN9 Hazard Note 9 CHAR21
PDAIN10 Hazard Note 10 CHAR21
PHYGRO Hygroscopicity CHAR21
PDGF1 User-Defined Text Key 1 CHAR21
PDGF2 User-Defined Text Key 2 CHAR21
PDGF3 User-Defined Text Key 3 CHAR21
PDGF4 User-Defined Text Key 4 CHAR21
PDGF5 User-Defined Text Key 5 CHAR21
PDGF6 User-Defined Text Key 6 CHAR21
PDGF7 User-Defined Text Key 7 CHAR21
PDGF8 User-Defined Text Key 8 CHAR21
PDGF9 User-Defined Text Key 9 CHAR21
PDGFA User-Defined Text Key 10 CHAR21
PDGFB User-Defined Text Key 11 CHAR21
PDGFC User-Defined Text Key 12 CHAR21
PDGFD User-Defined Text Key 13 CHAR21
PDGFE User-Defined Text Key 14 CHAR21
PDGFF User-Defined Text Key 15 CHAR21
PTXTPATT Dangerous Goods Text Pattern CHAR21
PREMP2 Hazard-inducing substance (marine pollutant) CHAR21
FORM_PHYS_CHEM Physical and Chemical Form CHAR21
EXPL_REL_PERCENT Relative Net Explosive Substance Percentage DEC3_3
MUNAKODE Ammunition Code CHAR4
EXNUMBER EX Number CHAR12
CERTIFIC Identification Mark for Approval Certificate CHAR21
HAZCHEM_CODE Code for Chemical Hazard CBDUD_HAZCHEM_CODE
CARR_TYPE Transport Category CBUND_CARR_TYPE
PDGNUDPRE Dangerous Goods Description Prefix CHAR21
PDGNUDSUF Dangerous Goods Description Suffix CHAR21
Master Data Relations Join Conditions
Unit of Relative Maximum Activity
  • DGMSD.MANDT == T006.MANDT
  • DGMSD.ACTVTY_MAX_REL_U == T006.MSEHI
Unit of Maximum Activity
  • DGMSD.MANDT == T006.MANDT
  • DGMSD.ACTVTY_MAX_U == T006.MSEHI
DG-MAT: DGTMD-COWE
  • Water Pollution Class
  • Client
  • DGMSD.COWE == TDG15.COWE
  • DGMSD.MANDT == TDG15.MANDT
Dangerous Goods Class
  • Dangerous Goods Class
  • Dangerous Goods Regulation
  • Client
Non-DG Full Transport
  • Non-Dangerous Goods Full Transport
  • Client
DG-MAT: DGTMD - DGWOS
DG: Enterprise-Specific Mixed Loading Groups 1
DG: Enterprise-Specific Mixed Loading Groups 2
DG: Enterprise-Specific Mixed Loading Groups 3
Unit for Net Explosive Substance Mass
  • DGMSD.MANDT == T006.MANDT
  • DGMSD.EXPL_NET_U == T006.MSEHI
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
  • DGMSD.MANDT == T006.MANDT
  • DGMSD.HQTUN == T006.MSEHI
DG-MAT: DGTMD - LAB1
  • DGMSD.MANDT == TDG29.MANDT
  • DGMSD.LAB1 == TDG29.LAB
DG-MAT: DGTMD - LAB10
  • DGMSD.MANDT == TDG29.MANDT
  • DGMSD.LAB10 == TDG29.LAB
DG-MAT: DGTMD - LAB2
  • DGMSD.MANDT == TDG29.MANDT
  • DGMSD.LAB2 == TDG29.LAB
DG-MAT: DGTMD - LAB3
  • DGMSD.MANDT == TDG29.MANDT
  • DGMSD.LAB3 == TDG29.LAB
DG-MAT: DGTMD - LAB4
  • DGMSD.MANDT == TDG29.MANDT
  • DGMSD.LAB4 == TDG29.LAB
DG-MAT: DGTMD - LAB5
  • DGMSD.MANDT == TDG29.MANDT
  • DGMSD.LAB5 == TDG29.LAB
DG-MAT: DGTMD - LAB6
  • DGMSD.MANDT == TDG29.MANDT
  • DGMSD.LAB6 == TDG29.LAB
DG-MAT: DGTMD - LAB7
  • DGMSD.MANDT == TDG29.MANDT
  • DGMSD.LAB7 == TDG29.LAB
DG-MAT: DGTMD - LAB8
  • DGMSD.MANDT == TDG29.MANDT
  • DGMSD.LAB8 == TDG29.LAB
DG-MAT: DGTMD - LAB9
  • DGMSD.MANDT == TDG29.MANDT
  • DGMSD.LAB9 == TDG29.LAB
Classification Code
  • Dangerous Goods Class
  • Classification Code
  • Client
  • Dangerous Goods Regulation
DG-MAT: DGTMD - LWDG
Client DGMSD.MANDT == T000.MANDT
Material Number
  • Material Number
  • Client
  • DGMSD.MATNR == MARA.MATNR
  • DGMSD.MANDT == MARA.MANDT
DG-MAT: DGTMD-MAXU
  • DGMSD.MANDT == T006.MANDT
  • DGMSD.MAXU == T006.MSEHI
DG-MAT: DGTMD-MINU
  • DGMSD.MANDT == T006.MANDT
  • DGMSD.MINU == T006.MSEHI
DG: Mixed Loading Rule 1
  • Dangerous Goods Regulation
  • Client
  • Mixed Loading Rule 1
DG: Mixed Loading Rule 2
  • Dangerous Goods Regulation
  • Client
  • Mixed Loading Rule 2
DG: Mixed Loading Rule 3
  • Dangerous Goods Regulation
  • Client
  • Mixed Loading Rule 3
DG: Mixed Loading Rule 4
  • Dangerous Goods Regulation
  • Client
  • Mixed Loading Rule 4
DG: Mixed Loading Rule 5
  • Dangerous Goods Regulation
  • Client
  • Mixed Loading Rule 5
DG: Mixed Loading Rule 6
  • Dangerous Goods Regulation
  • Client
  • Mixed Loading Rule 6
DG: Mixed Loading Rule 7
  • Dangerous Goods Regulation
  • Client
  • Mixed Loading Rule 7
DG: Mixed Loading Rule 8
  • Dangerous Goods Regulation
  • Client
  • Mixed Loading Rule 8
DG: Mixed Loading Rule 9
  • Dangerous Goods Regulation
  • Client
  • Mixed Loading Rule 9
DG: Mixed Loading Rule A
  • Dangerous Goods Regulation
  • Client
  • Mixed Loading Rule 10
Dangerous Goods Transport Type
  • Dangerous Goods Transport Type
  • Client
  • Dangerous Goods Regulation
Dangerous Goods Transport Type
  • Dangerous Goods Transport Type
  • Client
  • Dangerous Goods Regulation
Dangerous Goods Transport Type
  • Dangerous Goods Transport Type
  • Client
  • Dangerous Goods Regulation
Dangerous Goods Transport Type
  • Dangerous Goods Transport Type
  • Client
  • Dangerous Goods Regulation
Dangerous Goods Transport Type
  • Dangerous Goods Transport Type
  • Client
  • Dangerous Goods Regulation
Dangerous Goods Transport Type
  • Dangerous Goods Transport Type
  • Client
  • Dangerous Goods Regulation
Dangerous Goods Transport Type
  • Dangerous Goods Transport Type
  • Client
  • Dangerous Goods Regulation
Dangerous Goods Transport Type
  • Dangerous Goods Transport Type
  • Client
  • Dangerous Goods Regulation
Dangerous Goods Transport Type
  • Dangerous Goods Transport Type
  • Client
  • Dangerous Goods Regulation
Dangerous Goods Transport Type
  • Dangerous Goods Transport Type
  • Client
  • Dangerous Goods Regulation
DGMSD: Mode of Transport Category
DG: Segregation Rule 1
  • Dangerous Goods Regulation
  • Client
  • Segregation Key 1
DG: Segregation Rule 2
  • Dangerous Goods Regulation
  • Client
  • Segregation Key 2
DG: Segregation Rule 3
  • Dangerous Goods Regulation
  • Client
  • Segregation Key 3
DG: Segregation Rule 4
  • Dangerous Goods Regulation
  • Client
  • Segregation Key 4
DG: Segregation Rule 5
  • Dangerous Goods Regulation
  • Client
  • Segregation Key 5
DG: Segregation Rule 6
  • Dangerous Goods Regulation
  • Client
  • Segregation Key 6
DG: Segregation Rule 7
  • Dangerous Goods Regulation
  • Client
  • Segregation Key 7
DG: Segregation Rule 8
  • Dangerous Goods Regulation
  • Client
  • Segregation Key 8
DG: Segregation Rule 9
  • Dangerous Goods Regulation
  • Client
  • Segregation Key 9
DG: Segregation Rule A
  • Dangerous Goods Regulation
  • Client
  • Segregation Key 10
DG: Segregation Rule B
  • Dangerous Goods Regulation
  • Client
  • Segregation Key 11
DG: Segregation Rule C
  • Dangerous Goods Regulation
  • Client
  • Segregation Key 12
DG: Segregation Rule D
  • Dangerous Goods Regulation
  • Client
  • Segregation Key 13
DG: Segregation Rule E
  • Dangerous Goods Regulation
  • Client
  • Segregation Key 14
DG: Segregation Rule F
  • Dangerous Goods Regulation
  • Client
  • Segregation Key 15
DG: Segregation Rule G
  • Dangerous Goods Regulation
  • Client
  • Segregation Key 16
DG: Segregation Rule H
  • Dangerous Goods Regulation
  • Client
  • Segregation Key 17
Non-DG Empty Transport
  • Non-Dangerous Goods Empty Transport
  • Client
DG-MAT: DGTMD-PAIU
  • DGMSD.MANDT == T006.MANDT
  • DGMSD.PAIU == T006.MSEHI
DG-MAT: DGTMD-PAOU
  • DGMSD.MANDT == T006.MANDT
  • DGMSD.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)
Profile for Dangerous Goods User-Defined Text 1
  • Profile for Dangerous Goods User-Defined Text 1
  • Client
  • Dangerous Goods Regulation
Profile for Dangerous Goods User-Defined Text 2
  • Profile for Dangerous Goods User-Defined Text 2
  • Client
  • Dangerous Goods Regulation
Profile for Dangerous Goods User-Defined Text 3
  • Profile for Dangerous Goods User-Defined Text 3
  • Client
  • Dangerous Goods Regulation
Profile for Dangerous Goods User-Defined Text 4
  • Profile for Dangerous Goods User-Defined Text 4
  • Client
  • Dangerous Goods Regulation
Profile for Dangerous Goods User-Defined Text 5
  • Profile for Dangerous Goods User-Defined Text 5
  • Client
  • Dangerous Goods Regulation
Profile for Dangerous Goods User-Defined Text 6
  • Profile for Dangerous Goods User-Defined Text 6
  • Client
  • Dangerous Goods Regulation
Profile for Dangerous Goods User-Defined Text 7
  • Profile for Dangerous Goods User-Defined Text 7
  • Client
  • Dangerous Goods Regulation
Profile for Dangerous Goods User-Defined Text 8
  • Profile for Dangerous Goods User-Defined Text 8
  • Client
  • Dangerous Goods Regulation
Profile for Dangerous Goods User-Defined Text 9
  • Profile for Dangerous Goods User-Defined Text 9
  • Client
  • Dangerous Goods Regulation
Profile for Dangerous Goods User-Defined Text 10
  • Profile for Dangerous Goods User-Defined Text 10
  • Client
  • Dangerous Goods Regulation
Profile for Dangerous Goods User-Defined Text 11
  • Profile for Dangerous Goods User-Defined Text 11
  • Client
  • Dangerous Goods Regulation
Profile for Dangerous Goods User-Defined Text 12
  • Profile for Dangerous Goods User-Defined Text 12
  • Client
  • Dangerous Goods Regulation
Profile for Dangerous Goods User-Defined Text 13
  • Profile for Dangerous Goods User-Defined Text 13
  • Client
  • Dangerous Goods Regulation
Profile for Dangerous Goods User-Defined Text 14
  • Profile for Dangerous Goods User-Defined Text 14
  • Client
  • Dangerous Goods Regulation
Profile for Dangerous Goods User-Defined Text 15
  • Profile for Dangerous Goods User-Defined Text 15
  • Client
  • Dangerous Goods Regulation
DG-MAT: DGTMD-RELU
  • DGMSD.MANDT == T006.MANDT
  • DGMSD.RELU == T006.MSEHI
DG-MAT: DGTMD-RQU
  • DGMSD.MANDT == T006.MANDT
  • DGMSD.RQU == T006.MSEHI
Unit of measure for reportable quantities
  • DGMSD.MANDT == T006.MANDT
  • DGMSD.RQU2 == T006.MSEHI
DG: Regulation-Dependent Mixed Loading Group 1
  • Dangerous Goods Regulation
  • Regulation-Dependent Mixed Loading Group 1
  • Client
DG: Regulation-Dependent Mixed Loading Group 2
  • Dangerous Goods Regulation
  • Regulation-Dependent Mixed Loading Group 2
  • Client
DG: Regulation-Dependent Mixed Loading Group 3
  • Dangerous Goods Regulation
  • Regulation-Dependent Mixed Loading Group 3
  • Client
DG-MAT: DGTMD-RVLID
  • DGMSD.MANDT == TCG91.MANDT
  • DGMSD.RVLID == TCG91.RVLID
DG-MAT: DGTMD - SDCL
  • Storage Hazard Class
  • Client
  • DGMSD.SDCL == TDG37.SDCL
  • DGMSD.MANDT == TDG37.MANDT
Stowage Category
  • Stowage Category
  • ?
  • Client
DGTMD - TKUI
  • Identification Number Type
  • Client
  • DGMSD.TKUI == TDG73.TKUI
  • DGMSD.MANDT == TDG73.MANDT
DG-MAT: DGTMD-TPCUN
  • DGMSD.MANDT == T006.MANDT
  • DGMSD.TPCUN == T006.MSEHI
DG-MAT: DGTMD-TPEUN
  • DGMSD.MANDT == T006.MANDT
  • DGMSD.TPEUN == T006.MSEHI
DG-MAT: DGTMD-TPFUN
  • DGMSD.MANDT == T006.MANDT
  • DGMSD.TPFUN == T006.MSEHI
DG-MAT: DGTMD-TPSHU
  • DGMSD.MANDT == T006.MANDT
  • DGMSD.TPSHU == T006.MSEHI
DG-MAT: DGTMD-TPSLU
  • DGMSD.MANDT == T006.MANDT
  • DGMSD.TPSLU == T006.MSEHI
DG-MAT: DGTMD - UBOPO
  • DGMSD.MANDT == T006.MANDT
  • DGMSD.UBOPO == T006.MSEHI
DG-MAT: DGTMD - UBUDE
  • DGMSD.MANDT == T006.MANDT
  • DGMSD.UBUDE == T006.MSEHI
DG-MAT: DGTMD - UCOOE
  • DGMSD.MANDT == T006.MANDT
  • DGMSD.UCOOE == T006.MSEHI
DG-MAT: DGTMD - UDENFE
  • DGMSD.MANDT == T006.MANDT
  • DGMSD.UDENFE == T006.MSEHI
DG-MAT: DGTMD - UDENFI
  • DGMSD.MANDT == T006.MANDT
  • DGMSD.UDENFI == T006.MSEHI
DG-MAT: DGTMD - UDENTW
  • DGMSD.MANDT == T006.MANDT
  • DGMSD.UDENTW == T006.MSEHI
DG-MAT: DGTMD - UMEPO
  • DGMSD.MANDT == T006.MANDT
  • DGMSD.UMEPO == T006.MSEHI
DG: RDGM2 - UMIOW
  • DGMSD.MANDT == T006.MANDT
  • DGMSD.UMIOW == T006.MSEHI
DG-MAT: DGTMD - UMTMP
  • DGMSD.MANDT == T006.MANDT
  • DGMSD.UMTMP == T006.MSEHI
DG-MAT: DGTMD - UPAGW
  • DGMSD.MANDT == T006.MANDT
  • DGMSD.UPAGW == T006.MSEHI
DG-MAT: DGTMD - UPASI
  • DGMSD.MANDT == T006.MANDT
  • DGMSD.UPASI == T006.MSEHI
DG-MAT: DGTMD - USOOW
  • DGMSD.MANDT == T006.MANDT
  • DGMSD.USOOW == T006.MSEHI
DG-MAT: DGTMD - USTPRE
  • DGMSD.MANDT == T006.MANDT
  • DGMSD.USTPRE == T006.MSEHI
DG-MAT: DGTMD - UVISC
  • DGMSD.MANDT == T006.MANDT
  • DGMSD.UVISC == T006.MSEHI
DG-MAT: DGTMD - VBFC
  • DGMSD.MANDT == TDG35.MANDT
  • DGMSD.VBFC == TDG35.VBFC