	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	INV1	265	A/R Invoice - Rows
7	OPCH	386	A/P Invoice
8	JDT1	124	Journal Entry - Rows
9	OPOR	386	Purchase Order
10	OVTG	52	Tax Definition

	Table	Columns	Description
1	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

149 COLUMNS | 10 INDEXES | ERP 6.0 | QMEL TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Plant Maintenance :: Maintenance Processing :: Maintenance Notifications
1	ERP EHP7	6.0	QMEL	149	10	Quality Notification	Maintenance Notifications

SQL: selectupdate insert create

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

SELECT MANDT, QMNUM, QMART, QMTXT, ARTPR, PRIOK, ERNAM, ERDAT, AENAM, AEDAT, MZEIT, QMDAT, QMNAM, STRMN, STRUR, LTRMN, LTRUR, WAERS, AUFNR, VERID, RM_MATNR, RM_WERKS, SA_AUFNR, MATNR, REVLV, MATKL, PRDHA, KZKRI, KZDKZ, KUNUM, FEKNZ, MAKNZ, OBJNR, QMDAB, QMZAB, RBNR, RBNRI, INDTX, KZMLA, HERKZ, BEZDT, BEZUR, LIFNUM, BUNAME, VBELN, BSTNK, BSTDK, SPART, VKORG, VTWEG, ADRNR, AEZEIT, ERZEIT, MAWERK, QMKAT, QMGRP, QMCOD, AUSWIRK, TEILEV, PRUEFLOS, CHARG, LGORTCHARG, LICHN, HERSTELLER, EMATNR, EKORG, BKGRP, LGORTVORG, FERTAUFNR, FERTAUFPL, EBELN, EBELP, MJAHR, MBLNR, MBLPO, LS_KDAUF, LS_KDPOS, LS_VBELN, LS_POSNR, CROBJTY, ARBPL, ARBPLWERK, FEART, PNLKN, MGEIG, MGFRD, MGEIN, BZMNG, RKMNG, RGMNG, RKDAT, COAUFNR, QWRNUM, REFNUM, KDMAT, IDNLF, SERIALNR, KZLOESCH, PRODDAT, DEVICEID, VKBUR, VKGRP, AUTKZ, BEDID, BEDZL, PROFIL_TYP, PROFIL_ID, HANDLE, TSEGFL, TSEGTP, TZONSO, TZONID, FUNKTION, /SAPSMOSS/INSTN, /SAPSMOSS/MNUMM, /SAPSMOSS/OSSYS, /SAPSMOSS/DBSYS, /SAPSMOSS/REL, /SAPSMOSS/COMP, /SAPSMOSS/FRONT, /SAPSMOSS/SYSTYP, /SAPSMOSS/ADDID, /SAPSMOSS/ADDREL, /SAPSMOSS/TSTMP, /SAPSMOSS/STATUS, /SAPSMOSS/ERDAT, /SAPSMOSS/ERZEIT, /SAPSMOSS/SYSID, /SAPSMOSS/MANDT, PSP_NR, ESTIMATED_COSTS, CLAIMED_COSTS, RESULT_COSTS, CHANCE, OPPONENT, KALNR, KALVAR, OBJNR_REAL, OBJNR_STAT, PHASE, /ISDFPS/OBJNR, LOGSYSTEM, /ISDFPS/MEQUI, SHN_OBJTY, SHN_OBJID, SHN_FUNCT_LOC, SHN_EQUIPMENT, SHN_ORIGIN, UII FROM QMEL

TOP ERP 6.0 | QMEL COLUMNS

