	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	OVPM	154	Outgoing Payments
5	OIVL	77	Whse Journal
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

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	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	QMNUM	Notification No	nvarchar	12	0	CHAR	(N' ')	No		QMNUM	Allow NULL?
3	QMART	Notification Type	nvarchar	2	0	CHAR	(N' ')	Yes	TQ80	QMART	Allow NULL?
4	QMTXT	Short Text	nvarchar	40	0	CHAR	(N' ')	Yes		QMTXT	Allow NULL?
5	ARTPR	Priority Type	nvarchar	2	0	CHAR	(N' ')	Yes	T356A	ARTPR	Allow NULL?
6	PRIOK	Priority	char	1	0	CHAR	(N' ')	Yes	T356	PRIOK	Allow NULL?
7	ERNAM	Name of Person who Created the Object	nvarchar	12	0	CHAR	(N' ')	Yes		ERNAM	Allow NULL?
8	ERDAT	Date on Which Record Was Created	nvarchar	8	0	DATS	(N'00000000')	Yes		ERDAT	Allow NULL?
9	AENAM	Name of Person Who Changed Object	nvarchar	12	0	CHAR	(N' ')	Yes		AENAM	Allow NULL?
10	AEDAT	Changed On	nvarchar	8	0	DATS	(N'00000000')	Yes		AEDAT	Allow NULL?
11	MZEIT	Time of Notification	nvarchar	6	0	TIMS	(N'000000')	Yes		MZEIT	Allow NULL?
12	QMDAT	Date of Notification	nvarchar	8	0	DATS	(N'00000000')	Yes		QMDAT	Allow NULL?
13	QMNAM	Name of Person Reporting Notification	nvarchar	12	0	CHAR	(N' ')	Yes		QMNAM	Allow NULL?
14	STRMN	Required start date	nvarchar	8	0	DATS	(N'00000000')	Yes		STRMN	Allow NULL?
15	STRUR	Required Start Time	nvarchar	6	0	TIMS	(N'000000')	Yes		STRUR	Allow NULL?
16	LTRMN	Required End Date	nvarchar	8	0	DATS	(N'00000000')	Yes		LTRMN	Allow NULL?
17	LTRUR	Requested End Time	nvarchar	6	0	TIMS	(N'000000')	Yes		LTRUR	Allow NULL?
18	WAERS	Currency Key	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	WAERS	Allow NULL?
19	AUFNR	Order Number	nvarchar	12	0	CHAR	(N' ')	Yes	AUFK	AUFNR	Allow NULL?
20	VERID	Production Version	nvarchar	4	0	CHAR	(N' ')	Yes	MKAL	VERID	Allow NULL?
21	RM_MATNR	Material number of the production version	nvarchar	18	0	CHAR	(N' ')	Yes	MKAL	RM_MATNR	Allow NULL?
22	RM_WERKS	Plant of production version	nvarchar	4	0	CHAR	(N' ')	Yes	MKAL	RM_WERKS	Allow NULL?
23	SA_AUFNR	Run schedule header number	nvarchar	12	0	CHAR	(N' ')	Yes	SAFK	SA_AUFNR	Allow NULL?
24	MATNR	Material Number	nvarchar	18	0	CHAR	(N' ')	Yes	MARA	MATNR	Allow NULL?
25	REVLV	Revision Level	nvarchar	2	0	CHAR	(N' ')	Yes		REVLV	Allow NULL?
26	MATKL	Material Group	nvarchar	9	0	CHAR	(N' ')	Yes	T023	MATKL	Allow NULL?
27	PRDHA	Product hierarchy	nvarchar	18	0	CHAR	(N' ')	Yes	T179	PRODH_D	Allow NULL?
28	KZKRI	Indicator: Critical part	char	1	0	CHAR	(N' ')	Yes		KZKRI	Allow NULL?
29	KZDKZ	Documentation required indicator	char	1	0	CHAR	(N' ')	Yes		KZDKZ	Allow NULL?
30	KUNUM	Account Number of Customer	nvarchar	10	0	CHAR	(N' ')	Yes	KNA1	QKUNUM	Allow NULL?
31	FEKNZ	Error Records Exist	char	1	0	CHAR	(N' ')	Yes		FEKNZ	Allow NULL?
32	MAKNZ	Task Records Exist	char	1	0	CHAR	(N' ')	Yes		MAKNZ	Allow NULL?
33	OBJNR	Object Number for Status Management	nvarchar	22	0	CHAR	(N' ')	Yes	ONR00	QMOBJNR	Allow NULL?
34	QMDAB	Date for Notification Completion	nvarchar	8	0	DATS	(N'00000000')	Yes		QMDAB	Allow NULL?
35	QMZAB	Completion Time of Notification	nvarchar	6	0	TIMS	(N'000000')	Yes		QMZAB	Allow NULL?
36	RBNR	Catalog Profile	nvarchar	9	0	CHAR	(N' ')	Yes	T352B	RBNR	Allow NULL?
37	RBNRI	Origin of Notifications Catalog Profile	char	1	0	CHAR	(N' ')	Yes		RBNRI	Allow NULL?
38	INDTX	Object Long Text Available	char	1	0	CHAR	(N' ')	Yes		INDLTX	Allow NULL?
39	KZMLA	Primary language indicator for text segment	char	1	0	CHAR	(N' ')	Yes		KZMLA	Allow NULL?
40	HERKZ	Origin of Notification	nvarchar	2	0	CHAR	(N' ')	Yes		HERKZ	Allow NULL?
41	BEZDT	Notification Reference Date	nvarchar	8	0	DATS	(N'00000000')	Yes		BEZDT	Allow NULL?
42	BEZUR	Notification Reference Time	nvarchar	6	0	TIMS	(N'000000')	Yes		BEZUR_D	Allow NULL?
43	LIFNUM	Vendor Account Number	nvarchar	10	0	CHAR	(N' ')	Yes	LFA1	LIFNUM	Allow NULL?
44	BUNAME	Author of a Q/PM Notification	nvarchar	12	0	CHAR	(N' ')	Yes	*	BUNAME	Allow NULL?
45	VBELN	Sales Order Number	nvarchar	10	0	CHAR	(N' ')	Yes	VBUK	KDAUF	Allow NULL?
46	BSTNK	Customer purchase order number	nvarchar	35	0	CHAR	(N' ')	Yes		BSTKD	Allow NULL?
47	BSTDK	Customer purchase order date	nvarchar	8	0	DATS	(N'00000000')	Yes		BSTDK	Allow NULL?
48	SPART	Division	nvarchar	2	0	CHAR	(N' ')	Yes	TSPA	SPART	Allow NULL?
49	VKORG	Sales Organization	nvarchar	4	0	CHAR	(N' ')	Yes	TVKO	VKORG	Allow NULL?
50	VTWEG	Distribution Channel	nvarchar	2	0	CHAR	(N' ')	Yes	TVTW	VTWEG	Allow NULL?
51	ADRNR	Addresses: Address Number	nvarchar	10	0	CHAR	(N' ')	Yes	*	CADNR	Allow NULL?
52	AEZEIT	Time of Change	nvarchar	6	0	TIMS	(N'000000')	Yes		AEZEIT	Allow NULL?
53	ERZEIT	Time, at Which Record Was Added	nvarchar	6	0	TIMS	(N'000000')	Yes		ERZEIT	Allow NULL?
54	MAWERK	Plant for Material	nvarchar	4	0	CHAR	(N' ')	Yes	T001W	QMAWERKS	Allow NULL?
55	QMKAT	Catalog Type - Coding	char	1	0	CHAR	(N' ')	Yes	TQ15	QMKAT	Allow NULL?
56	QMGRP	Code Group - Coding	nvarchar	8	0	CHAR	(N' ')	Yes	QPGR	QMGRP	Allow NULL?
57	QMCOD	Coding	nvarchar	4	0	CHAR	(N' ')	Yes	*	QMCOD	Allow NULL?
58	AUSWIRK	Key for a Scenario	nvarchar	4	0	CHAR	(N' ')	Yes	TQ81	QSCENARIO	Allow NULL?
59	TEILEV	Usage of Parts	nvarchar	4	0	CHAR	(N' ')	Yes	TQ81V	QTEILEV	Allow NULL?
60	PRUEFLOS	Inspection Lot Number	nvarchar	12	0	NUMC	(N'000000000000')	Yes	QALS	QPLOS	Allow NULL?
61	CHARG	Batch Number	nvarchar	10	0	CHAR	(N' ')	Yes	MCH1	CHARG_D	Allow NULL?
62	LGORTCHARG	Storage Location of Batch	nvarchar	4	0	CHAR	(N' ')	Yes	T001L	QLGORTCHAR	Allow NULL?
63	LICHN	Vendor Batch Number	nvarchar	15	0	CHAR	(N' ')	Yes		LICHN	Allow NULL?
64	HERSTELLER	Number of Manufacturer	nvarchar	10	0	CHAR	(N' ')	Yes	LFA1	QLIFNR	Allow NULL?
65	EMATNR	Material Number Corresponding to Manufacturer Part Number	nvarchar	18	0	CHAR	(N' ')	Yes	MARA	EMATN	Allow NULL?
66	EKORG	Purchasing Organization	nvarchar	4	0	CHAR	(N' ')	Yes	T024E	EKORG	Allow NULL?
67	BKGRP	Purchasing Group	nvarchar	3	0	CHAR	(N' ')	Yes	T024	BKGRP	Allow NULL?
68	LGORTVORG	Storage Location for Inspection Lot Stock	nvarchar	4	0	CHAR	(N' ')	Yes	T001L	QLGORTVORG	Allow NULL?
69	FERTAUFNR	Order Number (Production Order)	nvarchar	12	0	CHAR	(N' ')	Yes	AUFK	FERTAUFNR	Allow NULL?
70	FERTAUFPL	Plan Number for Operations in Order (Production Order)	nvarchar	10	0	NUMC	(N'0000000000')	Yes		FERTAUFPL	Allow NULL?
71	EBELN	Purchasing Document Number	nvarchar	10	0	CHAR	(N' ')	Yes	EKKO	EBELN	Allow NULL?
72	EBELP	Item Number of Purchasing Document	nvarchar	5	0	NUMC	(N'00000')	Yes	EKPO	QEBELP	Allow NULL?
73	MJAHR	Material Document Year	nvarchar	4	0	NUMC	(N'0000')	Yes		MJAHR	Allow NULL?
74	MBLNR	Number of Material Document	nvarchar	10	0	CHAR	(N' ')	Yes		MBLNR	Allow NULL?
75	MBLPO	Item in Material Document	nvarchar	4	0	NUMC	(N'0000')	Yes		QMBLPO	Allow NULL?
76	LS_KDAUF	Sales Order Number	nvarchar	10	0	CHAR	(N' ')	Yes	VBUK	KDAUF	Allow NULL?
77	LS_KDPOS	Item number of the SD document	nvarchar	6	0	NUMC	(N'000000')	Yes	VBUP	POSNR	Allow NULL?
78	LS_VBELN	Delivery	nvarchar	10	0	CHAR	(N' ')	Yes	VBUK	VBELN_VL	Allow NULL?
79	LS_POSNR	Delivery Item	nvarchar	6	0	NUMC	(N'000000')	Yes	VBUP	QPOSNR_VL	Allow NULL?
80	CROBJTY	Object types of the CIM resource	nvarchar	2	0	CHAR	(N' ')	Yes		CR_OBJTY	Allow NULL?
81	ARBPL	Object ID of the Work Center	nvarchar	8	0	NUMC	(N'00000000')	Yes	CRID	LGWID	Allow NULL?
82	ARBPLWERK	Plant for Work Center	nvarchar	4	0	CHAR	(N' ')	Yes	T001W	QARBPWERKS	Allow NULL?
83	FEART	Report Type for Defects Recording	nvarchar	8	0	CHAR	(N' ')	Yes	TQ86	QFEART	Allow NULL?
84	PNLKN	Current Node Number from Order Counter APLZL	nvarchar	8	0	NUMC	(N'00000000')	Yes		QLFNKN	Allow NULL?
85	MGEIG	Defective Quantity (Internal)	decimal	13	3	QUAN	((0))	Yes		MGEIG
86	MGFRD	Defective Quantity (External)	decimal	13	3	QUAN	((0))	Yes		MGFRD
87	MGEIN	Unit of Measure	nvarchar	3	0	UNIT	(N' ')	Yes	T006	MGEIN	Allow NULL?
88	BZMNG	General Reference Quantity	decimal	13	3	QUAN	((0))	Yes		QBZMNG
89	RKMNG	Complaint Quantity	decimal	13	3	QUAN	((0))	Yes		RKMNG
90	RGMNG	Return Delivery Quantity	decimal	13	3	QUAN	((0))	Yes		RGMNG
91	RKDAT	Date of Return Delivery	nvarchar	8	0	DATS	(N'00000000')	Yes		RKDAT	Allow NULL?
92	COAUFNR	Order Number (QM Order)	nvarchar	12	0	CHAR	(N' ')	Yes	AUFK	COAUFNR	Allow NULL?
93	QWRNUM	Reference Notification Number	nvarchar	12	0	CHAR	(N' ')	Yes	QMEL	QWRNUM	Allow NULL?
94	REFNUM	External Reference Number	nvarchar	20	0	CHAR	(N' ')	Yes		QMEXTNR	Allow NULL?
95	KDMAT	Material Number Used by Customer	nvarchar	35	0	CHAR	(N' ')	Yes		MATNR_KU	Allow NULL?
96	IDNLF	Material Number Used by Vendor	nvarchar	35	0	CHAR	(N' ')	Yes		IDNLF	Allow NULL?
97	SERIALNR	Serial Number	nvarchar	18	0	CHAR	(N' ')	Yes		GERNR	Allow NULL?
98	KZLOESCH	Delete Data Record	char	1	0	CHAR	(N' ')	Yes		KZLOESCH	Allow NULL?
99	PRODDAT	Production Date	nvarchar	8	0	DATS	(N'00000000')	Yes		QPRODDAT	Allow NULL?
100	DEVICEID	Additional Device Data	nvarchar	40	0	CHAR	(N' ')	Yes		DEVICEID	Allow NULL?
101	VKBUR	Sales Office	nvarchar	4	0	CHAR	(N' ')	Yes	TVKBZ	VKBUR	Allow NULL?
102	VKGRP	Sales Group	nvarchar	3	0	CHAR	(N' ')	Yes	TVBVK	VKGRP	Allow NULL?
103	AUTKZ	Data Record Created with Function 'Create with Copy Model'	char	1	0	CHAR	(N' ')	Yes		QAUTKZ	Allow NULL?
104	BEDID	ID of the capacity requirements record	nvarchar	12	0	NUMC	(N'000000000000')	Yes	*	BEDID	Allow NULL?
105	BEDZL	Internal counter	nvarchar	8	0	NUMC	(N'00000000')	Yes		CIM_COUNT	Allow NULL?
106	PROFIL_TYP	Object Type	nvarchar	2	0	CHAR	(N' ')	Yes	*	OTYPE	Allow NULL?
107	PROFIL_ID	Object ID	nvarchar	8	0	NUMC	(N'00000000')	Yes		OBJEKTID	Allow NULL?
108	HANDLE	Globally unique identifier (linked to time segment, etc)	nvarchar	22	0	CHAR	(N' ')	Yes		TSEGGUID	Allow NULL?
109	TSEGFL	Time segment exists	char	1	0	CHAR	(N' ')	Yes		TSEGEXISTS	Allow NULL?
110	TSEGTP	Template	nvarchar	10	0	CHAR	(N' ')	Yes	TTSEGTPLH	TSEGTEMPLA	Allow NULL?
111	TZONSO	Time Zone for Notification	nvarchar	6	0	CHAR	(N' ')	Yes	TTZZ	TZONSO	Allow NULL?
112	TZONID	Origin of Time Zone in Notification	char	1	0	CHAR	(N' ')	Yes		TZONSMID	Allow NULL?
113	FUNKTION	Keys for Function in Action Box	nvarchar	4	0	CHAR	(N' ')	Yes		QNFUNKTION	Allow NULL?
114	/SAPSMOSS/INSTN	Installation number	nvarchar	10	0	CHAR	(N' ')	Yes	/SAPSMOSS/INSTN	/SAPSMOSS/R3INSTN	Allow NULL?
115	/SAPSMOSS/MNUMM	SAPNet notification number	nvarchar	24	0	NUMC	(N'000000000000000000000000')	Yes		/SAPSMOSS/MNUMM	Allow NULL?
116	/SAPSMOSS/OSSYS	Operating system and version	nvarchar	10	0	CHAR	(N' ')	Yes	/SAPSMOSS/OSYS	/SAPSMOSS/OSSYS	Allow NULL?
117	/SAPSMOSS/DBSYS	Database system	nvarchar	10	0	CHAR	(N' ')	Yes	/SAPSMOSS/DBSY	/SAPSMOSS/DBSYS	Allow NULL?
118	/SAPSMOSS/REL	R/3 Release	nvarchar	10	0	CHAR	(N' ')	Yes	/SAPSMOSS/REL	/SAPSMOSS/R3REL	Allow NULL?
119	/SAPSMOSS/COMP	Area	nvarchar	20	0	CHAR	(N' ')	Yes		/SAPSMOSS/R3COMP	Allow NULL?
120	/SAPSMOSS/FRONT	Frontend	nvarchar	10	0	CHAR	(N' ')	Yes	/SAPSMOSS/FRNT	/SAPSMOSS/FRONTEND	Allow NULL?
121	/SAPSMOSS/SYSTYP	R/3 System type	char	1	0	CHAR	(N' ')	Yes	/SAPSMOSS/SYST	/SAPSMOSS/R3SYSTYPE	Allow NULL?
122	/SAPSMOSS/ADDID	Add-on ID	nvarchar	10	0	CHAR	(N' ')	Yes	/SAPSMOSS/ADDID	/SAPSMOSS/R3ADDID	Allow NULL?
123	/SAPSMOSS/ADDREL	Add-On Release	nvarchar	10	0	CHAR	(N' ')	Yes	/SAPSMOSS/ADDRL	/SAPSMOSS/R3ADDREL	Allow NULL?
124	/SAPSMOSS/TSTMP	SAPNet time stamp	nvarchar	14	0	NUMC	(N'00000000000000')	Yes		/SAPSMOSS/NSTSTMP	Allow NULL?
125	/SAPSMOSS/STATUS	Status of R/3 notification in SAPNet	char	1	0	CHAR	(N' ')	Yes	/SAPSMOSS/STAT	/SAPSMOSS/STATUS	Allow NULL?
126	/SAPSMOSS/ERDAT	Date on which notification was completed at SAP	nvarchar	8	0	DATS	(N'00000000')	Yes		/SAPSMOSS/ERDAT	Allow NULL?
127	/SAPSMOSS/ERZEIT	Time when notification was completed at SAP	nvarchar	6	0	TIMS	(N'000000')	Yes		/SAPSMOSS/ERZEIT	Allow NULL?
128	/SAPSMOSS/SYSID	Name of SAP System	nvarchar	8	0	CHAR	(N' ')	Yes		SYSYSID	Allow NULL?
129	/SAPSMOSS/MANDT	Client ID	nvarchar	3	0	CLNT	(N'000')	Yes	*	SYMANDT	Allow NULL?
130	PSP_NR	WBS Element	nvarchar	8	0	NUMC	(N'00000000')	Yes	*	PS_POSNR	Allow NULL?
131	ESTIMATED_COSTS	Estimated Costs for a Claim	decimal	13	2	CURR	((0))	Yes		PS_COSTS
132	CLAIMED_COSTS	Costs Claimed	decimal	13	2	CURR	((0))	Yes		COSTS_CLAIM
133	RESULT_COSTS	Costs Accepted	decimal	13	2	CURR	((0))	Yes		COSTS_RESULT
134	CHANCE	Chance of Completing a Claim	nvarchar	2	0	NUMC	(N'00')	Yes		PS_CHANCE	Allow NULL?
135	OPPONENT	Partner Type	nvarchar	2	0	CHAR	(N' ')	Yes		PS_OPPONENT	Allow NULL?
136	KALNR	Cost Estimate Number for Cost Est. w/o Qty Structure	nvarchar	12	0	NUMC	(N'000000000000')	Yes	*	CK_KALNR	Allow NULL?
137	KALVAR	Costing Variant for Postprocessing with Unit Costing	nvarchar	4	0	CHAR	(N' ')	Yes	*	CK_KALVAR	Allow NULL?
138	OBJNR_REAL	Object number of real CO account assignment	nvarchar	22	0	CHAR	(N' ')	Yes	ONR00	J_OBJNR_REAL	Allow NULL?
139	OBJNR_STAT	Auxiliary account assignment 1	nvarchar	22	0	CHAR	(N' ')	Yes	ONR00	OBJNR_N1	Allow NULL?
140	PHASE	Notification Processing Phase	char	1	0	CHAR	(N' ')	Yes		QM_PHASE	Allow NULL?
141	/ISDFPS/OBJNR	Object number	nvarchar	22	0	CHAR	(N' ')	Yes	*	J_OBJNR	Allow NULL?
142	LOGSYSTEM	Logical System	nvarchar	10	0	CHAR	(N' ')	Yes	*	LOGSYSTEM	Allow NULL?
143	/ISDFPS/MEQUI	Master Equipment	nvarchar	18	0	CHAR	(N' ')	Yes	*	/ISDFPS/MEQUI	Allow NULL?
144	SHN_OBJTY	Object types of the CIM resource	nvarchar	2	0	CHAR	(N' ')	Yes		CR_OBJTY	Allow NULL?
145	SHN_OBJID	Object ID of the resource	nvarchar	8	0	NUMC	(N'00000000')	Yes	*	CR_OBJID	Allow NULL?
146	SHN_FUNCT_LOC	Functional Location	nvarchar	30	0	CHAR	(N' ')	Yes	*	TPLNR	Allow NULL?
147	SHN_EQUIPMENT	Equipment Number	nvarchar	18	0	CHAR	(N' ')	Yes	*	EQUNR	Allow NULL?
148	SHN_ORIGIN	Origin or Use of Shift Note or Report	nvarchar	2	0	NUMC	(N'00')	Yes		COCF_SRN_ORIGIN	Allow NULL?
149	UII	Unique Item Identifier	nvarchar	72	0	CHAR	(N' ')	Yes		UII_CHAR72	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