	Table	Columns	Description
1	TJKWE	15	IS-M/SD: WBZ, Order Data for Inbound Processing
2	RSADMINC	96	Customizing Table General BW
3	BBP_PD_XML	8	Table for Persistent Class CL_XML_PPF_BBP
4	/OTX/RM_TELIB	24	Enterprise Library Server Settings
5	UMV_TR125	9	Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6	/ISDFPS/CHVW_E	34	External Batch Where-Used List
7	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
8	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
9	BSEG	345	Accounting Document Segment
10	FMARCPAR	4	Parallelization of FMARC_BATCH

	Table	Columns	Description
1	OITM	299	Items
2	OINV	386	A/R Invoice
3	OCRD	332	Business Partner
4	ORDR	386	Sales Order
5	OJDT	100	Journal Entry
6	INV1	265	A/R Invoice - Rows
7	OPCH	386	A/P Invoice
8	JDT1	124	Journal Entry - Rows
9	OPOR	386	Purchase Order
10	OVTG	52	Tax Definition

	Table	Columns	Description
1	OITM	249	Items
2	ORCT	154	Incoming Payment
3	OINV	268	A/R Invoice
4	OIVL	77	Whse Journal
5	OVPM	154	Outgoing Payments
6	OPCH	268	A/P Invoice
7	JDT1	110	Journal Entry - Rows
8	OOCR	9	Loading Factors
9	OINM	101	Whse Journal
10	OSRN	20	Serial Numbers Master Data

242 COLUMNS | 1 INDEXES | ERP 6.0 | DGMSD TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Environment, Health and Safety
1	ERP EHP7	6.0	DGMSD	242	1	DG: Dangerous Goods Document Table DGMSD	Environment, Health and Safety

SQL: selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT MANDT, VBELN, POSNR, LFDNR, LWDG, MATNR, MOT, RVLID, DGNHM, DGCAO, TKUI, DGNU, DGCL, DGSC, SDBC, SLBE, LDBC, COTMP, TPCUN, EMTMP, TPEUN, FLTMP, TPFUN, TPSNL, TPSLU, TPSNH, TPSHU, COWE, VBFC, SDCL, EINU, EICN, EMSN1, EMSN2, MFAG1, MFAG2, MOS1, MOS2, MOS3, MOS4, MOS5, MOS6, MOS7, MOS8, MOS9, MOSA, HQTU, HQTUN, PIN, PGRO, HNU, HPN1, HPN2, HPN3, HPN4, HPN5, HPN6, HPN7, LAB1, LAB2, LAB3, LAB4, LAB5, LAB6, LAB7, LAB8, LAB9, LAB10, PAI, PAIU, PAO, PAOU, RQA, RQU, PBI, MINQ, MINU, MAXQ, MAXU, RELQ, RELU, MULRQ, RCHEM, DGPTA, DGTNA, DGWOS, NHME, DGSHE, PIMDG, SOOWA, USOOW, DENFEE, UDENFE, DENTWE, UDENTW, DENFIF, UDENFI, BUDEN, UBUDE, BOPOI, UBOPO, VISCO, UVISC, STPRES, USTPRE, MEPOI, UMEPO, COOEX, UCOOE, MTMPF, UMTMP, STOPA, SPPRO, MAPOL, PINLQ, PASI, UPASI, PAGW, UPAGW, EXCEP, SCASE, COLNO, EIMDG, PDGNUD, PRES1, PRES2, PRES3, PREMP1, PRERQ1, PRERQ2, PSTOSU, PDAIN1, PDAIN2, PDAIN3, PDAIN4, PDAIN5, PDAIN6, PDAIN7, PDAIN8, PDAIN9, PDAIN10, MIOWA, UMIOW, PHYGRO, PDGF1, PDGF2, PDGF3, PDGF4, PDGF5, PDGF6, PDGF7, PDGF8, PDGF9, PDGFA, PDGFB, PDGFC, PDGFD, PDGFE, PDGFF, PTXTPATT, MSEPR1, MSEPR2, MSEPR3, MSEPR4, MSEPR5, MSEPR6, MSEPR7, MSEPR8, MSEPR9, MSEPRA, MSEPRB, MSEPRC, MSEPRD, MSEPRE, MSEPRF, MSEPRG, MSEPRH, MLOAR1, MLOAR2, MLOAR3, MLOAR4, MLOAR5, MLOAR6, MLOAR7, MLOAR8, MLOAR9, MLOARA, RSMLG1, RSMLG2, RSMLG3, ESMLG1, ESMLG2, ESMLG3, PREMP2, RQA2, RQU2, PPDG1, PPDG2, PPDG3, PPDG4, PPDG5, PPDG6, PPDG7, PPDG8, PPDG9, PPDGA, PPDGB, PPDGC, PPDGE, PPDGF, PPDGG, DAOR, FORM_PHYS_CHEM, EXPL_NET, EXPL_NET_U, EXPL_REL_PERCENT, ACTVTY_MAX, ACTVTY_MAX_U, ACTVTY_MAX_REL, ACTVTY_MAX_REL_U, LTSK, EMV, FSAK, SFK, MUNAKODE, EXNUMBER, CERTIFIC, HAZCHEM_CODE, FLG_EMSN1_U, FLG_EMSN2_U, STOWAGE, CARR_TYPE, FLG_PAI, FLG_PAO, FLG_PASI, FLG_PAGW, FLG_RELQ, FLG_MULRQ, FLG_RELQ_UNLIMIT, FLG_MULRQ_FORBID, PDGNUDPRE, PDGNUDSUF FROM DGMSD

