SAP ABAP View VQQMELST_L (Selection of Q-notifications via status 'Delete mark')

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_L
Short Description	Selection of Q-notifications via status 'Delete mark'
Root table	JEST	Individual Object Status

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	JEST	JEST
2	ONR00
3	ONRQM
4	QMEL

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	ONR00	MANDT	JL	EQ				0	0
2	JEST	MANDT	JR	EQ			AND	0	0
3	ONR00	OBJNR	JL	EQ				0	0
4	JEST	OBJNR	JR	EQ			AND	0	0
5	ONR00	MANDT	JL	EQ				0	0
6	ONRQM	MANDT	JR	EQ			AND	0	0
7	ONR00	OBJNR	JL	EQ				0	0
8	ONRQM	OBJNR	JR	EQ			AND	0	0
9	QMEL	MANDT	JL	EQ				0	0
10	ONRQM	MANDT	JR	EQ			AND	0	0
11	QMEL	QMNUM	JL	EQ				0	0
12	ONRQM	QMNUM	JR	EQ			AND	0	0
13	JEST	STAT		EQ	'I0076'		AND	0	0
14	JEST	INACT		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	QMNUM	QMEL	QMNUM		☐	QMNUM	☐	Message Number
5	QMART	QMEL	QMART		☐	QMART	☐	Message Type
6	QMTXT	QMEL	QMTXT		☐	QMTXT	☐	Short Text
7	PRIOK	QMEL	PRIOK		☐	PRIOK	☐	Priority
8	ERNAM	QMEL	ERNAM		☐	ERNAM	☐	Name of Person who Created the Object
9	ERDAT	QMEL	ERDAT		☐	ERDAT	☐	Date on which the record was created
10	AENAM	QMEL	AENAM		☐	AENAM	☐	Name of Person Who Changed Object
11	AEDAT	QMEL	AEDAT		☐	AEDAT	☐	Last Changed On
12	MZEIT	QMEL	MZEIT		☐	MZEIT	☐	Notification Time
13	QMDAT	QMEL	QMDAT		☐	QMDAT	☐	Date of Notification
14	QMNAM	QMEL	QMNAM		☐	QMNAM	☐	Name of declarant
15	STRMN	QMEL	STRMN		☐	STRMN	☐	Desired Start Date
16	STRUR	QMEL	STRUR		☐	STRUR	☐	Desired Start Time
17	LTRMN	QMEL	LTRMN		☐	LTRMN	☐	Required Finish Date
18	LTRUR	QMEL	LTRUR		☐	LTRUR	☐	Required End Date-Time
19	WAERS	QMEL	WAERS		☐	WAERS	☐	Currency Key
20	MATNR	QMEL	MATNR		☐	MATNR	☐	Material Number
21	REVLV	QMEL	REVLV		☐	REVLV	☐	Revision level
22	KUNUM	QMEL	KUNUM		☐	QKUNUM	☐	Account Number of Customer
23	QMDAB	QMEL	QMDAB		☐	QMDAB	☐	Date for Completion of Notification
24	QMZAB	QMEL	QMZAB		☐	QMZAB	☐	Completion Time of Notification
25	RBNR	QMEL	RBNR		☐	RBNR	☐	Report layout
26	AUFNR	QMEL	AUFNR		☐	AUFNR	☐	Order Number
27	VERID	QMEL	VERID		☐	VERID	☐	Production Version
28	RM_MATNR	QMEL	RM_MATNR		☐	RM_MATNR	☐	Material number of the production version
29	RM_WERKS	QMEL	RM_WERKS		☐	RM_WERKS	☐	Plant of production version
30	SA_AUFNR	QMEL	SA_AUFNR		☐	SA_AUFNR	☐	Run schedule header number
31	ARTPR	QMEL	ARTPR		☐	ARTPR	☐	Priority Type
32	FEKNZ	QMEL	FEKNZ		☐	FEKNZ	☐	Error Records Exist
33	MAKNZ	QMEL	MAKNZ		☐	MAKNZ	☐	Task Records Exist
34	RBNRI	QMEL	RBNRI		☐	RBNRI	☐	Origin of Notifications Catalog Profile
35	INDTX	QMEL	INDTX		☐	INDLTX	☐	Object Long Text Available
36	KZMLA	QMEL	KZMLA		☐	KZMLA	☐	Primary language indicator for text segment
37	HERKZ	QMEL	HERKZ		☐	HERKZ	☐	Origin Indicator for Notification
38	BEZDT	QMEL	BEZDT		☐	BEZDT	☐	Notification Reference Date
39	BEZUR	QMEL	BEZUR		☐	BEZUR_D	☐	Notification Reference Time
40	LIFNUM	QMEL	LIFNUM		☐	LIFNUM	☐	Vendor Account Number
41	BUNAME	QMEL	BUNAME		☐	BUNAME	☐	Author of a Q/PM Notification
42	VBELN	QMEL	VBELN		☐	KDAUF	☐	Sales Order Number
43	BSTNK	QMEL	BSTNK		☐	BSTKD	☐	Customer purchase order number
44	BSTDK	QMEL	BSTDK		☐	BSTDK	☐	Customer purchase order date
45	SPART	QMEL	SPART		☐	SPART	☐	Division
46	VKORG	QMEL	VKORG		☐	VKORG	☐	Sales Organization
47	VTWEG	QMEL	VTWEG		☐	VTWEG	☐	Distribution Channel
48	ADRNR	QMEL	ADRNR		☐	CADNR	☐	Addresses: Address Number
49	KZLOESCH	QMEL	KZLOESCH		☐	KZLOESCH	☐	Delete Data Record
50	QMKAT	QMEL	QMKAT		☐	QMKAT	☐	Catalog type - coding
51	QMGRP	QMEL	QMGRP		☐	QMGRP	☐	Code group - coding
52	QMCOD	QMEL	QMCOD		☐	QMCOD	☐	Coding
53	AEZEIT	QMEL	AEZEIT		☐	AEZEIT	☐	Time of Change
54	ERZEIT	QMEL	ERZEIT		☐	ERZEIT	☐	Time, at Which Record Was Added
55	MAWERK	QMEL	MAWERK		☐	QMAWERKS	☐	Plant for Material
56	PRUEFLOS	QMEL	PRUEFLOS		☐	QPLOS	☐	Inspection Lot Number
57	CHARG	QMEL	CHARG		☐	CHARG_D	☐	Batch Number
58	LGORTCHARG	QMEL	LGORTCHARG		☐	QLGORTCHAR	☐	Storage Location of Batch
59	LICHN	QMEL	LICHN		☐	LICHN	☐	Vendor Batch Number
60	HERSTELLER	QMEL	HERSTELLER		☐	QLIFNR	☐	Number of Manufacturer
61	EKORG	QMEL	EKORG		☐	EKORG	☐	Purchasing organization
62	LGORTVORG	QMEL	LGORTVORG		☐	QLGORTVORG	☐	Storage Location for Inspection Lot Stock
63	FERTAUFNR	QMEL	FERTAUFNR		☐	FERTAUFNR	☐	Order Number (Production Order)
64	FERTAUFPL	QMEL	FERTAUFPL		☐	FERTAUFPL	☐	Plan Number for Operations in Order (Production Order)
65	ARBPL	QMEL	ARBPL		☐	LGWID	☐	Object ID of the Work Center
66	ARBPLWERK	QMEL	ARBPLWERK		☐	QARBPWERKS	☐	Plant for Work Center
67	FEART	QMEL	FEART		☐	QFEART	☐	Report Type for Defects Recording
68	PNLKN	QMEL	PNLKN		☐	QLFNKN	☐	Current Node Number from Order Counter APLZL
69	MGEIG	QMEL	MGEIG		☐	MGEIG	☐	Defective Quantity (Internal)
70	MGFRD	QMEL	MGFRD		☐	MGFRD	☐	Defective Quantity (External)
71	MGEIN	QMEL	MGEIN		☐	MGEIN	☐	Unit of Measure
72	RKMNG	QMEL	RKMNG		☐	RKMNG	☐	Complaint Quantity
73	RGMNG	QMEL	RGMNG		☐	RGMNG	☐	Return Delivery Quantity
74	RKDAT	QMEL	RKDAT		☐	RKDAT	☐	Date of Return Delivery
75	COAUFNR	QMEL	COAUFNR		☐	COAUFNR	☐	Order Number (QM Order)
76	SERIALNR	QMEL	SERIALNR		☐	GERNR	☐	Serial Number
77	EBELN	QMEL	EBELN		☐	EBELN	☐	Purchasing Document Number
78	EBELP	QMEL	EBELP		☐	QEBELP	☐	Item Number of Purchasing Document
79	MJAHR	QMEL	MJAHR		☐	MJAHR	☐	Year of material document
80	MBLNR	QMEL	MBLNR		☐	MBLNR	☐	Number of Material Document
81	MBLPO	QMEL	MBLPO		☐	QMBLPO	☐	Item in Material Document
82	LS_KDAUF	QMEL	LS_KDAUF		☐	KDAUF	☐	Sales Order Number
83	LS_KDPOS	QMEL	LS_KDPOS		☐	POSNR	☐	Item number of the SD document
84	LS_VBELN	QMEL	LS_VBELN		☐	VBELN_VL	☐	Delivery
85	LS_POSNR	QMEL	LS_POSNR		☐	QPOSNR_VL	☐	Delivery Item
86	CROBJTY	QMEL	CROBJTY		☐	CR_OBJTY	☐	Object types of the CIM resource

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