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