	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

166 COLUMNS | 3 INDEXES | ERP 6.0 | DGTMD 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	DGTMD	166	3	DG: Dangerous Goods Master	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, VALFR, VALTO, AENNR, DELFLG, PARKFLG, CRDAT, CRNAM, UPDDAT, UPDNAM, SRSID, OWNID, RECNROOT, MATNR, MOT, RVLID, DGNHM, DGCAO, TKUI, DGNU, DGRES1, DGRES2, DGCL, DGSC, SDBC, SLBE, LDBC, LWDG, STOSU, COTMP, TPCUN, EMTMP, TPEUN, FLTMP, TPFUN, TPSNL, TPSLU, TPSNH, TPSHU, DAIN1, DAIN2, DAIN3, DAIN4, DAIN5, DAIN6, DAIN7, DAIN8, DAIN9, DAIN10, 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, KDGVS, KDGNS, KDGMP, KDGEX, KDGHI, KDGF1, KDGF2, KDGF3, KDGF4, KDGF5, KDGF6, KDGF7, KDGF8, KDGF9, KDGF10, 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, HYGRO, MEPOI, UMEPO, COOEX, UCOOE, MTMPF, UMTMP, STOPA, SPPRO, MAPOL, PINLQ, PASI, UPASI, PAGW, UPAGW, EXCEP, SCASE, COLNO, DGRES3, DGREMP, DGRERQ, EIMDG FROM DGTMD

