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