SAP Table DGTMD - DG: Dangerous Goods Master

Field Key Data Element Type Offset Leng Decimals Check Table Text
MANDT X MANDT CLNT 0 3 0 T000 Client
RECN X ESERECN NUMC 3 20 0 Sequential Number of Data Record
ACTN X ESEACTN NUMC 23 20 0 Sequential Number of the Change State
VALFR ESEVALFR DATS 43 8 0 Valid-From Date
VALTO ESEVALTO DATS 51 8 0 Valid-To Date
AENNR ESEAENNR CHAR 59 12 0 Change Number
DELFLG ADGE_DELFLG CHAR 71 1 0 Deletion Indicator
PARKFLG ESEPARKFLG CHAR 72 1 0 Data Record Is Inactive
CRDAT ESECRDAT DATS 73 8 0 Created On
CRNAM ESECRNAM CHAR 81 12 0 Created By
UPDDAT ESEUPDDAT DATS 93 8 0 Changed On
UPDNAM ESEUPDNAM CHAR 101 12 0 Last Changed By
SRSID ESESRSID CHAR 113 10 0 Source of Data
OWNID ESEVENDRID CHAR 123 10 0 Data Provider
RECNROOT ESERECN NUMC 133 20 0 Sequential Number of Data Record
MATNR BASE_MATID CHAR 153 40 0 Material or Product (Internal Key)
MOT THME_MOT NUMC 193 2 0 THM151 Dangerous Goods - Mode-of-Transport Category
RVLID ESERVLID CHAR 195 10 0 TCG91 Validity Area
DGNHM THME_NHM CHAR 205 1 0 Non-Dangerous Goods Full Transport
DGCAO ADGE_DGCAO CHAR 206 1 0 Only Cargo Air Transport Permitted
TKUI THME_TKUI CHAR 207 3 0 Identification Number Type
DGNU THME_DGNU CHAR 210 4 0 Identification Number
DGRES1 ADGE_RES CHAR 214 12 0 Hazard-Inducing Substance
DGRES2 ADGE_RES CHAR 226 12 0 Hazard-Inducing Substance
DGCL THME_DGCL CHAR 238 3 0 Dangerous Goods Class
DGSC ADGE_DGSC CHAR 241 6 0 Dangerous Goods Subclass
SDBC ADGE_SDBC NUMC 247 4 0 Hazard Item Number
SLBE THME_SLBE NUMC 251 4 0 Hazard Item Number (Empty Transport)
LDBC THME_LDBC CHAR 255 5 0 Classification Code
LWDG THME_LWDG CHAR 260 12 0 DGTEXCEPT Dangerous Goods Regulation
STOSU ADGE_STOSU CHAR 272 1 0 Aggregate State for Transport
COTMP ADGE_COTMP QUAN 273 8 2 Control Temperature
TPCUN ADGE_TPCUN UNIT 278 3 0 T006 Temperature Unit (Control)
EMTMP ADGE_EMTMP QUAN 281 8 2 Emergency Temperature
TPEUN ADGE_TPEUN UNIT 286 3 0 T006 Temperature Unit (Emergency)
FLTMP ADGE_FLTMP QUAN 289 8 2 Flash Point
TPFUN ADGE_TPFUN UNIT 294 3 0 T006 Temperature Unit (Flame)
TPSNL ADGE_TPSNL QUAN 297 8 2 Temperature Sensitivity (Lower Limit)
TPSLU ADGE_TPSLU UNIT 302 3 0 T006 Unit for temperature sensitivity (lower limit)
TPSNH ADGE_TPSNH QUAN 305 8 2 Temperature sensitivity (upper limit)
TPSHU ADGE_TPSHU UNIT 310 3 0 T006 Temperature Unit (Sensitivity - Upper Limit)
DAIN1 ADGE_DAIN CHAR 313 4 0 Hazard Note
DAIN2 ADGE_DAIN CHAR 317 4 0 Hazard Note
DAIN3 ADGE_DAIN CHAR 321 4 0 Hazard Note
DAIN4 ADGE_DAIN CHAR 325 4 0 Hazard Note
DAIN5 ADGE_DAIN CHAR 329 4 0 Hazard Note
DAIN6 ADGE_DAIN CHAR 333 4 0 Hazard Note
DAIN7 ADGE_DAIN CHAR 337 4 0 Hazard Note
DAIN8 ADGE_DAIN CHAR 341 4 0 Hazard Note
DAIN9 ADGE_DAIN CHAR 345 4 0 Hazard Note
DAIN10 ADGE_DAIN CHAR 349 4 0 Hazard Note
COWE ADGE_COWE CHAR 353 1 0 Water Pollution Class
VBFC ADGE_VBFC CHAR 354 4 0 VbF Class
SDCL ADGE_SDCL CHAR 358 4 0 Storage Hazard Class
EINU ADGE_EINU CHAR 362 7 0 Tremcard Number
EICN ADGE_EICN CHAR 369 7 0 Replacement Tremcard Number
EMSN1 ADGE_EMSN1 CHAR 376 7 0 EmS/ERG Number 1
EMSN2 ADGE_EMSN2 CHAR 383 7 0 EmS/ERG Number 2
MFAG1 ADGE_MFAG1 CHAR 390 4 0 MFAG Number 1
MFAG2 ADGE_MFAG2 CHAR 394 4 0 MFAG Number 2
MOS1 THME_MOS NUMC 398 3 0 Dangerous Goods Transport Type
MOS2 THME_MOS NUMC 401 3 0 Dangerous Goods Transport Type
MOS3 THME_MOS NUMC 404 3 0 Dangerous Goods Transport Type
MOS4 THME_MOS NUMC 407 3 0 Dangerous Goods Transport Type
MOS5 THME_MOS NUMC 410 3 0 Dangerous Goods Transport Type
MOS6 THME_MOS NUMC 413 3 0 Dangerous Goods Transport Type
MOS7 THME_MOS NUMC 416 3 0 Dangerous Goods Transport Type
MOS8 THME_MOS NUMC 419 3 0 Dangerous Goods Transport Type
MOS9 THME_MOS NUMC 422 3 0 Dangerous Goods Transport Type
MOSA THME_MOS NUMC 425 3 0 Dangerous Goods Transport Type
HQTU ADGE_HQTU QUAN 428 8 2 Maximum Quantity per Transport Unit
HQTUN ADGE_HQTUN UNIT 433 3 0 T006 Maximum Quantity Unit
PIN THME_PIN CHAR 436 25 0 Packing Instruction Number
PGRO THME_PGRO CHAR 461 3 0 Packing Group
HNU THME_HNU CHAR 464 4 0 Hazard Identification Number
HPN1 THME_HPN1 CHAR 468 10 0 Danger Label Number 1
HPN2 THME_HPN2 CHAR 478 10 0 Danger Label Number 2
HPN3 THME_HPN3 CHAR 488 10 0 Danger Label Number 3
HPN4 THME_HPN4 CHAR 498 10 0 Danger Label Number 4
HPN5 THME_HPN5 CHAR 508 10 0 Danger Label Number 5
HPN6 THME_HPN6 CHAR 518 10 0 Danger Label Number 6
HPN7 THME_HPN7 CHAR 528 10 0 Danger Label Number 7
LAB1 ADGE_LAB1 CHAR 538 7 0 Label Number 1
LAB2 ADGE_LAB2 CHAR 545 7 0 Label Number 2
LAB3 ADGE_LAB3 CHAR 552 7 0 Label Number 3
LAB4 ADGE_LAB4 CHAR 559 7 0 Label Number 4
LAB5 ADGE_LAB5 CHAR 566 7 0 Label Number 5
LAB6 ADGE_LAB6 CHAR 573 7 0 Label Number 6
LAB7 ADGE_LAB7 CHAR 580 7 0 Label Number 7
LAB8 ADGE_LAB8 CHAR 587 7 0 Label Number 8
LAB9 ADGE_LAB9 CHAR 594 7 0 Label Number 9
LAB10 ADGE_LABA CHAR 601 7 0 Label Number 10
KDGVS ADGE_KDGVS CHAR 608 70 0 Text Key Highly Viscous Substances
KDGNS ADGE_KDGNS CHAR 678 70 0 Text Key Exemption for Named Substances
KDGMP ADGE_KDGMP CHAR 748 70 0 Text Key Marine Pollutant
KDGEX ADGE_KDGEX CHAR 818 70 0 Text Key Exceptions
KDGHI ADGE_KDGHI CHAR 888 70 0 Text key handling data
KDGF1 ADGE_KDGF1 CHAR 958 70 0 User-Defined Text Key 1
KDGF2 ADGE_KDGF2 CHAR 1028 70 0 User-Defined Text Key 2
KDGF3 ADGE_KDGF3 CHAR 1098 70 0 User-Defined Text Key 3
KDGF4 ADGE_KDGF4 CHAR 1168 70 0 User-Defined Text Key 4
KDGF5 ADGE_KDGF5 CHAR 1238 70 0 User-Defined Text Key 5
KDGF6 ADGE_KDGF6 CHAR 1308 70 0 User-Defined Text Key 6
KDGF7 ADGE_KDGF7 CHAR 1378 70 0 User-Defined Text Key 7
KDGF8 ADGE_KDGF8 CHAR 1448 70 0 User-Defined Text Key 8
KDGF9 ADGE_KDGF9 CHAR 1518 70 0 User-Defined Text Key 9
KDGF10 ADGE_KDGFA CHAR 1588 70 0 User-Defined Text Key 10
PAI THME_PAI QUAN 1658 8 2 Limited Quantity (LQ) Inner Packaging
PAIU THME_PAIU UNIT 1663 3 0 T006 Unit of Meas. for Limited Quantity (LQ) Inner Packaging
PAO THME_PAO QUAN 1666 8 2 Limited Quantity (LQ) Outer Packaging
PAOU THME_PAOU UNIT 1671 3 0 T006 Unit of Meas. for Limited Quantity (LQ) Outer Packaging
RQA ADGE_RQA QUAN 1674 8 2 Reportable Quantity
RQU ADGE_RQU UNIT 1679 3 0 T006 Unit of measure for reportable quantities
PBI ADGE_PBI CHAR 1682 1 0 Poisonous by Inhalation
MINQ ADGE_MINQ QUAN 1683 8 2 Minimum Quantity for Listed Goods
MINU ADGE_MINU UNIT 1688 3 0 T006 Unit of Measurement Minimum Quantity (Listed Goods)
MAXQ ADGE_MAXQ QUAN 1691 8 2 Maximum Quantity for Listed Goods
MAXU ADGE_MAXU UNIT 1696 3 0 T006 Unit of Measurement Maximum Quantity (Listed Goods)
RELQ THME_RELQ QUAN 1699 8 2 Exemption (ADR 1.1.3.6)
RELU THME_RELU UNIT 1704 3 0 T006 Unit of Measure Quantity Limit
MULRQ THME_MULRQ NUMC 1707 4 0 Multiplication Factor Exemption (ADR 1.1.3.6)
RCHEM ADGE_RCHEM CHAR 1711 1 0 Notification Status (Law on Control of Toxic Substances)
DGPTA ADGE_DGPTA CHAR 1712 1 0 Shipping by Mail Permitted
DGTNA ADGE_DGTNA CHAR 1713 1 0 Transport Not Permitted
DGWOS THME_WOS CHAR 1714 2 0 Processing Status for Basic Data and Master Data
NHME THME_NHME CHAR 1716 1 0 Non-Dangerous Goods Empty Transport
DGSHE ADGE_DGSHE CHAR 1717 4 0 Schedule of Class 7
PIMDG ADGE_PIMDG CHAR 1721 10 0 Note on Regulation
SOOWA ADGE_SOOWA QUAN 1731 12 2 Solubility of water
USOOW ADGE_USOOW UNIT 1738 3 0 T006 Unit for solubility of water
DENFEE ADGE_DENFE QUAN 1741 11 2 Density I
UDENFE ADGE_UDENF UNIT 1747 3 0 T006 Unit for density I
DENTWE ADGE_DENTW QUAN 1750 11 2 Density II
UDENTW ADGE_UDENT UNIT 1756 3 0 T006 Unit for density II
DENFIF ADGE_DENFI QUAN 1759 11 2 Density III
UDENFI ADGE_UDEFI UNIT 1765 3 0 T006 Unit for density III
BUDEN ADGE_BUDEN QUAN 1768 11 2 Bulk Density
UBUDE ADGE_UBUDE UNIT 1774 3 0 T006 Unit for Bulk Density
BOPOI ADGE_BOPOI QUAN 1777 8 2 Boiling Point
UBOPO ADGE_UBOPO UNIT 1782 3 0 T006 Unit for Boiling Point
VISCO ADGE_VISCO QUAN 1785 9 2 Viscosity
UVISC ADGE_UVISC UNIT 1790 3 0 T006 Unit for Viscosity
STPRES ADGE_STPRE QUAN 1793 10 2 Vapor Pressure
USTPRE ADGE_USTPR UNIT 1799 3 0 T006 Unit for vapor pressure
HYGRO ADGE_HYGRO CHAR 1802 1 0 Hygroscopicity
MEPOI ADGE_MEPOI QUAN 1803 8 2 Melting Point
UMEPO ADGE_UMEPO UNIT 1808 3 0 T006 Unit for Melting Point
COOEX ADGE_COOEX QUAN 1811 8 2 Coefficient of Expansion
UCOOE ADGE_UCOOE UNIT 1816 3 0 T006 Unit for Coefficient of Expansion
MTMPF ADGE_MTMPF QUAN 1819 8 2 Medium Temperature of Liquid During Filling
UMTMP ADGE_UMTMP UNIT 1824 3 0 T006 Unit for medium filling temperature
STOPA THME_STOPA CHAR 1827 1 0 Packaging Mark
SPPRO THME_SPPRO CHAR 1828 5 0 Special Provision
MAPOL ADGE_MAPOL CHAR 1833 2 0 Marine Pollutant
PINLQ THME_PINLQ CHAR 1835 25 0 Packing Instruction Number for Limited Quantity (LQ)
PASI THME_PASI QUAN 1860 8 2 Maximum Quantity per Package
UPASI THME_UPASI UNIT 1865 3 0 T006 Unit of Measurement for Single Packaging
PAGW THME_PAGW QUAN 1868 8 2 Limited Quantity (LQ) Gross Weight
UPAGW THME_UPAGW UNIT 1873 3 0 T006 Unit of Measurement for Limited Quantity (LQ) Gross
EXCEP ADGE_EXCEP CHAR 1876 40 0 Exception and Agreement Number
SCASE ADGE_SCASE CHAR 1916 1 0 Special Case (Packing Check)
COLNO ADGE_COLNO CHAR 1917 1 0 Collective Number
DGRES3 ADGE_RES CHAR 1918 12 0 Hazard-Inducing Substance
DGREMP ADGE_REMP CHAR 1930 12 0 Hazard-inducing substance (marine pollutant)
DGRERQ ADGE_RERQ CHAR 1942 12 0 Hazard-inducing substance (reportable quantity)
EIMDG ADGE_EIMDG CHAR 1954 4 0 Regulation Edition

1105036Mapping the tunnel regulation from the ADR 2007
1341030Report RC1PHDEL does not delete any entries from table DGTM2
1010878Conversion report for value indic. in dangerous goods master
1052970DGP3: Existing dangerous goods master records not displayed
493887Performance problem when reading dangerous goods data
438565Correction of docu. regarding output of dangerous goods data