TOP ERP 6.0 | DGMSD COLUMNS

Column	Field	Description	SQL Type	Length	Decimals	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	Allow NULL?
2	VBELN	Sales and Distribution Document Number	nvarchar	10	0	Allow NULL?
3	POSNR	Sales Document Item	nvarchar	6	0	Allow NULL?
4	LFDNR	Counter used to differentiate between data base entries	nvarchar	4	0	Allow NULL?
5	LWDG	Dangerous Goods Regulation	nvarchar	12	0	Allow NULL?
6	MATNR	Material Number	nvarchar	18	0	Allow NULL?
7	MOT	Dangerous Goods - Mode-of-Transport Category	nvarchar	2	0	Allow NULL?
8	RVLID	Validity Area	nvarchar	10	0	Allow NULL?
9	DGNHM	Non-Dangerous Goods Full Transport	char	1	0	Allow NULL?
10	DGCAO	Only Cargo Air Transport Permitted	char	1	0	Allow NULL?
11	TKUI	Identification Number Type	nvarchar	3	0	Allow NULL?
12	DGNU	Identification Number	nvarchar	4	0	Allow NULL?
13	DGCL	Dangerous Goods Class	nvarchar	3	0	Allow NULL?
14	DGSC	Dangerous Goods Subclass	nvarchar	6	0	Allow NULL?
15	SDBC	Hazard Item Number	nvarchar	4	0	Allow NULL?
16	SLBE	Hazard Item Number (Empty Transport)	nvarchar	4	0	Allow NULL?
17	LDBC	Classification Code	nvarchar	5	0	Allow NULL?
18	COTMP	Control Temperature	decimal	8	2
19	TPCUN	Temperature Unit (Control)	nvarchar	3	0	Allow NULL?
20	EMTMP	Emergency Temperature	decimal	8	2
21	TPEUN	Temperature Unit (Emergency)	nvarchar	3	0	Allow NULL?
22	FLTMP	Flash Point	decimal	8	2
23	TPFUN	Temperature Unit (Flame)	nvarchar	3	0	Allow NULL?
24	TPSNL	Temperature Sensitivity (Lower Limit)	decimal	8	2
25	TPSLU	Unit for temperature sensitivity (lower limit)	nvarchar	3	0	Allow NULL?
26	TPSNH	Temperature sensitivity (upper limit)	decimal	8	2
27	TPSHU	Temperature Unit (Sensitivity - Upper Limit)	nvarchar	3	0	Allow NULL?
28	COWE	Water Pollution Class	char	1	0	Allow NULL?
29	VBFC	VbF Class	nvarchar	4	0	Allow NULL?
30	SDCL	Storage Hazard Class	nvarchar	4	0	Allow NULL?
31	EINU	Tremcard Number	nvarchar	7	0	Allow NULL?
32	EICN	Replacement Tremcard Number	nvarchar	7	0	Allow NULL?
33	EMSN1	EmS/ERG Number 1	nvarchar	7	0	Allow NULL?
34	EMSN2	EmS/ERG Number 2	nvarchar	7	0	Allow NULL?
35	MFAG1	MFAG Number 1	nvarchar	4	0	Allow NULL?
36	MFAG2	MFAG Number 2	nvarchar	4	0	Allow NULL?
37	MOS1	Dangerous Goods Transport Type	nvarchar	3	0	Allow NULL?
38	MOS2	Dangerous Goods Transport Type	nvarchar	3	0	Allow NULL?
39	MOS3	Dangerous Goods Transport Type	nvarchar	3	0	Allow NULL?
40	MOS4	Dangerous Goods Transport Type	nvarchar	3	0	Allow NULL?
41	MOS5	Dangerous Goods Transport Type	nvarchar	3	0	Allow NULL?
42	MOS6	Dangerous Goods Transport Type	nvarchar	3	0	Allow NULL?
43	MOS7	Dangerous Goods Transport Type	nvarchar	3	0	Allow NULL?
44	MOS8	Dangerous Goods Transport Type	nvarchar	3	0	Allow NULL?
45	MOS9	Dangerous Goods Transport Type	nvarchar	3	0	Allow NULL?
46	MOSA	Dangerous Goods Transport Type	nvarchar	3	0	Allow NULL?
47	HQTU	Maximum Quantity per Transport Unit	decimal	8	2
48	HQTUN	Maximum Quantity Unit	nvarchar	3	0	Allow NULL?
49	PIN	Packing Instruction Number	nvarchar	25	0	Allow NULL?
50	PGRO	Packing Group	nvarchar	3	0	Allow NULL?
51	HNU	Hazard Identification Number	nvarchar	4	0	Allow NULL?
52	HPN1	Danger Label Number 1	nvarchar	10	0	Allow NULL?
53	HPN2	Danger Label Number 2	nvarchar	10	0	Allow NULL?
54	HPN3	Danger Label Number 3	nvarchar	10	0	Allow NULL?
55	HPN4	Danger Label Number 4	nvarchar	10	0	Allow NULL?
56	HPN5	Danger Label Number 5	nvarchar	10	0	Allow NULL?
57	HPN6	Danger Label Number 6	nvarchar	10	0	Allow NULL?
58	HPN7	Danger Label Number 7	nvarchar	10	0	Allow NULL?
59	LAB1	Label Number 1	nvarchar	7	0	Allow NULL?
60	LAB2	Label Number 2	nvarchar	7	0	Allow NULL?
61	LAB3	Label Number 3	nvarchar	7	0	Allow NULL?
62	LAB4	Label Number 4	nvarchar	7	0	Allow NULL?
63	LAB5	Label Number 5	nvarchar	7	0	Allow NULL?
64	LAB6	Label Number 6	nvarchar	7	0	Allow NULL?
65	LAB7	Label Number 7	nvarchar	7	0	Allow NULL?
66	LAB8	Label Number 8	nvarchar	7	0	Allow NULL?
67	LAB9	Label Number 9	nvarchar	7	0	Allow NULL?
68	LAB10	Label Number 10	nvarchar	7	0	Allow NULL?
69	PAI	Limited Quantity (LQ) Inner Packaging	decimal	8	2
70	PAIU	Unit of Meas. for Limited Quantity (LQ) Inner Packaging	nvarchar	3	0	Allow NULL?
71	PAO	Limited Quantity (LQ) Outer Packaging	decimal	8	2
72	PAOU	Unit of Meas. for Limited Quantity (LQ) Outer Packaging	nvarchar	3	0	Allow NULL?
73	RQA	Reportable Quantity	decimal	8	2
74	RQU	Unit of measure for reportable quantities	nvarchar	3	0	Allow NULL?
75	PBI	Poisonous by Inhalation	char	1	0	Allow NULL?
76	MINQ	Minimum Quantity for Listed Goods	decimal	8	2
77	MINU	Unit of Measurement Minimum Quantity (Listed Goods)	nvarchar	3	0	Allow NULL?
78	MAXQ	Maximum Quantity for Listed Goods	decimal	8	2
79	MAXU	Unit of Measurement Maximum Quantity (Listed Goods)	nvarchar	3	0	Allow NULL?
80	RELQ	Exemption (ADR 1.1.3.6)	decimal	8	2
81	RELU	Unit of Measure Quantity Limit	nvarchar	3	0	Allow NULL?
82	MULRQ	Multiplication Factor Exemption (ADR 1.1.3.6)	nvarchar	4	0	Allow NULL?
83	RCHEM	Notification Status (Law on Control of Toxic Substances)	char	1	0	Allow NULL?
84	DGPTA	Shipping by Mail Permitted	char	1	0	Allow NULL?
85	DGTNA	Transport Not Permitted	char	1	0	Allow NULL?
86	DGWOS	Processing Status for Basic Data and Master Data	nvarchar	2	0	Allow NULL?
87	NHME	Non-Dangerous Goods Empty Transport	char	1	0	Allow NULL?
88	DGSHE	Schedule of Class 7	nvarchar	4	0	Allow NULL?
89	PIMDG	Note on Regulation	nvarchar	10	0	Allow NULL?
90	SOOWA	Solubility of water	decimal	12	2
91	USOOW	Unit for solubility of water	nvarchar	3	0	Allow NULL?
92	DENFEE	Density I	decimal	11	2
93	UDENFE	Unit for density I	nvarchar	3	0	Allow NULL?
94	DENTWE	Density II	decimal	11	2
95	UDENTW	Unit for density II	nvarchar	3	0	Allow NULL?
96	DENFIF	Density III	decimal	11	2
97	UDENFI	Unit for density III	nvarchar	3	0	Allow NULL?
98	BUDEN	Bulk Density	decimal	11	2
99	UBUDE	Unit for Bulk Density	nvarchar	3	0	Allow NULL?
100	BOPOI	Boiling Point	decimal	8	2
101	UBOPO	Unit for Boiling Point	nvarchar	3	0	Allow NULL?
102	VISCO	Viscosity	decimal	9	2
103	UVISC	Unit for Viscosity	nvarchar	3	0	Allow NULL?
104	STPRES	Vapor Pressure	decimal	10	2
105	USTPRE	Unit for vapor pressure	nvarchar	3	0	Allow NULL?
106	MEPOI	Melting Point	decimal	8	2
107	UMEPO	Unit for Melting Point	nvarchar	3	0	Allow NULL?
108	COOEX	Coefficient of Expansion	decimal	8	2
109	UCOOE	Unit for Coefficient of Expansion	nvarchar	3	0	Allow NULL?
110	MTMPF	Medium Temperature of Liquid During Filling	decimal	8	2
111	UMTMP	Unit for medium filling temperature	nvarchar	3	0	Allow NULL?
112	STOPA	Packaging Mark	char	1	0	Allow NULL?
113	SPPRO	Special Provision	nvarchar	5	0	Allow NULL?
114	MAPOL	Marine Pollutant	nvarchar	2	0	Allow NULL?
115	PINLQ	Packing Instruction Number for Limited Quantity (LQ)	nvarchar	25	0	Allow NULL?
116	PASI	Maximum Quantity per Package	decimal	8	2
117	UPASI	Unit of Measurement for Single Packaging	nvarchar	3	0	Allow NULL?
118	PAGW	Limited Quantity (LQ) Gross Weight	decimal	8	2
119	UPAGW	Unit of Measurement for Limited Quantity (LQ) Gross	nvarchar	3	0	Allow NULL?
120	EXCEP	Exception and Agreement Number	nvarchar	40	0	Allow NULL?
121	SCASE	Special Case (Packing Check)	char	1	0	Allow NULL?
122	COLNO	Collective Number	char	1	0	Allow NULL?
123	EIMDG	Regulation Edition	nvarchar	4	0	Allow NULL?
124	PDGNUD	Dangerous Goods Description	nvarchar	21	0	Allow NULL?
125	PRES1	Hazard-Inducing Substance	nvarchar	21	0	Allow NULL?
126	PRES2	Hazard-Inducing Substance	nvarchar	21	0	Allow NULL?
127	PRES3	Hazard-Inducing Substance	nvarchar	21	0	Allow NULL?
128	PREMP1	Hazard-inducing substance (marine pollutant)	nvarchar	21	0	Allow NULL?
129	PRERQ1	Hazard-inducing substance (reportable quantity)	nvarchar	21	0	Allow NULL?
130	PRERQ2	Hazard-inducing substance (reportable quantity)	nvarchar	21	0	Allow NULL?
131	PSTOSU	Aggregate State for Transport	nvarchar	21	0	Allow NULL?
132	PDAIN1	Hazard Note 1	nvarchar	21	0	Allow NULL?
133	PDAIN2	Hazard Note 2	nvarchar	21	0	Allow NULL?
134	PDAIN3	Hazard Note 3	nvarchar	21	0	Allow NULL?
135	PDAIN4	Hazard Note 4	nvarchar	21	0	Allow NULL?
136	PDAIN5	Hazard Note 5	nvarchar	21	0	Allow NULL?
137	PDAIN6	Hazard Note 6	nvarchar	21	0	Allow NULL?
138	PDAIN7	Hazard Note 7	nvarchar	21	0	Allow NULL?
139	PDAIN8	Hazard Note 8	nvarchar	21	0	Allow NULL?
140	PDAIN9	Hazard Note 9	nvarchar	21	0	Allow NULL?
141	PDAIN10	Hazard Note 10	nvarchar	21	0	Allow NULL?
142	MIOWA	Miscibility with Water	decimal	8	2
143	UMIOW	Unit for Miscibility with Water	nvarchar	3	0	Allow NULL?
144	PHYGRO	Hygroscopicity	nvarchar	21	0	Allow NULL?
145	PDGF1	User-Defined Text Key 1	nvarchar	21	0	Allow NULL?
146	PDGF2	User-Defined Text Key 2	nvarchar	21	0	Allow NULL?
147	PDGF3	User-Defined Text Key 3	nvarchar	21	0	Allow NULL?
148	PDGF4	User-Defined Text Key 4	nvarchar	21	0	Allow NULL?
149	PDGF5	User-Defined Text Key 5	nvarchar	21	0	Allow NULL?
150	PDGF6	User-Defined Text Key 6	nvarchar	21	0	Allow NULL?
151	PDGF7	User-Defined Text Key 7	nvarchar	21	0	Allow NULL?
152	PDGF8	User-Defined Text Key 8	nvarchar	21	0	Allow NULL?
153	PDGF9	User-Defined Text Key 9	nvarchar	21	0	Allow NULL?
154	PDGFA	User-Defined Text Key 10	nvarchar	21	0	Allow NULL?
155	PDGFB	User-Defined Text Key 11	nvarchar	21	0	Allow NULL?
156	PDGFC	User-Defined Text Key 12	nvarchar	21	0	Allow NULL?
157	PDGFD	User-Defined Text Key 13	nvarchar	21	0	Allow NULL?
158	PDGFE	User-Defined Text Key 14	nvarchar	21	0	Allow NULL?
159	PDGFF	User-Defined Text Key 15	nvarchar	21	0	Allow NULL?
160	PTXTPATT	Dangerous Goods Text Pattern	nvarchar	21	0	Allow NULL?
161	MSEPR1	Segregation Key 1	nvarchar	4	0	Allow NULL?
162	MSEPR2	Segregation Key 2	nvarchar	4	0	Allow NULL?
163	MSEPR3	Segregation Key 3	nvarchar	4	0	Allow NULL?
164	MSEPR4	Segregation Key 4	nvarchar	4	0	Allow NULL?
165	MSEPR5	Segregation Key 5	nvarchar	4	0	Allow NULL?
166	MSEPR6	Segregation Key 6	nvarchar	4	0	Allow NULL?
167	MSEPR7	Segregation Key 7	nvarchar	4	0	Allow NULL?
168	MSEPR8	Segregation Key 8	nvarchar	4	0	Allow NULL?
169	MSEPR9	Segregation Key 9	nvarchar	4	0	Allow NULL?
170	MSEPRA	Segregation Key 10	nvarchar	4	0	Allow NULL?
171	MSEPRB	Segregation Key 11	nvarchar	4	0	Allow NULL?
172	MSEPRC	Segregation Key 12	nvarchar	4	0	Allow NULL?
173	MSEPRD	Segregation Key 13	nvarchar	4	0	Allow NULL?
174	MSEPRE	Segregation Key 14	nvarchar	4	0	Allow NULL?
175	MSEPRF	Segregation Key 15	nvarchar	4	0	Allow NULL?
176	MSEPRG	Segregation Key 16	nvarchar	4	0	Allow NULL?
177	MSEPRH	Segregation Key 17	nvarchar	4	0	Allow NULL?
178	MLOAR1	Mixed Loading Rule 1	nvarchar	6	0	Allow NULL?
179	MLOAR2	Mixed Loading Rule 2	nvarchar	6	0	Allow NULL?
180	MLOAR3	Mixed Loading Rule 3	nvarchar	6	0	Allow NULL?
181	MLOAR4	Mixed Loading Rule 4	nvarchar	6	0	Allow NULL?
182	MLOAR5	Mixed Loading Rule 5	nvarchar	6	0	Allow NULL?
183	MLOAR6	Mixed Loading Rule 6	nvarchar	6	0	Allow NULL?
184	MLOAR7	Mixed Loading Rule 7	nvarchar	6	0	Allow NULL?
185	MLOAR8	Mixed Loading Rule 8	nvarchar	6	0	Allow NULL?
186	MLOAR9	Mixed Loading Rule 9	nvarchar	6	0	Allow NULL?
187	MLOARA	Mixed Loading Rule 10	nvarchar	6	0	Allow NULL?
188	RSMLG1	Regulation-Dependent Mixed Loading Group 1	nvarchar	4	0	Allow NULL?
189	RSMLG2	Regulation-Dependent Mixed Loading Group 2	nvarchar	4	0	Allow NULL?
190	RSMLG3	Regulation-Dependent Mixed Loading Group 3	nvarchar	4	0	Allow NULL?
191	ESMLG1	Enterprise-Specific Mixed Loading Group 1	nvarchar	4	0	Allow NULL?
192	ESMLG2	Enterprise-Specific Mixed Loading Group 2	nvarchar	4	0	Allow NULL?
193	ESMLG3	Enterprise-Specific Mixed Loading Group 3	nvarchar	4	0	Allow NULL?
194	PREMP2	Hazard-inducing substance (marine pollutant)	nvarchar	21	0	Allow NULL?
195	RQA2	Reportable Quantity	decimal	8	2
196	RQU2	Unit of measure for reportable quantities	nvarchar	3	0	Allow NULL?
197	PPDG1	Profile for Dangerous Goods User-Defined Text 1	nvarchar	2	0	Allow NULL?
198	PPDG2	Profile for Dangerous Goods User-Defined Text 2	nvarchar	2	0	Allow NULL?
199	PPDG3	Profile for Dangerous Goods User-Defined Text 3	nvarchar	2	0	Allow NULL?
200	PPDG4	Profile for Dangerous Goods User-Defined Text 4	nvarchar	2	0	Allow NULL?
201	PPDG5	Profile for Dangerous Goods User-Defined Text 5	nvarchar	2	0	Allow NULL?
202	PPDG6	Profile for Dangerous Goods User-Defined Text 6	nvarchar	2	0	Allow NULL?
203	PPDG7	Profile for Dangerous Goods User-Defined Text 7	nvarchar	2	0	Allow NULL?
204	PPDG8	Profile for Dangerous Goods User-Defined Text 8	nvarchar	2	0	Allow NULL?
205	PPDG9	Profile for Dangerous Goods User-Defined Text 9	nvarchar	2	0	Allow NULL?
206	PPDGA	Profile for Dangerous Goods User-Defined Text 10	nvarchar	2	0	Allow NULL?
207	PPDGB	Profile for Dangerous Goods User-Defined Text 11	nvarchar	2	0	Allow NULL?
208	PPDGC	Profile for Dangerous Goods User-Defined Text 12	nvarchar	2	0	Allow NULL?
209	PPDGE	Profile for Dangerous Goods User-Defined Text 13	nvarchar	2	0	Allow NULL?
210	PPDGF	Profile for Dangerous Goods User-Defined Text 14	nvarchar	2	0	Allow NULL?
211	PPDGG	Profile for Dangerous Goods User-Defined Text 15	nvarchar	2	0	Allow NULL?
212	DAOR	Data Origin (Filling and Distribution)	char	1	0	Allow NULL?
213	FORM_PHYS_CHEM	Physical and Chemical Form	nvarchar	21	0	Allow NULL?
214	EXPL_NET	Net Explosive Substance Mass	decimal	9	3
215	EXPL_NET_U	Unit for Net Explosive Substance Mass	nvarchar	3	0	Allow NULL?
216	EXPL_REL_PERCENT	Relative Net Explosive Substance Percentage	decimal	6	3
217	ACTVTY_MAX	Maximum Activity	decimal	8	2
218	ACTVTY_MAX_U	Unit of Maximum Activity	nvarchar	3	0	Allow NULL?
219	ACTVTY_MAX_REL	Relative Maximum Activity	decimal	8	2
220	ACTVTY_MAX_REL_U	Unit of Relative Maximum Activity	nvarchar	3	0	Allow NULL?
221	LTSK	Air Transport Safety Code	char	1	0	Allow NULL?
222	EMV	Electromagnetic Compatibility	char	1	0	Allow NULL?
223	FSAK	Parachute Drop Code	char	1	0	Allow NULL?
224	SFK	Thrust Code	char	1	0	Allow NULL?
225	MUNAKODE	Ammunition Code	nvarchar	4	0	Allow NULL?
226	EXNUMBER	EX-Number	nvarchar	12	0	Allow NULL?
227	CERTIFIC	Identification Mark for Approval Certificate	nvarchar	21	0	Allow NULL?
228	HAZCHEM_CODE	Code for Chemical Hazard	nvarchar	10	0	Allow NULL?
229	FLG_EMSN1_U	EmS Number 1 Underlined	char	1	0	Allow NULL?
230	FLG_EMSN2_U	EmS Number 2 Underlined	char	1	0	Allow NULL?
231	STOWAGE	Stowage Category	nvarchar	3	0	Allow NULL?
232	CARR_TYPE	Transport Category	nvarchar	3	0	Allow NULL?
233	FLG_PAI	Value Entered for Limited Quantity (LQ) Inner Packaging	char	1	0	Allow NULL?
234	FLG_PAO	Value Entered for Limited Quantity (LQ) Outer Packaging	char	1	0	Allow NULL?
235	FLG_PASI	Value Entered for Maximum Quantity per Package	char	1	0	Allow NULL?
236	FLG_PAGW	Value Entered for Limited Quantity (LQ) Gross Weight	char	1	0	Allow NULL?
237	FLG_RELQ	Value Entered for Exemption	char	1	0	Allow NULL?
238	FLG_MULRQ	Value Entered for Multiplication Factor	char	1	0	Allow NULL?
239	FLG_RELQ_UNLIMIT	Unlimited Set for Exemption	char	1	0	Allow NULL?
240	FLG_MULRQ_FORBID	Prohibited Set for Multiplication Factor	char	1	0	Allow NULL?
241	PDGNUDPRE	Dangerous Goods Description Prefix	nvarchar	21	0	Allow NULL?
242	PDGNUDSUF	Dangerous Goods Description Suffix	nvarchar	21	0	Allow NULL?

TOP ERP 6.0 | DGMSD INDEXES

Name	Primary	Unique	Type	Columns
DGMSD~0	Yes	Yes	CLUSTERED	LFDNR, POSNR, VBELN, MANDT

SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

SAP TABLESv1

ERP 6.0: Top 10 requests

B1 9.2: Top 10 requests

B1 8.8: Top 10 requests

242 COLUMNS | 1 INDEXES | ERP 6.0 | DGMSD TABLE

TOP ERP 6.0 | DGMSD COLUMNS

TOP ERP 6.0 | DGMSD INDEXES

SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

SAP TABLESv1

ERP 6.0: Top 10 requests

B1 9.2: Top 10 requests

B1 8.8: Top 10 requests

242 COLUMNS | 1 INDEXES | ERP 6.0 | DGMSD TABLE

TOPERP 6.0 | DGMSD COLUMNS

TOPERP 6.0 | DGMSD INDEXES

TOP ERP 6.0 | DGMSD COLUMNS

TOP ERP 6.0 | DGMSD INDEXES