SAP ABAP View VQQMELST (Select QM messages via status)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ QQM (Package) QM quality notification

Basic Data

View Type	D	Database View
Database View	VQQMELST
Short Description	Select QM messages via status
Root table	QMEL	Quality Notification

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	QMEL	QMEL
2	JEST	JEST
3	QMIH

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	JEST	OBJNR	JL	EQ				0	0
2	QMEL	OBJNR	JR	EQ			AND	0	0
3	QMIH	QMNUM	JL	EQ				0	0
4	QMEL	QMNUM	JR	EQ			AND	0	0
5	JEST	MANDT	JL	EQ				0	0
6	QMEL	MANDT	JR	EQ			AND	0	0
7	QMIH	MANDT	JL	EQ				0	0
8	QMEL	MANDT	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	JEST	MANDT		☐	MANDT	☐	Client
2	OBJNR	JEST	OBJNR		☐	J_OBJNR	☐	Object number
3	STAT	JEST	STAT		☐	J_STATUS	☐	Object status
4	*	QMEL	*		☐		☐
5	-	QMEL	MANDT		☐	MANDT	☐	Client
6	QMNUM	QMEL	QMNUM		☐	QMNUM	☐	Message Number
7	QMART	QMEL	QMART		☐	QMART	☐	Message Type
8	QMTXT	QMEL	QMTXT		☐	QMTXT	☐	Short Text
9	ARTPR	QMEL	ARTPR		☐	ARTPR	☐	Priority Type
10	PRIOK	QMEL	PRIOK		☐	PRIOK	☐	Priority
11	ERNAM	QMEL	ERNAM		☐	ERNAM	☐	Name of Person who Created the Object
12	ERDAT	QMEL	ERDAT		☐	ERDAT	☐	Date on which the record was created
13	AENAM	QMEL	AENAM		☐	AENAM	☐	Name of Person Who Changed Object
14	AEDAT	QMEL	AEDAT		☐	AEDAT	☐	Last Changed On
15	MZEIT	QMEL	MZEIT		☐	MZEIT	☐	Notification Time
16	QMDAT	QMEL	QMDAT		☐	QMDAT	☐	Date of Notification
17	QMNAM	QMEL	QMNAM		☐	QMNAM	☐	Name of declarant
18	STRMN	QMEL	STRMN		☐	STRMN	☐	Desired Start Date
19	STRUR	QMEL	STRUR		☐	STRUR	☐	Desired Start Time
20	LTRMN	QMEL	LTRMN		☐	LTRMN	☐	Required Finish Date
21	LTRUR	QMEL	LTRUR		☐	LTRUR	☐	Required End Date-Time
22	WAERS	QMEL	WAERS		☐	WAERS	☐	Currency Key
23	AUFNR	QMEL	AUFNR		☐	AUFNR	☐	Order Number
24	VERID	QMEL	VERID		☐	VERID	☐	Production Version
25	RM_MATNR	QMEL	RM_MATNR		☐	RM_MATNR	☐	Material number of the production version
26	RM_WERKS	QMEL	RM_WERKS		☐	RM_WERKS	☐	Plant of production version
27	SA_AUFNR	QMEL	SA_AUFNR		☐	SA_AUFNR	☐	Run schedule header number
28	MATNR	QMEL	MATNR		☐	MATNR	☐	Material Number
29	REVLV	QMEL	REVLV		☐	REVLV	☐	Revision level
30	MATKL	QMEL	MATKL		☐	MATKL	☐	Material Group
31	PRDHA	QMEL	PRDHA		☐	PRODH_D	☐	Product Hierarchy
32	KZKRI	QMEL	KZKRI		☐	KZKRI	☐	Indicator: Critical part
33	KZDKZ	QMEL	KZDKZ		☐	KZDKZ	☐	Documentation required indicator
34	KUNUM	QMEL	KUNUM		☐	QKUNUM	☐	Account Number of Customer
35	FEKNZ	QMEL	FEKNZ		☐	FEKNZ	☐	Error Records Exist
36	MAKNZ	QMEL	MAKNZ		☐	MAKNZ	☐	Task Records Exist
37	-	QMEL	OBJNR		☐	QMOBJNR	☐	Object Number for Status Management
38	QMDAB	QMEL	QMDAB		☐	QMDAB	☐	Date for Completion of Notification
39	QMZAB	QMEL	QMZAB		☐	QMZAB	☐	Completion Time of Notification
40	RBNR	QMEL	RBNR		☐	RBNR	☐	Report layout
41	RBNRI	QMEL	RBNRI		☐	RBNRI	☐	Origin of Notifications Catalog Profile
42	INDTX	QMEL	INDTX		☐	INDLTX	☐	Object Long Text Available
43	KZMLA	QMEL	KZMLA		☐	KZMLA	☐	Primary language indicator for text segment
44	HERKZ	QMEL	HERKZ		☐	HERKZ	☐	Origin Indicator for Notification
45	BEZDT	QMEL	BEZDT		☐	BEZDT	☐	Notification Reference Date
46	BEZUR	QMEL	BEZUR		☐	BEZUR_D	☐	Notification Reference Time
47	LIFNUM	QMEL	LIFNUM		☐	LIFNUM	☐	Vendor Account Number
48	BUNAME	QMEL	BUNAME		☐	BUNAME	☐	Author of a Q/PM Notification
49	VBELN	QMEL	VBELN		☐	KDAUF	☐	Sales Order Number
50	BSTNK	QMEL	BSTNK		☐	BSTKD	☐	Customer purchase order number
51	BSTDK	QMEL	BSTDK		☐	BSTDK	☐	Customer purchase order date
52	SPART	QMEL	SPART		☐	SPART	☐	Division
53	VKORG	QMEL	VKORG		☐	VKORG	☐	Sales Organization
54	VTWEG	QMEL	VTWEG		☐	VTWEG	☐	Distribution Channel
55	ADRNR	QMEL	ADRNR		☐	CADNR	☐	Addresses: Address Number
56	AEZEIT	QMEL	AEZEIT		☐	AEZEIT	☐	Time of Change
57	ERZEIT	QMEL	ERZEIT		☐	ERZEIT	☐	Time, at Which Record Was Added
58	MAWERK	QMEL	MAWERK		☐	QMAWERKS	☐	Plant for Material
59	QMKAT	QMEL	QMKAT		☐	QMKAT	☐	Catalog type - coding
60	QMGRP	QMEL	QMGRP		☐	QMGRP	☐	Code group - coding
61	QMCOD	QMEL	QMCOD		☐	QMCOD	☐	Coding
62	AUSWIRK	QMEL	AUSWIRK		☐	QSCENARIO	☐	Key for a Scenario
63	TEILEV	QMEL	TEILEV		☐	QTEILEV	☐	Usage of Parts
64	PRUEFLOS	QMEL	PRUEFLOS		☐	QPLOS	☐	Inspection Lot Number
65	CHARG	QMEL	CHARG		☐	CHARG_D	☐	Batch Number
66	LGORTCHARG	QMEL	LGORTCHARG		☐	QLGORTCHAR	☐	Storage Location of Batch
67	LICHN	QMEL	LICHN		☐	LICHN	☐	Vendor Batch Number
68	HERSTELLER	QMEL	HERSTELLER		☐	QLIFNR	☐	Number of Manufacturer
69	EMATNR	QMEL	EMATNR		☐	EMATN	☐	Material number corresponding to manufacturer part number
70	EKORG	QMEL	EKORG		☐	EKORG	☐	Purchasing organization
71	BKGRP	QMEL	BKGRP		☐	BKGRP	☐	Purchasing Group
72	LGORTVORG	QMEL	LGORTVORG		☐	QLGORTVORG	☐	Storage Location for Inspection Lot Stock
73	FERTAUFNR	QMEL	FERTAUFNR		☐	FERTAUFNR	☐	Order Number (Production Order)
74	FERTAUFPL	QMEL	FERTAUFPL		☐	FERTAUFPL	☐	Plan Number for Operations in Order (Production Order)
75	EBELN	QMEL	EBELN		☐	EBELN	☐	Purchasing Document Number
76	EBELP	QMEL	EBELP		☐	QEBELP	☐	Item Number of Purchasing Document
77	MJAHR	QMEL	MJAHR		☐	MJAHR	☐	Year of material document
78	MBLNR	QMEL	MBLNR		☐	MBLNR	☐	Number of Material Document
79	MBLPO	QMEL	MBLPO		☐	QMBLPO	☐	Item in Material Document
80	LS_KDAUF	QMEL	LS_KDAUF		☐	KDAUF	☐	Sales Order Number
81	LS_KDPOS	QMEL	LS_KDPOS		☐	POSNR	☐	Item number of the SD document
82	LS_VBELN	QMEL	LS_VBELN		☐	VBELN_VL	☐	Delivery
83	LS_POSNR	QMEL	LS_POSNR		☐	QPOSNR_VL	☐	Delivery Item
84	CROBJTY	QMEL	CROBJTY		☐	CR_OBJTY	☐	Object types of the CIM resource
85	ARBPL	QMEL	ARBPL		☐	LGWID	☐	Object ID of the Work Center
86	ARBPLWERK	QMEL	ARBPLWERK		☐	QARBPWERKS	☐	Plant for Work Center
87	FEART	QMEL	FEART		☐	QFEART	☐	Report Type for Defects Recording
88	PNLKN	QMEL	PNLKN		☐	QLFNKN	☐	Current Node Number from Order Counter APLZL
89	MGEIG	QMEL	MGEIG		☐	MGEIG	☐	Defective Quantity (Internal)
90	MGFRD	QMEL	MGFRD		☐	MGFRD	☐	Defective Quantity (External)
91	MGEIN	QMEL	MGEIN		☐	MGEIN	☐	Unit of Measure
92	BZMNG	QMEL	BZMNG		☐	QBZMNG	☐	General Reference Quantity
93	RKMNG	QMEL	RKMNG		☐	RKMNG	☐	Complaint Quantity
94	RGMNG	QMEL	RGMNG		☐	RGMNG	☐	Return Delivery Quantity
95	RKDAT	QMEL	RKDAT		☐	RKDAT	☐	Date of Return Delivery
96	COAUFNR	QMEL	COAUFNR		☐	COAUFNR	☐	Order Number (QM Order)
97	QWRNUM	QMEL	QWRNUM		☐	QWRNUM	☐	Reference Notification Number
98	REFNUM	QMEL	REFNUM		☐	QMEXTNR	☐	External Reference Number
99	KDMAT	QMEL	KDMAT		☐	MATNR_KU	☐	Customer Material Number
100	IDNLF	QMEL	IDNLF		☐	IDNLF	☐	Material Number Used by Vendor
101	SERIALNR	QMEL	SERIALNR		☐	GERNR	☐	Serial Number
102	KZLOESCH	QMEL	KZLOESCH		☐	KZLOESCH	☐	Delete Data Record
103	PRODDAT	QMEL	PRODDAT		☐	QPRODDAT	☐	Production Date
104	DEVICEID	QMEL	DEVICEID		☐	DEVICEID	☐	Additional Device Data
105	VKBUR	QMEL	VKBUR		☐	VKBUR	☐	Sales office
106	VKGRP	QMEL	VKGRP		☐	VKGRP	☐	Sales group
107	AUTKZ	QMEL	AUTKZ		☐	QAUTKZ	☐	Data Record Created with Function 'Create with Copy Model'
108	BEDID	QMEL	BEDID		☐	BEDID	☐	ID of the capacity requirements record
109	BEDZL	QMEL	BEDZL		☐	CIM_COUNT	☐	Internal counter
110	PROFIL_TYP	QMEL	PROFIL_TYP		☐	OTYPE	☐	Object Type
111	PROFIL_ID	QMEL	PROFIL_ID		☐	OBJEKTID	☐	Object ID
112	HANDLE	QMEL	HANDLE		☐	TSEGGUID	☐	Globally unique identifier (linked to time segment, etc)
113	TSEGFL	QMEL	TSEGFL		☐	TSEGEXISTS	☐	Time segment exists
114	TSEGTP	QMEL	TSEGTP		☐	TSEGTEMPLA	☐	Template
115	TZONSO	QMEL	TZONSO		☐	TZONSO	☐	Time zone for notification
116	TZONID	QMEL	TZONID		☐	TZONSMID	☐	Origin of Time Zone in Notification
117	FUNKTION	QMEL	FUNKTION		☐	QNFUNKTION	☐	Keys for Function in Action Box
118	/SAPSMOSS/INSTN	QMEL	/SAPSMOSS/INSTN		☐	/SAPSMOSS/R3INSTN	☐	Installation number
119	/SAPSMOSS/MNUMM	QMEL	/SAPSMOSS/MNUMM		☐	/SAPSMOSS/MNUMM	☐	SAPNet notification number
120	/SAPSMOSS/OSSYS	QMEL	/SAPSMOSS/OSSYS		☐	/SAPSMOSS/OSSYS	☐	Operating system and version
121	/SAPSMOSS/DBSYS	QMEL	/SAPSMOSS/DBSYS		☐	/SAPSMOSS/DBSYS	☐	Database system
122	/SAPSMOSS/REL	QMEL	/SAPSMOSS/REL		☐	/SAPSMOSS/R3REL	☐	R/3 Release
123	/SAPSMOSS/COMP	QMEL	/SAPSMOSS/COMP		☐	/SAPSMOSS/R3COMP	☐	Area
124	/SAPSMOSS/FRONT	QMEL	/SAPSMOSS/FRONT		☐	/SAPSMOSS/FRONTEND	☐	Frontend
125	/SAPSMOSS/SYSTYP	QMEL	/SAPSMOSS/SYSTYP		☐	/SAPSMOSS/R3SYSTYPE	☐	R/3 System type
126	/SAPSMOSS/ADDID	QMEL	/SAPSMOSS/ADDID		☐	/SAPSMOSS/R3ADDID	☐	Add-on ID
127	/SAPSMOSS/ADDREL	QMEL	/SAPSMOSS/ADDREL		☐	/SAPSMOSS/R3ADDREL	☐	Add-On Release
128	/SAPSMOSS/TSTMP	QMEL	/SAPSMOSS/TSTMP		☐	/SAPSMOSS/NSTSTMP	☐	SAPNet time stamp
129	/SAPSMOSS/STATUS	QMEL	/SAPSMOSS/STATUS		☐	/SAPSMOSS/STATUS	☐	Status of R/3 notification in SAPNet
130	/SAPSMOSS/ERDAT	QMEL	/SAPSMOSS/ERDAT		☐	/SAPSMOSS/ERDAT	☐	Date on which notification was completed at SAP
131	/SAPSMOSS/ERZEIT	QMEL	/SAPSMOSS/ERZEIT		☐	/SAPSMOSS/ERZEIT	☐	Time when notification was completed at SAP
132	/SAPSMOSS/SYSID	QMEL	/SAPSMOSS/SYSID		☐	SYSYSID	☐	Name of SAP System
133	/SAPSMOSS/MANDT	QMEL	/SAPSMOSS/MANDT		☐	SYMANDT	☐	Client ID
134	PSP_NR	QMEL	PSP_NR		☐	PS_POSNR	☐	WBS Element
135	ESTIMATED_COSTS	QMEL	ESTIMATED_COSTS		☐	PS_COSTS	☐	Estimated Costs for a Claim
136	CLAIMED_COSTS	QMEL	CLAIMED_COSTS		☐	COSTS_CLAIM	☐	Costs Claimed
137	RESULT_COSTS	QMEL	RESULT_COSTS		☐	COSTS_RESULT	☐	Costs Accepted
138	CHANCE	QMEL	CHANCE		☐	PS_CHANCE	☐	Chance of Completing a Claim
139	OPPONENT	QMEL	OPPONENT		☐	PS_OPPONENT	☐	Partner Type
140	KALNR	QMEL	KALNR		☐	CK_KALNR	☐	Cost Estimate Number for Cost Est. w/o Qty Structure
141	KALVAR	QMEL	KALVAR		☐	CK_KALVAR	☐	Costing Variant for Postprocessing with Unit Costing
142	OBJNR_REAL	QMEL	OBJNR_REAL		☐	J_OBJNR_REAL	☐	Object number of real CO account assignment
143	OBJNR_STAT	QMEL	OBJNR_STAT		☐	OBJNR_N1	☐	Auxiliary account assignment 1
144	PHASE	QMEL	PHASE		☐	QM_PHASE	☐	Notification Processing Phase
145	/ISDFPS/OBJNR	QMEL	/ISDFPS/OBJNR		☐	J_OBJNR	☐	Object number
146	LOGSYSTEM	QMEL	LOGSYSTEM		☐	LOGSYSTEM	☐	Logical System
147	/ISDFPS/MEQUI	QMEL	/ISDFPS/MEQUI		☐	/ISDFPS/MEQUI	☐	Master Equipment
148	SHN_OBJTY	QMEL	SHN_OBJTY		☐	CR_OBJTY	☐	Object types of the CIM resource
149	SHN_OBJID	QMEL	SHN_OBJID		☐	CR_OBJID	☐	Object ID of the resource
150	SHN_FUNCT_LOC	QMEL	SHN_FUNCT_LOC		☐	TPLNR	☐	Functional Location
151	SHN_EQUIPMENT	QMEL	SHN_EQUIPMENT		☐	EQUNR	☐	Equipment Number
152	SHN_ORIGIN	QMEL	SHN_ORIGIN		☐	COCF_SRN_ORIGIN	☐	Origin or Use of Shift Note or Report
153	UII	QMEL	UII		☐	UII_CHAR72	☐	Unique Item Identifier
154	AUSVN	QMIH	AUSVN		☐	AUSVN	☐	Start of Malfunction (Date)
155	AUSBS	QMIH	AUSBS		☐	AUSBS	☐	End of Malfunction (Date)
156	AUZTV	QMIH	AUZTV		☐	AUZTV	☐	Start of Malfunction (Time)
157	AUZTB	QMIH	AUZTB		☐	AUZTB	☐	End of Malfunction (Time)
158	MSAUS	QMIH	MSAUS		☐	MSAUS	☐	Breakdown Indicator
159	BTPLN	QMIH	BTPLN		☐	BTPLN	☐	Functional Location Affected
160	BEQUI	QMIH	BEQUI		☐	BEQUI	☐	Equipment Affected
161	AUSWK	QMIH	AUSWK		☐	AUSWK	☐	Effect on Operation
162	VERFV	QMIH	VERFV		☐	VERFV	☐	Availability Before Malfunction
163	VERFN	QMIH	VERFN		☐	VERFN	☐	Availability After Malfunction
164	VERFM	QMIH	VERFM		☐	VERFM	☐	Availability After Completion of Task
165	ANLZV	QMIH	ANLZV		☐	ANLZV	☐	System Condition Before Malfunction
166	ANLZN	QMIH	ANLZN		☐	ANLZN	☐	System Condition After Malfunction
167	ANLZE	QMIH	ANLZE		☐	ANLZE	☐	System Condition After Completion of Task
168	INACT	JEST	INACT		☐	J_INACT	☐	Indicator: Status Is Inactive

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

History

Last changed by/on	SAP	20130529
SAP Release Created in