SAP ABAP Table VDGTMD (Change Document Structure; Generated by RSSCD000)
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 | VDGTMD |
|
| Short Description | Change Document Structure; Generated by RSSCD000 |
Delivery and Maintenance
| Pool/cluster | ||
| Delivery Class | ||
| 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 | |
0 | 0 | DG: Dangerous Goods Master | |||||
| 2 | |
0 | 0 | EHS: Structure for key info of master data | |||||
| 3 | |
MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
| 4 | |
ESERECN | ESDRECN | NUMC | 20 | 0 | Sequential Number of Data Record | ||
| 5 | |
ESEACTN | ESDACTN | NUMC | 20 | 0 | Sequential Number of the Change State | ||
| 6 | |
0 | 0 | DG: Structure for General Administration Information | |||||
| 7 | |
ESEVALFR | DATUM | DATS | 8 | 0 | Valid-From Date | ||
| 8 | |
ESEVALTO | DATUM | DATS | 8 | 0 | Valid-To Date | ||
| 9 | |
ESEAENNR | AENNR | CHAR | 12 | 0 | Change Number | AENR | |
| 10 | |
ADGE_DELFLG | ESDFLAG | CHAR | 1 | 0 | Deletion Indicator | ||
| 11 | |
ESEPARKFLG | ESDFLAG | CHAR | 1 | 0 | Data Record Is Inactive | ||
| 12 | |
ESECRDAT | DATUM | DATS | 8 | 0 | Created On | ||
| 13 | |
ESECRNAM | USNAM | CHAR | 12 | 0 | Created By | ||
| 14 | |
ESEUPDDAT | DATUM | DATS | 8 | 0 | Changed On | ||
| 15 | |
ESEUPDNAM | USNAM | CHAR | 12 | 0 | Last Changed By | ||
| 16 | |
ESESRSID | ESDSRSID | CHAR | 10 | 0 | Source of Data | TCG56 | |
| 17 | |
ESEVENDRID | AD_ADDRNUM | CHAR | 10 | 0 | Data Provider | * | |
| 18 | |
ESERECN | ESDRECN | NUMC | 20 | 0 | Sequential Number of Data Record | ||
| 19 | |
0 | 0 | EHS: Logical Database Key to RDGKEY | |||||
| 20 | |
BASE_MATID | BASD_MATID | CHAR | 40 | 0 | Material or Product (Internal Key) | * | |
| 21 | |
THME_MOT | HMD_MOT | NUMC | 2 | 0 | Dangerous Goods - Mode-of-Transport Category | THM151 | |
| 22 | |
ESERVLID | ESDRVLID | CHAR | 10 | 0 | Validity Area | TCG91 | |
| 23 | |
0 | 0 | EHS: Application Data for Table DGTMD | |||||
| 24 | |
THME_NHM | HMD_NDG | CHAR | 1 | 0 | Non-Dangerous Goods Full Transport | THM159 | |
| 25 | |
ADGE_DGCAO | X | CHAR | 1 | 0 | Only Cargo Air Transport Permitted | ||
| 26 | |
THME_TKUI | HMD_TKUI | CHAR | 3 | 0 | Identification Number Type | TDG73 | |
| 27 | |
THME_DGNU | CHAR4 | CHAR | 4 | 0 | Identification Number | * | |
| 28 | |
ADGE_RES | CHAR12 | CHAR | 12 | 0 | Hazard-Inducing Substance | * | |
| 29 | |
ADGE_RES | CHAR12 | CHAR | 12 | 0 | Hazard-Inducing Substance | * | |
| 30 | |
THME_DGCL | HMD_DGCL | CHAR | 3 | 0 | Dangerous Goods Class | THM009 | |
| 31 | |
ADGE_DGSC | CHAR6 | CHAR | 6 | 0 | Dangerous Goods Subclass | * | |
| 32 | |
ADGE_SDBC | NUMC4 | NUMC | 4 | 0 | Hazard Item Number | * | |
| 33 | |
THME_SLBE | NUMC4 | NUMC | 4 | 0 | Hazard Item Number (Empty Transport) | * | |
| 34 | |
THME_LDBC | HMD_LDBC | CHAR | 5 | 0 | Classification Code | THM011 | |
| 35 | |
THME_LWDG | HMD_LWDG | CHAR | 12 | 0 | Dangerous Goods Regulation | THM063 | |
| 36 | |
ADGE_STOSU | CHAR1 | CHAR | 1 | 0 | Aggregate State for Transport | * | |
| 37 | |
ADGE_COTMP | ADGD_Q82 | QUAN | 8 | 2 | Control Temperature | ||
| 38 | |
ADGE_TPCUN | MEINS | UNIT | 3 | 0 | Temperature Unit (Control) | T006 | |
| 39 | |
ADGE_EMTMP | ADGD_Q82 | QUAN | 8 | 2 | Emergency Temperature | ||
| 40 | |
ADGE_TPEUN | MEINS | UNIT | 3 | 0 | Temperature Unit (Emergency) | T006 | |
| 41 | |
ADGE_FLTMP | ADGD_Q82 | QUAN | 8 | 2 | Flash Point | ||
| 42 | |
ADGE_TPFUN | MEINS | UNIT | 3 | 0 | Temperature Unit (Flame) | T006 | |
| 43 | |
ADGE_TPSNL | ADGD_Q82 | QUAN | 8 | 2 | Temperature Sensitivity (Lower Limit) | ||
| 44 | |
ADGE_TPSLU | MEINS | UNIT | 3 | 0 | Unit for temperature sensitivity (lower limit) | T006 | |
| 45 | |
ADGE_TPSNH | ADGD_Q82 | QUAN | 8 | 2 | Temperature sensitivity (upper limit) | ||
| 46 | |
ADGE_TPSHU | MEINS | UNIT | 3 | 0 | Temperature Unit (Sensitivity - Upper Limit) | T006 | |
| 47 | |
ADGE_DAIN | CHAR4 | CHAR | 4 | 0 | Hazard Note | * | |
| 48 | |
ADGE_DAIN | CHAR4 | CHAR | 4 | 0 | Hazard Note | * | |
| 49 | |
ADGE_DAIN | CHAR4 | CHAR | 4 | 0 | Hazard Note | * | |
| 50 | |
ADGE_DAIN | CHAR4 | CHAR | 4 | 0 | Hazard Note | * | |
| 51 | |
ADGE_DAIN | CHAR4 | CHAR | 4 | 0 | Hazard Note | * | |
| 52 | |
ADGE_DAIN | CHAR4 | CHAR | 4 | 0 | Hazard Note | * | |
| 53 | |
ADGE_DAIN | CHAR4 | CHAR | 4 | 0 | Hazard Note | * | |
| 54 | |
ADGE_DAIN | CHAR4 | CHAR | 4 | 0 | Hazard Note | * | |
| 55 | |
ADGE_DAIN | CHAR4 | CHAR | 4 | 0 | Hazard Note | * | |
| 56 | |
ADGE_DAIN | CHAR4 | CHAR | 4 | 0 | Hazard Note | * | |
| 57 | |
ADGE_COWE | ADGD_COWE | CHAR | 1 | 0 | Water Pollution Class | TDG15 | |
| 58 | |
ADGE_VBFC | ADGD_VBFC | CHAR | 4 | 0 | VbF Class | TDG35 | |
| 59 | |
ADGE_SDCL | ADGD_SDCL | CHAR | 4 | 0 | Storage Hazard Class | TDG37 | |
| 60 | |
ADGE_EINU | CHAR7 | CHAR | 7 | 0 | Tremcard Number | ||
| 61 | |
ADGE_EICN | CHAR7 | CHAR | 7 | 0 | Replacement Tremcard Number | ||
| 62 | |
ADGE_EMSN1 | CHAR7 | CHAR | 7 | 0 | EmS/ERG Number 1 | ||
| 63 | |
ADGE_EMSN2 | CHAR7 | CHAR | 7 | 0 | EmS/ERG Number 2 | ||
| 64 | |
ADGE_MFAG1 | CHAR4 | CHAR | 4 | 0 | MFAG Number 1 | ||
| 65 | |
ADGE_MFAG2 | CHAR4 | CHAR | 4 | 0 | MFAG Number 2 | ||
| 66 | |
THME_MOS | HMD_MOS | NUMC | 3 | 0 | Dangerous Goods Transport Type | THM003 | |
| 67 | |
THME_MOS | HMD_MOS | NUMC | 3 | 0 | Dangerous Goods Transport Type | THM003 | |
| 68 | |
THME_MOS | HMD_MOS | NUMC | 3 | 0 | Dangerous Goods Transport Type | THM003 | |
| 69 | |
THME_MOS | HMD_MOS | NUMC | 3 | 0 | Dangerous Goods Transport Type | THM003 | |
| 70 | |
THME_MOS | HMD_MOS | NUMC | 3 | 0 | Dangerous Goods Transport Type | THM003 | |
| 71 | |
THME_MOS | HMD_MOS | NUMC | 3 | 0 | Dangerous Goods Transport Type | THM003 | |
| 72 | |
THME_MOS | HMD_MOS | NUMC | 3 | 0 | Dangerous Goods Transport Type | THM003 | |
| 73 | |
THME_MOS | HMD_MOS | NUMC | 3 | 0 | Dangerous Goods Transport Type | THM003 | |
| 74 | |
THME_MOS | HMD_MOS | NUMC | 3 | 0 | Dangerous Goods Transport Type | THM003 | |
| 75 | |
THME_MOS | HMD_MOS | NUMC | 3 | 0 | Dangerous Goods Transport Type | THM003 | |
| 76 | |
ADGE_HQTU | ADGD_Q82 | QUAN | 8 | 2 | Maximum Quantity per Transport Unit | ||
| 77 | |
ADGE_HQTUN | MEINS | UNIT | 3 | 0 | Maximum Quantity Unit | T006 | |
| 78 | |
THME_PIN | HMD_PIN | CHAR | 25 | 0 | Packing Instruction Number | THM075 | |
| 79 | |
THME_PGRO | CHAR3 | CHAR | 3 | 0 | Packing Group | ||
| 80 | |
THME_HNU | HMD_HNU | CHAR | 4 | 0 | Hazard Identification Number | THM031 | |
| 81 | |
THME_HPN1 | HMD_HPN | CHAR | 10 | 0 | Danger Label Number 1 | THM017 | |
| 82 | |
THME_HPN2 | HMD_HPN | CHAR | 10 | 0 | Danger Label Number 2 | THM017 | |
| 83 | |
THME_HPN3 | HMD_HPN | CHAR | 10 | 0 | Danger Label Number 3 | THM017 | |
| 84 | |
THME_HPN4 | HMD_HPN | CHAR | 10 | 0 | Danger Label Number 4 | THM017 | |
| 85 | |
THME_HPN5 | HMD_HPN | CHAR | 10 | 0 | Danger Label Number 5 | THM017 | |
| 86 | |
THME_HPN6 | HMD_HPN | CHAR | 10 | 0 | Danger Label Number 6 | THM017 | |
| 87 | |
THME_HPN7 | HMD_HPN | CHAR | 10 | 0 | Danger Label Number 7 | THM017 | |
| 88 | |
ADGE_LAB1 | ADGD_LAB | CHAR | 7 | 0 | Label Number 1 | TDG29 | |
| 89 | |
ADGE_LAB2 | ADGD_LAB | CHAR | 7 | 0 | Label Number 2 | TDG29 | |
| 90 | |
ADGE_LAB3 | ADGD_LAB | CHAR | 7 | 0 | Label Number 3 | TDG29 | |
| 91 | |
ADGE_LAB4 | ADGD_LAB | CHAR | 7 | 0 | Label Number 4 | TDG29 | |
| 92 | |
ADGE_LAB5 | ADGD_LAB | CHAR | 7 | 0 | Label Number 5 | TDG29 | |
| 93 | |
ADGE_LAB6 | ADGD_LAB | CHAR | 7 | 0 | Label Number 6 | TDG29 | |
| 94 | |
ADGE_LAB7 | ADGD_LAB | CHAR | 7 | 0 | Label Number 7 | TDG29 | |
| 95 | |
ADGE_LAB8 | ADGD_LAB | CHAR | 7 | 0 | Label Number 8 | TDG29 | |
| 96 | |
ADGE_LAB9 | ADGD_LAB | CHAR | 7 | 0 | Label Number 9 | TDG29 | |
| 97 | |
ADGE_LABA | ADGD_LAB | CHAR | 7 | 0 | Label Number 10 | TDG29 | |
| 98 | |
ADGE_KDGVS | TDOBNAME | CHAR | 70 | 0 | Text Key Highly Viscous Substances | * | |
| 99 | |
ADGE_KDGNS | TDOBNAME | CHAR | 70 | 0 | Text Key Exemption for Named Substances | * | |
| 100 | |
ADGE_KDGMP | TDOBNAME | CHAR | 70 | 0 | Text Key Marine Pollutant | * | |
| 101 | |
ADGE_KDGEX | TDOBNAME | CHAR | 70 | 0 | Text Key Exceptions | * | |
| 102 | |
ADGE_KDGHI | TDOBNAME | CHAR | 70 | 0 | Text key handling data | * | |
| 103 | |
ADGE_KDGF1 | TDOBNAME | CHAR | 70 | 0 | User-Defined Text Key 1 | * | |
| 104 | |
ADGE_KDGF2 | TDOBNAME | CHAR | 70 | 0 | User-Defined Text Key 2 | * | |
| 105 | |
ADGE_KDGF3 | TDOBNAME | CHAR | 70 | 0 | User-Defined Text Key 3 | * | |
| 106 | |
ADGE_KDGF4 | TDOBNAME | CHAR | 70 | 0 | User-Defined Text Key 4 | * | |
| 107 | |
ADGE_KDGF5 | TDOBNAME | CHAR | 70 | 0 | User-Defined Text Key 5 | * | |
| 108 | |
ADGE_KDGF6 | TDOBNAME | CHAR | 70 | 0 | User-Defined Text Key 6 | * | |
| 109 | |
ADGE_KDGF7 | TDOBNAME | CHAR | 70 | 0 | User-Defined Text Key 7 | * | |
| 110 | |
ADGE_KDGF8 | TDOBNAME | CHAR | 70 | 0 | User-Defined Text Key 8 | * | |
| 111 | |
ADGE_KDGF9 | TDOBNAME | CHAR | 70 | 0 | User-Defined Text Key 9 | * | |
| 112 | |
ADGE_KDGFA | TDOBNAME | CHAR | 70 | 0 | User-Defined Text Key 10 | * | |
| 113 | |
THME_PAI | HMD_QUAN | QUAN | 8 | 2 | Limited Quantity (LQ) Inner Packaging | ||
| 114 | |
THME_PAIU | MEINS | UNIT | 3 | 0 | Unit of Meas. for Limited Quantity (LQ) Inner Packaging | T006 | |
| 115 | |
THME_PAO | HMD_QUAN | QUAN | 8 | 2 | Limited Quantity (LQ) Outer Packaging | ||
| 116 | |
THME_PAOU | MEINS | UNIT | 3 | 0 | Unit of Meas. for Limited Quantity (LQ) Outer Packaging | T006 | |
| 117 | |
ADGE_RQA | ADGD_Q82 | QUAN | 8 | 2 | Reportable Quantity | ||
| 118 | |
ADGE_RQU | MEINS | UNIT | 3 | 0 | Unit of measure for reportable quantities | T006 | |
| 119 | |
ADGE_PBI | ADGD_PIH | CHAR | 1 | 0 | Poisonous by Inhalation | ||
| 120 | |
ADGE_MINQ | ADGD_Q82 | QUAN | 8 | 2 | Minimum Quantity for Listed Goods | ||
| 121 | |
ADGE_MINU | MEINS | UNIT | 3 | 0 | Unit of Measurement Minimum Quantity (Listed Goods) | T006 | |
| 122 | |
ADGE_MAXQ | ADGD_Q82 | QUAN | 8 | 2 | Maximum Quantity for Listed Goods | ||
| 123 | |
ADGE_MAXU | MEINS | UNIT | 3 | 0 | Unit of Measurement Maximum Quantity (Listed Goods) | T006 | |
| 124 | |
THME_RELQ | HMD_QUAN | QUAN | 8 | 2 | Exemption (ADR 1.1.3.6) | ||
| 125 | |
THME_RELU | MEINS | UNIT | 3 | 0 | Unit of Measure Quantity Limit | T006 | |
| 126 | |
THME_MULRQ | NUMC4 | NUMC | 4 | 0 | Multiplication Factor Exemption (ADR 1.1.3.6) | ||
| 127 | |
ADGE_RCHEM | X | CHAR | 1 | 0 | Notification Status (Law on Control of Toxic Substances) | ||
| 128 | |
ADGE_DGPTA | X | CHAR | 1 | 0 | Shipping by Mail Permitted | ||
| 129 | |
ADGE_DGTNA | X | CHAR | 1 | 0 | Transport Not Permitted | ||
| 130 | |
THME_WOS | HMD_WOS | CHAR | 2 | 0 | Processing Status for Basic Data and Master Data | THM039 | |
| 131 | |
THME_NHME | HMD_NDG | CHAR | 1 | 0 | Non-Dangerous Goods Empty Transport | THM159 | |
| 132 | |
ADGE_DGSHE | CHAR4 | CHAR | 4 | 0 | Schedule of Class 7 | ||
| 133 | |
ADGE_PIMDG | CHAR10 | CHAR | 10 | 0 | Note on Regulation | ||
| 134 | |
ADGE_SOOWA | ADGD_Q122 | QUAN | 12 | 2 | Solubility of water | ||
| 135 | |
ADGE_USOOW | MEINS | UNIT | 3 | 0 | Unit for solubility of water | T006 | |
| 136 | |
ADGE_DENFE | ADGD_Q112 | QUAN | 11 | 2 | Density I | ||
| 137 | |
ADGE_UDENF | MEINS | UNIT | 3 | 0 | Unit for density I | T006 | |
| 138 | |
ADGE_DENTW | ADGD_Q112 | QUAN | 11 | 2 | Density II | ||
| 139 | |
ADGE_UDENT | MEINS | UNIT | 3 | 0 | Unit for density II | T006 | |
| 140 | |
ADGE_DENFI | ADGD_Q112 | QUAN | 11 | 2 | Density III | ||
| 141 | |
ADGE_UDEFI | MEINS | UNIT | 3 | 0 | Unit for density III | T006 | |
| 142 | |
ADGE_BUDEN | ADGD_Q112 | QUAN | 11 | 2 | Bulk Density | ||
| 143 | |
ADGE_UBUDE | MEINS | UNIT | 3 | 0 | Unit for Bulk Density | T006 | |
| 144 | |
ADGE_BOPOI | HMD_QUAN | QUAN | 8 | 2 | Boiling Point | ||
| 145 | |
ADGE_UBOPO | MEINS | UNIT | 3 | 0 | Unit for Boiling Point | T006 | |
| 146 | |
ADGE_VISCO | ADGD_Q92 | QUAN | 9 | 2 | Viscosity | ||
| 147 | |
ADGE_UVISC | MEINS | UNIT | 3 | 0 | Unit for Viscosity | T006 | |
| 148 | |
ADGE_STPRE | ADGD_Q102 | QUAN | 10 | 2 | Vapor Pressure | ||
| 149 | |
ADGE_USTPR | MEINS | UNIT | 3 | 0 | Unit for vapor pressure | T006 | |
| 150 | |
ADGE_HYGRO | CHAR1 | CHAR | 1 | 0 | Hygroscopicity | ||
| 151 | |
ADGE_MEPOI | HMD_QUAN | QUAN | 8 | 2 | Melting Point | ||
| 152 | |
ADGE_UMEPO | MEINS | UNIT | 3 | 0 | Unit for Melting Point | T006 | |
| 153 | |
ADGE_COOEX | HMD_QUAN | QUAN | 8 | 2 | Coefficient of Expansion | ||
| 154 | |
ADGE_UCOOE | MEINS | UNIT | 3 | 0 | Unit for Coefficient of Expansion | T006 | |
| 155 | |
ADGE_MTMPF | HMD_QUAN | QUAN | 8 | 2 | Medium Temperature of Liquid During Filling | ||
| 156 | |
ADGE_UMTMP | MEINS | UNIT | 3 | 0 | Unit for medium filling temperature | T006 | |
| 157 | |
THME_STOPA | CHAR1 | CHAR | 1 | 0 | Packaging Mark | ||
| 158 | |
THME_SPPRO | CHAR5 | CHAR | 5 | 0 | Special Provision | ||
| 159 | |
ADGE_MAPOL | ADGD_MAPOL | CHAR | 2 | 0 | Marine Pollutant | ||
| 160 | |
THME_PINLQ | HMD_PIN | CHAR | 25 | 0 | Packing Instruction Number for Limited Quantity (LQ) | THM075 | |
| 161 | |
THME_PASI | HMD_QUAN | QUAN | 8 | 2 | Maximum Quantity per Package | ||
| 162 | |
THME_UPASI | MEINS | UNIT | 3 | 0 | Unit of Measurement for Single Packaging | T006 | |
| 163 | |
THME_PAGW | HMD_QUAN | QUAN | 8 | 2 | Limited Quantity (LQ) Gross Weight | ||
| 164 | |
THME_UPAGW | MEINS | UNIT | 3 | 0 | Unit of Measurement for Limited Quantity (LQ) Gross | T006 | |
| 165 | |
ADGE_EXCEP | CHAR40 | CHAR | 40 | 0 | Exception and Agreement Number | ||
| 166 | |
ADGE_SCASE | X | CHAR | 1 | 0 | Special Case (Packing Check) | ||
| 167 | |
ADGE_COLNO | X | CHAR | 1 | 0 | Collective Number | ||
| 168 | |
ADGE_RES | CHAR12 | CHAR | 12 | 0 | Hazard-Inducing Substance | * | |
| 169 | |
ADGE_REMP | CHAR12 | CHAR | 12 | 0 | Hazard-inducing substance (marine pollutant) | * | |
| 170 | |
ADGE_RERQ | CHAR12 | CHAR | 12 | 0 | Hazard-inducing substance (reportable quantity) | * | |
| 171 | |
ADGE_EIMDG | CHAR4 | CHAR | 4 | 0 | Regulation Edition | ||
| 172 | |
0 | 0 | Structures for generating change document update programs | |||||
| 173 | |
CDCHNGIND | CDCHNGIND | CHAR | 1 | 0 | Change type (U, I, E, D) |
Foreign Keys
History
| Last changed by/on | SAP | 20110901 |
| SAP Release Created in | 110 |