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