	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	BSEG	345	Accounting Document Segment
9	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
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	OPCH	386	A/P Invoice
7	INV1	265	A/R Invoice - Rows
8	JDT1	124	Journal Entry - Rows
9	OPOR	386	Purchase Order
10	OVTG	52	Tax Definition

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

217 COLUMNS | 1 INDEXES | ERP 6.0 | DGTM2 TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Cross-Application Components :: General Application Functions :: Environment, Health and Safety Master Data
1	ERP EHP7	6.0	DGTM2	217	1	DG: Dangerous Goods Master (App. Table)	Environment, Health and Safety Master Data

SQL: selectupdate insert create

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

SELECT MANDT, RECN, ACTN, 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, 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 DGTM2

TOP ERP 6.0 | DGTM2 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	RECN	Sequential Number of Data Record	nvarchar	20	0	NUMC	(N'00000000000000000000')	No		ESERECN	Allow NULL?
3	ACTN	Sequential Number of the Change State	nvarchar	20	0	NUMC	(N'00000000000000000000')	No		ESEACTN	Allow NULL?
4	PDGNUD	Dangerous Goods Description	nvarchar	21	0	CHAR	(N' ')	Yes		ADGE_PDGND	Allow NULL?
5	PRES1	Hazard-Inducing Substance	nvarchar	21	0	CHAR	(N' ')	Yes		ADGE_PRES	Allow NULL?
6	PRES2	Hazard-Inducing Substance	nvarchar	21	0	CHAR	(N' ')	Yes		ADGE_PRES	Allow NULL?
7	PRES3	Hazard-Inducing Substance	nvarchar	21	0	CHAR	(N' ')	Yes		ADGE_PRES	Allow NULL?
8	PREMP1	Hazard-inducing substance (marine pollutant)	nvarchar	21	0	CHAR	(N' ')	Yes		ADGE_PRMP	Allow NULL?
9	PRERQ1	Hazard-inducing substance (reportable quantity)	nvarchar	21	0	CHAR	(N' ')	Yes		ADGE_PRRQ	Allow NULL?
10	PRERQ2	Hazard-inducing substance (reportable quantity)	nvarchar	21	0	CHAR	(N' ')	Yes		ADGE_PRRQ	Allow NULL?
11	PSTOSU	Aggregate State for Transport	nvarchar	21	0	CHAR	(N' ')	Yes		ADGE_PSTOS	Allow NULL?
12	PDAIN1	Hazard Note 1	nvarchar	21	0	CHAR	(N' ')	Yes		ADGE_PDAI1	Allow NULL?
13	PDAIN2	Hazard Note 2	nvarchar	21	0	CHAR	(N' ')	Yes		ADGE_PDAI2	Allow NULL?
14	PDAIN3	Hazard Note 3	nvarchar	21	0	CHAR	(N' ')	Yes		ADGE_PDAI3	Allow NULL?
15	PDAIN4	Hazard Note 4	nvarchar	21	0	CHAR	(N' ')	Yes		ADGE_PDAI4	Allow NULL?
16	PDAIN5	Hazard Note 5	nvarchar	21	0	CHAR	(N' ')	Yes		ADGE_PDAI5	Allow NULL?
17	PDAIN6	Hazard Note 6	nvarchar	21	0	CHAR	(N' ')	Yes		ADGE_PDAI6	Allow NULL?
18	PDAIN7	Hazard Note 7	nvarchar	21	0	CHAR	(N' ')	Yes		ADGE_PDAI7	Allow NULL?
19	PDAIN8	Hazard Note 8	nvarchar	21	0	CHAR	(N' ')	Yes		ADGE_PDAI8	Allow NULL?
20	PDAIN9	Hazard Note 9	nvarchar	21	0	CHAR	(N' ')	Yes		ADGE_PDAI9	Allow NULL?
21	PDAIN10	Hazard Note 10	nvarchar	21	0	CHAR	(N' ')	Yes		ADGE_PDAIA	Allow NULL?
22	MIOWA	Miscibility with Water	decimal	8	2	QUAN	((0))	Yes		ADGE_MIOWA
23	UMIOW	Unit for Miscibility with Water	nvarchar	3	0	UNIT	(N' ')	Yes	T006	ADGE_UMIOW	Allow NULL?
24	PHYGRO	Hygroscopicity	nvarchar	21	0	CHAR	(N' ')	Yes		ADGE_PHYGR	Allow NULL?
25	PDGF1	User-Defined Text Key 1	nvarchar	21	0	CHAR	(N' ')	Yes		ADGE_PDGF1	Allow NULL?
26	PDGF2	User-Defined Text Key 2	nvarchar	21	0	CHAR	(N' ')	Yes		ADGE_PDGF2	Allow NULL?
27	PDGF3	User-Defined Text Key 3	nvarchar	21	0	CHAR	(N' ')	Yes		ADGE_PDGF3	Allow NULL?
28	PDGF4	User-Defined Text Key 4	nvarchar	21	0	CHAR	(N' ')	Yes		ADGE_PDGF4	Allow NULL?
29	PDGF5	User-Defined Text Key 5	nvarchar	21	0	CHAR	(N' ')	Yes		ADGE_PDGF5	Allow NULL?
30	PDGF6	User-Defined Text Key 6	nvarchar	21	0	CHAR	(N' ')	Yes		ADGE_PDGF6	Allow NULL?
31	PDGF7	User-Defined Text Key 7	nvarchar	21	0	CHAR	(N' ')	Yes		ADGE_PDGF7	Allow NULL?
32	PDGF8	User-Defined Text Key 8	nvarchar	21	0	CHAR	(N' ')	Yes		ADGE_PDGF8	Allow NULL?
33	PDGF9	User-Defined Text Key 9	nvarchar	21	0	CHAR	(N' ')	Yes		ADGE_PDGF9	Allow NULL?
34	PDGFA	User-Defined Text Key 10	nvarchar	21	0	CHAR	(N' ')	Yes		ADGE_PDGFA	Allow NULL?
35	PDGFB	User-Defined Text Key 11	nvarchar	21	0	CHAR	(N' ')	Yes		ADGE_PDGFB	Allow NULL?
36	PDGFC	User-Defined Text Key 12	nvarchar	21	0	CHAR	(N' ')	Yes		ADGE_PDGFC	Allow NULL?
37	PDGFD	User-Defined Text Key 13	nvarchar	21	0	CHAR	(N' ')	Yes		ADGE_PDGFD	Allow NULL?
38	PDGFE	User-Defined Text Key 14	nvarchar	21	0	CHAR	(N' ')	Yes		ADGE_PDGFE	Allow NULL?
39	PDGFF	User-Defined Text Key 15	nvarchar	21	0	CHAR	(N' ')	Yes		ADGE_PDGFF	Allow NULL?
40	PTXTPATT	Dangerous Goods Text Pattern	nvarchar	21	0	CHAR	(N' ')	Yes		ADGE_PTXTPATT	Allow NULL?
41	MSEPR1	Segregation Key 1	nvarchar	4	0	CHAR	(N' ')	Yes	THM091	THME_DYKY1	Allow NULL?
42	MSEPR2	Segregation Key 2	nvarchar	4	0	CHAR	(N' ')	Yes	THM091	THME_DYKY2	Allow NULL?
43	MSEPR3	Segregation Key 3	nvarchar	4	0	CHAR	(N' ')	Yes	THM091	THME_DYKY3	Allow NULL?
44	MSEPR4	Segregation Key 4	nvarchar	4	0	CHAR	(N' ')	Yes	THM091	THME_DYKY4	Allow NULL?
45	MSEPR5	Segregation Key 5	nvarchar	4	0	CHAR	(N' ')	Yes	THM091	THME_DYKY5	Allow NULL?
46	MSEPR6	Segregation Key 6	nvarchar	4	0	CHAR	(N' ')	Yes	THM091	THME_DYKY6	Allow NULL?
47	MSEPR7	Segregation Key 7	nvarchar	4	0	CHAR	(N' ')	Yes	THM091	THME_DYKY7	Allow NULL?
48	MSEPR8	Segregation Key 8	nvarchar	4	0	CHAR	(N' ')	Yes	THM091	THME_DYKY8	Allow NULL?
49	MSEPR9	Segregation Key 9	nvarchar	4	0	CHAR	(N' ')	Yes	THM091	THME_DYKY9	Allow NULL?
50	MSEPRA	Segregation Key 10	nvarchar	4	0	CHAR	(N' ')	Yes	THM091	THME_DYKYA	Allow NULL?
51	MSEPRB	Segregation Key 11	nvarchar	4	0	CHAR	(N' ')	Yes	THM091	THME_DYKYB	Allow NULL?
52	MSEPRC	Segregation Key 12	nvarchar	4	0	CHAR	(N' ')	Yes	THM091	THME_DYKYC	Allow NULL?
53	MSEPRD	Segregation Key 13	nvarchar	4	0	CHAR	(N' ')	Yes	THM091	THME_DYKYD1	Allow NULL?
54	MSEPRE	Segregation Key 14	nvarchar	4	0	CHAR	(N' ')	Yes	THM091	THME_DYKYE	Allow NULL?
55	MSEPRF	Segregation Key 15	nvarchar	4	0	CHAR	(N' ')	Yes	THM091	THME_DYKYF	Allow NULL?
56	MSEPRG	Segregation Key 16	nvarchar	4	0	CHAR	(N' ')	Yes	THM091	THME_DYKYG	Allow NULL?
57	MSEPRH	Segregation Key 17	nvarchar	4	0	CHAR	(N' ')	Yes	THM091	THME_DYKYH	Allow NULL?
58	MLOAR1	Mixed Loading Rule 1	nvarchar	6	0	CHAR	(N' ')	Yes	THM097	THME_MLOAR1	Allow NULL?
59	MLOAR2	Mixed Loading Rule 2	nvarchar	6	0	CHAR	(N' ')	Yes	THM097	THME_MLOAR2	Allow NULL?
60	MLOAR3	Mixed Loading Rule 3	nvarchar	6	0	CHAR	(N' ')	Yes	THM097	THME_MLOAR3	Allow NULL?
61	MLOAR4	Mixed Loading Rule 4	nvarchar	6	0	CHAR	(N' ')	Yes	THM097	THME_MLOAR4	Allow NULL?
62	MLOAR5	Mixed Loading Rule 5	nvarchar	6	0	CHAR	(N' ')	Yes	THM097	THME_MLOAR5	Allow NULL?
63	MLOAR6	Mixed Loading Rule 6	nvarchar	6	0	CHAR	(N' ')	Yes	THM097	THME_MLOAR6	Allow NULL?
64	MLOAR7	Mixed Loading Rule 7	nvarchar	6	0	CHAR	(N' ')	Yes	THM097	THME_MLOAR7	Allow NULL?
65	MLOAR8	Mixed Loading Rule 8	nvarchar	6	0	CHAR	(N' ')	Yes	THM097	THME_MLOAR8	Allow NULL?
66	MLOAR9	Mixed Loading Rule 9	nvarchar	6	0	CHAR	(N' ')	Yes	THM097	THME_MLOAR9	Allow NULL?
67	MLOARA	Mixed Loading Rule 10	nvarchar	6	0	CHAR	(N' ')	Yes	THM097	THME_MLOARA	Allow NULL?
68	RSMLG1	Regulation-Dependent Mixed Loading Group 1	nvarchar	4	0	CHAR	(N' ')	Yes	THM101	THME_RSMLG1	Allow NULL?
69	RSMLG2	Regulation-Dependent Mixed Loading Group 2	nvarchar	4	0	CHAR	(N' ')	Yes	THM101	THME_RSMLG2	Allow NULL?
70	RSMLG3	Regulation-Dependent Mixed Loading Group 3	nvarchar	4	0	CHAR	(N' ')	Yes	THM101	THME_RSMLG3	Allow NULL?
71	ESMLG1	Enterprise-Specific Mixed Loading Group 1	nvarchar	4	0	CHAR	(N' ')	Yes	THM103	THME_ESMLG1	Allow NULL?
72	ESMLG2	Enterprise-Specific Mixed Loading Group 2	nvarchar	4	0	CHAR	(N' ')	Yes	THM103	THME_ESMLG2	Allow NULL?
73	ESMLG3	Enterprise-Specific Mixed Loading Group 3	nvarchar	4	0	CHAR	(N' ')	Yes	THM103	THME_ESMLG3	Allow NULL?
74	PREMP2	Hazard-inducing substance (marine pollutant)	nvarchar	21	0	CHAR	(N' ')	Yes		ADGE_PRMP	Allow NULL?
75	RQA2	Reportable Quantity	decimal	8	2	QUAN	((0))	Yes		ADGE_RQA
76	RQU2	Unit of measure for reportable quantities	nvarchar	3	0	UNIT	(N' ')	Yes	T006	ADGE_RQU	Allow NULL?
77	PPDG1	Profile for Dangerous Goods User-Defined Text 1	nvarchar	2	0	CHAR	(N' ')	Yes		THME_PPDG1	Allow NULL?
78	PPDG2	Profile for Dangerous Goods User-Defined Text 2	nvarchar	2	0	CHAR	(N' ')	Yes		THME_PPDG2	Allow NULL?
79	PPDG3	Profile for Dangerous Goods User-Defined Text 3	nvarchar	2	0	CHAR	(N' ')	Yes		THME_PPDG3	Allow NULL?
80	PPDG4	Profile for Dangerous Goods User-Defined Text 4	nvarchar	2	0	CHAR	(N' ')	Yes		THME_PPDG4	Allow NULL?
81	PPDG5	Profile for Dangerous Goods User-Defined Text 5	nvarchar	2	0	CHAR	(N' ')	Yes		THME_PPDG5	Allow NULL?
82	PPDG6	Profile for Dangerous Goods User-Defined Text 6	nvarchar	2	0	CHAR	(N' ')	Yes		THME_PPDG6	Allow NULL?
83	PPDG7	Profile for Dangerous Goods User-Defined Text 7	nvarchar	2	0	CHAR	(N' ')	Yes		THME_PPDG7	Allow NULL?
84	PPDG8	Profile for Dangerous Goods User-Defined Text 8	nvarchar	2	0	CHAR	(N' ')	Yes		THME_PPDG8	Allow NULL?
85	PPDG9	Profile for Dangerous Goods User-Defined Text 9	nvarchar	2	0	CHAR	(N' ')	Yes		THME_PPDG9	Allow NULL?
86	PPDGA	Profile for Dangerous Goods User-Defined Text 10	nvarchar	2	0	CHAR	(N' ')	Yes		THME_PPDGA	Allow NULL?
87	PPDGB	Profile for Dangerous Goods User-Defined Text 11	nvarchar	2	0	CHAR	(N' ')	Yes		THME_PPDGB	Allow NULL?
88	PPDGC	Profile for Dangerous Goods User-Defined Text 12	nvarchar	2	0	CHAR	(N' ')	Yes		THME_PPDGC	Allow NULL?
89	PPDGE	Profile for Dangerous Goods User-Defined Text 13	nvarchar	2	0	CHAR	(N' ')	Yes		THME_PPDGE	Allow NULL?
90	PPDGF	Profile for Dangerous Goods User-Defined Text 14	nvarchar	2	0	CHAR	(N' ')	Yes		THME_PPDGF	Allow NULL?
91	PPDGG	Profile for Dangerous Goods User-Defined Text 15	nvarchar	2	0	CHAR	(N' ')	Yes		THME_PPDGG	Allow NULL?
92	DAOR	Data Origin (Filling and Distribution)	char	1	0	CHAR	(N' ')	Yes		ADGE_DAOR	Allow NULL?
93	FORM_PHYS_CHEM	Physical and Chemical Form	nvarchar	21	0	CHAR	(N' ')	Yes		EHS_ADGE_FORM_PHYS_CHEM	Allow NULL?
94	EXPL_NET	Net Explosive Substance Mass	decimal	9	3	QUAN	((0))	Yes		EHS_ADGE_EXPL_NET
95	EXPL_NET_U	Unit for Net Explosive Substance Mass	nvarchar	3	0	UNIT	(N' ')	Yes	T006	EHS_ADGE_EXPL_NET_U	Allow NULL?
96	EXPL_REL_PERCENT	Relative Net Explosive Substance Percentage	decimal	6	3	DEC	((0))	Yes		EHS_ADGE_EXPL_REL_PERCENT
97	ACTVTY_MAX	Maximum Activity	decimal	8	2	QUAN	((0))	Yes		EHS_ADGE_ACTVTY_MAX
98	ACTVTY_MAX_U	Unit of Maximum Activity	nvarchar	3	0	UNIT	(N' ')	Yes	T006	EHS_ADGE_ACTVTY_MAX_U	Allow NULL?
99	ACTVTY_MAX_REL	Relative Maximum Activity	decimal	8	2	QUAN	((0))	Yes		EHS_ADGE_ACTVTY_MAX_REL
100	ACTVTY_MAX_REL_U	Unit of Relative Maximum Activity	nvarchar	3	0	UNIT	(N' ')	Yes	T006	EHS_ADGE_ACTVTY_MAX_REL_U	Allow NULL?
101	LTSK	Air Transport Safety Code	char	1	0	CHAR	(N' ')	Yes		EHS_ADGE_LTSK	Allow NULL?
102	EMV	Electromagnetic Compatibility	char	1	0	CHAR	(N' ')	Yes		EHS_ADGE_EMV	Allow NULL?
103	FSAK	Parachute Drop Code	char	1	0	CHAR	(N' ')	Yes		EHS_ADGE_FSAK	Allow NULL?
104	SFK	Thrust Code	char	1	0	CHAR	(N' ')	Yes		EHS_ADGE_SFK	Allow NULL?
105	MUNAKODE	Ammunition Code	nvarchar	4	0	CHAR	(N' ')	Yes		EHS_ADGE_MUNAKODE	Allow NULL?
106	EXNUMBER	EX-Number	nvarchar	12	0	CHAR	(N' ')	Yes		EHS_ADGE_EXNUMBER	Allow NULL?
107	CERTIFIC	Identification Mark for Approval Certificate	nvarchar	21	0	CHAR	(N' ')	Yes		EHS_ADGE_APPROV_CERTIFIC	Allow NULL?
108	HAZCHEM_CODE	Code for Chemical Hazard	nvarchar	10	0	CHAR	(N' ')	Yes		CBDUE_HAZCHEM_CODE	Allow NULL?
109	FLG_EMSN1_U	EmS Number 1 Underlined	char	1	0	CHAR	(N' ')	Yes		CBDUE_FLG_EMSN1_U	Allow NULL?
110	FLG_EMSN2_U	EmS Number 2 Underlined	char	1	0	CHAR	(N' ')	Yes		CBDUE_FLG_EMSN2_U	Allow NULL?
111	STOWAGE	Stowage Category	nvarchar	3	0	CHAR	(N' ')	Yes	CCUNC111	CBDUE_STOWAGE	Allow NULL?
112	CARR_TYPE	Transport Category	nvarchar	3	0	CHAR	(N' ')	Yes		CBDUE_CARR_TYPE	Allow NULL?
113	FLG_PAI	Value Entered for Limited Quantity (LQ) Inner Packaging	char	1	0	CHAR	(N' ')	Yes		CBDUE_FLG_PAI	Allow NULL?
114	FLG_PAO	Value Entered for Limited Quantity (LQ) Outer Packaging	char	1	0	CHAR	(N' ')	Yes		CBDUE_FLG_PAO	Allow NULL?
115	FLG_PASI	Value Entered for Maximum Quantity per Package	char	1	0	CHAR	(N' ')	Yes		CBDUE_FLG_PASI	Allow NULL?
116	FLG_PAGW	Value Entered for Limited Quantity (LQ) Gross Weight	char	1	0	CHAR	(N' ')	Yes		CBDUE_FLG_PAGW	Allow NULL?
117	FLG_RELQ	Value Entered for Exemption	char	1	0	CHAR	(N' ')	Yes		CBDUE_FLG_RELQ	Allow NULL?
118	FLG_MULRQ	Value Entered for Multiplication Factor	char	1	0	CHAR	(N' ')	Yes		CBDUE_FLG_MULRQ	Allow NULL?
119	FLG_RELQ_UNLIMIT	Unlimited Set for Exemption	char	1	0	CHAR	(N' ')	Yes		CBDUE_FLG_RELQ_UNLIMIT	Allow NULL?
120	FLG_MULRQ_FORBID	Prohibited Set for Multiplication Factor	char	1	0	CHAR	(N' ')	Yes		CBDUE_FLG_MULRQ_FORBID	Allow NULL?
121	PDGNUDPRE	Dangerous Goods Description Prefix	nvarchar	21	0	CHAR	(N' ')	Yes		CBDUE_PDGNUDPRE	Allow NULL?
122	PDGNUDSUF	Dangerous Goods Description Suffix	nvarchar	21	0	CHAR	(N' ')	Yes		CBDUE_PDGNUDSUF	Allow NULL?
123	TEXTPATT_PROF01	Text Pattern Profile 01	nvarchar	10	0	CHAR	(N' ')	Yes	TDG91	ADGE_TEXTPATT_PROF01	Allow NULL?
124	TEXTPATT01	Dangerous Goods Text Pattern 01	nvarchar	21	0	CHAR	(N' ')	Yes		ADGE_PTXTPATT01	Allow NULL?
125	TEXTPATT_PROF02	Text Pattern Profile 02	nvarchar	10	0	CHAR	(N' ')	Yes	TDG91	ADGE_TEXTPATT_PROF02	Allow NULL?
126	TEXTPATT02	Dangerous Goods Text Pattern 02	nvarchar	21	0	CHAR	(N' ')	Yes		ADGE_PTXTPATT02	Allow NULL?
127	TEXTPATT_PROF03	Text Pattern Profile 03	nvarchar	10	0	CHAR	(N' ')	Yes	TDG91	ADGE_TEXTPATT_PROF03	Allow NULL?
128	TEXTPATT03	Dangerous Goods Text Pattern 03	nvarchar	21	0	CHAR	(N' ')	Yes		ADGE_PTXTPATT03	Allow NULL?
129	TEXTPATT_PROF04	Text Pattern Profile 04	nvarchar	10	0	CHAR	(N' ')	Yes	TDG91	ADGE_TEXTPATT_PROF04	Allow NULL?
130	TEXTPATT04	Dangerous Goods Text Pattern 04	nvarchar	21	0	CHAR	(N' ')	Yes		ADGE_PTXTPATT04	Allow NULL?
131	TEXTPATT_PROF05	Text Pattern Profile 05	nvarchar	10	0	CHAR	(N' ')	Yes	TDG91	ADGE_TEXTPATT_PROF05	Allow NULL?
132	TEXTPATT05	Dangerous Goods Text Pattern 05	nvarchar	21	0	CHAR	(N' ')	Yes		ADGE_PTXTPATT05	Allow NULL?
133	TEXTPATT_PROF06	Text Pattern Profile 06	nvarchar	10	0	CHAR	(N' ')	Yes	TDG91	ADGE_TEXTPATT_PROF06	Allow NULL?
134	TEXTPATT06	Dangerous Goods Text Pattern 06	nvarchar	21	0	CHAR	(N' ')	Yes		ADGE_PTXTPATT06	Allow NULL?
135	TEXTPATT_PROF07	Text Pattern Profile 07	nvarchar	10	0	CHAR	(N' ')	Yes	TDG91	ADGE_TEXTPATT_PROF07	Allow NULL?
136	TEXTPATT07	Dangerous Goods Text Pattern 07	nvarchar	21	0	CHAR	(N' ')	Yes		ADGE_PTXTPATT07	Allow NULL?
137	TEXTPATT_PROF08	Text Pattern Profile 08	nvarchar	10	0	CHAR	(N' ')	Yes	TDG91	ADGE_TEXTPATT_PROF08	Allow NULL?
138	TEXTPATT08	Dangerous Goods Text Pattern 08	nvarchar	21	0	CHAR	(N' ')	Yes		ADGE_PTXTPATT08	Allow NULL?
139	TEXTPATT_PROF09	Text Pattern Profile 09	nvarchar	10	0	CHAR	(N' ')	Yes	TDG91	ADGE_TEXTPATT_PROF09	Allow NULL?
140	TEXTPATT09	Dangerous Goods Text Pattern 09	nvarchar	21	0	CHAR	(N' ')	Yes		ADGE_PTXTPATT09	Allow NULL?
141	TEXTPATT_PROF10	Text Pattern Profile 10	nvarchar	10	0	CHAR	(N' ')	Yes	TDG91	ADGE_TEXTPATT_PROF10	Allow NULL?
142	TEXTPATT10	Dangerous Goods Text Pattern 10	nvarchar	21	0	CHAR	(N' ')	Yes		ADGE_PTXTPATT10	Allow NULL?
143	TEXTPATT_PROF11	Text Pattern Profile 11	nvarchar	10	0	CHAR	(N' ')	Yes	TDG91	ADGE_TEXTPATT_PROF11	Allow NULL?
144	TEXTPATT11	Dangerous Goods Text Pattern 11	nvarchar	21	0	CHAR	(N' ')	Yes		ADGE_PTXTPATT11	Allow NULL?
145	TEXTPATT_PROF12	Text Pattern Profile 12	nvarchar	10	0	CHAR	(N' ')	Yes	TDG91	ADGE_TEXTPATT_PROF12	Allow NULL?
146	TEXTPATT12	Dangerous Goods Text Pattern 12	nvarchar	21	0	CHAR	(N' ')	Yes		ADGE_PTXTPATT12	Allow NULL?
147	TEXTPATT_PROF13	Text Pattern Profile 13	nvarchar	10	0	CHAR	(N' ')	Yes	TDG91	ADGE_TEXTPATT_PROF13	Allow NULL?
148	TEXTPATT13	Dangerous Goods Text Pattern 13	nvarchar	21	0	CHAR	(N' ')	Yes		ADGE_PTXTPATT13	Allow NULL?
149	TEXTPATT_PROF14	Text Pattern Profile 14	nvarchar	10	0	CHAR	(N' ')	Yes	TDG91	ADGE_TEXTPATT_PROF14	Allow NULL?
150	TEXTPATT14	Dangerous Goods Text Pattern 14	nvarchar	21	0	CHAR	(N' ')	Yes		ADGE_PTXTPATT14	Allow NULL?
151	TEXTPATT_PROF15	Text Pattern Profile 15	nvarchar	10	0	CHAR	(N' ')	Yes	TDG91	ADGE_TEXTPATT_PROF15	Allow NULL?
152	TEXTPATT15	Dangerous Goods Text Pattern 15	nvarchar	21	0	CHAR	(N' ')	Yes		ADGE_PTXTPATT15	Allow NULL?
153	ABS_ACT	Absolute Activity	decimal	11	4	QUAN	((0))	Yes		ADGE_ABS_ACT
154	ABS_ACT_U	Unit of Absolute Activity	nvarchar	3	0	UNIT	(N' ')	Yes	T006	ADGE_ABS_ACT_U	Allow NULL?
155	REL_SPEC_ACT	Relative Specific Activity	decimal	11	4	QUAN	((0))	Yes		ADGE_REL_SPEC_ACT
156	REL_SPEC_ACT_U	Unit of Relative Specific Activity	nvarchar	3	0	UNIT	(N' ')	Yes	T006	ADGE_REL_SPEC_ACT_U	Allow NULL?
157	CONTAMINATION	Contamination	decimal	8	3	QUAN	((0))	Yes		ADGE_CONTAMINATION
158	CONTAMINATION_U	Unit of Contamination	nvarchar	3	0	UNIT	(N' ')	Yes	T006	ADGE_CONTAMINATION_U	Allow NULL?
159	DOSE_RATE	Radiation Level (Unpacked)	decimal	9	5	QUAN	((0))	Yes		ADGE_DOSE_RATE
160	DOSE_RATE_U	Unit of Radiation Level (Unpacked)	nvarchar	3	0	UNIT	(N' ')	Yes	T006	ADGE_DOSE_RATE_U	Allow NULL?
161	MAX_ACT1	A1 Activity Limit	decimal	11	4	QUAN	((0))	Yes		ADGE_MAX_ACT1
162	MAX_ACT1_U	A1 Activity Limit: Unit	nvarchar	3	0	UNIT	(N' ')	Yes	T006	ADGE_MAX_ACT1_U	Allow NULL?
163	ACT1_UNLIMIT	A1 Activity Limit: Unlimited	char	1	0	CHAR	(N' ')	Yes		ADGE_ACT1_UNLIMIT	Allow NULL?
164	MAX_ACT2	A2 Activity Limit	decimal	11	4	QUAN	((0))	Yes		ADGE_MAX_ACT2
165	MAX_ACT2_U	A2 Activity Limit: Unit	nvarchar	3	0	UNIT	(N' ')	Yes	T006	ADGE_MAX_ACT2_U	Allow NULL?
166	ACT2_UNLIMIT	A2 Activity Limit: Unlimited	char	1	0	CHAR	(N' ')	Yes		ADGE_ACT2_UNLIMIT	Allow NULL?
167	ACT_SUB_PACK	Activity Concentration for Substances in Excepted Packages	decimal	11	4	QUAN	((0))	Yes		ADGE_ACT_SUB_PACK
168	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?
169	MAX_ACT_CONSG	Activity Limit for Exempt Consignment	decimal	11	4	QUAN	((0))	Yes		ADGE_MAX_ACT_CONSG
170	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?
171	MULT_ACT_SGL	Multiplier Activity Limit Item	decimal	11	7	DEC	((0))	Yes		ADGE_MULT_ACT_SGL
172	REF_ACT_SGL	Reference Value for Multiplier Item	nvarchar	2	0	CHAR	(N' ')	Yes		ADGE_REF_ACT_SGL	Allow NULL?
173	MULT_ACT_PACK	Multiplier Activity Limit Package	decimal	11	7	DEC	((0))	Yes		ADGE_MULT_ACT_PACK
174	REF_ACT_PACK	Reference Value for Multiplier Package	nvarchar	2	0	CHAR	(N' ')	Yes		ADGE_REF_ACT_PACK	Allow NULL?
175	MAX_CONT_A	Contamination Limit (Alpha)	decimal	8	3	QUAN	((0))	Yes		ADGE_MAX_CONT_A
176	MAX_CONT_A_U	Unit of Contamination Limit (Alpha)	nvarchar	3	0	UNIT	(N' ')	Yes	T006	ADGE_MAX_CONT_A_U	Allow NULL?
177	MAX_CONT_B_G	Contamination Limit (Beta, Gamma)	decimal	8	3	QUAN	((0))	Yes		ADGE_MAX_CONT_B_G
178	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?
179	MAX_DOSE_UNP	Limit Radiation Level Unpacked	decimal	9	5	QUAN	((0))	Yes		ADGE_MAX_DOSE_UNP
180	MAX_DOSE_UNP_U	Unit of Limit Radiation Level Unpacked	nvarchar	3	0	UNIT	(N' ')	Yes	T006	ADGE_MAX_DOSE_UNP_U	Allow NULL?
181	DIST_DOSE_UNP	Measured Distance for Limit Unpacked	decimal	5	3	QUAN	((0))	Yes		ADGE_DIST_DOSE_UNP
182	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?
183	NO_DIST_UNP	Measurement Unpacked at Surface	char	1	0	CHAR	(N' ')	Yes		ADGE_NO_DIST_UNP	Allow NULL?
184	MAX_DOSE_PACK	Limit Radiation Level Packed	decimal	9	5	QUAN	((0))	Yes		ADGE_MAX_DOSE_PACK
185	MAX_DOSE_PACK_U	Unit of Limit Radiation Level Packed	nvarchar	3	0	UNIT	(N' ')	Yes	T006	ADGE_MAX_DOSE_PACK_U	Allow NULL?
186	DIST_DOSE_PACK	Measured Distance for Limit Packed	decimal	5	3	QUAN	((0))	Yes		ADGE_DIST_DOSE_PACK
187	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?
188	NO_DIST_PACK	Measurement Packed at Surface	char	1	0	CHAR	(N' ')	Yes		ADGE_NO_DIST_PACK	Allow NULL?
189	MAX_ACT_SGL_DC	Maximum Activity: Item	decimal	11	4	QUAN	((0))	Yes		ADGE_MAX_ACT_SGL_DC
190	MAX_ACT_SGL_U_DC	Maximum Activity Unit: Item	nvarchar	3	0	UNIT	(N' ')	Yes	T006	ADGE_MAX_ACT_SGL_DYN_U	Allow NULL?
191	ACT_SGL_UNLIM_DC	Maximum Activity of Item Unlimited	char	1	0	CHAR	(N' ')	Yes		ADGE_ACT_SGL_UNLIM_DC	Allow NULL?
192	MAX_ACT_PAC_DC	Maximum Activity: Package	decimal	11	4	QUAN	((0))	Yes		ADGE_MAX_ACT_PAC_DC
193	MAX_ACT_PAC_U_DC	Maximum Activity Unit: Package	nvarchar	3	0	UNIT	(N' ')	Yes	T006	ADGE_MAX_ACT_PACK_DYN_U	Allow NULL?
194	ACT_PAC_UNLIM_DC	Maximum Activity of Package Unlimited	char	1	0	CHAR	(N' ')	Yes		ADGE_ACT_PAC_UNLIM_DC	Allow NULL?
195	EXCPT_PAC_OPT_DC	Excepted Package: Optional	char	1	0	CHAR	(N' ')	Yes		ADGE_EXCPT_PAC_OPT_DC	Allow NULL?
196	MAX_GRS_WGHT_DC	Maximum Gross Mass	decimal	8	2	QUAN	((0))	Yes		ADGE_MAX_GRS_WGHT_DC
197	U_MAX_GRS_WGT_DC	Unit for Maximum Gross Mass	nvarchar	3	0	UNIT	(N' ')	Yes	T006	ADGE_U_MAX_GROSS_WGHT	Allow NULL?
198	EXCEPTID01	Exception to Dangerous Goods Regulations 01	nvarchar	18	0	CHAR	(N' ')	Yes		ADGE_EXCEPTID01	Allow NULL?
199	EXCEPTID02	Exception to Dangerous Goods Regulations 02	nvarchar	18	0	CHAR	(N' ')	Yes		ADGE_EXCEPTID02	Allow NULL?
200	EXCEPTID03	Exception to Dangerous Goods Regulations 03	nvarchar	18	0	CHAR	(N' ')	Yes		ADGE_EXCEPTID03	Allow NULL?
201	EXCEPTID04	Exception to Dangerous Goods Regulations 04	nvarchar	18	0	CHAR	(N' ')	Yes		ADGE_EXCEPTID04	Allow NULL?
202	EXCEPTID05	Exception to Dangerous Goods Regulations 05	nvarchar	18	0	CHAR	(N' ')	Yes		ADGE_EXCEPTID05	Allow NULL?
203	EXCEPTID06	Exception to Dangerous Goods Regulations 06	nvarchar	18	0	CHAR	(N' ')	Yes		ADGE_EXCEPTID06	Allow NULL?
204	EXCEPTID07	Exception to Dangerous Goods Regulations 07	nvarchar	18	0	CHAR	(N' ')	Yes		ADGE_EXCEPTID07	Allow NULL?
205	EXCEPTID08	Exception to Dangerous Goods Regulations 08	nvarchar	18	0	CHAR	(N' ')	Yes		ADGE_EXCEPTID08	Allow NULL?
206	EXCEPTID09	Exception to Dangerous Goods Regulations 09	nvarchar	18	0	CHAR	(N' ')	Yes		ADGE_EXCEPTID09	Allow NULL?
207	EXCEPTID10	Exception to Dangerous Goods Regulations 10	nvarchar	18	0	CHAR	(N' ')	Yes		ADGE_EXCEPTID10	Allow NULL?
208	ACT_EMIS_TYPE	Radioactive Emission Type	nvarchar	3	0	CHAR	(N' ')	Yes		ADGE_ACT_EMIS_TYPE	Allow NULL?
209	MAX_NEM_DC	Maximum Net Explosive Substance Mass	decimal	9	3	QUAN	((0))	Yes		ADGE_MAX_NEM_DC
210	MAX_NEM_U_DC	Unit of Maximum Net Explosive Substance Mass	nvarchar	3	0	UNIT	(N' ')	Yes	*	ADGE_MAX_NEM_DC_U	Allow NULL?
211	PINEQ	Excepted Quantity: Packing Instruction Number	nvarchar	25	0	CHAR	(N' ')	Yes	*	ADGE_PINEQ	Allow NULL?
212	EXC_QUANT_IP	Excepted Quantity: Maximum Quantity/Volume Inner Packaging	decimal	8	2	QUAN	((0))	Yes		ADGE_EXC_QUANT_IP
213	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?
214	EXC_QUANT_OP	Excepted Quantity: Maximum Quantity/Volume Outer Packaging	decimal	8	2	QUAN	((0))	Yes		ADGE_EXC_QUANT_OP
215	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?
216	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?
217	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 | DGTM2 INDEXES

Name	Primary	Unique	Type	Columns
DGTM2~0	Yes	Yes	CLUSTERED	ACTN, RECN, 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

217 COLUMNS | 1 INDEXES | ERP 6.0 | DGTM2 TABLE

TOP ERP 6.0 | DGTM2 COLUMNS

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

217 COLUMNS | 1 INDEXES | ERP 6.0 | DGTM2 TABLE

TOPERP 6.0 | DGTM2 COLUMNS

TOPERP 6.0 | DGTM2 INDEXES

TOP ERP 6.0 | DGTM2 COLUMNS

TOP ERP 6.0 | DGTM2 INDEXES