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