Menu

SAP Table DGTMD

DG: Dangerous Goods Master

The table DGTMD (DG: Dangerous Goods Master) is a standard table in SAP ERP. It belongs to the package CBEHS.

Technical Information

Table DGTMD
Short Text DG: Dangerous Goods Master
Package CBEHS
Table Type Transparent Table

Fields for Table DGTMD

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