	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	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
7	/ISDFPS/CHVW_E	34	External Batch Where-Used List
8	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
9	FMARCPAR	4	Parallelization of FMARC_BATCH
10	CEKRS	5	Movement type parameters for automatic ERS

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

	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	OSRN	20	Serial Numbers Master Data
10	OBOT	10	Bill Of Exchang Transaction

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	SAP Type	Default Value	Null Allowed	CheckTable	Rollname	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	CLNT	(N'000')	No	T000	MANDT	Allow NULL?
2	VBELN	Sales and Distribution Document Number	nvarchar	10	0	CHAR	(N' ')	No	VBUK	VBELN	Allow NULL?
3	POSNR	Sales Document Item	nvarchar	6	0	NUMC	(N'000000')	No	VBUP	POSNR_VA	Allow NULL?
4	LFDNR	Counter used to differentiate between data base entries	nvarchar	4	0	NUMC	(N'0000')	No		J_ZAEHL	Allow NULL?
5	LWDG	Dangerous Goods Regulation	nvarchar	12	0	CHAR	(N' ')	Yes	THM063	THME_LWDG	Allow NULL?
6	MATNR	Material Number	nvarchar	18	0	CHAR	(N' ')	Yes	MARA	MATNR	Allow NULL?
7	MOT	Dangerous Goods - Mode-of-Transport Category	nvarchar	2	0	NUMC	(N'00')	Yes	THM151	THME_MOT	Allow NULL?
8	RVLID	Validity Area	nvarchar	10	0	CHAR	(N' ')	Yes	TCG91	ESERVLID	Allow NULL?
9	DGNHM	Non-Dangerous Goods Full Transport	char	1	0	CHAR	(N' ')	Yes	THM159	THME_NHM	Allow NULL?
10	DGCAO	Only Cargo Air Transport Permitted	char	1	0	CHAR	(N' ')	Yes		ADGE_DGCAO	Allow NULL?
11	TKUI	Identification Number Type	nvarchar	3	0	CHAR	(N' ')	Yes	TDG73	THME_TKUI	Allow NULL?
12	DGNU	Identification Number	nvarchar	4	0	CHAR	(N' ')	Yes		THME_DGNU	Allow NULL?
13	DGCL	Dangerous Goods Class	nvarchar	3	0	CHAR	(N' ')	Yes	THM009	THME_DGCL	Allow NULL?
14	DGSC	Dangerous Goods Subclass	nvarchar	6	0	CHAR	(N' ')	Yes		ADGE_DGSC	Allow NULL?
15	SDBC	Hazard Item Number	nvarchar	4	0	NUMC	(N'0000')	Yes		ADGE_SDBC	Allow NULL?
16	SLBE	Hazard Item Number (Empty Transport)	nvarchar	4	0	NUMC	(N'0000')	Yes		THME_SLBE	Allow NULL?
17	LDBC	Classification Code	nvarchar	5	0	CHAR	(N' ')	Yes	THM011	THME_LDBC	Allow NULL?
18	COTMP	Control Temperature	decimal	8	2	QUAN	((0))	Yes		ADGE_COTMP
19	TPCUN	Temperature Unit (Control)	nvarchar	3	0	UNIT	(N' ')	Yes	T006	ADGE_TPCUN	Allow NULL?
20	EMTMP	Emergency Temperature	decimal	8	2	QUAN	((0))	Yes		ADGE_EMTMP
21	TPEUN	Temperature Unit (Emergency)	nvarchar	3	0	UNIT	(N' ')	Yes	T006	ADGE_TPEUN	Allow NULL?
22	FLTMP	Flash Point	decimal	8	2	QUAN	((0))	Yes		ADGE_FLTMP
23	TPFUN	Temperature Unit (Flame)	nvarchar	3	0	UNIT	(N' ')	Yes	T006	ADGE_TPFUN	Allow NULL?
24	TPSNL	Temperature Sensitivity (Lower Limit)	decimal	8	2	QUAN	((0))	Yes		ADGE_TPSNL
25	TPSLU	Unit for temperature sensitivity (lower limit)	nvarchar	3	0	UNIT	(N' ')	Yes	T006	ADGE_TPSLU	Allow NULL?
26	TPSNH	Temperature sensitivity (upper limit)	decimal	8	2	QUAN	((0))	Yes		ADGE_TPSNH
27	TPSHU	Temperature Unit (Sensitivity - Upper Limit)	nvarchar	3	0	UNIT	(N' ')	Yes	T006	ADGE_TPSHU	Allow NULL?
28	COWE	Water Pollution Class	char	1	0	CHAR	(N' ')	Yes	TDG15	ADGE_COWE	Allow NULL?
29	VBFC	VbF Class	nvarchar	4	0	CHAR	(N' ')	Yes	TDG35	ADGE_VBFC	Allow NULL?
30	SDCL	Storage Hazard Class	nvarchar	4	0	CHAR	(N' ')	Yes	TDG37	ADGE_SDCL	Allow NULL?
31	EINU	Tremcard Number	nvarchar	7	0	CHAR	(N' ')	Yes		ADGE_EINU	Allow NULL?
32	EICN	Replacement Tremcard Number	nvarchar	7	0	CHAR	(N' ')	Yes		ADGE_EICN	Allow NULL?
33	EMSN1	EmS/ERG Number 1	nvarchar	7	0	CHAR	(N' ')	Yes		ADGE_EMSN1	Allow NULL?
34	EMSN2	EmS/ERG Number 2	nvarchar	7	0	CHAR	(N' ')	Yes		ADGE_EMSN2	Allow NULL?
35	MFAG1	MFAG Number 1	nvarchar	4	0	CHAR	(N' ')	Yes		ADGE_MFAG1	Allow NULL?
36	MFAG2	MFAG Number 2	nvarchar	4	0	CHAR	(N' ')	Yes		ADGE_MFAG2	Allow NULL?
37	MOS1	Dangerous Goods Transport Type	nvarchar	3	0	NUMC	(N'000')	Yes	THM003	THME_MOS	Allow NULL?
38	MOS2	Dangerous Goods Transport Type	nvarchar	3	0	NUMC	(N'000')	Yes	THM003	THME_MOS	Allow NULL?
39	MOS3	Dangerous Goods Transport Type	nvarchar	3	0	NUMC	(N'000')	Yes	THM003	THME_MOS	Allow NULL?
40	MOS4	Dangerous Goods Transport Type	nvarchar	3	0	NUMC	(N'000')	Yes	THM003	THME_MOS	Allow NULL?
41	MOS5	Dangerous Goods Transport Type	nvarchar	3	0	NUMC	(N'000')	Yes	THM003	THME_MOS	Allow NULL?
42	MOS6	Dangerous Goods Transport Type	nvarchar	3	0	NUMC	(N'000')	Yes	THM003	THME_MOS	Allow NULL?
43	MOS7	Dangerous Goods Transport Type	nvarchar	3	0	NUMC	(N'000')	Yes	THM003	THME_MOS	Allow NULL?
44	MOS8	Dangerous Goods Transport Type	nvarchar	3	0	NUMC	(N'000')	Yes	THM003	THME_MOS	Allow NULL?
45	MOS9	Dangerous Goods Transport Type	nvarchar	3	0	NUMC	(N'000')	Yes	THM003	THME_MOS	Allow NULL?
46	MOSA	Dangerous Goods Transport Type	nvarchar	3	0	NUMC	(N'000')	Yes	THM003	THME_MOS	Allow NULL?
47	HQTU	Maximum Quantity per Transport Unit	decimal	8	2	QUAN	((0))	Yes		ADGE_HQTU
48	HQTUN	Maximum Quantity Unit	nvarchar	3	0	UNIT	(N' ')	Yes	T006	ADGE_HQTUN	Allow NULL?
49	PIN	Packing Instruction Number	nvarchar	25	0	CHAR	(N' ')	Yes	THM075	THME_PIN	Allow NULL?
50	PGRO	Packing Group	nvarchar	3	0	CHAR	(N' ')	Yes		THME_PGRO	Allow NULL?
51	HNU	Hazard Identification Number	nvarchar	4	0	CHAR	(N' ')	Yes	THM031	THME_HNU	Allow NULL?
52	HPN1	Danger Label Number 1	nvarchar	10	0	CHAR	(N' ')	Yes	THM017	THME_HPN1	Allow NULL?
53	HPN2	Danger Label Number 2	nvarchar	10	0	CHAR	(N' ')	Yes	THM017	THME_HPN2	Allow NULL?
54	HPN3	Danger Label Number 3	nvarchar	10	0	CHAR	(N' ')	Yes	THM017	THME_HPN3	Allow NULL?
55	HPN4	Danger Label Number 4	nvarchar	10	0	CHAR	(N' ')	Yes	THM017	THME_HPN4	Allow NULL?
56	HPN5	Danger Label Number 5	nvarchar	10	0	CHAR	(N' ')	Yes	THM017	THME_HPN5	Allow NULL?
57	HPN6	Danger Label Number 6	nvarchar	10	0	CHAR	(N' ')	Yes	THM017	THME_HPN6	Allow NULL?
58	HPN7	Danger Label Number 7	nvarchar	10	0	CHAR	(N' ')	Yes	THM017	THME_HPN7	Allow NULL?
59	LAB1	Label Number 1	nvarchar	7	0	CHAR	(N' ')	Yes	TDG29	ADGE_LAB1	Allow NULL?
60	LAB2	Label Number 2	nvarchar	7	0	CHAR	(N' ')	Yes	TDG29	ADGE_LAB2	Allow NULL?
61	LAB3	Label Number 3	nvarchar	7	0	CHAR	(N' ')	Yes	TDG29	ADGE_LAB3	Allow NULL?
62	LAB4	Label Number 4	nvarchar	7	0	CHAR	(N' ')	Yes	TDG29	ADGE_LAB4	Allow NULL?
63	LAB5	Label Number 5	nvarchar	7	0	CHAR	(N' ')	Yes	TDG29	ADGE_LAB5	Allow NULL?
64	LAB6	Label Number 6	nvarchar	7	0	CHAR	(N' ')	Yes	TDG29	ADGE_LAB6	Allow NULL?
65	LAB7	Label Number 7	nvarchar	7	0	CHAR	(N' ')	Yes	TDG29	ADGE_LAB7	Allow NULL?
66	LAB8	Label Number 8	nvarchar	7	0	CHAR	(N' ')	Yes	TDG29	ADGE_LAB8	Allow NULL?
67	LAB9	Label Number 9	nvarchar	7	0	CHAR	(N' ')	Yes	TDG29	ADGE_LAB9	Allow NULL?
68	LAB10	Label Number 10	nvarchar	7	0	CHAR	(N' ')	Yes	TDG29	ADGE_LABA	Allow NULL?
69	PAI	Limited Quantity (LQ) Inner Packaging	decimal	8	2	QUAN	((0))	Yes		THME_PAI
70	PAIU	Unit of Meas. for Limited Quantity (LQ) Inner Packaging	nvarchar	3	0	UNIT	(N' ')	Yes	T006	THME_PAIU	Allow NULL?
71	PAO	Limited Quantity (LQ) Outer Packaging	decimal	8	2	QUAN	((0))	Yes		THME_PAO
72	PAOU	Unit of Meas. for Limited Quantity (LQ) Outer Packaging	nvarchar	3	0	UNIT	(N' ')	Yes	T006	THME_PAOU	Allow NULL?
73	RQA	Reportable Quantity	decimal	8	2	QUAN	((0))	Yes		ADGE_RQA
74	RQU	Unit of measure for reportable quantities	nvarchar	3	0	UNIT	(N' ')	Yes	T006	ADGE_RQU	Allow NULL?
75	PBI	Poisonous by Inhalation	char	1	0	CHAR	(N' ')	Yes		ADGE_PBI	Allow NULL?
76	MINQ	Minimum Quantity for Listed Goods	decimal	8	2	QUAN	((0))	Yes		ADGE_MINQ
77	MINU	Unit of Measurement Minimum Quantity (Listed Goods)	nvarchar	3	0	UNIT	(N' ')	Yes	T006	ADGE_MINU	Allow NULL?
78	MAXQ	Maximum Quantity for Listed Goods	decimal	8	2	QUAN	((0))	Yes		ADGE_MAXQ
79	MAXU	Unit of Measurement Maximum Quantity (Listed Goods)	nvarchar	3	0	UNIT	(N' ')	Yes	T006	ADGE_MAXU	Allow NULL?
80	RELQ	Exemption (ADR 1.1.3.6)	decimal	8	2	QUAN	((0))	Yes		THME_RELQ
81	RELU	Unit of Measure Quantity Limit	nvarchar	3	0	UNIT	(N' ')	Yes	T006	THME_RELU	Allow NULL?
82	MULRQ	Multiplication Factor Exemption (ADR 1.1.3.6)	nvarchar	4	0	NUMC	(N'0000')	Yes		THME_MULRQ	Allow NULL?
83	RCHEM	Notification Status (Law on Control of Toxic Substances)	char	1	0	CHAR	(N' ')	Yes		ADGE_RCHEM	Allow NULL?
84	DGPTA	Shipping by Mail Permitted	char	1	0	CHAR	(N' ')	Yes		ADGE_DGPTA	Allow NULL?
85	DGTNA	Transport Not Permitted	char	1	0	CHAR	(N' ')	Yes		ADGE_DGTNA	Allow NULL?
86	DGWOS	Processing Status for Basic Data and Master Data	nvarchar	2	0	CHAR	(N' ')	Yes	THM039	THME_WOS	Allow NULL?
87	NHME	Non-Dangerous Goods Empty Transport	char	1	0	CHAR	(N' ')	Yes	THM159	THME_NHME	Allow NULL?
88	DGSHE	Schedule of Class 7	nvarchar	4	0	CHAR	(N' ')	Yes		ADGE_DGSHE	Allow NULL?
89	PIMDG	Note on Regulation	nvarchar	10	0	CHAR	(N' ')	Yes		ADGE_PIMDG	Allow NULL?
90	SOOWA	Solubility of water	decimal	12	2	QUAN	((0))	Yes		ADGE_SOOWA
91	USOOW	Unit for solubility of water	nvarchar	3	0	UNIT	(N' ')	Yes	T006	ADGE_USOOW	Allow NULL?
92	DENFEE	Density I	decimal	11	2	QUAN	((0))	Yes		ADGE_DENFE
93	UDENFE	Unit for density I	nvarchar	3	0	UNIT	(N' ')	Yes	T006	ADGE_UDENF	Allow NULL?
94	DENTWE	Density II	decimal	11	2	QUAN	((0))	Yes		ADGE_DENTW
95	UDENTW	Unit for density II	nvarchar	3	0	UNIT	(N' ')	Yes	T006	ADGE_UDENT	Allow NULL?
96	DENFIF	Density III	decimal	11	2	QUAN	((0))	Yes		ADGE_DENFI
97	UDENFI	Unit for density III	nvarchar	3	0	UNIT	(N' ')	Yes	T006	ADGE_UDEFI	Allow NULL?
98	BUDEN	Bulk Density	decimal	11	2	QUAN	((0))	Yes		ADGE_BUDEN
99	UBUDE	Unit for Bulk Density	nvarchar	3	0	UNIT	(N' ')	Yes	T006	ADGE_UBUDE	Allow NULL?
100	BOPOI	Boiling Point	decimal	8	2	QUAN	((0))	Yes		ADGE_BOPOI
101	UBOPO	Unit for Boiling Point	nvarchar	3	0	UNIT	(N' ')	Yes	T006	ADGE_UBOPO	Allow NULL?
102	VISCO	Viscosity	decimal	9	2	QUAN	((0))	Yes		ADGE_VISCO
103	UVISC	Unit for Viscosity	nvarchar	3	0	UNIT	(N' ')	Yes	T006	ADGE_UVISC	Allow NULL?
104	STPRES	Vapor Pressure	decimal	10	2	QUAN	((0))	Yes		ADGE_STPRE
105	USTPRE	Unit for vapor pressure	nvarchar	3	0	UNIT	(N' ')	Yes	T006	ADGE_USTPR	Allow NULL?
106	MEPOI	Melting Point	decimal	8	2	QUAN	((0))	Yes		ADGE_MEPOI
107	UMEPO	Unit for Melting Point	nvarchar	3	0	UNIT	(N' ')	Yes	T006	ADGE_UMEPO	Allow NULL?
108	COOEX	Coefficient of Expansion	decimal	8	2	QUAN	((0))	Yes		ADGE_COOEX
109	UCOOE	Unit for Coefficient of Expansion	nvarchar	3	0	UNIT	(N' ')	Yes	T006	ADGE_UCOOE	Allow NULL?
110	MTMPF	Medium Temperature of Liquid During Filling	decimal	8	2	QUAN	((0))	Yes		ADGE_MTMPF
111	UMTMP	Unit for medium filling temperature	nvarchar	3	0	UNIT	(N' ')	Yes	T006	ADGE_UMTMP	Allow NULL?
112	STOPA	Packaging Mark	char	1	0	CHAR	(N' ')	Yes		THME_STOPA	Allow NULL?
113	SPPRO	Special Provision	nvarchar	5	0	CHAR	(N' ')	Yes		THME_SPPRO	Allow NULL?
114	MAPOL	Marine Pollutant	nvarchar	2	0	CHAR	(N' ')	Yes		ADGE_MAPOL	Allow NULL?
115	PINLQ	Packing Instruction Number for Limited Quantity (LQ)	nvarchar	25	0	CHAR	(N' ')	Yes	THM075	THME_PINLQ	Allow NULL?
116	PASI	Maximum Quantity per Package	decimal	8	2	QUAN	((0))	Yes		THME_PASI
117	UPASI	Unit of Measurement for Single Packaging	nvarchar	3	0	UNIT	(N' ')	Yes	T006	THME_UPASI	Allow NULL?
118	PAGW	Limited Quantity (LQ) Gross Weight	decimal	8	2	QUAN	((0))	Yes		THME_PAGW
119	UPAGW	Unit of Measurement for Limited Quantity (LQ) Gross	nvarchar	3	0	UNIT	(N' ')	Yes	T006	THME_UPAGW	Allow NULL?
120	EXCEP	Exception and Agreement Number	nvarchar	40	0	CHAR	(N' ')	Yes		ADGE_EXCEP	Allow NULL?
121	SCASE	Special Case (Packing Check)	char	1	0	CHAR	(N' ')	Yes		ADGE_SCASE	Allow NULL?
122	COLNO	Collective Number	char	1	0	CHAR	(N' ')	Yes		ADGE_COLNO	Allow NULL?
123	EIMDG	Regulation Edition	nvarchar	4	0	CHAR	(N' ')	Yes		ADGE_EIMDG	Allow NULL?
124	PDGNUD	Dangerous Goods Description	nvarchar	21	0	CHAR	(N' ')	Yes		ADGE_PDGND	Allow NULL?
125	PRES1	Hazard-Inducing Substance	nvarchar	21	0	CHAR	(N' ')	Yes		ADGE_PRES	Allow NULL?
126	PRES2	Hazard-Inducing Substance	nvarchar	21	0	CHAR	(N' ')	Yes		ADGE_PRES	Allow NULL?
127	PRES3	Hazard-Inducing Substance	nvarchar	21	0	CHAR	(N' ')	Yes		ADGE_PRES	Allow NULL?
128	PREMP1	Hazard-inducing substance (marine pollutant)	nvarchar	21	0	CHAR	(N' ')	Yes		ADGE_PRMP	Allow NULL?
129	PRERQ1	Hazard-inducing substance (reportable quantity)	nvarchar	21	0	CHAR	(N' ')	Yes		ADGE_PRRQ	Allow NULL?
130	PRERQ2	Hazard-inducing substance (reportable quantity)	nvarchar	21	0	CHAR	(N' ')	Yes		ADGE_PRRQ	Allow NULL?
131	PSTOSU	Aggregate State for Transport	nvarchar	21	0	CHAR	(N' ')	Yes		ADGE_PSTOS	Allow NULL?
132	PDAIN1	Hazard Note 1	nvarchar	21	0	CHAR	(N' ')	Yes		ADGE_PDAI1	Allow NULL?
133	PDAIN2	Hazard Note 2	nvarchar	21	0	CHAR	(N' ')	Yes		ADGE_PDAI2	Allow NULL?
134	PDAIN3	Hazard Note 3	nvarchar	21	0	CHAR	(N' ')	Yes		ADGE_PDAI3	Allow NULL?
135	PDAIN4	Hazard Note 4	nvarchar	21	0	CHAR	(N' ')	Yes		ADGE_PDAI4	Allow NULL?
136	PDAIN5	Hazard Note 5	nvarchar	21	0	CHAR	(N' ')	Yes		ADGE_PDAI5	Allow NULL?
137	PDAIN6	Hazard Note 6	nvarchar	21	0	CHAR	(N' ')	Yes		ADGE_PDAI6	Allow NULL?
138	PDAIN7	Hazard Note 7	nvarchar	21	0	CHAR	(N' ')	Yes		ADGE_PDAI7	Allow NULL?
139	PDAIN8	Hazard Note 8	nvarchar	21	0	CHAR	(N' ')	Yes		ADGE_PDAI8	Allow NULL?
140	PDAIN9	Hazard Note 9	nvarchar	21	0	CHAR	(N' ')	Yes		ADGE_PDAI9	Allow NULL?
141	PDAIN10	Hazard Note 10	nvarchar	21	0	CHAR	(N' ')	Yes		ADGE_PDAIA	Allow NULL?
142	MIOWA	Miscibility with Water	decimal	8	2	QUAN	((0))	Yes		ADGE_MIOWA
143	UMIOW	Unit for Miscibility with Water	nvarchar	3	0	UNIT	(N' ')	Yes	T006	ADGE_UMIOW	Allow NULL?
144	PHYGRO	Hygroscopicity	nvarchar	21	0	CHAR	(N' ')	Yes		ADGE_PHYGR	Allow NULL?
145	PDGF1	User-Defined Text Key 1	nvarchar	21	0	CHAR	(N' ')	Yes		ADGE_PDGF1	Allow NULL?
146	PDGF2	User-Defined Text Key 2	nvarchar	21	0	CHAR	(N' ')	Yes		ADGE_PDGF2	Allow NULL?
147	PDGF3	User-Defined Text Key 3	nvarchar	21	0	CHAR	(N' ')	Yes		ADGE_PDGF3	Allow NULL?
148	PDGF4	User-Defined Text Key 4	nvarchar	21	0	CHAR	(N' ')	Yes		ADGE_PDGF4	Allow NULL?
149	PDGF5	User-Defined Text Key 5	nvarchar	21	0	CHAR	(N' ')	Yes		ADGE_PDGF5	Allow NULL?
150	PDGF6	User-Defined Text Key 6	nvarchar	21	0	CHAR	(N' ')	Yes		ADGE_PDGF6	Allow NULL?
151	PDGF7	User-Defined Text Key 7	nvarchar	21	0	CHAR	(N' ')	Yes		ADGE_PDGF7	Allow NULL?
152	PDGF8	User-Defined Text Key 8	nvarchar	21	0	CHAR	(N' ')	Yes		ADGE_PDGF8	Allow NULL?
153	PDGF9	User-Defined Text Key 9	nvarchar	21	0	CHAR	(N' ')	Yes		ADGE_PDGF9	Allow NULL?
154	PDGFA	User-Defined Text Key 10	nvarchar	21	0	CHAR	(N' ')	Yes		ADGE_PDGFA	Allow NULL?
155	PDGFB	User-Defined Text Key 11	nvarchar	21	0	CHAR	(N' ')	Yes		ADGE_PDGFB	Allow NULL?
156	PDGFC	User-Defined Text Key 12	nvarchar	21	0	CHAR	(N' ')	Yes		ADGE_PDGFC	Allow NULL?
157	PDGFD	User-Defined Text Key 13	nvarchar	21	0	CHAR	(N' ')	Yes		ADGE_PDGFD	Allow NULL?
158	PDGFE	User-Defined Text Key 14	nvarchar	21	0	CHAR	(N' ')	Yes		ADGE_PDGFE	Allow NULL?
159	PDGFF	User-Defined Text Key 15	nvarchar	21	0	CHAR	(N' ')	Yes		ADGE_PDGFF	Allow NULL?
160	PTXTPATT	Dangerous Goods Text Pattern	nvarchar	21	0	CHAR	(N' ')	Yes		ADGE_PTXTPATT	Allow NULL?
161	MSEPR1	Segregation Key 1	nvarchar	4	0	CHAR	(N' ')	Yes	THM091	THME_DYKY1	Allow NULL?
162	MSEPR2	Segregation Key 2	nvarchar	4	0	CHAR	(N' ')	Yes	THM091	THME_DYKY2	Allow NULL?
163	MSEPR3	Segregation Key 3	nvarchar	4	0	CHAR	(N' ')	Yes	THM091	THME_DYKY3	Allow NULL?
164	MSEPR4	Segregation Key 4	nvarchar	4	0	CHAR	(N' ')	Yes	THM091	THME_DYKY4	Allow NULL?
165	MSEPR5	Segregation Key 5	nvarchar	4	0	CHAR	(N' ')	Yes	THM091	THME_DYKY5	Allow NULL?
166	MSEPR6	Segregation Key 6	nvarchar	4	0	CHAR	(N' ')	Yes	THM091	THME_DYKY6	Allow NULL?
167	MSEPR7	Segregation Key 7	nvarchar	4	0	CHAR	(N' ')	Yes	THM091	THME_DYKY7	Allow NULL?
168	MSEPR8	Segregation Key 8	nvarchar	4	0	CHAR	(N' ')	Yes	THM091	THME_DYKY8	Allow NULL?
169	MSEPR9	Segregation Key 9	nvarchar	4	0	CHAR	(N' ')	Yes	THM091	THME_DYKY9	Allow NULL?
170	MSEPRA	Segregation Key 10	nvarchar	4	0	CHAR	(N' ')	Yes	THM091	THME_DYKYA	Allow NULL?
171	MSEPRB	Segregation Key 11	nvarchar	4	0	CHAR	(N' ')	Yes	THM091	THME_DYKYB	Allow NULL?
172	MSEPRC	Segregation Key 12	nvarchar	4	0	CHAR	(N' ')	Yes	THM091	THME_DYKYC	Allow NULL?
173	MSEPRD	Segregation Key 13	nvarchar	4	0	CHAR	(N' ')	Yes	THM091	THME_DYKYD1	Allow NULL?
174	MSEPRE	Segregation Key 14	nvarchar	4	0	CHAR	(N' ')	Yes	THM091	THME_DYKYE	Allow NULL?
175	MSEPRF	Segregation Key 15	nvarchar	4	0	CHAR	(N' ')	Yes	THM091	THME_DYKYF	Allow NULL?
176	MSEPRG	Segregation Key 16	nvarchar	4	0	CHAR	(N' ')	Yes	THM091	THME_DYKYG	Allow NULL?
177	MSEPRH	Segregation Key 17	nvarchar	4	0	CHAR	(N' ')	Yes	THM091	THME_DYKYH	Allow NULL?
178	MLOAR1	Mixed Loading Rule 1	nvarchar	6	0	CHAR	(N' ')	Yes	THM097	THME_MLOAR1	Allow NULL?
179	MLOAR2	Mixed Loading Rule 2	nvarchar	6	0	CHAR	(N' ')	Yes	THM097	THME_MLOAR2	Allow NULL?
180	MLOAR3	Mixed Loading Rule 3	nvarchar	6	0	CHAR	(N' ')	Yes	THM097	THME_MLOAR3	Allow NULL?
181	MLOAR4	Mixed Loading Rule 4	nvarchar	6	0	CHAR	(N' ')	Yes	THM097	THME_MLOAR4	Allow NULL?
182	MLOAR5	Mixed Loading Rule 5	nvarchar	6	0	CHAR	(N' ')	Yes	THM097	THME_MLOAR5	Allow NULL?
183	MLOAR6	Mixed Loading Rule 6	nvarchar	6	0	CHAR	(N' ')	Yes	THM097	THME_MLOAR6	Allow NULL?
184	MLOAR7	Mixed Loading Rule 7	nvarchar	6	0	CHAR	(N' ')	Yes	THM097	THME_MLOAR7	Allow NULL?
185	MLOAR8	Mixed Loading Rule 8	nvarchar	6	0	CHAR	(N' ')	Yes	THM097	THME_MLOAR8	Allow NULL?
186	MLOAR9	Mixed Loading Rule 9	nvarchar	6	0	CHAR	(N' ')	Yes	THM097	THME_MLOAR9	Allow NULL?
187	MLOARA	Mixed Loading Rule 10	nvarchar	6	0	CHAR	(N' ')	Yes	THM097	THME_MLOARA	Allow NULL?
188	RSMLG1	Regulation-Dependent Mixed Loading Group 1	nvarchar	4	0	CHAR	(N' ')	Yes	THM101	THME_RSMLG1	Allow NULL?
189	RSMLG2	Regulation-Dependent Mixed Loading Group 2	nvarchar	4	0	CHAR	(N' ')	Yes	THM101	THME_RSMLG2	Allow NULL?
190	RSMLG3	Regulation-Dependent Mixed Loading Group 3	nvarchar	4	0	CHAR	(N' ')	Yes	THM101	THME_RSMLG3	Allow NULL?
191	ESMLG1	Enterprise-Specific Mixed Loading Group 1	nvarchar	4	0	CHAR	(N' ')	Yes	THM103	THME_ESMLG1	Allow NULL?
192	ESMLG2	Enterprise-Specific Mixed Loading Group 2	nvarchar	4	0	CHAR	(N' ')	Yes	THM103	THME_ESMLG2	Allow NULL?
193	ESMLG3	Enterprise-Specific Mixed Loading Group 3	nvarchar	4	0	CHAR	(N' ')	Yes	THM103	THME_ESMLG3	Allow NULL?
194	PREMP2	Hazard-inducing substance (marine pollutant)	nvarchar	21	0	CHAR	(N' ')	Yes		ADGE_PRMP	Allow NULL?
195	RQA2	Reportable Quantity	decimal	8	2	QUAN	((0))	Yes		ADGE_RQA
196	RQU2	Unit of measure for reportable quantities	nvarchar	3	0	UNIT	(N' ')	Yes	T006	ADGE_RQU	Allow NULL?
197	PPDG1	Profile for Dangerous Goods User-Defined Text 1	nvarchar	2	0	CHAR	(N' ')	Yes	THM157	THME_PPDG1	Allow NULL?
198	PPDG2	Profile for Dangerous Goods User-Defined Text 2	nvarchar	2	0	CHAR	(N' ')	Yes	THM157	THME_PPDG2	Allow NULL?
199	PPDG3	Profile for Dangerous Goods User-Defined Text 3	nvarchar	2	0	CHAR	(N' ')	Yes	THM157	THME_PPDG3	Allow NULL?
200	PPDG4	Profile for Dangerous Goods User-Defined Text 4	nvarchar	2	0	CHAR	(N' ')	Yes	THM157	THME_PPDG4	Allow NULL?
201	PPDG5	Profile for Dangerous Goods User-Defined Text 5	nvarchar	2	0	CHAR	(N' ')	Yes	THM157	THME_PPDG5	Allow NULL?
202	PPDG6	Profile for Dangerous Goods User-Defined Text 6	nvarchar	2	0	CHAR	(N' ')	Yes	THM157	THME_PPDG6	Allow NULL?
203	PPDG7	Profile for Dangerous Goods User-Defined Text 7	nvarchar	2	0	CHAR	(N' ')	Yes	THM157	THME_PPDG7	Allow NULL?
204	PPDG8	Profile for Dangerous Goods User-Defined Text 8	nvarchar	2	0	CHAR	(N' ')	Yes	THM157	THME_PPDG8	Allow NULL?
205	PPDG9	Profile for Dangerous Goods User-Defined Text 9	nvarchar	2	0	CHAR	(N' ')	Yes	THM157	THME_PPDG9	Allow NULL?
206	PPDGA	Profile for Dangerous Goods User-Defined Text 10	nvarchar	2	0	CHAR	(N' ')	Yes	THM157	THME_PPDGA	Allow NULL?
207	PPDGB	Profile for Dangerous Goods User-Defined Text 11	nvarchar	2	0	CHAR	(N' ')	Yes	THM157	THME_PPDGB	Allow NULL?
208	PPDGC	Profile for Dangerous Goods User-Defined Text 12	nvarchar	2	0	CHAR	(N' ')	Yes	THM157	THME_PPDGC	Allow NULL?
209	PPDGE	Profile for Dangerous Goods User-Defined Text 13	nvarchar	2	0	CHAR	(N' ')	Yes	THM157	THME_PPDGE	Allow NULL?
210	PPDGF	Profile for Dangerous Goods User-Defined Text 14	nvarchar	2	0	CHAR	(N' ')	Yes	THM157	THME_PPDGF	Allow NULL?
211	PPDGG	Profile for Dangerous Goods User-Defined Text 15	nvarchar	2	0	CHAR	(N' ')	Yes	THM157	THME_PPDGG	Allow NULL?
212	DAOR	Data Origin (Filling and Distribution)	char	1	0	CHAR	(N' ')	Yes		ADGE_DAOR	Allow NULL?
213	FORM_PHYS_CHEM	Physical and Chemical Form	nvarchar	21	0	CHAR	(N' ')	Yes		EHS_ADGE_FORM_PHYS_CHEM	Allow NULL?
214	EXPL_NET	Net Explosive Substance Mass	decimal	9	3	QUAN	((0))	Yes		EHS_ADGE_EXPL_NET
215	EXPL_NET_U	Unit for Net Explosive Substance Mass	nvarchar	3	0	UNIT	(N' ')	Yes	T006	EHS_ADGE_EXPL_NET_U	Allow NULL?
216	EXPL_REL_PERCENT	Relative Net Explosive Substance Percentage	decimal	6	3	DEC	((0))	Yes		EHS_ADGE_EXPL_REL_PERCENT
217	ACTVTY_MAX	Maximum Activity	decimal	8	2	QUAN	((0))	Yes		EHS_ADGE_ACTVTY_MAX
218	ACTVTY_MAX_U	Unit of Maximum Activity	nvarchar	3	0	UNIT	(N' ')	Yes	T006	EHS_ADGE_ACTVTY_MAX_U	Allow NULL?
219	ACTVTY_MAX_REL	Relative Maximum Activity	decimal	8	2	QUAN	((0))	Yes		EHS_ADGE_ACTVTY_MAX_REL
220	ACTVTY_MAX_REL_U	Unit of Relative Maximum Activity	nvarchar	3	0	UNIT	(N' ')	Yes	T006	EHS_ADGE_ACTVTY_MAX_REL_U	Allow NULL?
221	LTSK	Air Transport Safety Code	char	1	0	CHAR	(N' ')	Yes		EHS_ADGE_LTSK	Allow NULL?
222	EMV	Electromagnetic Compatibility	char	1	0	CHAR	(N' ')	Yes		EHS_ADGE_EMV	Allow NULL?
223	FSAK	Parachute Drop Code	char	1	0	CHAR	(N' ')	Yes		EHS_ADGE_FSAK	Allow NULL?
224	SFK	Thrust Code	char	1	0	CHAR	(N' ')	Yes		EHS_ADGE_SFK	Allow NULL?
225	MUNAKODE	Ammunition Code	nvarchar	4	0	CHAR	(N' ')	Yes		EHS_ADGE_MUNAKODE	Allow NULL?
226	EXNUMBER	EX-Number	nvarchar	12	0	CHAR	(N' ')	Yes		EHS_ADGE_EXNUMBER	Allow NULL?
227	CERTIFIC	Identification Mark for Approval Certificate	nvarchar	21	0	CHAR	(N' ')	Yes		EHS_ADGE_APPROV_CERTIFIC	Allow NULL?
228	HAZCHEM_CODE	Code for Chemical Hazard	nvarchar	10	0	CHAR	(N' ')	Yes		CBDUE_HAZCHEM_CODE	Allow NULL?
229	FLG_EMSN1_U	EmS Number 1 Underlined	char	1	0	CHAR	(N' ')	Yes		CBDUE_FLG_EMSN1_U	Allow NULL?
230	FLG_EMSN2_U	EmS Number 2 Underlined	char	1	0	CHAR	(N' ')	Yes		CBDUE_FLG_EMSN2_U	Allow NULL?
231	STOWAGE	Stowage Category	nvarchar	3	0	CHAR	(N' ')	Yes	CCUNC111	CBDUE_STOWAGE	Allow NULL?
232	CARR_TYPE	Transport Category	nvarchar	3	0	CHAR	(N' ')	Yes		CBDUE_CARR_TYPE	Allow NULL?
233	FLG_PAI	Value Entered for Limited Quantity (LQ) Inner Packaging	char	1	0	CHAR	(N' ')	Yes		CBDUE_FLG_PAI	Allow NULL?
234	FLG_PAO	Value Entered for Limited Quantity (LQ) Outer Packaging	char	1	0	CHAR	(N' ')	Yes		CBDUE_FLG_PAO	Allow NULL?
235	FLG_PASI	Value Entered for Maximum Quantity per Package	char	1	0	CHAR	(N' ')	Yes		CBDUE_FLG_PASI	Allow NULL?
236	FLG_PAGW	Value Entered for Limited Quantity (LQ) Gross Weight	char	1	0	CHAR	(N' ')	Yes		CBDUE_FLG_PAGW	Allow NULL?
237	FLG_RELQ	Value Entered for Exemption	char	1	0	CHAR	(N' ')	Yes		CBDUE_FLG_RELQ	Allow NULL?
238	FLG_MULRQ	Value Entered for Multiplication Factor	char	1	0	CHAR	(N' ')	Yes		CBDUE_FLG_MULRQ	Allow NULL?
239	FLG_RELQ_UNLIMIT	Unlimited Set for Exemption	char	1	0	CHAR	(N' ')	Yes		CBDUE_FLG_RELQ_UNLIMIT	Allow NULL?
240	FLG_MULRQ_FORBID	Prohibited Set for Multiplication Factor	char	1	0	CHAR	(N' ')	Yes		CBDUE_FLG_MULRQ_FORBID	Allow NULL?
241	PDGNUDPRE	Dangerous Goods Description Prefix	nvarchar	21	0	CHAR	(N' ')	Yes		CBDUE_PDGNUDPRE	Allow NULL?
242	PDGNUDSUF	Dangerous Goods Description Suffix	nvarchar	21	0	CHAR	(N' ')	Yes		CBDUE_PDGNUDSUF	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