Column	Field	Description	SQL Type	Length	Decimals	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	Allow NULL?
2	QMNUM	Notification No	nvarchar	12	0	Allow NULL?
3	QMART	Notification Type	nvarchar	2	0	Allow NULL?
4	QMTXT	Short Text	nvarchar	40	0	Allow NULL?
5	ARTPR	Priority Type	nvarchar	2	0	Allow NULL?
6	PRIOK	Priority	char	1	0	Allow NULL?
7	ERNAM	Name of Person who Created the Object	nvarchar	12	0	Allow NULL?
8	ERDAT	Date on Which Record Was Created	nvarchar	8	0	Allow NULL?
9	AENAM	Name of Person Who Changed Object	nvarchar	12	0	Allow NULL?
10	AEDAT	Changed On	nvarchar	8	0	Allow NULL?
11	MZEIT	Time of Notification	nvarchar	6	0	Allow NULL?
12	QMDAT	Date of Notification	nvarchar	8	0	Allow NULL?
13	QMNAM	Name of Person Reporting Notification	nvarchar	12	0	Allow NULL?
14	STRMN	Required start date	nvarchar	8	0	Allow NULL?
15	STRUR	Required Start Time	nvarchar	6	0	Allow NULL?
16	LTRMN	Required End Date	nvarchar	8	0	Allow NULL?
17	LTRUR	Requested End Time	nvarchar	6	0	Allow NULL?
18	WAERS	Currency Key	nvarchar	5	0	Allow NULL?
19	AUFNR	Order Number	nvarchar	12	0	Allow NULL?
20	VERID	Production Version	nvarchar	4	0	Allow NULL?
21	RM_MATNR	Material number of the production version	nvarchar	18	0	Allow NULL?
22	RM_WERKS	Plant of production version	nvarchar	4	0	Allow NULL?
23	SA_AUFNR	Run schedule header number	nvarchar	12	0	Allow NULL?
24	MATNR	Material Number	nvarchar	18	0	Allow NULL?
25	REVLV	Revision Level	nvarchar	2	0	Allow NULL?
26	MATKL	Material Group	nvarchar	9	0	Allow NULL?
27	PRDHA	Product hierarchy	nvarchar	18	0	Allow NULL?
28	KZKRI	Indicator: Critical part	char	1	0	Allow NULL?
29	KZDKZ	Documentation required indicator	char	1	0	Allow NULL?
30	KUNUM	Account Number of Customer	nvarchar	10	0	Allow NULL?
31	FEKNZ	Error Records Exist	char	1	0	Allow NULL?
32	MAKNZ	Task Records Exist	char	1	0	Allow NULL?
33	OBJNR	Object Number for Status Management	nvarchar	22	0	Allow NULL?
34	QMDAB	Date for Notification Completion	nvarchar	8	0	Allow NULL?
35	QMZAB	Completion Time of Notification	nvarchar	6	0	Allow NULL?
36	RBNR	Catalog Profile	nvarchar	9	0	Allow NULL?
37	RBNRI	Origin of Notifications Catalog Profile	char	1	0	Allow NULL?
38	INDTX	Object Long Text Available	char	1	0	Allow NULL?
39	KZMLA	Primary language indicator for text segment	char	1	0	Allow NULL?
40	HERKZ	Origin of Notification	nvarchar	2	0	Allow NULL?
41	BEZDT	Notification Reference Date	nvarchar	8	0	Allow NULL?
42	BEZUR	Notification Reference Time	nvarchar	6	0	Allow NULL?
43	LIFNUM	Vendor Account Number	nvarchar	10	0	Allow NULL?
44	BUNAME	Author of a Q/PM Notification	nvarchar	12	0	Allow NULL?
45	VBELN	Sales Order Number	nvarchar	10	0	Allow NULL?
46	BSTNK	Customer purchase order number	nvarchar	35	0	Allow NULL?
47	BSTDK	Customer purchase order date	nvarchar	8	0	Allow NULL?
48	SPART	Division	nvarchar	2	0	Allow NULL?
49	VKORG	Sales Organization	nvarchar	4	0	Allow NULL?
50	VTWEG	Distribution Channel	nvarchar	2	0	Allow NULL?
51	ADRNR	Addresses: Address Number	nvarchar	10	0	Allow NULL?
52	AEZEIT	Time of Change	nvarchar	6	0	Allow NULL?
53	ERZEIT	Time, at Which Record Was Added	nvarchar	6	0	Allow NULL?
54	MAWERK	Plant for Material	nvarchar	4	0	Allow NULL?
55	QMKAT	Catalog Type - Coding	char	1	0	Allow NULL?
56	QMGRP	Code Group - Coding	nvarchar	8	0	Allow NULL?
57	QMCOD	Coding	nvarchar	4	0	Allow NULL?
58	AUSWIRK	Key for a Scenario	nvarchar	4	0	Allow NULL?
59	TEILEV	Usage of Parts	nvarchar	4	0	Allow NULL?
60	PRUEFLOS	Inspection Lot Number	nvarchar	12	0	Allow NULL?
61	CHARG	Batch Number	nvarchar	10	0	Allow NULL?
62	LGORTCHARG	Storage Location of Batch	nvarchar	4	0	Allow NULL?
63	LICHN	Vendor Batch Number	nvarchar	15	0	Allow NULL?
64	HERSTELLER	Number of Manufacturer	nvarchar	10	0	Allow NULL?
65	EMATNR	Material Number Corresponding to Manufacturer Part Number	nvarchar	18	0	Allow NULL?
66	EKORG	Purchasing Organization	nvarchar	4	0	Allow NULL?
67	BKGRP	Purchasing Group	nvarchar	3	0	Allow NULL?
68	LGORTVORG	Storage Location for Inspection Lot Stock	nvarchar	4	0	Allow NULL?
69	FERTAUFNR	Order Number (Production Order)	nvarchar	12	0	Allow NULL?
70	FERTAUFPL	Plan Number for Operations in Order (Production Order)	nvarchar	10	0	Allow NULL?
71	EBELN	Purchasing Document Number	nvarchar	10	0	Allow NULL?
72	EBELP	Item Number of Purchasing Document	nvarchar	5	0	Allow NULL?
73	MJAHR	Material Document Year	nvarchar	4	0	Allow NULL?
74	MBLNR	Number of Material Document	nvarchar	10	0	Allow NULL?
75	MBLPO	Item in Material Document	nvarchar	4	0	Allow NULL?
76	LS_KDAUF	Sales Order Number	nvarchar	10	0	Allow NULL?
77	LS_KDPOS	Item number of the SD document	nvarchar	6	0	Allow NULL?
78	LS_VBELN	Delivery	nvarchar	10	0	Allow NULL?
79	LS_POSNR	Delivery Item	nvarchar	6	0	Allow NULL?
80	CROBJTY	Object types of the CIM resource	nvarchar	2	0	Allow NULL?
81	ARBPL	Object ID of the Work Center	nvarchar	8	0	Allow NULL?
82	ARBPLWERK	Plant for Work Center	nvarchar	4	0	Allow NULL?
83	FEART	Report Type for Defects Recording	nvarchar	8	0	Allow NULL?
84	PNLKN	Current Node Number from Order Counter APLZL	nvarchar	8	0	Allow NULL?
85	MGEIG	Defective Quantity (Internal)	decimal	13	3
86	MGFRD	Defective Quantity (External)	decimal	13	3
87	MGEIN	Unit of Measure	nvarchar	3	0	Allow NULL?
88	BZMNG	General Reference Quantity	decimal	13	3
89	RKMNG	Complaint Quantity	decimal	13	3
90	RGMNG	Return Delivery Quantity	decimal	13	3
91	RKDAT	Date of Return Delivery	nvarchar	8	0	Allow NULL?
92	COAUFNR	Order Number (QM Order)	nvarchar	12	0	Allow NULL?
93	QWRNUM	Reference Notification Number	nvarchar	12	0	Allow NULL?
94	REFNUM	External Reference Number	nvarchar	20	0	Allow NULL?
95	KDMAT	Material Number Used by Customer	nvarchar	35	0	Allow NULL?
96	IDNLF	Material Number Used by Vendor	nvarchar	35	0	Allow NULL?
97	SERIALNR	Serial Number	nvarchar	18	0	Allow NULL?
98	KZLOESCH	Delete Data Record	char	1	0	Allow NULL?
99	PRODDAT	Production Date	nvarchar	8	0	Allow NULL?
100	DEVICEID	Additional Device Data	nvarchar	40	0	Allow NULL?
101	VKBUR	Sales Office	nvarchar	4	0	Allow NULL?
102	VKGRP	Sales Group	nvarchar	3	0	Allow NULL?
103	AUTKZ	Data Record Created with Function 'Create with Copy Model'	char	1	0	Allow NULL?
104	BEDID	ID of the capacity requirements record	nvarchar	12	0	Allow NULL?
105	BEDZL	Internal counter	nvarchar	8	0	Allow NULL?
106	PROFIL_TYP	Object Type	nvarchar	2	0	Allow NULL?
107	PROFIL_ID	Object ID	nvarchar	8	0	Allow NULL?
108	HANDLE	Globally unique identifier (linked to time segment, etc)	nvarchar	22	0	Allow NULL?
109	TSEGFL	Time segment exists	char	1	0	Allow NULL?
110	TSEGTP	Template	nvarchar	10	0	Allow NULL?
111	TZONSO	Time Zone for Notification	nvarchar	6	0	Allow NULL?
112	TZONID	Origin of Time Zone in Notification	char	1	0	Allow NULL?
113	FUNKTION	Keys for Function in Action Box	nvarchar	4	0	Allow NULL?
114	/SAPSMOSS/INSTN	Installation number	nvarchar	10	0	Allow NULL?
115	/SAPSMOSS/MNUMM	SAPNet notification number	nvarchar	24	0	Allow NULL?
116	/SAPSMOSS/OSSYS	Operating system and version	nvarchar	10	0	Allow NULL?
117	/SAPSMOSS/DBSYS	Database system	nvarchar	10	0	Allow NULL?
118	/SAPSMOSS/REL	R/3 Release	nvarchar	10	0	Allow NULL?
119	/SAPSMOSS/COMP	Area	nvarchar	20	0	Allow NULL?
120	/SAPSMOSS/FRONT	Frontend	nvarchar	10	0	Allow NULL?
121	/SAPSMOSS/SYSTYP	R/3 System type	char	1	0	Allow NULL?
122	/SAPSMOSS/ADDID	Add-on ID	nvarchar	10	0	Allow NULL?
123	/SAPSMOSS/ADDREL	Add-On Release	nvarchar	10	0	Allow NULL?
124	/SAPSMOSS/TSTMP	SAPNet time stamp	nvarchar	14	0	Allow NULL?
125	/SAPSMOSS/STATUS	Status of R/3 notification in SAPNet	char	1	0	Allow NULL?
126	/SAPSMOSS/ERDAT	Date on which notification was completed at SAP	nvarchar	8	0	Allow NULL?
127	/SAPSMOSS/ERZEIT	Time when notification was completed at SAP	nvarchar	6	0	Allow NULL?
128	/SAPSMOSS/SYSID	Name of SAP System	nvarchar	8	0	Allow NULL?
129	/SAPSMOSS/MANDT	Client ID	nvarchar	3	0	Allow NULL?
130	PSP_NR	WBS Element	nvarchar	8	0	Allow NULL?
131	ESTIMATED_COSTS	Estimated Costs for a Claim	decimal	13	2
132	CLAIMED_COSTS	Costs Claimed	decimal	13	2
133	RESULT_COSTS	Costs Accepted	decimal	13	2
134	CHANCE	Chance of Completing a Claim	nvarchar	2	0	Allow NULL?
135	OPPONENT	Partner Type	nvarchar	2	0	Allow NULL?
136	KALNR	Cost Estimate Number for Cost Est. w/o Qty Structure	nvarchar	12	0	Allow NULL?
137	KALVAR	Costing Variant for Postprocessing with Unit Costing	nvarchar	4	0	Allow NULL?
138	OBJNR_REAL	Object number of real CO account assignment	nvarchar	22	0	Allow NULL?
139	OBJNR_STAT	Auxiliary account assignment 1	nvarchar	22	0	Allow NULL?
140	PHASE	Notification Processing Phase	char	1	0	Allow NULL?
141	/ISDFPS/OBJNR	Object number	nvarchar	22	0	Allow NULL?
142	LOGSYSTEM	Logical System	nvarchar	10	0	Allow NULL?
143	/ISDFPS/MEQUI	Master Equipment	nvarchar	18	0	Allow NULL?
144	SHN_OBJTY	Object types of the CIM resource	nvarchar	2	0	Allow NULL?
145	SHN_OBJID	Object ID of the resource	nvarchar	8	0	Allow NULL?
146	SHN_FUNCT_LOC	Functional Location	nvarchar	30	0	Allow NULL?
147	SHN_EQUIPMENT	Equipment Number	nvarchar	18	0	Allow NULL?
148	SHN_ORIGIN	Origin or Use of Shift Note or Report	nvarchar	2	0	Allow NULL?
149	UII	Unique Item Identifier	nvarchar	72	0	Allow NULL?

