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
⤷ 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
History
Last changed by/on | SAP | 20110901 |
SAP Release Created in |