TOP ERP 6.0 | DGTMD 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	VALFR	Valid-From Date	nvarchar	8	0	DATS	(N'00000000')	Yes		ESEVALFR	Allow NULL?
5	VALTO	Valid-To Date	nvarchar	8	0	DATS	(N'00000000')	Yes		ESEVALTO	Allow NULL?
6	AENNR	Change Number	nvarchar	12	0	CHAR	(N' ')	Yes	AENR	ESEAENNR	Allow NULL?
7	DELFLG	Deletion Indicator	char	1	0	CHAR	(N' ')	Yes		ADGE_DELFLG	Allow NULL?
8	PARKFLG	Data Record Is Inactive	char	1	0	CHAR	(N' ')	Yes		ESEPARKFLG	Allow NULL?
9	CRDAT	Created On	nvarchar	8	0	DATS	(N'00000000')	Yes		ESECRDAT	Allow NULL?
10	CRNAM	Created By	nvarchar	12	0	CHAR	(N' ')	Yes		ESECRNAM	Allow NULL?
11	UPDDAT	Changed On	nvarchar	8	0	DATS	(N'00000000')	Yes		ESEUPDDAT	Allow NULL?
12	UPDNAM	Last Changed By	nvarchar	12	0	CHAR	(N' ')	Yes		ESEUPDNAM	Allow NULL?
13	SRSID	Source of Data	nvarchar	10	0	CHAR	(N' ')	Yes	TCG56	ESESRSID	Allow NULL?
14	OWNID	Data Provider	nvarchar	10	0	CHAR	(N' ')	Yes	*	ESEVENDRID	Allow NULL?
15	RECNROOT	Sequential Number of Data Record	nvarchar	20	0	NUMC	(N'00000000000000000000')	Yes		ESERECN	Allow NULL?
16	MATNR	Material or Product (Internal Key)	nvarchar	40	0	CHAR	(N' ')	Yes	*	BASE_MATID	Allow NULL?
17	MOT	Dangerous Goods - Mode-of-Transport Category	nvarchar	2	0	NUMC	(N'00')	Yes	THM151	THME_MOT	Allow NULL?
18	RVLID	Validity Area	nvarchar	10	0	CHAR	(N' ')	Yes	TCG91	ESERVLID	Allow NULL?
19	DGNHM	Non-Dangerous Goods Full Transport	char	1	0	CHAR	(N' ')	Yes	THM159	THME_NHM	Allow NULL?
20	DGCAO	Only Cargo Air Transport Permitted	char	1	0	CHAR	(N' ')	Yes		ADGE_DGCAO	Allow NULL?
21	TKUI	Identification Number Type	nvarchar	3	0	CHAR	(N' ')	Yes	TDG73	THME_TKUI	Allow NULL?
22	DGNU	Identification Number	nvarchar	4	0	CHAR	(N' ')	Yes		THME_DGNU	Allow NULL?
23	DGRES1	Hazard-Inducing Substance	nvarchar	12	0	CHAR	(N' ')	Yes		ADGE_RES	Allow NULL?
24	DGRES2	Hazard-Inducing Substance	nvarchar	12	0	CHAR	(N' ')	Yes		ADGE_RES	Allow NULL?
25	DGCL	Dangerous Goods Class	nvarchar	3	0	CHAR	(N' ')	Yes	THM009	THME_DGCL	Allow NULL?
26	DGSC	Dangerous Goods Subclass	nvarchar	6	0	CHAR	(N' ')	Yes		ADGE_DGSC	Allow NULL?
27	SDBC	Hazard Item Number	nvarchar	4	0	NUMC	(N'0000')	Yes		ADGE_SDBC	Allow NULL?
28	SLBE	Hazard Item Number (Empty Transport)	nvarchar	4	0	NUMC	(N'0000')	Yes		THME_SLBE	Allow NULL?
29	LDBC	Classification Code	nvarchar	5	0	CHAR	(N' ')	Yes	THM011	THME_LDBC	Allow NULL?
30	LWDG	Dangerous Goods Regulation	nvarchar	12	0	CHAR	(N' ')	Yes	THM063	THME_LWDG	Allow NULL?
31	STOSU	Aggregate State for Transport	char	1	0	CHAR	(N' ')	Yes		ADGE_STOSU	Allow NULL?
32	COTMP	Control Temperature	decimal	8	2	QUAN	((0))	Yes		ADGE_COTMP
33	TPCUN	Temperature Unit (Control)	nvarchar	3	0	UNIT	(N' ')	Yes	T006	ADGE_TPCUN	Allow NULL?
34	EMTMP	Emergency Temperature	decimal	8	2	QUAN	((0))	Yes		ADGE_EMTMP
35	TPEUN	Temperature Unit (Emergency)	nvarchar	3	0	UNIT	(N' ')	Yes	T006	ADGE_TPEUN	Allow NULL?
36	FLTMP	Flash Point	decimal	8	2	QUAN	((0))	Yes		ADGE_FLTMP
37	TPFUN	Temperature Unit (Flame)	nvarchar	3	0	UNIT	(N' ')	Yes	T006	ADGE_TPFUN	Allow NULL?
38	TPSNL	Temperature Sensitivity (Lower Limit)	decimal	8	2	QUAN	((0))	Yes		ADGE_TPSNL
39	TPSLU	Unit for temperature sensitivity (lower limit)	nvarchar	3	0	UNIT	(N' ')	Yes	T006	ADGE_TPSLU	Allow NULL?
40	TPSNH	Temperature sensitivity (upper limit)	decimal	8	2	QUAN	((0))	Yes		ADGE_TPSNH
41	TPSHU	Temperature Unit (Sensitivity - Upper Limit)	nvarchar	3	0	UNIT	(N' ')	Yes	T006	ADGE_TPSHU	Allow NULL?
42	DAIN1	Hazard Note	nvarchar	4	0	CHAR	(N' ')	Yes		ADGE_DAIN	Allow NULL?
43	DAIN2	Hazard Note	nvarchar	4	0	CHAR	(N' ')	Yes		ADGE_DAIN	Allow NULL?
44	DAIN3	Hazard Note	nvarchar	4	0	CHAR	(N' ')	Yes		ADGE_DAIN	Allow NULL?
45	DAIN4	Hazard Note	nvarchar	4	0	CHAR	(N' ')	Yes		ADGE_DAIN	Allow NULL?
46	DAIN5	Hazard Note	nvarchar	4	0	CHAR	(N' ')	Yes		ADGE_DAIN	Allow NULL?
47	DAIN6	Hazard Note	nvarchar	4	0	CHAR	(N' ')	Yes		ADGE_DAIN	Allow NULL?
48	DAIN7	Hazard Note	nvarchar	4	0	CHAR	(N' ')	Yes		ADGE_DAIN	Allow NULL?
49	DAIN8	Hazard Note	nvarchar	4	0	CHAR	(N' ')	Yes		ADGE_DAIN	Allow NULL?
50	DAIN9	Hazard Note	nvarchar	4	0	CHAR	(N' ')	Yes		ADGE_DAIN	Allow NULL?
51	DAIN10	Hazard Note	nvarchar	4	0	CHAR	(N' ')	Yes		ADGE_DAIN	Allow NULL?
52	COWE	Water Pollution Class	char	1	0	CHAR	(N' ')	Yes	TDG15	ADGE_COWE	Allow NULL?
53	VBFC	VbF Class	nvarchar	4	0	CHAR	(N' ')	Yes	TDG35	ADGE_VBFC	Allow NULL?
54	SDCL	Storage Hazard Class	nvarchar	4	0	CHAR	(N' ')	Yes	TDG37	ADGE_SDCL	Allow NULL?
55	EINU	Tremcard Number	nvarchar	7	0	CHAR	(N' ')	Yes		ADGE_EINU	Allow NULL?
56	EICN	Replacement Tremcard Number	nvarchar	7	0	CHAR	(N' ')	Yes		ADGE_EICN	Allow NULL?
57	EMSN1	EmS/ERG Number 1	nvarchar	7	0	CHAR	(N' ')	Yes		ADGE_EMSN1	Allow NULL?
58	EMSN2	EmS/ERG Number 2	nvarchar	7	0	CHAR	(N' ')	Yes		ADGE_EMSN2	Allow NULL?
59	MFAG1	MFAG Number 1	nvarchar	4	0	CHAR	(N' ')	Yes		ADGE_MFAG1	Allow NULL?
60	MFAG2	MFAG Number 2	nvarchar	4	0	CHAR	(N' ')	Yes		ADGE_MFAG2	Allow NULL?
61	MOS1	Dangerous Goods Transport Type	nvarchar	3	0	NUMC	(N'000')	Yes	THM003	THME_MOS	Allow NULL?
62	MOS2	Dangerous Goods Transport Type	nvarchar	3	0	NUMC	(N'000')	Yes	THM003	THME_MOS	Allow NULL?
63	MOS3	Dangerous Goods Transport Type	nvarchar	3	0	NUMC	(N'000')	Yes	THM003	THME_MOS	Allow NULL?
64	MOS4	Dangerous Goods Transport Type	nvarchar	3	0	NUMC	(N'000')	Yes	THM003	THME_MOS	Allow NULL?
65	MOS5	Dangerous Goods Transport Type	nvarchar	3	0	NUMC	(N'000')	Yes	THM003	THME_MOS	Allow NULL?
66	MOS6	Dangerous Goods Transport Type	nvarchar	3	0	NUMC	(N'000')	Yes	THM003	THME_MOS	Allow NULL?
67	MOS7	Dangerous Goods Transport Type	nvarchar	3	0	NUMC	(N'000')	Yes	THM003	THME_MOS	Allow NULL?
68	MOS8	Dangerous Goods Transport Type	nvarchar	3	0	NUMC	(N'000')	Yes	THM003	THME_MOS	Allow NULL?
69	MOS9	Dangerous Goods Transport Type	nvarchar	3	0	NUMC	(N'000')	Yes	THM003	THME_MOS	Allow NULL?
70	MOSA	Dangerous Goods Transport Type	nvarchar	3	0	NUMC	(N'000')	Yes	THM003	THME_MOS	Allow NULL?
71	HQTU	Maximum Quantity per Transport Unit	decimal	8	2	QUAN	((0))	Yes		ADGE_HQTU
72	HQTUN	Maximum Quantity Unit	nvarchar	3	0	UNIT	(N' ')	Yes	T006	ADGE_HQTUN	Allow NULL?
73	PIN	Packing Instruction Number	nvarchar	25	0	CHAR	(N' ')	Yes	THM075	THME_PIN	Allow NULL?
74	PGRO	Packing Group	nvarchar	3	0	CHAR	(N' ')	Yes		THME_PGRO	Allow NULL?
75	HNU	Hazard Identification Number	nvarchar	4	0	CHAR	(N' ')	Yes	THM031	THME_HNU	Allow NULL?
76	HPN1	Danger Label Number 1	nvarchar	10	0	CHAR	(N' ')	Yes	THM017	THME_HPN1	Allow NULL?
77	HPN2	Danger Label Number 2	nvarchar	10	0	CHAR	(N' ')	Yes	THM017	THME_HPN2	Allow NULL?
78	HPN3	Danger Label Number 3	nvarchar	10	0	CHAR	(N' ')	Yes	THM017	THME_HPN3	Allow NULL?
79	HPN4	Danger Label Number 4	nvarchar	10	0	CHAR	(N' ')	Yes	THM017	THME_HPN4	Allow NULL?
80	HPN5	Danger Label Number 5	nvarchar	10	0	CHAR	(N' ')	Yes	THM017	THME_HPN5	Allow NULL?
81	HPN6	Danger Label Number 6	nvarchar	10	0	CHAR	(N' ')	Yes	THM017	THME_HPN6	Allow NULL?
82	HPN7	Danger Label Number 7	nvarchar	10	0	CHAR	(N' ')	Yes	THM017	THME_HPN7	Allow NULL?
83	LAB1	Label Number 1	nvarchar	7	0	CHAR	(N' ')	Yes	TDG29	ADGE_LAB1	Allow NULL?
84	LAB2	Label Number 2	nvarchar	7	0	CHAR	(N' ')	Yes	TDG29	ADGE_LAB2	Allow NULL?
85	LAB3	Label Number 3	nvarchar	7	0	CHAR	(N' ')	Yes	TDG29	ADGE_LAB3	Allow NULL?
86	LAB4	Label Number 4	nvarchar	7	0	CHAR	(N' ')	Yes	TDG29	ADGE_LAB4	Allow NULL?
87	LAB5	Label Number 5	nvarchar	7	0	CHAR	(N' ')	Yes	TDG29	ADGE_LAB5	Allow NULL?
88	LAB6	Label Number 6	nvarchar	7	0	CHAR	(N' ')	Yes	TDG29	ADGE_LAB6	Allow NULL?
89	LAB7	Label Number 7	nvarchar	7	0	CHAR	(N' ')	Yes	TDG29	ADGE_LAB7	Allow NULL?
90	LAB8	Label Number 8	nvarchar	7	0	CHAR	(N' ')	Yes	TDG29	ADGE_LAB8	Allow NULL?
91	LAB9	Label Number 9	nvarchar	7	0	CHAR	(N' ')	Yes	TDG29	ADGE_LAB9	Allow NULL?
92	LAB10	Label Number 10	nvarchar	7	0	CHAR	(N' ')	Yes	TDG29	ADGE_LABA	Allow NULL?
93	KDGVS	Text Key Highly Viscous Substances	nvarchar	70	0	CHAR	(N' ')	Yes		ADGE_KDGVS	Allow NULL?
94	KDGNS	Text Key Exemption for Named Substances	nvarchar	70	0	CHAR	(N' ')	Yes		ADGE_KDGNS	Allow NULL?
95	KDGMP	Text Key Marine Pollutant	nvarchar	70	0	CHAR	(N' ')	Yes		ADGE_KDGMP	Allow NULL?
96	KDGEX	Text Key Exceptions	nvarchar	70	0	CHAR	(N' ')	Yes		ADGE_KDGEX	Allow NULL?
97	KDGHI	Text key handling data	nvarchar	70	0	CHAR	(N' ')	Yes		ADGE_KDGHI	Allow NULL?
98	KDGF1	User-Defined Text Key 1	nvarchar	70	0	CHAR	(N' ')	Yes		ADGE_KDGF1	Allow NULL?
99	KDGF2	User-Defined Text Key 2	nvarchar	70	0	CHAR	(N' ')	Yes		ADGE_KDGF2	Allow NULL?
100	KDGF3	User-Defined Text Key 3	nvarchar	70	0	CHAR	(N' ')	Yes		ADGE_KDGF3	Allow NULL?
101	KDGF4	User-Defined Text Key 4	nvarchar	70	0	CHAR	(N' ')	Yes		ADGE_KDGF4	Allow NULL?
102	KDGF5	User-Defined Text Key 5	nvarchar	70	0	CHAR	(N' ')	Yes		ADGE_KDGF5	Allow NULL?
103	KDGF6	User-Defined Text Key 6	nvarchar	70	0	CHAR	(N' ')	Yes		ADGE_KDGF6	Allow NULL?
104	KDGF7	User-Defined Text Key 7	nvarchar	70	0	CHAR	(N' ')	Yes		ADGE_KDGF7	Allow NULL?
105	KDGF8	User-Defined Text Key 8	nvarchar	70	0	CHAR	(N' ')	Yes		ADGE_KDGF8	Allow NULL?
106	KDGF9	User-Defined Text Key 9	nvarchar	70	0	CHAR	(N' ')	Yes		ADGE_KDGF9	Allow NULL?
107	KDGF10	User-Defined Text Key 10	nvarchar	70	0	CHAR	(N' ')	Yes		ADGE_KDGFA	Allow NULL?
108	PAI	Limited Quantity (LQ) Inner Packaging	decimal	8	2	QUAN	((0))	Yes		THME_PAI
109	PAIU	Unit of Meas. for Limited Quantity (LQ) Inner Packaging	nvarchar	3	0	UNIT	(N' ')	Yes	T006	THME_PAIU	Allow NULL?
110	PAO	Limited Quantity (LQ) Outer Packaging	decimal	8	2	QUAN	((0))	Yes		THME_PAO
111	PAOU	Unit of Meas. for Limited Quantity (LQ) Outer Packaging	nvarchar	3	0	UNIT	(N' ')	Yes	T006	THME_PAOU	Allow NULL?
112	RQA	Reportable Quantity	decimal	8	2	QUAN	((0))	Yes		ADGE_RQA
113	RQU	Unit of measure for reportable quantities	nvarchar	3	0	UNIT	(N' ')	Yes	T006	ADGE_RQU	Allow NULL?
114	PBI	Poisonous by Inhalation	char	1	0	CHAR	(N' ')	Yes		ADGE_PBI	Allow NULL?
115	MINQ	Minimum Quantity for Listed Goods	decimal	8	2	QUAN	((0))	Yes		ADGE_MINQ
116	MINU	Unit of Measurement Minimum Quantity (Listed Goods)	nvarchar	3	0	UNIT	(N' ')	Yes	T006	ADGE_MINU	Allow NULL?
117	MAXQ	Maximum Quantity for Listed Goods	decimal	8	2	QUAN	((0))	Yes		ADGE_MAXQ
118	MAXU	Unit of Measurement Maximum Quantity (Listed Goods)	nvarchar	3	0	UNIT	(N' ')	Yes	T006	ADGE_MAXU	Allow NULL?
119	RELQ	Exemption (ADR 1.1.3.6)	decimal	8	2	QUAN	((0))	Yes		THME_RELQ
120	RELU	Unit of Measure Quantity Limit	nvarchar	3	0	UNIT	(N' ')	Yes	T006	THME_RELU	Allow NULL?
121	MULRQ	Multiplication Factor Exemption (ADR 1.1.3.6)	nvarchar	4	0	NUMC	(N'0000')	Yes		THME_MULRQ	Allow NULL?
122	RCHEM	Notification Status (Law on Control of Toxic Substances)	char	1	0	CHAR	(N' ')	Yes		ADGE_RCHEM	Allow NULL?
123	DGPTA	Shipping by Mail Permitted	char	1	0	CHAR	(N' ')	Yes		ADGE_DGPTA	Allow NULL?
124	DGTNA	Transport Not Permitted	char	1	0	CHAR	(N' ')	Yes		ADGE_DGTNA	Allow NULL?
125	DGWOS	Processing Status for Basic Data and Master Data	nvarchar	2	0	CHAR	(N' ')	Yes	THM039	THME_WOS	Allow NULL?
126	NHME	Non-Dangerous Goods Empty Transport	char	1	0	CHAR	(N' ')	Yes	THM159	THME_NHME	Allow NULL?
127	DGSHE	Schedule of Class 7	nvarchar	4	0	CHAR	(N' ')	Yes		ADGE_DGSHE	Allow NULL?
128	PIMDG	Note on Regulation	nvarchar	10	0	CHAR	(N' ')	Yes		ADGE_PIMDG	Allow NULL?
129	SOOWA	Solubility of water	decimal	12	2	QUAN	((0))	Yes		ADGE_SOOWA
130	USOOW	Unit for solubility of water	nvarchar	3	0	UNIT	(N' ')	Yes	T006	ADGE_USOOW	Allow NULL?
131	DENFEE	Density I	decimal	11	2	QUAN	((0))	Yes		ADGE_DENFE
132	UDENFE	Unit for density I	nvarchar	3	0	UNIT	(N' ')	Yes	T006	ADGE_UDENF	Allow NULL?
133	DENTWE	Density II	decimal	11	2	QUAN	((0))	Yes		ADGE_DENTW
134	UDENTW	Unit for density II	nvarchar	3	0	UNIT	(N' ')	Yes	T006	ADGE_UDENT	Allow NULL?
135	DENFIF	Density III	decimal	11	2	QUAN	((0))	Yes		ADGE_DENFI
136	UDENFI	Unit for density III	nvarchar	3	0	UNIT	(N' ')	Yes	T006	ADGE_UDEFI	Allow NULL?
137	BUDEN	Bulk Density	decimal	11	2	QUAN	((0))	Yes		ADGE_BUDEN
138	UBUDE	Unit for Bulk Density	nvarchar	3	0	UNIT	(N' ')	Yes	T006	ADGE_UBUDE	Allow NULL?
139	BOPOI	Boiling Point	decimal	8	2	QUAN	((0))	Yes		ADGE_BOPOI
140	UBOPO	Unit for Boiling Point	nvarchar	3	0	UNIT	(N' ')	Yes	T006	ADGE_UBOPO	Allow NULL?
141	VISCO	Viscosity	decimal	9	2	QUAN	((0))	Yes		ADGE_VISCO
142	UVISC	Unit for Viscosity	nvarchar	3	0	UNIT	(N' ')	Yes	T006	ADGE_UVISC	Allow NULL?
143	STPRES	Vapor Pressure	decimal	10	2	QUAN	((0))	Yes		ADGE_STPRE
144	USTPRE	Unit for vapor pressure	nvarchar	3	0	UNIT	(N' ')	Yes	T006	ADGE_USTPR	Allow NULL?
145	HYGRO	Hygroscopicity	char	1	0	CHAR	(N' ')	Yes		ADGE_HYGRO	Allow NULL?
146	MEPOI	Melting Point	decimal	8	2	QUAN	((0))	Yes		ADGE_MEPOI
147	UMEPO	Unit for Melting Point	nvarchar	3	0	UNIT	(N' ')	Yes	T006	ADGE_UMEPO	Allow NULL?
148	COOEX	Coefficient of Expansion	decimal	8	2	QUAN	((0))	Yes		ADGE_COOEX
149	UCOOE	Unit for Coefficient of Expansion	nvarchar	3	0	UNIT	(N' ')	Yes	T006	ADGE_UCOOE	Allow NULL?
150	MTMPF	Medium Temperature of Liquid During Filling	decimal	8	2	QUAN	((0))	Yes		ADGE_MTMPF
151	UMTMP	Unit for medium filling temperature	nvarchar	3	0	UNIT	(N' ')	Yes	T006	ADGE_UMTMP	Allow NULL?
152	STOPA	Packaging Mark	char	1	0	CHAR	(N' ')	Yes		THME_STOPA	Allow NULL?
153	SPPRO	Special Provision	nvarchar	5	0	CHAR	(N' ')	Yes		THME_SPPRO	Allow NULL?
154	MAPOL	Marine Pollutant	nvarchar	2	0	CHAR	(N' ')	Yes		ADGE_MAPOL	Allow NULL?
155	PINLQ	Packing Instruction Number for Limited Quantity (LQ)	nvarchar	25	0	CHAR	(N' ')	Yes	THM075	THME_PINLQ	Allow NULL?
156	PASI	Maximum Quantity per Package	decimal	8	2	QUAN	((0))	Yes		THME_PASI
157	UPASI	Unit of Measurement for Single Packaging	nvarchar	3	0	UNIT	(N' ')	Yes	T006	THME_UPASI	Allow NULL?
158	PAGW	Limited Quantity (LQ) Gross Weight	decimal	8	2	QUAN	((0))	Yes		THME_PAGW
159	UPAGW	Unit of Measurement for Limited Quantity (LQ) Gross	nvarchar	3	0	UNIT	(N' ')	Yes	T006	THME_UPAGW	Allow NULL?
160	EXCEP	Exception and Agreement Number	nvarchar	40	0	CHAR	(N' ')	Yes		ADGE_EXCEP	Allow NULL?
161	SCASE	Special Case (Packing Check)	char	1	0	CHAR	(N' ')	Yes		ADGE_SCASE	Allow NULL?
162	COLNO	Collective Number	char	1	0	CHAR	(N' ')	Yes		ADGE_COLNO	Allow NULL?
163	DGRES3	Hazard-Inducing Substance	nvarchar	12	0	CHAR	(N' ')	Yes		ADGE_RES	Allow NULL?
164	DGREMP	Hazard-inducing substance (marine pollutant)	nvarchar	12	0	CHAR	(N' ')	Yes		ADGE_REMP	Allow NULL?
165	DGRERQ	Hazard-inducing substance (reportable quantity)	nvarchar	12	0	CHAR	(N' ')	Yes		ADGE_RERQ	Allow NULL?
166	EIMDG	Regulation Edition	nvarchar	4	0	CHAR	(N' ')	Yes		ADGE_EIMDG	Allow NULL?

TOP ERP 6.0 | DGTMD INDEXES

Name	Primary	Unique	Type	Columns
DGTMD~0	Yes	Yes	CLUSTERED	ACTN, RECN, MANDT
DGTMD~LKM	No	No	NONCLUSTERED	LWDG, MATNR, MANDT
DGTMD~LKY	No	No	NONCLUSTERED	RVLID, MOT, MATNR, 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

166 COLUMNS | 3 INDEXES | ERP 6.0 | DGTMD TABLE

TOP ERP 6.0 | DGTMD COLUMNS

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

166 COLUMNS | 3 INDEXES | ERP 6.0 | DGTMD TABLE

TOPERP 6.0 | DGTMD COLUMNS

TOPERP 6.0 | DGTMD INDEXES

TOP ERP 6.0 | DGTMD COLUMNS

TOP ERP 6.0 | DGTMD INDEXES