TOP ERP 6.0 | QMEL INDEXES

Name	Primary	Unique	Type	Columns
QMEL~0	Yes	Yes	CLUSTERED	QMNUM, MANDT
QMEL~A	No	No	NONCLUSTERED	AUFNR, MANDT
QMEL~EPP	No	No	NONCLUSTERED	ARBPL, CROBJTY, SHN_OBJID, SHN_OBJTY, QMART, MANDT
QMEL~FA	No	No	NONCLUSTERED	FERTAUFNR, MANDT
QMEL~I	No	Yes	NONCLUSTERED	QMDAT, OBJNR, MANDT
QMEL~MCE	No	No	NONCLUSTERED	QMART, MAWERK, MATNR, EKORG, LIFNUM, MANDT
QMEL~MCK	No	No	NONCLUSTERED	QMART, MAWERK, MATNR, SPART, VTWEG, VKORG, KUNUM, MANDT
QMEL~MCM	No	No	NONCLUSTERED	MAWERK, QMART, MATNR, MANDT
QMEL~MCP	No	No	NONCLUSTERED	PRUEFLOS, MANDT
QMEL~T	No	No	NONCLUSTERED	QMTXT, 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

149 COLUMNS | 10 INDEXES | ERP 6.0 | QMEL TABLE

TOP ERP 6.0 | QMEL COLUMNS

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

149 COLUMNS | 10 INDEXES | ERP 6.0 | QMEL TABLE

TOPERP 6.0 | QMEL COLUMNS

TOPERP 6.0 | QMEL INDEXES

TOP ERP 6.0 | QMEL COLUMNS

TOP ERP 6.0 | QMEL INDEXES