SAP ABAP View VIQMELST_IFLOS (Selection of PM messages by status (altern. ID adjusted))
Hierarchy
BBPCRM (Software Component) BBPCRM
   CRM-MSE (Application Component) Mobile Service
     IWOC (Package) Application Development R/3 Work Order Cycle
Basic Data
View Type D Database View 
Database View VIQMELST_IFLOS  
Short Description Selection of PM messages by status (altern. ID adjusted)    
Root table JEST   Individual Object Status 
Table
# Table Name Foreign Table Foreign Field Foreign DIR
1 JEST JEST
2 QMEL  
3 QMIH  
4 ILOA  
5 IFLOS  
Join Conditions
# Table Name Field Name Negation Operator Constants Cont. line AND/OR Offset F Length Mco Field
1 JEST MANDT JL EQ 0 0
2 QMEL MANDT JR EQ AND 0 0
3 JEST OBJNR JL EQ 0 0
4 QMEL OBJNR JR EQ AND 0 0
5 QMIH MANDT JL EQ 0 0
6 QMEL MANDT JR EQ AND 0 0
7 QMIH QMNUM JL EQ 0 0
8 QMEL QMNUM JR EQ AND 0 0
9 ILOA MANDT JL EQ 0 0
10 QMIH MANDT JR EQ AND 0 0
11 ILOA ILOAN JL EQ 0 0
12 QMIH ILOAN JR EQ AND 0 0
13 IFLOS MANDT JL EQ 0 0
14 ILOA MANDT JR EQ AND 0 0
15 IFLOS TPLNR JL EQ 0 0
16 ILOA TPLNR JR EQ AND 0 0
17 JEST STAT EQ 'I0068' OR 0 0
18 JEST STAT EQ 'I0069' OR 0 0
19 JEST STAT EQ 'I0070' OR 0 0
20 JEST STAT EQ 'I0076' OR 0 0
21 JEST STAT EQ 'I0072' OR 0 0
22 JEST STAT EQ 'I0167' AND 0 0
23 JEST INACT EQ ' ' AND 0 0
24 IFLOS ACTVS EQ 'X' 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 * QMEL *    
6 - QMEL MANDT   MANDT Client
7 - QMEL QMNUM   QMNUM Message Number
8 QMART QMEL QMART   QMART Message Type
9 QMTXT QMEL QMTXT   QMTXT Short Text
10 ARTPR QMEL ARTPR   ARTPR Priority Type
11 PRIOK QMEL PRIOK   PRIOK Priority
12 ERNAM QMEL ERNAM   ERNAM Name of Person who Created the Object
13 ERDAT QMEL ERDAT   ERDAT Date on which the record was created
14 AENAM QMEL AENAM   AENAM Name of Person Who Changed Object
15 AEDAT QMEL AEDAT   AEDAT Last Changed On
16 MZEIT QMEL MZEIT   MZEIT Notification Time
17 QMDAT QMEL QMDAT   QMDAT Date of Notification
18 QMNAM QMEL QMNAM   QMNAM Name of declarant
19 STRMN QMEL STRMN   STRMN Desired Start Date
20 STRUR QMEL STRUR   STRUR Desired Start Time
21 LTRMN QMEL LTRMN   LTRMN Required Finish Date
22 LTRUR QMEL LTRUR   LTRUR Required End Date-Time
23 WAERS QMEL WAERS   WAERS Currency Key
24 AUFNR QMEL AUFNR   AUFNR Order Number
25 VERID QMEL VERID   VERID Production Version
26 RM_MATNR QMEL RM_MATNR   RM_MATNR Material number of the production version
27 RM_WERKS QMEL RM_WERKS   RM_WERKS Plant of production version
28 SA_AUFNR QMEL SA_AUFNR   SA_AUFNR Run schedule header number
29 MATNR QMEL MATNR   MATNR Material Number
30 REVLV QMEL REVLV   REVLV Revision level
31 MATKL QMEL MATKL   MATKL Material Group
32 PRDHA QMEL PRDHA   PRODH_D Product Hierarchy
33 KZKRI QMEL KZKRI   KZKRI Indicator: Critical part
34 KZDKZ QMEL KZDKZ   KZDKZ Documentation required indicator
35 KUNUM QMEL KUNUM   QKUNUM Account Number of Customer
36 FEKNZ QMEL FEKNZ   FEKNZ Error Records Exist
37 MAKNZ QMEL MAKNZ   MAKNZ Task Records Exist
38 - QMEL OBJNR   QMOBJNR Object Number for Status Management
39 QMDAB QMEL QMDAB   QMDAB Date for Completion of Notification
40 QMZAB QMEL QMZAB   QMZAB Completion Time of Notification
41 RBNR QMEL RBNR   RBNR Report layout
42 RBNRI QMEL RBNRI   RBNRI Origin of Notifications Catalog Profile
43 INDTX QMEL INDTX   INDLTX Object Long Text Available
44 KZMLA QMEL KZMLA   KZMLA Primary language indicator for text segment
45 HERKZ QMEL HERKZ   HERKZ Origin Indicator for Notification
46 BEZDT QMEL BEZDT   BEZDT Notification Reference Date
47 BEZUR QMEL BEZUR   BEZUR_D Notification Reference Time
48 LIFNUM QMEL LIFNUM   LIFNUM Vendor Account Number
49 BUNAME QMEL BUNAME   BUNAME Author of a Q/PM Notification
50 VBELN QMEL VBELN   KDAUF Sales Order Number
51 BSTNK QMEL BSTNK   BSTKD Customer purchase order number
52 BSTDK QMEL BSTDK   BSTDK Customer purchase order date
53 SPART QMEL SPART   SPART Division
54 VKORG QMEL VKORG   VKORG Sales Organization
55 VTWEG QMEL VTWEG   VTWEG Distribution Channel
56 ADRNR QMEL ADRNR   CADNR Addresses: Address Number
57 ERZEIT QMEL ERZEIT   ERZEIT Time, at Which Record Was Added
58 QMKAT QMEL QMKAT   QMKAT Catalog type - coding
59 QMGRP QMEL QMGRP   QMGRP Code group - coding
60 AUSWIRK QMEL AUSWIRK   QSCENARIO Key for a Scenario
61 TEILEV QMEL TEILEV   QTEILEV Usage of Parts
62 PRUEFLOS QMEL PRUEFLOS   QPLOS Inspection Lot Number
63 CHARG QMEL CHARG   CHARG_D Batch Number
64 LGORTCHARG QMEL LGORTCHARG   QLGORTCHAR Storage Location of Batch
65 LICHN QMEL LICHN   LICHN Vendor Batch Number
66 HERSTELLER QMEL HERSTELLER   QLIFNR Number of Manufacturer
67 EMATNR QMEL EMATNR   EMATN Material number corresponding to manufacturer part number
68 EKORG QMEL EKORG   EKORG Purchasing organization
69 BKGRP QMEL BKGRP   BKGRP Purchasing Group
70 LGORTVORG QMEL LGORTVORG   QLGORTVORG Storage Location for Inspection Lot Stock
71 FERTAUFNR QMEL FERTAUFNR   FERTAUFNR Order Number (Production Order)
72 FERTAUFPL QMEL FERTAUFPL   FERTAUFPL Plan Number for Operations in Order (Production Order)
73 EBELN QMEL EBELN   EBELN Purchasing Document Number
74 EBELP QMEL EBELP   QEBELP Item Number of Purchasing Document
75 MJAHR QMEL MJAHR   MJAHR Year of material document
76 MBLNR QMEL MBLNR   MBLNR Number of Material Document
77 MBLPO QMEL MBLPO   QMBLPO Item in Material Document
78 LS_KDAUF QMEL LS_KDAUF   KDAUF Sales Order Number
79 LS_KDPOS QMEL LS_KDPOS   POSNR Item number of the SD document
80 LS_VBELN QMEL LS_VBELN   VBELN_VL Delivery
81 LS_POSNR QMEL LS_POSNR   QPOSNR_VL Delivery Item
82 FEART QMEL FEART   QFEART Report Type for Defects Recording
83 PNLKN QMEL PNLKN   QLFNKN Current Node Number from Order Counter APLZL
84 MGEIG QMEL MGEIG   MGEIG Defective Quantity (Internal)
85 MGFRD QMEL MGFRD   MGFRD Defective Quantity (External)
86 MGEIN QMEL MGEIN   MGEIN Unit of Measure
87 BZMNG QMEL BZMNG   QBZMNG General Reference Quantity
88 RKMNG QMEL RKMNG   RKMNG Complaint Quantity
89 RGMNG QMEL RGMNG   RGMNG Return Delivery Quantity
90 RKDAT QMEL RKDAT   RKDAT Date of Return Delivery
91 COAUFNR QMEL COAUFNR   COAUFNR Order Number (QM Order)
92 QWRNUM QMEL QWRNUM   QWRNUM Reference Notification Number
93 REFNUM QMEL REFNUM   QMEXTNR External Reference Number
94 KDMAT QMEL KDMAT   MATNR_KU Customer Material Number
95 IDNLF QMEL IDNLF   IDNLF Material Number Used by Vendor
96 SERIALNR QMEL SERIALNR   GERNR Serial Number
97 KZLOESCH QMEL KZLOESCH   KZLOESCH Delete Data Record
98 PRODDAT QMEL PRODDAT   QPRODDAT Production Date
99 DEVICEID QMEL DEVICEID   DEVICEID Additional Device Data
100 VKBUR QMEL VKBUR   VKBUR Sales office
101 VKGRP QMEL VKGRP   VKGRP Sales group
102 AUTKZ QMEL AUTKZ   QAUTKZ Data Record Created with Function 'Create with Copy Model'
103 BEDID QMEL BEDID   BEDID ID of the capacity requirements record
104 BEDZL QMEL BEDZL   CIM_COUNT Internal counter
105 PROFIL_TYP QMEL PROFIL_TYP   OTYPE Object Type
106 PROFIL_ID QMEL PROFIL_ID   OBJEKTID Object ID
107 HANDLE QMEL HANDLE   TSEGGUID Globally unique identifier (linked to time segment, etc)
108 TSEGFL QMEL TSEGFL   TSEGEXISTS Time segment exists
109 TSEGTP QMEL TSEGTP   TSEGTEMPLA Template
110 TZONSO QMEL TZONSO   TZONSO Time zone for notification
111 TZONID QMEL TZONID   TZONSMID Origin of Time Zone in Notification
112 FUNKTION QMEL FUNKTION   QNFUNKTION Keys for Function in Action Box
113 /SAPSMOSS/INSTN QMEL /SAPSMOSS/INSTN   /SAPSMOSS/R3INSTN Installation number
114 /SAPSMOSS/MNUMM QMEL /SAPSMOSS/MNUMM   /SAPSMOSS/MNUMM SAPNet notification number
115 /SAPSMOSS/OSSYS QMEL /SAPSMOSS/OSSYS   /SAPSMOSS/OSSYS Operating system and version
116 /SAPSMOSS/DBSYS QMEL /SAPSMOSS/DBSYS   /SAPSMOSS/DBSYS Database system
117 /SAPSMOSS/REL QMEL /SAPSMOSS/REL   /SAPSMOSS/R3REL R/3 Release
118 /SAPSMOSS/COMP QMEL /SAPSMOSS/COMP   /SAPSMOSS/R3COMP Area
119 /SAPSMOSS/FRONT QMEL /SAPSMOSS/FRONT   /SAPSMOSS/FRONTEND Frontend
120 /SAPSMOSS/SYSTYP QMEL /SAPSMOSS/SYSTYP   /SAPSMOSS/R3SYSTYPE R/3 System type
121 /SAPSMOSS/ADDID QMEL /SAPSMOSS/ADDID   /SAPSMOSS/R3ADDID Add-on ID
122 /SAPSMOSS/ADDREL QMEL /SAPSMOSS/ADDREL   /SAPSMOSS/R3ADDREL Add-On Release
123 /SAPSMOSS/TSTMP QMEL /SAPSMOSS/TSTMP   /SAPSMOSS/NSTSTMP SAPNet time stamp
124 /SAPSMOSS/STATUS QMEL /SAPSMOSS/STATUS   /SAPSMOSS/STATUS Status of R/3 notification in SAPNet
125 /SAPSMOSS/ERDAT QMEL /SAPSMOSS/ERDAT   /SAPSMOSS/ERDAT Date on which notification was completed at SAP
126 /SAPSMOSS/ERZEIT QMEL /SAPSMOSS/ERZEIT   /SAPSMOSS/ERZEIT Time when notification was completed at SAP
127 /SAPSMOSS/SYSID QMEL /SAPSMOSS/SYSID   SYSYSID Name of SAP System
128 /SAPSMOSS/MANDT QMEL /SAPSMOSS/MANDT   SYMANDT Client ID
129 PSP_NR QMEL PSP_NR   PS_POSNR WBS Element
130 ESTIMATED_COSTS QMEL ESTIMATED_COSTS   PS_COSTS Estimated Costs for a Claim
131 CLAIMED_COSTS QMEL CLAIMED_COSTS   COSTS_CLAIM Costs Claimed
132 RESULT_COSTS QMEL RESULT_COSTS   COSTS_RESULT Costs Accepted
133 CHANCE QMEL CHANCE   PS_CHANCE Chance of Completing a Claim
134 OPPONENT QMEL OPPONENT   PS_OPPONENT Partner Type
135 KALNR QMEL KALNR   CK_KALNR Cost Estimate Number for Cost Est. w/o Qty Structure
136 KALVAR QMEL KALVAR   CK_KALVAR Costing Variant for Postprocessing with Unit Costing
137 OBJNR_REAL QMEL OBJNR_REAL   J_OBJNR_REAL Object number of real CO account assignment
138 OBJNR_STAT QMEL OBJNR_STAT   OBJNR_N1 Auxiliary account assignment 1
139 PHASE QMEL PHASE   QM_PHASE Notification Processing Phase
140 /ISDFPS/OBJNR QMEL /ISDFPS/OBJNR   J_OBJNR Object number
141 LOGSYSTEM QMEL LOGSYSTEM   LOGSYSTEM Logical System
142 /ISDFPS/MEQUI QMEL /ISDFPS/MEQUI   /ISDFPS/MEQUI Master Equipment
143 SHN_OBJTY QMEL SHN_OBJTY   CR_OBJTY Object types of the CIM resource
144 SHN_OBJID QMEL SHN_OBJID   CR_OBJID Object ID of the resource
145 SHN_FUNCT_LOC QMEL SHN_FUNCT_LOC   TPLNR Functional Location
146 SHN_EQUIPMENT QMEL SHN_EQUIPMENT   EQUNR Equipment Number
147 SHN_ORIGIN QMEL SHN_ORIGIN   COCF_SRN_ORIGIN Origin or Use of Shift Note or Report
148 UII QMEL UII   UII_CHAR72 Unique Item Identifier
149 ILOAN ILOA ILOAN   ILOAN Location and account assignment for technical object
150 IWERK QMIH IWERK   IWERK Maintenance Planning Plant
151 EQUNR QMIH EQUNR   EQUNR Equipment Number
152 BAUTL QMIH BAUTL   BAUTL Assembly
153 EBORT QMIH EBORT   EBORT Installation Point for Subitem
154 MSAUS QMIH MSAUS   MSAUS Breakdown Indicator
155 AUSVN QMIH AUSVN   AUSVN Start of Malfunction (Date)
156 AUSBS QMIH AUSBS   AUSBS End of Malfunction (Date)
157 AUZTV QMIH AUZTV   AUZTV Start of Malfunction (Time)
158 AUZTB QMIH AUZTB   AUZTB End of Malfunction (Time)
159 AUSZT QMIH AUSZT   AUSZT Breakdown Duration
160 MAUEH QMIH MAUEH   MAUEH Unit for Breakdown Duration
161 BTPLN QMIH BTPLN   BTPLN Functional Location Affected
162 BEQUI QMIH BEQUI   BEQUI Equipment Affected
163 AUSWK QMIH AUSWK   AUSWK Effect on Operation
164 VERFV QMIH VERFV   VERFV Availability Before Malfunction
165 VERFN QMIH VERFN   VERFN Availability After Malfunction
166 VERFM QMIH VERFM   VERFM Availability After Completion of Task
167 ANLZV QMIH ANLZV   ANLZV System Condition Before Malfunction
168 ANLZN QMIH ANLZN   ANLZN System Condition After Malfunction
169 ANLZE QMIH ANLZE   ANLZE System Condition After Completion of Task
170 INSPK QMIH INSPK   INSPK Name of Person Responsible for Technical Inspection
171 DATAN QMIH DATAN   DATAN Date of Technical Inspection
172 INGRP QMIH INGRP   INGRP Planner Group for Customer Service and Plant Maintenance
173 TPLNR IFLOS STRNO   ILOM_STRNO Functional location label
174 ABCKZ ILOA ABCKZ   ABCKZ ABC Indicator for Technical Object
175 EQFNR ILOA EQFNR   EQFNR Sort Field
176 SWERK ILOA SWERK   SWERK Maintenance Plant
177 STORT ILOA STORT   PMLOC Location of maintenance object
178 MSGRP ILOA MSGRP   RAUMNR Room
179 BEBER ILOA BEBER   BEBER Organizational Area
180 GSBER ILOA GSBER   GSBER Business Area
181 KOKRS ILOA KOKRS   KOKRS Controlling Area
182 KOSTL ILOA KOSTL   KOSTL Cost Center
183 BUKRS ILOA BUKRS   BUKRS Company Code
184 ANLNR ILOA ANLNR   ANLN1 Main Asset Number
185 ANLUN ILOA ANLUN   ANLN2 Asset Subnumber
186 PPSID ILOA PPSID   PPSID Object ID of PP work center
187 ILOAI QMIH ILOAI   ILOAI ILOA Individual
188 ABCKZI ILOA ABCKZI   INH_ABCKZI Data origin for ABC indicator field
189 EQFNRI ILOA EQFNRI   INH_EQFNRI Data origin for sort field
190 SWERKI ILOA SWERKI   INH_SWERKI Data origin for maintenance plant field
191 STORTI ILOA STORTI   INH_STORTI Data origin for location field
192 MSGRPI ILOA MSGRPI   INH_MSGRPI Data origin for room number field
193 BEBERI ILOA BEBERI   INH_BEBERI Data origin for company area field
194 CR_OBJTY ILOA CR_OBJTY   CR_OBJTY Object types of the CIM resource
195 PPSIDI ILOA PPSIDI   INH_PPSIDI Data origin for PP work center field
196 GSBERI ILOA GSBERI   INH_GSBERI Data origin for business area field
197 KOKRSI ILOA KOKRSI   INH_KOKRSI Data origin for controlling area field
198 KOSTLI ILOA KOSTLI   INH_KOSTLI Data origin for cost center field
199 PROID ILOA PROID   PS_PSP_PNR Work Breakdown Structure Element (WBS Element)
200 PROIDI ILOA PROIDI   INH_PROIDI Data origin for WBS element field
201 BUKRSI ILOA BUKRSI   INH_BUKRSI Data origin for company code field
202 ANLNRI ILOA ANLNRI   INH_ANLNRI Data origin for asset main no./sub-no. fields
203 ANLUNI ILOA ANLUNI   INHER Data origin indicator
204 DAUFN ILOA DAUFN   DAUFN Standing order number
205 DAUFNI ILOA DAUFNI   INH_DAUFNI Data origin of standing order number field
206 KAUFN ILOA AUFNR   ILOM_ORDST Settlement order
207 AUFNRI ILOA AUFNRI   INH_AUFNRI Data origin for settlement order field
208 ADRNR_ILOA ILOA ADRNR   AD_ADDRNUM Address number
209 OWNER ILOA OWNER   ILOM_OWNER Object reference indicator
210 KDAUF QMIH KDAUF   VBELN_VA Sales Document
211 KDPOS QMIH KDPOS   POSNR_VA Sales Document Item
212 CROBJTY QMEL CROBJTY   CR_OBJTY Object types of the CIM resource
213 ARBPL QMEL ARBPL   LGWID Object ID of the Work Center
214 ARBPLWERK QMEL ARBPLWERK   QARBPWERKS Plant for Work Center
215 AEZEIT QMEL AEZEIT   AEZEIT Time of Change
216 MAWERK QMEL MAWERK   QMAWERKS Plant for Material
217 QMCOD QMEL QMCOD   QMCOD Coding
218 WARPL QMIH WARPL   WARPL Maintenance Plan
219 WAPOS QMIH WAPOS   WAPOS Maintenance item
220 ALKEY IFLOS ALKEY   ILOM_ALKEY Labeling system for functional locations
221 VERSN IFLOS VERSN   ILOM_VERSN Version of functional location label
222 TPLNR_INT IFLOS TPLNR   TPLNR Functional Location
                 
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 46C