SAP ABAP Table RDGMD (DG: Include Structure for Dangerous Goods Data (Table DGTMD))
Hierarchy
SAP_APPL (Software Component) Logistics and Accounting
   EHS (Application Component) Environment, Health and Safety
     CBEHS (Package) EH&S: Interface Objects
Basic Data
Table Category INTTAB    Structure 
Structure RDGMD   Table Relationship Diagram
Short Description DG: Include Structure for Dangerous Goods Data (Table DGTMD)    
Delivery and Maintenance
Pool/cluster      
Delivery Class      
Data Browser/Table View Maintenance     Display/Maintenance Allowed with Restrictions 
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   DG: Include for Logical Key  
19 MATNR MATNR MATNR CHAR 18   0   Material Number MARA
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 RDGMD AENNR AENR AENNR REF 1 CN
2 RDGMD COWE TDG15 COWE KEY 1 CN
3 RDGMD DGCL THM009 DGCL KEY 1 CN
4 RDGMD DGNHM THM159 NDG KEY 1 CN
5 RDGMD DGWOS THM039 DGWOS KEY 1 CN
6 RDGMD HNU THM031 HNU KEY 1 CN
7 RDGMD HPN1 THM017 HPN KEY 1 CN
8 RDGMD HPN2 THM017 HPN KEY 1 CN
9 RDGMD HPN3 THM017 HPN KEY 1 CN
10 RDGMD HPN4 THM017 HPN KEY 1 CN
11 RDGMD HPN5 THM017 HPN KEY 1 CN
12 RDGMD HPN6 THM017 HPN KEY 1 CN
13 RDGMD HPN7 THM017 HPN KEY 1 CN
14 RDGMD HQTUN T006 MSEHI REF 1 CN
15 RDGMD LAB1 TDG29 LAB KEY 1 CN
16 RDGMD LAB10 TDG29 LAB KEY 1 CN
17 RDGMD LAB2 TDG29 LAB KEY 1 CN
18 RDGMD LAB3 TDG29 LAB KEY 1 CN
19 RDGMD LAB4 TDG29 LAB KEY 1 CN
20 RDGMD LAB5 TDG29 LAB KEY 1 CN
21 RDGMD LAB6 TDG29 LAB KEY 1 CN
22 RDGMD LAB7 TDG29 LAB KEY 1 CN
23 RDGMD LAB8 TDG29 LAB KEY 1 CN
24 RDGMD LAB9 TDG29 LAB KEY 1 CN
25 RDGMD LDBC THM011 LDBC KEY 1 CN
26 RDGMD LWDG THM063 LWDG KEY 1 CN
27 RDGMD MANDT T000 MANDT    
28 RDGMD MATNR MARA MATNR KEY 1 CN
29 RDGMD MAXU T006 MSEHI REF 1 CN
30 RDGMD MINU T006 MSEHI REF 1 CN
31 RDGMD MOS1 THM003 MOS KEY 1 CN
32 RDGMD MOS2 THM003 MOS KEY 1 CN
33 RDGMD MOS3 THM003 MOS KEY 1 CN
34 RDGMD MOS4 THM003 MOS KEY 1 CN
35 RDGMD MOS5 THM003 MOS KEY 1 CN
36 RDGMD MOS6 THM003 MOS KEY 1 CN
37 RDGMD MOS7 THM003 MOS KEY 1 CN
38 RDGMD MOS8 THM003 MOS KEY 1 CN
39 RDGMD MOS9 THM003 MOS KEY 1 CN
40 RDGMD MOSA THM003 MOS KEY 1 CN
41 RDGMD MOT THM151 MOT 1 CN
42 RDGMD NHME THM159 NDG KEY 1 CN
43 RDGMD PAIU T006 MSEHI REF 1 CN
44 RDGMD PAOU T006 MSEHI REF 1 CN
45 RDGMD PIN THM075 PIN KEY 1 CN
46 RDGMD PINLQ THM075 PIN KEY 1 CN
47 RDGMD RELU T006 MSEHI REF 1 CN
48 RDGMD RQU T006 MSEHI REF 1 CN
49 RDGMD RVLID TCG91 RVLID 1 N
50 RDGMD SDCL TDG37 SDCL KEY 1 CN
51 RDGMD SRSID TCG56 SRSID REF 1 CN
52 RDGMD TKUI TDG73 TKUI KEY 1 CN
53 RDGMD TPCUN T006 MSEHI REF 1 CN
54 RDGMD TPEUN T006 MSEHI REF 1 CN
55 RDGMD TPFUN T006 MSEHI REF 1 CN
56 RDGMD TPSHU T006 MSEHI REF 1 CN
57 RDGMD TPSLU T006 MSEHI REF 1 CN
58 RDGMD UBOPO T006 MSEHI REF 1 CN
59 RDGMD UBUDE T006 MSEHI REF 1 CN
60 RDGMD UCOOE T006 MSEHI REF 1 CN
61 RDGMD UDENFE T006 MSEHI REF 1 CN
62 RDGMD UDENFI T006 MSEHI REF 1 CN
63 RDGMD UDENTW T006 MSEHI REF 1 CN
64 RDGMD UMEPO T006 MSEHI REF 1 CN
65 RDGMD UMTMP T006 MSEHI REF 1 CN
66 RDGMD UPAGW T006 MSEHI REF 1 CN
67 RDGMD UPASI T006 MSEHI REF 1 CN
68 RDGMD USOOW T006 MSEHI REF 1 CN
69 RDGMD USTPRE T006 MSEHI REF 1 CN
70 RDGMD UVISC T006 MSEHI REF 1 CN
71 RDGMD VBFC TDG35 VBFC KEY 1 CN
History
Last changed by/on SAP  20110901 
SAP Release Created in 600