	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

170 COLUMNS | 1 INDEXES | ERP 6.0 | DGMS2 TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Environment, Health and Safety
1	ERP EHP7	6.0	DGMS2	170	1	DG: Dangerous Goods Document Table (Appendix Table)	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, TRANSP_TYPE, TRANSP_APPROVED, LEG_SRC_RESTR, RESTR_PHRKEY, MIN_QUANT, U_MIN_QUANT, FLG_MIN_QUANT, MAX_QUANT, U_MAX_QUANT, FLG_MAX_QUANT, SPPROV_PHRKEY, SP_PRINT_PHRKEY, MIX_PACK_PHRKEY, SEGREGAT_PHRKEY, PACKAGES_PHRKEY, BULK_PHRKEY, HANDLING_PHRKEY, OPERATION_PHRKEY, VEHICLE_PHRKEY, SP_PRINT_PHRKEY1, SP_PRINT_PHRKEY2, SP_PRINT_PHRKEY3, PRIO_ALTERN, FLG_RELEASED, FLG_TRANS_PERM, FLG_NO_DG, FLG_LQ, FLG_RQ, INSTR_ENCL, FLG_SINGLE_PACK, PACOD, QUANT_OUT_PACK, U_QUANT_OUT_PACK, PACK_NOTE, RECN_SUB, RECN_CLASS, FLG_CC, FLG_PACKED, TRANSPORT_TYPE, APPROVAL_CODE, MAT_DAMAGED_CL7, MAX_GROSS_WEIGHT, U_MAX_GROSS_WGHT, SUBID_DG_CLASS, EMV_DYN, LTSK_DYN, EXPL_NET_DYN, EXPL_NET_DYN_U, MAX_ACT_SGL, MAX_ACT_SGL_U, ACT_SGL_UNLIMIT, MAX_ACT_PACK, MAX_ACT_PACK_U, ACT_PACK_UNLIMIT, EXCEPT_PACK_OPT, DG_USE_CASE, PRIO_DYNCL, MAX_NEM, MAX_NEM_U, DUMMY_RCBDUDGREL, FLG_EQ, DGREL_TRANSIND01, DGREL_TRANSIND02, DGREL_TRANSIND03, DGREL_TRANSIND04, DGREL_TRANSIND05, DGREL_TRANSIND06, DGREL_TRANSIND07, DGREL_TRANSIND08, PACKAGE_MATNR, MATNR_REPLACE, TEXTPATT_PROF01, TEXTPATT01, TEXTPATT_PROF02, TEXTPATT02, TEXTPATT_PROF03, TEXTPATT03, TEXTPATT_PROF04, TEXTPATT04, TEXTPATT_PROF05, TEXTPATT05, TEXTPATT_PROF06, TEXTPATT06, TEXTPATT_PROF07, TEXTPATT07, TEXTPATT_PROF08, TEXTPATT08, TEXTPATT_PROF09, TEXTPATT09, TEXTPATT_PROF10, TEXTPATT10, TEXTPATT_PROF11, TEXTPATT11, TEXTPATT_PROF12, TEXTPATT12, TEXTPATT_PROF13, TEXTPATT13, TEXTPATT_PROF14, TEXTPATT14, TEXTPATT_PROF15, TEXTPATT15, ABS_ACT, ABS_ACT_U, REL_SPEC_ACT, REL_SPEC_ACT_U, CONTAMINATION, CONTAMINATION_U, DOSE_RATE, DOSE_RATE_U, MAX_ACT1, MAX_ACT1_U, ACT1_UNLIMIT, MAX_ACT2, MAX_ACT2_U, ACT2_UNLIMIT, ACT_SUB_PACK, ACT_SUB_PACK_U, MAX_ACT_CONSG, MAX_ACT_CONSG_U, MULT_ACT_SGL, REF_ACT_SGL, MULT_ACT_PACK, REF_ACT_PACK, MAX_CONT_A, MAX_CONT_A_U, MAX_CONT_B_G, MAX_CONT_B_G_U, MAX_DOSE_UNP, MAX_DOSE_UNP_U, DIST_DOSE_UNP, DIST_DOSE_UNP_U, NO_DIST_UNP, MAX_DOSE_PACK, MAX_DOSE_PACK_U, DIST_DOSE_PACK, DIST_DOSE_PACK_U, NO_DIST_PACK, MAX_ACT_SGL_DC, MAX_ACT_SGL_U_DC, ACT_SGL_UNLIM_DC, MAX_ACT_PAC_DC, MAX_ACT_PAC_U_DC, ACT_PAC_UNLIM_DC, EXCPT_PAC_OPT_DC, MAX_GRS_WGHT_DC, U_MAX_GRS_WGT_DC, EXCEPTID01, EXCEPTID02, EXCEPTID03, EXCEPTID04, EXCEPTID05, EXCEPTID06, EXCEPTID07, EXCEPTID08, EXCEPTID09, EXCEPTID10, ACT_EMIS_TYPE, MAX_NEM_DC, MAX_NEM_U_DC, PINEQ, EXC_QUANT_IP, EXC_QUANT_IP_U, EXC_QUANT_OP, EXC_QUANT_OP_U, FLG_EXC_QUANT_IP, FLG_EXC_QUANT_OP FROM DGMS2

