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