SAP ABAP Table DGTMD (DG: Dangerous Goods Master)
Hierarchy
SAP_ABA (Software Component) Cross-Application Component
   CA-GTF-EHS (Application Component) Environment, Health and Safety: Master Data
     CBEHS_DGP (Package) Dangerous Goods Master Data
Basic Data
Table Category TRANSP    Transparent table 
Transparent table DGTMD   Table Relationship Diagram
Short Description DG: Dangerous Goods Master    
Delivery and Maintenance
Pool/cluster      
Delivery Class A   Application Table (Master- and Transaction Data) 
Data Browser/Table View Maintenance X   Display/Maintenance Allowed 
Components
     
Field Key Data Element Domain Data
Type
Length Decimal
Places
Short Description Check
table
1 .INCLUDE       0   0   EHS: Structure for key info of master data  
2 MANDT MANDT MANDT CLNT 3   0   Client T000
3 RECN ESERECN ESDRECN NUMC 20   0   Sequential Number of Data Record  
4 ACTN ESEACTN ESDACTN NUMC 20   0   Sequential Number of the Change State  
5 .INCLUDE       0   0   DG: Structure for General Administration Information  
6 VALFR ESEVALFR DATUM DATS 8   0   Valid-From Date  
7 VALTO ESEVALTO DATUM DATS 8   0   Valid-To Date  
8 AENNR ESEAENNR AENNR CHAR 12   0   Change Number AENR
9 DELFLG ADGE_DELFLG ESDFLAG CHAR 1   0   Deletion Indicator  
10 PARKFLG ESEPARKFLG ESDFLAG CHAR 1   0   Data Record Is Inactive  
11 CRDAT ESECRDAT DATUM DATS 8   0   Created On  
12 CRNAM ESECRNAM USNAM CHAR 12   0   Created By  
13 UPDDAT ESEUPDDAT DATUM DATS 8   0   Changed On  
14 UPDNAM ESEUPDNAM USNAM CHAR 12   0   Last Changed By  
15 SRSID ESESRSID ESDSRSID CHAR 10   0   Source of Data TCG56
16 OWNID ESEVENDRID AD_ADDRNUM CHAR 10   0   Data Provider *
17 RECNROOT ESERECN ESDRECN NUMC 20   0   Sequential Number of Data Record  
18 .INCLUDE       0   0   EHS: Logical Database Key to RDGKEY  
19 MATNR BASE_MATID BASD_MATID CHAR 40   0   Material or Product (Internal Key) *
20 MOT THME_MOT HMD_MOT NUMC 2   0   Dangerous Goods - Mode-of-Transport Category THM151
21 RVLID ESERVLID ESDRVLID CHAR 10   0   Validity Area TCG91
22 .INCLUDE       0   0   EHS: Application Data for Table DGTMD  
23 DGNHM THME_NHM HMD_NDG CHAR 1   0   Non-Dangerous Goods Full Transport THM159
24 DGCAO ADGE_DGCAO X CHAR 1   0   Only Cargo Air Transport Permitted  
25 TKUI THME_TKUI HMD_TKUI CHAR 3   0   Identification Number Type TDG73
26 DGNU THME_DGNU CHAR4 CHAR 4   0   Identification Number  
27 DGRES1 ADGE_RES CHAR12 CHAR 12   0   Hazard-Inducing Substance  
28 DGRES2 ADGE_RES CHAR12 CHAR 12   0   Hazard-Inducing Substance  
29 DGCL THME_DGCL HMD_DGCL CHAR 3   0   Dangerous Goods Class THM009
30 DGSC ADGE_DGSC CHAR6 CHAR 6   0   Dangerous Goods Subclass  
31 SDBC ADGE_SDBC NUMC4 NUMC 4   0   Hazard Item Number  
32 SLBE THME_SLBE NUMC4 NUMC 4   0   Hazard Item Number (Empty Transport)  
33 LDBC THME_LDBC HMD_LDBC CHAR 5   0   Classification Code THM011
34 LWDG THME_LWDG HMD_LWDG CHAR 12   0   Dangerous Goods Regulation THM063
35 STOSU ADGE_STOSU CHAR1 CHAR 1   0   Aggregate State for Transport  
36 COTMP ADGE_COTMP ADGD_Q82 QUAN 8   2   Control Temperature  
37 TPCUN ADGE_TPCUN MEINS UNIT 3   0   Temperature Unit (Control) T006
38 EMTMP ADGE_EMTMP ADGD_Q82 QUAN 8   2   Emergency Temperature  
39 TPEUN ADGE_TPEUN MEINS UNIT 3   0   Temperature Unit (Emergency) T006
40 FLTMP ADGE_FLTMP ADGD_Q82 QUAN 8   2   Flash Point  
41 TPFUN ADGE_TPFUN MEINS UNIT 3   0   Temperature Unit (Flame) T006
42 TPSNL ADGE_TPSNL ADGD_Q82 QUAN 8   2   Temperature Sensitivity (Lower Limit)  
43 TPSLU ADGE_TPSLU MEINS UNIT 3   0   Unit for temperature sensitivity (lower limit) T006
44 TPSNH ADGE_TPSNH ADGD_Q82 QUAN 8   2   Temperature sensitivity (upper limit)  
45 TPSHU ADGE_TPSHU MEINS UNIT 3   0   Temperature Unit (Sensitivity - Upper Limit) T006
46 DAIN1 ADGE_DAIN CHAR4 CHAR 4   0   Hazard Note  
47 DAIN2 ADGE_DAIN CHAR4 CHAR 4   0   Hazard Note  
48 DAIN3 ADGE_DAIN CHAR4 CHAR 4   0   Hazard Note  
49 DAIN4 ADGE_DAIN CHAR4 CHAR 4   0   Hazard Note  
50 DAIN5 ADGE_DAIN CHAR4 CHAR 4   0   Hazard Note  
51 DAIN6 ADGE_DAIN CHAR4 CHAR 4   0   Hazard Note  
52 DAIN7 ADGE_DAIN CHAR4 CHAR 4   0   Hazard Note  
53 DAIN8 ADGE_DAIN CHAR4 CHAR 4   0   Hazard Note  
54 DAIN9 ADGE_DAIN CHAR4 CHAR 4   0   Hazard Note  
55 DAIN10 ADGE_DAIN CHAR4 CHAR 4   0   Hazard Note  
56 COWE ADGE_COWE ADGD_COWE CHAR 1   0   Water Pollution Class TDG15
57 VBFC ADGE_VBFC ADGD_VBFC CHAR 4   0   VbF Class TDG35
58 SDCL ADGE_SDCL ADGD_SDCL CHAR 4   0   Storage Hazard Class TDG37
59 EINU ADGE_EINU CHAR7 CHAR 7   0   Tremcard Number  
60 EICN ADGE_EICN CHAR7 CHAR 7   0   Replacement Tremcard Number  
61 EMSN1 ADGE_EMSN1 CHAR7 CHAR 7   0   EmS/ERG Number 1  
62 EMSN2 ADGE_EMSN2 CHAR7 CHAR 7   0   EmS/ERG Number 2  
63 MFAG1 ADGE_MFAG1 CHAR4 CHAR 4   0   MFAG Number 1  
64 MFAG2 ADGE_MFAG2 CHAR4 CHAR 4   0   MFAG Number 2  
65 MOS1 THME_MOS HMD_MOS NUMC 3   0   Dangerous Goods Transport Type THM003
66 MOS2 THME_MOS HMD_MOS NUMC 3   0   Dangerous Goods Transport Type THM003
67 MOS3 THME_MOS HMD_MOS NUMC 3   0   Dangerous Goods Transport Type THM003
68 MOS4 THME_MOS HMD_MOS NUMC 3   0   Dangerous Goods Transport Type THM003
69 MOS5 THME_MOS HMD_MOS NUMC 3   0   Dangerous Goods Transport Type THM003
70 MOS6 THME_MOS HMD_MOS NUMC 3   0   Dangerous Goods Transport Type THM003
71 MOS7 THME_MOS HMD_MOS NUMC 3   0   Dangerous Goods Transport Type THM003
72 MOS8 THME_MOS HMD_MOS NUMC 3   0   Dangerous Goods Transport Type THM003
73 MOS9 THME_MOS HMD_MOS NUMC 3   0   Dangerous Goods Transport Type THM003
74 MOSA THME_MOS HMD_MOS NUMC 3   0   Dangerous Goods Transport Type THM003
75 HQTU ADGE_HQTU ADGD_Q82 QUAN 8   2   Maximum Quantity per Transport Unit  
76 HQTUN ADGE_HQTUN MEINS UNIT 3   0   Maximum Quantity Unit T006
77 PIN THME_PIN HMD_PIN CHAR 25   0   Packing Instruction Number THM075
78 PGRO THME_PGRO CHAR3 CHAR 3   0   Packing Group  
79 HNU THME_HNU HMD_HNU CHAR 4   0   Hazard Identification Number THM031
80 HPN1 THME_HPN1 HMD_HPN CHAR 10   0   Danger Label Number 1 THM017
81 HPN2 THME_HPN2 HMD_HPN CHAR 10   0   Danger Label Number 2 THM017
82 HPN3 THME_HPN3 HMD_HPN CHAR 10   0   Danger Label Number 3 THM017
83 HPN4 THME_HPN4 HMD_HPN CHAR 10   0   Danger Label Number 4 THM017
84 HPN5 THME_HPN5 HMD_HPN CHAR 10   0   Danger Label Number 5 THM017
85 HPN6 THME_HPN6 HMD_HPN CHAR 10   0   Danger Label Number 6 THM017
86 HPN7 THME_HPN7 HMD_HPN CHAR 10   0   Danger Label Number 7 THM017
87 LAB1 ADGE_LAB1 ADGD_LAB CHAR 7   0   Label Number 1 TDG29
88 LAB2 ADGE_LAB2 ADGD_LAB CHAR 7   0   Label Number 2 TDG29
89 LAB3 ADGE_LAB3 ADGD_LAB CHAR 7   0   Label Number 3 TDG29
90 LAB4 ADGE_LAB4 ADGD_LAB CHAR 7   0   Label Number 4 TDG29
91 LAB5 ADGE_LAB5 ADGD_LAB CHAR 7   0   Label Number 5 TDG29
92 LAB6 ADGE_LAB6 ADGD_LAB CHAR 7   0   Label Number 6 TDG29
93 LAB7 ADGE_LAB7 ADGD_LAB CHAR 7   0   Label Number 7 TDG29
94 LAB8 ADGE_LAB8 ADGD_LAB CHAR 7   0   Label Number 8 TDG29
95 LAB9 ADGE_LAB9 ADGD_LAB CHAR 7   0   Label Number 9 TDG29
96 LAB10 ADGE_LABA ADGD_LAB CHAR 7   0   Label Number 10 TDG29
97 KDGVS ADGE_KDGVS TDOBNAME CHAR 70   0   Text Key Highly Viscous Substances  
98 KDGNS ADGE_KDGNS TDOBNAME CHAR 70   0   Text Key Exemption for Named Substances  
99 KDGMP ADGE_KDGMP TDOBNAME CHAR 70   0   Text Key Marine Pollutant  
100 KDGEX ADGE_KDGEX TDOBNAME CHAR 70   0   Text Key Exceptions  
101 KDGHI ADGE_KDGHI TDOBNAME CHAR 70   0   Text key handling data  
102 KDGF1 ADGE_KDGF1 TDOBNAME CHAR 70   0   User-Defined Text Key 1  
103 KDGF2 ADGE_KDGF2 TDOBNAME CHAR 70   0   User-Defined Text Key 2  
104 KDGF3 ADGE_KDGF3 TDOBNAME CHAR 70   0   User-Defined Text Key 3  
105 KDGF4 ADGE_KDGF4 TDOBNAME CHAR 70   0   User-Defined Text Key 4  
106 KDGF5 ADGE_KDGF5 TDOBNAME CHAR 70   0   User-Defined Text Key 5  
107 KDGF6 ADGE_KDGF6 TDOBNAME CHAR 70   0   User-Defined Text Key 6  
108 KDGF7 ADGE_KDGF7 TDOBNAME CHAR 70   0   User-Defined Text Key 7  
109 KDGF8 ADGE_KDGF8 TDOBNAME CHAR 70   0   User-Defined Text Key 8  
110 KDGF9 ADGE_KDGF9 TDOBNAME CHAR 70   0   User-Defined Text Key 9  
111 KDGF10 ADGE_KDGFA TDOBNAME CHAR 70   0   User-Defined Text Key 10  
112 PAI THME_PAI HMD_QUAN QUAN 8   2   Limited Quantity (LQ) Inner Packaging  
113 PAIU THME_PAIU MEINS UNIT 3   0   Unit of Meas. for Limited Quantity (LQ) Inner Packaging T006
114 PAO THME_PAO HMD_QUAN QUAN 8   2   Limited Quantity (LQ) Outer Packaging  
115 PAOU THME_PAOU MEINS UNIT 3   0   Unit of Meas. for Limited Quantity (LQ) Outer Packaging T006
116 RQA ADGE_RQA ADGD_Q82 QUAN 8   2   Reportable Quantity  
117 RQU ADGE_RQU MEINS UNIT 3   0   Unit of measure for reportable quantities T006
118 PBI ADGE_PBI ADGD_PIH CHAR 1   0   Poisonous by Inhalation  
119 MINQ ADGE_MINQ ADGD_Q82 QUAN 8   2   Minimum Quantity for Listed Goods  
120 MINU ADGE_MINU MEINS UNIT 3   0   Unit of Measurement Minimum Quantity (Listed Goods) T006
121 MAXQ ADGE_MAXQ ADGD_Q82 QUAN 8   2   Maximum Quantity for Listed Goods  
122 MAXU ADGE_MAXU MEINS UNIT 3   0   Unit of Measurement Maximum Quantity (Listed Goods) T006
123 RELQ THME_RELQ HMD_QUAN QUAN 8   2   Exemption (ADR 1.1.3.6)  
124 RELU THME_RELU MEINS UNIT 3   0   Unit of Measure Quantity Limit T006
125 MULRQ THME_MULRQ NUMC4 NUMC 4   0   Multiplication Factor Exemption (ADR 1.1.3.6)  
126 RCHEM ADGE_RCHEM X CHAR 1   0   Notification Status (Law on Control of Toxic Substances)  
127 DGPTA ADGE_DGPTA X CHAR 1   0   Shipping by Mail Permitted  
128 DGTNA ADGE_DGTNA X CHAR 1   0   Transport Not Permitted  
129 DGWOS THME_WOS HMD_WOS CHAR 2   0   Processing Status for Basic Data and Master Data THM039
130 NHME THME_NHME HMD_NDG CHAR 1   0   Non-Dangerous Goods Empty Transport THM159
131 DGSHE ADGE_DGSHE CHAR4 CHAR 4   0   Schedule of Class 7  
132 PIMDG ADGE_PIMDG CHAR10 CHAR 10   0   Note on Regulation  
133 SOOWA ADGE_SOOWA ADGD_Q122 QUAN 12   2   Solubility of water  
134 USOOW ADGE_USOOW MEINS UNIT 3   0   Unit for solubility of water T006
135 DENFEE ADGE_DENFE ADGD_Q112 QUAN 11   2   Density I  
136 UDENFE ADGE_UDENF MEINS UNIT 3   0   Unit for density I T006
137 DENTWE ADGE_DENTW ADGD_Q112 QUAN 11   2   Density II  
138 UDENTW ADGE_UDENT MEINS UNIT 3   0   Unit for density II T006
139 DENFIF ADGE_DENFI ADGD_Q112 QUAN 11   2   Density III  
140 UDENFI ADGE_UDEFI MEINS UNIT 3   0   Unit for density III T006
141 BUDEN ADGE_BUDEN ADGD_Q112 QUAN 11   2   Bulk Density  
142 UBUDE ADGE_UBUDE MEINS UNIT 3   0   Unit for Bulk Density T006
143 BOPOI ADGE_BOPOI HMD_QUAN QUAN 8   2   Boiling Point  
144 UBOPO ADGE_UBOPO MEINS UNIT 3   0   Unit for Boiling Point T006
145 VISCO ADGE_VISCO ADGD_Q92 QUAN 9   2   Viscosity  
146 UVISC ADGE_UVISC MEINS UNIT 3   0   Unit for Viscosity T006
147 STPRES ADGE_STPRE ADGD_Q102 QUAN 10   2   Vapor Pressure  
148 USTPRE ADGE_USTPR MEINS UNIT 3   0   Unit for vapor pressure T006
149 HYGRO ADGE_HYGRO CHAR1 CHAR 1   0   Hygroscopicity  
150 MEPOI ADGE_MEPOI HMD_QUAN QUAN 8   2   Melting Point  
151 UMEPO ADGE_UMEPO MEINS UNIT 3   0   Unit for Melting Point T006
152 COOEX ADGE_COOEX HMD_QUAN QUAN 8   2   Coefficient of Expansion  
153 UCOOE ADGE_UCOOE MEINS UNIT 3   0   Unit for Coefficient of Expansion T006
154 MTMPF ADGE_MTMPF HMD_QUAN QUAN 8   2   Medium Temperature of Liquid During Filling  
155 UMTMP ADGE_UMTMP MEINS UNIT 3   0   Unit for medium filling temperature T006
156 STOPA THME_STOPA CHAR1 CHAR 1   0   Packaging Mark  
157 SPPRO THME_SPPRO CHAR5 CHAR 5   0   Special Provision  
158 MAPOL ADGE_MAPOL ADGD_MAPOL CHAR 2   0   Marine Pollutant  
159 PINLQ THME_PINLQ HMD_PIN CHAR 25   0   Packing Instruction Number for Limited Quantity (LQ) THM075
160 PASI THME_PASI HMD_QUAN QUAN 8   2   Maximum Quantity per Package  
161 UPASI THME_UPASI MEINS UNIT 3   0   Unit of Measurement for Single Packaging T006
162 PAGW THME_PAGW HMD_QUAN QUAN 8   2   Limited Quantity (LQ) Gross Weight  
163 UPAGW THME_UPAGW MEINS UNIT 3   0   Unit of Measurement for Limited Quantity (LQ) Gross T006
164 EXCEP ADGE_EXCEP CHAR40 CHAR 40   0   Exception and Agreement Number  
165 SCASE ADGE_SCASE X CHAR 1   0   Special Case (Packing Check)  
166 COLNO ADGE_COLNO X CHAR 1   0   Collective Number  
167 DGRES3 ADGE_RES CHAR12 CHAR 12   0   Hazard-Inducing Substance  
168 DGREMP ADGE_REMP CHAR12 CHAR 12   0   Hazard-inducing substance (marine pollutant)  
169 DGRERQ ADGE_RERQ CHAR12 CHAR 12   0   Hazard-inducing substance (reportable quantity)  
170 EIMDG ADGE_EIMDG CHAR4 CHAR 4   0   Regulation Edition  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 DGTMD AENNR AENR AENNR REF 1 CN
2 DGTMD COWE TDG15 COWE REF 1 CN
3 DGTMD DGCL THM009 DGCL REF 1 CN
4 DGTMD DGNHM THM159 NDG REF 1 CN
5 DGTMD DGWOS THM039 DGWOS REF 1 CN
6 DGTMD HNU THM031 HNU REF 1 CN
7 DGTMD HPN1 THM017 HPN REF 1 CN
8 DGTMD HPN2 THM017 HPN REF 1 CN
9 DGTMD HPN3 THM017 HPN REF 1 CN
10 DGTMD HPN4 THM017 HPN REF 1 CN
11 DGTMD HPN5 THM017 HPN REF 1 CN
12 DGTMD HPN6 THM017 HPN REF 1 CN
13 DGTMD HPN7 THM017 HPN REF 1 CN
14 DGTMD HQTUN T006 MSEHI REF 1 CN
15 DGTMD LAB1 TDG29 LAB REF 1 CN
16 DGTMD LAB10 TDG29 LAB REF 1 CN
17 DGTMD LAB2 TDG29 LAB REF 1 CN
18 DGTMD LAB3 TDG29 LAB REF 1 CN
19 DGTMD LAB4 TDG29 LAB REF 1 CN
20 DGTMD LAB5 TDG29 LAB REF 1 CN
21 DGTMD LAB6 TDG29 LAB REF 1 CN
22 DGTMD LAB7 TDG29 LAB REF 1 CN
23 DGTMD LAB8 TDG29 LAB REF 1 CN
24 DGTMD LAB9 TDG29 LAB REF 1 CN
25 DGTMD LDBC THM011 LDBC REF 1 CN
26 DGTMD LWDG THM063 LWDG KEY 1 CN
27 DGTMD MANDT T000 MANDT    
28 DGTMD MAXU T006 MSEHI REF 1 CN
29 DGTMD MINU T006 MSEHI REF 1 CN
30 DGTMD MOS1 THM003 MOS REF 1 CN
31 DGTMD MOS2 THM003 MOS REF 1 CN
32 DGTMD MOS3 THM003 MOS REF 1 CN
33 DGTMD MOS4 THM003 MOS REF 1 CN
34 DGTMD MOS5 THM003 MOS REF 1 CN
35 DGTMD MOS6 THM003 MOS REF 1 CN
36 DGTMD MOS7 THM003 MOS REF 1 CN
37 DGTMD MOS8 THM003 MOS REF 1 CN
38 DGTMD MOS9 THM003 MOS REF 1 CN
39 DGTMD MOSA THM003 MOS REF 1 CN
40 DGTMD MOT THM151 MOT 1 CN
41 DGTMD NHME THM159 NDG REF 1 CN
42 DGTMD PAIU T006 MSEHI REF 1 CN
43 DGTMD PAOU T006 MSEHI REF 1 CN
44 DGTMD PIN THM075 PIN REF 1 CN
45 DGTMD PINLQ THM075 PIN REF 1 CN
46 DGTMD RELU T006 MSEHI REF 1 CN
47 DGTMD RQU T006 MSEHI REF 1 CN
48 DGTMD RVLID TCG91 RVLID    
49 DGTMD SDCL TDG37 SDCL REF 1 CN
50 DGTMD SRSID TCG56 SRSID REF 1 CN
51 DGTMD TKUI TDG73 TKUI REF 1 CN
52 DGTMD TPCUN T006 MSEHI REF 1 CN
53 DGTMD TPEUN T006 MSEHI REF 1 CN
54 DGTMD TPFUN T006 MSEHI REF 1 CN
55 DGTMD TPSHU T006 MSEHI REF 1 CN
56 DGTMD TPSLU T006 MSEHI REF 1 CN
57 DGTMD UBOPO T006 MSEHI REF 1 CN
58 DGTMD UBUDE T006 MSEHI REF 1 CN
59 DGTMD UCOOE T006 MSEHI REF 1 CN
60 DGTMD UDENFE T006 MSEHI REF 1 CN
61 DGTMD UDENFI T006 MSEHI REF 1 CN
62 DGTMD UDENTW T006 MSEHI REF 1 CN
63 DGTMD UMEPO T006 MSEHI REF 1 CN
64 DGTMD UMTMP T006 MSEHI REF 1 CN
65 DGTMD UPAGW T006 MSEHI REF 1 CN
66 DGTMD UPASI T006 MSEHI REF 1 CN
67 DGTMD USOOW T006 MSEHI REF 1 CN
68 DGTMD USTPRE T006 MSEHI REF 1 CN
69 DGTMD UVISC T006 MSEHI REF 1 CN
70 DGTMD VBFC TDG35 VBFC REF 1 CN
History
Last changed by/on SAP  20110908 
SAP Release Created in