TOP ERP 6.0 | DGMS2 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	TRANSP_TYPE	Dangerous Goods Transport Type	nvarchar	3	0	NUMC	(N'000')	Yes	THM003	THME_MOS	Allow NULL?
6	TRANSP_APPROVED	Transport Permitted	char	1	0	CHAR	(N' ')	Yes		CBDUE_FLG_TRANSP_APPR	Allow NULL?
7	LEG_SRC_RESTR	Regulatory Basis for Transport Restrictions	nvarchar	25	0	CHAR	(N' ')	Yes	CCUNC117	CBDUE_LEG_SRC_RESTR	Allow NULL?
8	RESTR_PHRKEY	Phrase Key for Transport Restriction	nvarchar	21	0	CHAR	(N' ')	Yes		CBDUE_RESTR_PHRKEY	Allow NULL?
9	MIN_QUANT	Minimum Quantity for Restriction	decimal	8	2	QUAN	((0))	Yes		CBDUE_MIN_QUANT
10	U_MIN_QUANT	Unit of Measurement for Minimum Quantity	nvarchar	3	0	UNIT	(N' ')	Yes	*	CBDUE_U_MIN_QUANT	Allow NULL?
11	FLG_MIN_QUANT	Value Entered for Minimum Quantity for Restriction	char	1	0	CHAR	(N' ')	Yes		CBDUE_FLG_MIN_QUANT	Allow NULL?
12	MAX_QUANT	Maximum Quantity for Exemption	decimal	8	2	QUAN	((0))	Yes		CBDUE_MAX_QUANT
13	U_MAX_QUANT	Unit of Measurement for Maximum Quantity	nvarchar	3	0	UNIT	(N' ')	Yes	*	CBDUE_U_MAX_QUANT	Allow NULL?
14	FLG_MAX_QUANT	Value Entered for Maximum Quantity for Restriction	char	1	0	CHAR	(N' ')	Yes		CBDUE_FLG_MAX_QUANT	Allow NULL?
15	SPPROV_PHRKEY	Phrase Key for Special Provision	nvarchar	21	0	CHAR	(N' ')	Yes		CBDUE_SP_PHRKEY	Allow NULL?
16	SP_PRINT_PHRKEY	Phrase Key for Special Provision Print Text	nvarchar	21	0	CHAR	(N' ')	Yes		CBDUE_SP_PRINT_PHRKEY	Allow NULL?
17	MIX_PACK_PHRKEY	Phrase Key for Mixed Packing	nvarchar	21	0	CHAR	(N' ')	Yes		CBDUE_MIX_PACK_PHRKEY	Allow NULL?
18	SEGREGAT_PHRKEY	Phrase Key for Segregation Regulation	nvarchar	21	0	CHAR	(N' ')	Yes		CBDUE_SEGREGAT_PHRKEY	Allow NULL?
19	PACKAGES_PHRKEY	Phrase Key for Packages	nvarchar	21	0	CHAR	(N' ')	Yes		CBDUE_PACKAGES_PHRKEY	Allow NULL?
20	BULK_PHRKEY	Phrase Key for Bulk	nvarchar	21	0	CHAR	(N' ')	Yes		CBDUE_BULK_PHRKEY	Allow NULL?
21	HANDLING_PHRKEY	Phrase Key for Handling	nvarchar	21	0	CHAR	(N' ')	Yes		CBDUE_HANDLING_PHRKEY	Allow NULL?
22	OPERATION_PHRKEY	Phrase Key for Operation	nvarchar	21	0	CHAR	(N' ')	Yes		CBDUE_OPERATION_PHRKEY	Allow NULL?
23	VEHICLE_PHRKEY	Phrase Key for Vehicle	nvarchar	21	0	CHAR	(N' ')	Yes		CBDUE_VEHICLE_PHRKEY	Allow NULL?
24	SP_PRINT_PHRKEY1	Phrase Key for Special Provision Print Text	nvarchar	21	0	CHAR	(N' ')	Yes		CBDUE_SP_PRINT_PHRKEY	Allow NULL?
25	SP_PRINT_PHRKEY2	Phrase Key for Special Provision Print Text	nvarchar	21	0	CHAR	(N' ')	Yes		CBDUE_SP_PRINT_PHRKEY	Allow NULL?
26	SP_PRINT_PHRKEY3	Phrase Key for Special Provision Print Text	nvarchar	21	0	CHAR	(N' ')	Yes		CBDUE_SP_PRINT_PHRKEY	Allow NULL?
27	PRIO_ALTERN	Priority of Release	nvarchar	2	0	NUMC	(N'00')	Yes		CBDUE_PRIO_ALTERN	Allow NULL?
28	FLG_RELEASED	Product Released for Regulation	char	1	0	CHAR	(N' ')	Yes		CBDUE_FLG_RELEASED	Allow NULL?
29	FLG_TRANS_PERM	Transport Not Permitted	char	1	0	CHAR	(N' ')	Yes		CBDUE_FLG_TRANS_PERM	Allow NULL?
30	FLG_NO_DG	Not Dangerous Goods	char	1	0	CHAR	(N' ')	Yes		CBDUE_FLG_NO_DG	Allow NULL?
31	FLG_LQ	Limited Quantity	char	1	0	CHAR	(N' ')	Yes		CBDUE_FLG_LQ	Allow NULL?
32	FLG_RQ	Reportable Quantity	char	1	0	CHAR	(N' ')	Yes		CBDUE_FLG_RQ	Allow NULL?
33	INSTR_ENCL	Actual Instruction for Enclosure	nvarchar	10	0	CHAR	(N' ')	Yes	CCUNC115	CBDUE_INSTR_ENCL	Allow NULL?
34	FLG_SINGLE_PACK	Single Packaging	char	1	0	CHAR	(N' ')	Yes		CBDUE_FLG_SGL_PACK	Allow NULL?
35	PACOD	Actual Packaging Code	nvarchar	10	0	CHAR	(N' ')	Yes	CCUNC121	CBDUE_PACOD	Allow NULL?
36	QUANT_OUT_PACK	Quantity Single/Outer Packaging	decimal	8	2	QUAN	((0))	Yes		CBDUE_QUANT_OUT
37	U_QUANT_OUT_PACK	Unit of Measurement for Quantity Outer Packaging	nvarchar	3	0	UNIT	(N' ')	Yes	T006	CBDUE_U_QUANT_OUT	Allow NULL?
38	PACK_NOTE	Note for Release	nvarchar	21	0	CHAR	(N' ')	Yes		CBDUE_PACK_NOTE	Allow NULL?
39	RECN_SUB	Sequential Number of Data Record	nvarchar	20	0	NUMC	(N'00000000000000000000')	Yes		ESERECN	Allow NULL?
40	RECN_CLASS	Sequential Number of Data Record	nvarchar	20	0	NUMC	(N'00000000000000000000')	Yes		ESERECN	Allow NULL?
41	FLG_CC	Consumer Commodity	char	1	0	CHAR	(N' ')	Yes		CBDUE_FLG_CC	Allow NULL?
42	FLG_PACKED	Packed Goods	char	1	0	CHAR	(N' ')	Yes		CBDUE_FLG_PACKED	Allow NULL?
43	TRANSPORT_TYPE	Actual Transport Type	nvarchar	3	0	NUMC	(N'000')	Yes	THM003	CBDUE_TRANSP_TYPE	Allow NULL?
44	APPROVAL_CODE	Full UN Packaging Code	nvarchar	72	0	CHAR	(N' ')	Yes		CBDUE_APPROVAL_CODE	Allow NULL?
45	MAT_DAMAGED_CL7	Damaged Material (Class 7)	char	1	0	CHAR	(N' ')	Yes		ADGE_MAT_DAMAGED_CL7	Allow NULL?
46	MAX_GROSS_WEIGHT	Maximum Gross Mass	decimal	8	2	QUAN	((0))	Yes		ADGE_MAX_GROSS_WEIGHT
47	U_MAX_GROSS_WGHT	Unit for Maximum Gross Mass	nvarchar	3	0	UNIT	(N' ')	Yes	*	ADGE_U_MAX_GROSS_WGHT	Allow NULL?
48	SUBID_DG_CLASS	Key (ID) of Dangerous Goods Classification	nvarchar	12	0	CHAR	(N' ')	Yes		ADGE_SUBID_CLASS	Allow NULL?
49	EMV_DYN	Electromagnetic Compatibility	char	1	0	CHAR	(N' ')	Yes		ADGE_EMV_DYN	Allow NULL?
50	LTSK_DYN	Air Transport Safety Code	char	1	0	CHAR	(N' ')	Yes		ADGE_LTSK_DYN	Allow NULL?
51	EXPL_NET_DYN	Net Explosive Substance Mass	decimal	9	3	QUAN	((0))	Yes		ADGE_EXPL_NET_DYN
52	EXPL_NET_DYN_U	Unit for Net Explosive Substance Mass	nvarchar	3	0	UNIT	(N' ')	Yes	*	EHS_ADGE_EXPL_NET_U	Allow NULL?
53	MAX_ACT_SGL	Maximum Activity: Item	decimal	11	4	QUAN	((0))	Yes		ADGE_MAX_ACT_SGL_DYN
54	MAX_ACT_SGL_U	Maximum Activity Unit: Item	nvarchar	3	0	UNIT	(N' ')	Yes	*	ADGE_MAX_ACT_SGL_DYN_U	Allow NULL?
55	ACT_SGL_UNLIMIT	Maximum Activity of Item Unlimited	char	1	0	CHAR	(N' ')	Yes		ADGE_ACT_SGL_DYN_UNLIMIT	Allow NULL?
56	MAX_ACT_PACK	Maximum Activity: Package	decimal	11	4	QUAN	((0))	Yes		ADGE_MAX_ACT_PACK_DYN
57	MAX_ACT_PACK_U	Maximum Activity Unit: Package	nvarchar	3	0	UNIT	(N' ')	Yes	*	ADGE_MAX_ACT_PACK_DYN_U	Allow NULL?
58	ACT_PACK_UNLIMIT	Maximum Activity of Package Unlimited	char	1	0	CHAR	(N' ')	Yes		ADGE_ACT_PACK_DYN_UNLIMIT	Allow NULL?
59	EXCEPT_PACK_OPT	Excepted Package: Optional	char	1	0	CHAR	(N' ')	Yes		ADGE_EXCEPT_PACK_OPT	Allow NULL?
60	DG_USE_CASE	Dangerous Goods: Use Case	char	1	0	CHAR	(N' ')	Yes		ADGE_DG_USE_CASE	Allow NULL?
61	PRIO_DYNCL	Priority of Dynamic Classification	nvarchar	2	0	NUMC	(N'00')	Yes		ADGE_PRIO_DYNCL	Allow NULL?
62	MAX_NEM	Maximum Net Explosive Substance Mass	decimal	9	3	QUAN	((0))	Yes		ADGE_MAX_NEM_DYN
63	MAX_NEM_U	Unit of Maximum Net Explosive Substance Mass	nvarchar	3	0	UNIT	(N' ')	Yes	*	ADGE_MAX_NEM_DYN_U	Allow NULL?
64	DUMMY_RCBDUDGREL		char	1	0		(N' ')	Yes			Allow NULL?
65	FLG_EQ	Excepted Quantity	char	1	0	CHAR	(N' ')	Yes		ADGE_EXC_QUANT	Allow NULL?
66	DGREL_TRANSIND01	Indicator for Transport	nvarchar	10	0	CHAR	(N' ')	Yes		ADGE_TRANSPORT_INDICATOR	Allow NULL?
67	DGREL_TRANSIND02	Indicator for Transport	nvarchar	10	0	CHAR	(N' ')	Yes		ADGE_TRANSPORT_INDICATOR	Allow NULL?
68	DGREL_TRANSIND03	Indicator for Transport	nvarchar	10	0	CHAR	(N' ')	Yes		ADGE_TRANSPORT_INDICATOR	Allow NULL?
69	DGREL_TRANSIND04	Indicator for Transport	nvarchar	10	0	CHAR	(N' ')	Yes		ADGE_TRANSPORT_INDICATOR	Allow NULL?
70	DGREL_TRANSIND05	Indicator for Transport	nvarchar	10	0	CHAR	(N' ')	Yes		ADGE_TRANSPORT_INDICATOR	Allow NULL?
71	DGREL_TRANSIND06	Indicator for Transport	nvarchar	10	0	CHAR	(N' ')	Yes		ADGE_TRANSPORT_INDICATOR	Allow NULL?
72	DGREL_TRANSIND07	Indicator for Transport	nvarchar	10	0	CHAR	(N' ')	Yes		ADGE_TRANSPORT_INDICATOR	Allow NULL?
73	DGREL_TRANSIND08	Indicator for Transport	nvarchar	10	0	CHAR	(N' ')	Yes		ADGE_TRANSPORT_INDICATOR	Allow NULL?
74	PACKAGE_MATNR	Packing Material	nvarchar	18	0	CHAR	(N' ')	Yes	*	CBDUE_PACKMAT	Allow NULL?
75	MATNR_REPLACE	Material Number of Replacement Material	nvarchar	18	0	CHAR	(N' ')	Yes	*	ADGE_MATNR_REPLACE	Allow NULL?
76	TEXTPATT_PROF01	Text Pattern Profile 01	nvarchar	10	0	CHAR	(N' ')	Yes	TDG91	ADGE_TEXTPATT_PROF01	Allow NULL?
77	TEXTPATT01	Dangerous Goods Text Pattern 01	nvarchar	21	0	CHAR	(N' ')	Yes		ADGE_PTXTPATT01	Allow NULL?
78	TEXTPATT_PROF02	Text Pattern Profile 02	nvarchar	10	0	CHAR	(N' ')	Yes	TDG91	ADGE_TEXTPATT_PROF02	Allow NULL?
79	TEXTPATT02	Dangerous Goods Text Pattern 02	nvarchar	21	0	CHAR	(N' ')	Yes		ADGE_PTXTPATT02	Allow NULL?
80	TEXTPATT_PROF03	Text Pattern Profile 03	nvarchar	10	0	CHAR	(N' ')	Yes	TDG91	ADGE_TEXTPATT_PROF03	Allow NULL?
81	TEXTPATT03	Dangerous Goods Text Pattern 03	nvarchar	21	0	CHAR	(N' ')	Yes		ADGE_PTXTPATT03	Allow NULL?
82	TEXTPATT_PROF04	Text Pattern Profile 04	nvarchar	10	0	CHAR	(N' ')	Yes	TDG91	ADGE_TEXTPATT_PROF04	Allow NULL?
83	TEXTPATT04	Dangerous Goods Text Pattern 04	nvarchar	21	0	CHAR	(N' ')	Yes		ADGE_PTXTPATT04	Allow NULL?
84	TEXTPATT_PROF05	Text Pattern Profile 05	nvarchar	10	0	CHAR	(N' ')	Yes	TDG91	ADGE_TEXTPATT_PROF05	Allow NULL?
85	TEXTPATT05	Dangerous Goods Text Pattern 05	nvarchar	21	0	CHAR	(N' ')	Yes		ADGE_PTXTPATT05	Allow NULL?
86	TEXTPATT_PROF06	Text Pattern Profile 06	nvarchar	10	0	CHAR	(N' ')	Yes	TDG91	ADGE_TEXTPATT_PROF06	Allow NULL?
87	TEXTPATT06	Dangerous Goods Text Pattern 06	nvarchar	21	0	CHAR	(N' ')	Yes		ADGE_PTXTPATT06	Allow NULL?
88	TEXTPATT_PROF07	Text Pattern Profile 07	nvarchar	10	0	CHAR	(N' ')	Yes	TDG91	ADGE_TEXTPATT_PROF07	Allow NULL?
89	TEXTPATT07	Dangerous Goods Text Pattern 07	nvarchar	21	0	CHAR	(N' ')	Yes		ADGE_PTXTPATT07	Allow NULL?
90	TEXTPATT_PROF08	Text Pattern Profile 08	nvarchar	10	0	CHAR	(N' ')	Yes	TDG91	ADGE_TEXTPATT_PROF08	Allow NULL?
91	TEXTPATT08	Dangerous Goods Text Pattern 08	nvarchar	21	0	CHAR	(N' ')	Yes		ADGE_PTXTPATT08	Allow NULL?
92	TEXTPATT_PROF09	Text Pattern Profile 09	nvarchar	10	0	CHAR	(N' ')	Yes	TDG91	ADGE_TEXTPATT_PROF09	Allow NULL?
93	TEXTPATT09	Dangerous Goods Text Pattern 09	nvarchar	21	0	CHAR	(N' ')	Yes		ADGE_PTXTPATT09	Allow NULL?
94	TEXTPATT_PROF10	Text Pattern Profile 10	nvarchar	10	0	CHAR	(N' ')	Yes	TDG91	ADGE_TEXTPATT_PROF10	Allow NULL?
95	TEXTPATT10	Dangerous Goods Text Pattern 10	nvarchar	21	0	CHAR	(N' ')	Yes		ADGE_PTXTPATT10	Allow NULL?
96	TEXTPATT_PROF11	Text Pattern Profile 11	nvarchar	10	0	CHAR	(N' ')	Yes	TDG91	ADGE_TEXTPATT_PROF11	Allow NULL?
97	TEXTPATT11	Dangerous Goods Text Pattern 11	nvarchar	21	0	CHAR	(N' ')	Yes		ADGE_PTXTPATT11	Allow NULL?
98	TEXTPATT_PROF12	Text Pattern Profile 12	nvarchar	10	0	CHAR	(N' ')	Yes	TDG91	ADGE_TEXTPATT_PROF12	Allow NULL?
99	TEXTPATT12	Dangerous Goods Text Pattern 12	nvarchar	21	0	CHAR	(N' ')	Yes		ADGE_PTXTPATT12	Allow NULL?
100	TEXTPATT_PROF13	Text Pattern Profile 13	nvarchar	10	0	CHAR	(N' ')	Yes	TDG91	ADGE_TEXTPATT_PROF13	Allow NULL?
101	TEXTPATT13	Dangerous Goods Text Pattern 13	nvarchar	21	0	CHAR	(N' ')	Yes		ADGE_PTXTPATT13	Allow NULL?
102	TEXTPATT_PROF14	Text Pattern Profile 14	nvarchar	10	0	CHAR	(N' ')	Yes	TDG91	ADGE_TEXTPATT_PROF14	Allow NULL?
103	TEXTPATT14	Dangerous Goods Text Pattern 14	nvarchar	21	0	CHAR	(N' ')	Yes		ADGE_PTXTPATT14	Allow NULL?
104	TEXTPATT_PROF15	Text Pattern Profile 15	nvarchar	10	0	CHAR	(N' ')	Yes	TDG91	ADGE_TEXTPATT_PROF15	Allow NULL?
105	TEXTPATT15	Dangerous Goods Text Pattern 15	nvarchar	21	0	CHAR	(N' ')	Yes		ADGE_PTXTPATT15	Allow NULL?
106	ABS_ACT	Absolute Activity	decimal	11	4	QUAN	((0))	Yes		ADGE_ABS_ACT
107	ABS_ACT_U	Unit of Absolute Activity	nvarchar	3	0	UNIT	(N' ')	Yes	T006	ADGE_ABS_ACT_U	Allow NULL?
108	REL_SPEC_ACT	Relative Specific Activity	decimal	11	4	QUAN	((0))	Yes		ADGE_REL_SPEC_ACT
109	REL_SPEC_ACT_U	Unit of Relative Specific Activity	nvarchar	3	0	UNIT	(N' ')	Yes	T006	ADGE_REL_SPEC_ACT_U	Allow NULL?
110	CONTAMINATION	Contamination	decimal	8	3	QUAN	((0))	Yes		ADGE_CONTAMINATION
111	CONTAMINATION_U	Unit of Contamination	nvarchar	3	0	UNIT	(N' ')	Yes	T006	ADGE_CONTAMINATION_U	Allow NULL?
112	DOSE_RATE	Radiation Level (Unpacked)	decimal	9	5	QUAN	((0))	Yes		ADGE_DOSE_RATE
113	DOSE_RATE_U	Unit of Radiation Level (Unpacked)	nvarchar	3	0	UNIT	(N' ')	Yes	T006	ADGE_DOSE_RATE_U	Allow NULL?
114	MAX_ACT1	A1 Activity Limit	decimal	11	4	QUAN	((0))	Yes		ADGE_MAX_ACT1
115	MAX_ACT1_U	A1 Activity Limit: Unit	nvarchar	3	0	UNIT	(N' ')	Yes	T006	ADGE_MAX_ACT1_U	Allow NULL?
116	ACT1_UNLIMIT	A1 Activity Limit: Unlimited	char	1	0	CHAR	(N' ')	Yes		ADGE_ACT1_UNLIMIT	Allow NULL?
117	MAX_ACT2	A2 Activity Limit	decimal	11	4	QUAN	((0))	Yes		ADGE_MAX_ACT2
118	MAX_ACT2_U	A2 Activity Limit: Unit	nvarchar	3	0	UNIT	(N' ')	Yes	T006	ADGE_MAX_ACT2_U	Allow NULL?
119	ACT2_UNLIMIT	A2 Activity Limit: Unlimited	char	1	0	CHAR	(N' ')	Yes		ADGE_ACT2_UNLIMIT	Allow NULL?
120	ACT_SUB_PACK	Activity Concentration for Substances in Excepted Packages	decimal	11	4	QUAN	((0))	Yes		ADGE_ACT_SUB_PACK
121	ACT_SUB_PACK_U	Activity Concentration Unit for Substances in Excepted Pkgs	nvarchar	3	0	UNIT	(N' ')	Yes	T006	ADGE_ACT_SUB_PACK_U	Allow NULL?
122	MAX_ACT_CONSG	Activity Limit for Exempt Consignment	decimal	11	4	QUAN	((0))	Yes		ADGE_MAX_ACT_CONSG
123	MAX_ACT_CONSG_U	Unit of Activity Limit for Exempt Consignment	nvarchar	3	0	UNIT	(N' ')	Yes	T006	ADGE_MAX_ACT_CONSG_U	Allow NULL?
124	MULT_ACT_SGL	Multiplier Activity Limit Item	decimal	11	7	DEC	((0))	Yes		ADGE_MULT_ACT_SGL
125	REF_ACT_SGL	Reference Value for Multiplier Item	nvarchar	2	0	CHAR	(N' ')	Yes		ADGE_REF_ACT_SGL	Allow NULL?
126	MULT_ACT_PACK	Multiplier Activity Limit Package	decimal	11	7	DEC	((0))	Yes		ADGE_MULT_ACT_PACK
127	REF_ACT_PACK	Reference Value for Multiplier Package	nvarchar	2	0	CHAR	(N' ')	Yes		ADGE_REF_ACT_PACK	Allow NULL?
128	MAX_CONT_A	Contamination Limit (Alpha)	decimal	8	3	QUAN	((0))	Yes		ADGE_MAX_CONT_A
129	MAX_CONT_A_U	Unit of Contamination Limit (Alpha)	nvarchar	3	0	UNIT	(N' ')	Yes	T006	ADGE_MAX_CONT_A_U	Allow NULL?
130	MAX_CONT_B_G	Contamination Limit (Beta, Gamma)	decimal	8	3	QUAN	((0))	Yes		ADGE_MAX_CONT_B_G
131	MAX_CONT_B_G_U	Unit of Contamination Limit (Beta, Gamma)	nvarchar	3	0	UNIT	(N' ')	Yes	T006	ADGE_MAX_CONT_B_G_U	Allow NULL?
132	MAX_DOSE_UNP	Limit Radiation Level Unpacked	decimal	9	5	QUAN	((0))	Yes		ADGE_MAX_DOSE_UNP
133	MAX_DOSE_UNP_U	Unit of Limit Radiation Level Unpacked	nvarchar	3	0	UNIT	(N' ')	Yes	T006	ADGE_MAX_DOSE_UNP_U	Allow NULL?
134	DIST_DOSE_UNP	Measured Distance for Limit Unpacked	decimal	5	3	QUAN	((0))	Yes		ADGE_DIST_DOSE_UNP
135	DIST_DOSE_UNP_U	Unit of Measured Distance for Limit Unpacked	nvarchar	3	0	UNIT	(N' ')	Yes	T006	ADGE_DIST_DOSE_UNP_U	Allow NULL?
136	NO_DIST_UNP	Measurement Unpacked at Surface	char	1	0	CHAR	(N' ')	Yes		ADGE_NO_DIST_UNP	Allow NULL?
137	MAX_DOSE_PACK	Limit Radiation Level Packed	decimal	9	5	QUAN	((0))	Yes		ADGE_MAX_DOSE_PACK
138	MAX_DOSE_PACK_U	Unit of Limit Radiation Level Packed	nvarchar	3	0	UNIT	(N' ')	Yes	T006	ADGE_MAX_DOSE_PACK_U	Allow NULL?
139	DIST_DOSE_PACK	Measured Distance for Limit Packed	decimal	5	3	QUAN	((0))	Yes		ADGE_DIST_DOSE_PACK
140	DIST_DOSE_PACK_U	Unit of Measured Distance for Limit Packed	nvarchar	3	0	UNIT	(N' ')	Yes	T006	ADGE_DIST_DOSE_PACK_U	Allow NULL?
141	NO_DIST_PACK	Measurement Packed at Surface	char	1	0	CHAR	(N' ')	Yes		ADGE_NO_DIST_PACK	Allow NULL?
142	MAX_ACT_SGL_DC	Maximum Activity: Item	decimal	11	4	QUAN	((0))	Yes		ADGE_MAX_ACT_SGL_DC
143	MAX_ACT_SGL_U_DC	Maximum Activity Unit: Item	nvarchar	3	0	UNIT	(N' ')	Yes	T006	ADGE_MAX_ACT_SGL_DYN_U	Allow NULL?
144	ACT_SGL_UNLIM_DC	Maximum Activity of Item Unlimited	char	1	0	CHAR	(N' ')	Yes		ADGE_ACT_SGL_UNLIM_DC	Allow NULL?
145	MAX_ACT_PAC_DC	Maximum Activity: Package	decimal	11	4	QUAN	((0))	Yes		ADGE_MAX_ACT_PAC_DC
146	MAX_ACT_PAC_U_DC	Maximum Activity Unit: Package	nvarchar	3	0	UNIT	(N' ')	Yes	T006	ADGE_MAX_ACT_PACK_DYN_U	Allow NULL?
147	ACT_PAC_UNLIM_DC	Maximum Activity of Package Unlimited	char	1	0	CHAR	(N' ')	Yes		ADGE_ACT_PAC_UNLIM_DC	Allow NULL?
148	EXCPT_PAC_OPT_DC	Excepted Package: Optional	char	1	0	CHAR	(N' ')	Yes		ADGE_EXCPT_PAC_OPT_DC	Allow NULL?
149	MAX_GRS_WGHT_DC	Maximum Gross Mass	decimal	8	2	QUAN	((0))	Yes		ADGE_MAX_GRS_WGHT_DC
150	U_MAX_GRS_WGT_DC	Unit for Maximum Gross Mass	nvarchar	3	0	UNIT	(N' ')	Yes	T006	ADGE_U_MAX_GROSS_WGHT	Allow NULL?
151	EXCEPTID01	Exception to Dangerous Goods Regulations 01	nvarchar	18	0	CHAR	(N' ')	Yes		ADGE_EXCEPTID01	Allow NULL?
152	EXCEPTID02	Exception to Dangerous Goods Regulations 02	nvarchar	18	0	CHAR	(N' ')	Yes		ADGE_EXCEPTID02	Allow NULL?
153	EXCEPTID03	Exception to Dangerous Goods Regulations 03	nvarchar	18	0	CHAR	(N' ')	Yes		ADGE_EXCEPTID03	Allow NULL?
154	EXCEPTID04	Exception to Dangerous Goods Regulations 04	nvarchar	18	0	CHAR	(N' ')	Yes		ADGE_EXCEPTID04	Allow NULL?
155	EXCEPTID05	Exception to Dangerous Goods Regulations 05	nvarchar	18	0	CHAR	(N' ')	Yes		ADGE_EXCEPTID05	Allow NULL?
156	EXCEPTID06	Exception to Dangerous Goods Regulations 06	nvarchar	18	0	CHAR	(N' ')	Yes		ADGE_EXCEPTID06	Allow NULL?
157	EXCEPTID07	Exception to Dangerous Goods Regulations 07	nvarchar	18	0	CHAR	(N' ')	Yes		ADGE_EXCEPTID07	Allow NULL?
158	EXCEPTID08	Exception to Dangerous Goods Regulations 08	nvarchar	18	0	CHAR	(N' ')	Yes		ADGE_EXCEPTID08	Allow NULL?
159	EXCEPTID09	Exception to Dangerous Goods Regulations 09	nvarchar	18	0	CHAR	(N' ')	Yes		ADGE_EXCEPTID09	Allow NULL?
160	EXCEPTID10	Exception to Dangerous Goods Regulations 10	nvarchar	18	0	CHAR	(N' ')	Yes		ADGE_EXCEPTID10	Allow NULL?
161	ACT_EMIS_TYPE	Radioactive Emission Type	nvarchar	3	0	CHAR	(N' ')	Yes		ADGE_ACT_EMIS_TYPE	Allow NULL?
162	MAX_NEM_DC	Maximum Net Explosive Substance Mass	decimal	9	3	QUAN	((0))	Yes		ADGE_MAX_NEM_DC
163	MAX_NEM_U_DC	Unit of Maximum Net Explosive Substance Mass	nvarchar	3	0	UNIT	(N' ')	Yes	*	ADGE_MAX_NEM_DC_U	Allow NULL?
164	PINEQ	Excepted Quantity: Packing Instruction Number	nvarchar	25	0	CHAR	(N' ')	Yes	*	ADGE_PINEQ	Allow NULL?
165	EXC_QUANT_IP	Excepted Quantity: Maximum Quantity/Volume Inner Packaging	decimal	8	2	QUAN	((0))	Yes		ADGE_EXC_QUANT_IP
166	EXC_QUANT_IP_U	Excepted Quantity: Unit of Meas. for Max.Qty Inner Packaging	nvarchar	3	0	UNIT	(N' ')	Yes	*	ADGE_EXC_QUANT_IP_U	Allow NULL?
167	EXC_QUANT_OP	Excepted Quantity: Maximum Quantity/Volume Outer Packaging	decimal	8	2	QUAN	((0))	Yes		ADGE_EXC_QUANT_OP
168	EXC_QUANT_OP_U	Excepted Quantity: Unit of Meas. for Max.Qty Outer Packaging	nvarchar	3	0	UNIT	(N' ')	Yes	*	ADGE_EXC_QUANT_OP_U	Allow NULL?
169	FLG_EXC_QUANT_IP	Value Entered for Max. Qty Inner Packaging (Excepted Qty)	char	1	0	CHAR	(N' ')	Yes		ADGE_FLG_EXC_QUANT_IP	Allow NULL?
170	FLG_EXC_QUANT_OP	Value Entered for Max. Qty Outer Packaging (Excepted Qty)	char	1	0	CHAR	(N' ')	Yes		ADGE_FLG_EXC_QUANT_OP	Allow NULL?

TOP ERP 6.0 | DGMS2 INDEXES

Name	Primary	Unique	Type	Columns
DGMS2~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

170 COLUMNS | 1 INDEXES | ERP 6.0 | DGMS2 TABLE

TOP ERP 6.0 | DGMS2 COLUMNS

TOP ERP 6.0 | DGMS2 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

170 COLUMNS | 1 INDEXES | ERP 6.0 | DGMS2 TABLE

TOPERP 6.0 | DGMS2 COLUMNS

TOPERP 6.0 | DGMS2 INDEXES

TOP ERP 6.0 | DGMS2 COLUMNS

TOP ERP 6.0 | DGMS2 INDEXES