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   Table Relationship Diagram
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 .INCLUDE       0   0   DG: Dangerous Goods Master  
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   EHS: Logical Database Key to RDGKEY  
20 MATNR BASE_MATID BASD_MATID CHAR 40   0   Material or Product (Internal Key) *
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 .INCLUDE       0   0   Structures for generating change document update programs  
173 KZ CDCHNGIND CDCHNGIND CHAR 1   0   Change type (U, I, E, D)  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 VDGTMD AENNR AENR AENNR REF 1 CN
2 VDGTMD COWE TDG15 COWE 1 CN
3 VDGTMD DGCL THM009 DGCL REF 1 CN
4 VDGTMD DGNHM THM159 NDG 1 CN
5 VDGTMD DGWOS THM039 DGWOS 1 CN
6 VDGTMD HNU THM031 HNU 1 CN
7 VDGTMD HPN1 THM017 HPN 1 CN
8 VDGTMD HPN2 THM017 HPN 1 CN
9 VDGTMD HPN3 THM017 HPN 1 CN
10 VDGTMD HPN4 THM017 HPN 1 CN
11 VDGTMD HPN5 THM017 HPN 1 CN
12 VDGTMD HPN6 THM017 HPN 1 CN
13 VDGTMD HPN7 THM017 HPN 1 CN
14 VDGTMD HQTUN T006 MSEHI 1 CN
15 VDGTMD LAB1 TDG29 LAB 1 CN
16 VDGTMD LAB10 TDG29 LAB 1 CN
17 VDGTMD LAB2 TDG29 LAB 1 CN
18 VDGTMD LAB3 TDG29 LAB 1 CN
19 VDGTMD LAB4 TDG29 LAB 1 CN
20 VDGTMD LAB5 TDG29 LAB 1 CN
21 VDGTMD LAB6 TDG29 LAB 1 CN
22 VDGTMD LAB7 TDG29 LAB 1 CN
23 VDGTMD LAB8 TDG29 LAB 1 CN
24 VDGTMD LAB9 TDG29 LAB 1 CN
25 VDGTMD LDBC THM011 LDBC REF 1 CN
26 VDGTMD LWDG THM063 LWDG 1 CN
27 VDGTMD MANDT T000 MANDT    
28 VDGTMD MAXU T006 MSEHI 1 CN
29 VDGTMD MINU T006 MSEHI 1 CN
30 VDGTMD MOS1 THM003 MOS 1 CN
31 VDGTMD MOS2 THM003 MOS 1 CN
32 VDGTMD MOS3 THM003 MOS 1 CN
33 VDGTMD MOS4 THM003 MOS 1 CN
34 VDGTMD MOS5 THM003 MOS 1 CN
35 VDGTMD MOS6 THM003 MOS 1 CN
36 VDGTMD MOS7 THM003 MOS 1 CN
37 VDGTMD MOS8 THM003 MOS 1 CN
38 VDGTMD MOS9 THM003 MOS 1 CN
39 VDGTMD MOSA THM003 MOS 1 CN
40 VDGTMD MOT THM151 MOT 1 CN
41 VDGTMD NHME THM159 NDG 1 CN
42 VDGTMD PAIU T006 MSEHI 1 CN
43 VDGTMD PAOU T006 MSEHI 1 CN
44 VDGTMD PIN THM075 PIN REF 1 CN
45 VDGTMD PINLQ THM075 PIN REF 1 CN
46 VDGTMD RELU T006 MSEHI 1 CN
47 VDGTMD RQU T006 MSEHI 1 CN
48 VDGTMD RVLID TCG91 RVLID    
49 VDGTMD SDCL TDG37 SDCL 1 CN
50 VDGTMD SRSID TCG56 SRSID REF 1 CN
51 VDGTMD TKUI TDG73 TKUI 1 CN
52 VDGTMD TPCUN T006 MSEHI 1 CN
53 VDGTMD TPEUN T006 MSEHI 1 CN
54 VDGTMD TPFUN T006 MSEHI    
55 VDGTMD TPSHU T006 MSEHI 1 CN
56 VDGTMD TPSLU T006 MSEHI 1 CN
57 VDGTMD UBOPO T006 MSEHI 1 CN
58 VDGTMD UBUDE T006 MSEHI 1 CN
59 VDGTMD UCOOE T006 MSEHI 1 CN
60 VDGTMD UDENFE T006 MSEHI 1 CN
61 VDGTMD UDENFI T006 MSEHI 1 CN
62 VDGTMD UDENTW T006 MSEHI 1 CN
63 VDGTMD UMEPO T006 MSEHI 1 CN
64 VDGTMD UMTMP T006 MSEHI 1 CN
65 VDGTMD UPAGW T006 MSEHI 1 CN
66 VDGTMD UPASI T006 MSEHI 1 CN
67 VDGTMD USOOW T006 MSEHI 1 CN
68 VDGTMD USTPRE T006 MSEHI 1 CN
69 VDGTMD UVISC T006 MSEHI 1 CN
70 VDGTMD VBFC TDG35 VBFC 1 CN
History
Last changed by/on SAP  20110901 
SAP Release Created in 110