SAP ABAP View VIQMFEL (Item (including notification header))

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	VIQMFEL
Short Description	Item (including notification header)
Root table	QMFE	Quality notification - items

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	QMFE	QMFE
2	QMEL
3	QMIH
4	ILOA

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	QMFE	MANDT	JR	EQ			AND	0	0
3	QMEL	QMNUM	JL	EQ				0	0
4	QMFE	QMNUM	JR	EQ			AND	0	0
5	QMEL	MANDT	JL	EQ				0	0
6	QMIH	MANDT	JR	EQ			AND	0	0
7	QMEL	QMNUM	JL	EQ				0	0
8	QMIH	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				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	QMFE	MANDT		☐	MANDT	☐	Client
2	QMNUM	QMFE	QMNUM		☐	QMNUM	☐	Message Number
3	FENUM	QMFE	FENUM		☐	FELFD	☐	Item Number in Item Record
4	ERNAM	QMFE	ERNAM		☐	ERNAM	☐	Name of Person who Created the Object
5	ERDAT	QMFE	ERDAT		☐	ERDAT	☐	Date on which the record was created
6	AENAM	QMFE	AENAM		☐	AENAM	☐	Name of Person Who Changed Object
7	AEDAT	QMFE	AEDAT		☐	AEDAT	☐	Last Changed On
8	FETXT	QMFE	FETXT		☐	FETXT	☐	Notification Item Short Text
9	FEGRP	QMFE	FEGRP		☐	FEGRP	☐	Code Group - Problem
10	FECOD	QMFE	FECOD		☐	FECOD	☐	Problem
11	FEVER	QMFE	FEVER		☐	QVERSNR	☐	Version Number
12	OTGRP	QMFE	OTGRP		☐	OTGRP	☐	Code Group - Object Parts
13	OTEIL	QMFE	OTEIL		☐	OTEIL	☐	Part of Object
14	OTVER	QMFE	OTVER		☐	QVERSNR	☐	Version Number
15	BAUTL	QMFE	BAUTL		☐	BAUTL	☐	Assembly
16	ERZEIT	QMFE	ERZEIT		☐	ERZEIT	☐	Time, at Which Record Was Added
17	AEZEIT	QMFE	AEZEIT		☐	AEZEIT	☐	Time of Change
18	KZORG	QMFE	KZORG		☐	KZORG	☐	Originating Defect
19	WDFEH	QMFE	WDFEH		☐	WDFEH	☐	Repetitive Defect
20	ANZFEHLER	QMFE	ANZFEHLER		☐	QANZFEHL4	☐	Number of Defects Found
21	KZSYSFE	QMFE	KZSYSFE		☐	QKZSYSFE	☐	Systematic Defect
22	PROBENR	QMFE	PROBENR		☐	QPROBENR	☐	Sample Number
23	MERKNR	QMFE	MERKNR		☐	QMERKNRP	☐	Inspection Characteristic Number
24	UNITFLBEW	QMFE	UNITFLBEW		☐	QUNITFLBEW	☐	Unit for Defect Valuation
25	FEHLBEW	QMFE	FEHLBEW		☐	QFEHLBEW	☐	Defect Valuation
26	INDTX	QMFE	INDTX		☐	INDLTX	☐	Object Long Text Available
27	KZMLA	QMFE	KZMLA		☐	KZMLA	☐	Primary language indicator for text segment
28	FEKAT	QMFE	FEKAT		☐	FEKAT	☐	Catalog Type - Problems
29	OTKAT	QMFE	OTKAT		☐	OTKAT	☐	Catalog Type - Object Parts
30	EBORT	QMFE	EBORT		☐	EBORT	☐	Installation Point for Subitem
31	QMART	QMEL	QMART		☐	QMART	☐	Message Type
32	QMTXT	QMEL	QMTXT		☐	QMTXT	☐	Short Text
33	ARTPR	QMEL	ARTPR		☐	ARTPR	☐	Priority Type
34	MZEIT	QMEL	MZEIT		☐	MZEIT	☐	Notification Time
35	QMDAT	QMEL	QMDAT		☐	QMDAT	☐	Date of Notification
36	QMNAM	QMEL	QMNAM		☐	QMNAM	☐	Name of declarant
37	STRMN	QMEL	STRMN		☐	STRMN	☐	Desired Start Date
38	STRUR	QMEL	STRUR		☐	STRUR	☐	Desired Start Time
39	LTRMN	QMEL	LTRMN		☐	LTRMN	☐	Required Finish Date
40	LTRUR	QMEL	LTRUR		☐	LTRUR	☐	Required End Date-Time
41	WAERS	QMEL	WAERS		☐	WAERS	☐	Currency Key
42	AUFNR	QMEL	AUFNR		☐	AUFNR	☐	Order Number
43	MATNR	QMEL	MATNR		☐	MATNR	☐	Material Number
44	REVLV	QMEL	REVLV		☐	REVLV	☐	Revision level
45	KUNUM	QMEL	KUNUM		☐	QKUNUM	☐	Account Number of Customer
46	FEKNZ	QMEL	FEKNZ		☐	FEKNZ	☐	Error Records Exist
47	MAKNZ	QMEL	MAKNZ		☐	MAKNZ	☐	Task Records Exist
48	OBJNR	QMEL	OBJNR		☐	QMOBJNR	☐	Object Number for Status Management
49	QMDAB	QMEL	QMDAB		☐	QMDAB	☐	Date for Completion of Notification
50	QMZAB	QMEL	QMZAB		☐	QMZAB	☐	Completion Time of Notification
51	RBNR	QMEL	RBNR		☐	RBNR	☐	Report layout
52	RBNRI	QMEL	RBNRI		☐	RBNRI	☐	Origin of Notifications Catalog Profile
53	HERKZ	QMEL	HERKZ		☐	HERKZ	☐	Origin Indicator for Notification
54	BEZDT	QMEL	BEZDT		☐	BEZDT	☐	Notification Reference Date
55	BEZUR	QMEL	BEZUR		☐	BEZUR_D	☐	Notification Reference Time
56	LIFNUM	QMEL	LIFNUM		☐	LIFNUM	☐	Vendor Account Number
57	VBELN	QMEL	VBELN		☐	KDAUF	☐	Sales Order Number
58	BSTNK	QMEL	BSTNK		☐	BSTKD	☐	Customer purchase order number
59	BSTDK	QMEL	BSTDK		☐	BSTDK	☐	Customer purchase order date
60	SPART	QMEL	SPART		☐	SPART	☐	Division
61	VKORG	QMEL	VKORG		☐	VKORG	☐	Sales Organization
62	VTWEG	QMEL	VTWEG		☐	VTWEG	☐	Distribution Channel
63	ADRNR	QMEL	ADRNR		☐	CADNR	☐	Addresses: Address Number
64	QMKAT	QMEL	QMKAT		☐	QMKAT	☐	Catalog type - coding
65	QMGRP	QMEL	QMGRP		☐	QMGRP	☐	Code group - coding
66	QMCOD	QMEL	QMCOD		☐	QMCOD	☐	Coding
67	ARBPL	QMEL	ARBPL		☐	LGWID	☐	Object ID of the Work Center
68	ARBPLWERK	QMEL	ARBPLWERK		☐	QARBPWERKS	☐	Plant for Work Center
69	FEART	QMEL	FEART		☐	QFEART	☐	Report Type for Defects Recording
70	PNLKN	QMEL	PNLKN		☐	QLFNKN	☐	Current Node Number from Order Counter APLZL
71	IWERK	QMIH	IWERK		☐	IWERK	☐	Maintenance Planning Plant
72	ILOAN	QMIH	ILOAN		☐	ILOAN	☐	Location and account assignment for technical object
73	ILOAI	QMIH	ILOAI		☐	ILOAI	☐	ILOA Individual
74	EQUNR	QMIH	EQUNR		☐	EQUNR	☐	Equipment Number
75	MSAUS	QMIH	MSAUS		☐	MSAUS	☐	Breakdown Indicator
76	AUSVN	QMIH	AUSVN		☐	AUSVN	☐	Start of Malfunction (Date)
77	AUSBS	QMIH	AUSBS		☐	AUSBS	☐	End of Malfunction (Date)
78	AUZTV	QMIH	AUZTV		☐	AUZTV	☐	Start of Malfunction (Time)
79	AUZTB	QMIH	AUZTB		☐	AUZTB	☐	End of Malfunction (Time)
80	AUSZT	QMIH	AUSZT		☐	AUSZT	☐	Breakdown Duration
81	MAUEH	QMIH	MAUEH		☐	MAUEH	☐	Unit for Breakdown Duration
82	BTPLN	QMIH	BTPLN		☐	BTPLN	☐	Functional Location Affected
83	BEQUI	QMIH	BEQUI		☐	BEQUI	☐	Equipment Affected
84	AUSWK	QMIH	AUSWK		☐	AUSWK	☐	Effect on Operation
85	VERFV	QMIH	VERFV		☐	VERFV	☐	Availability Before Malfunction
86	VERFN	QMIH	VERFN		☐	VERFN	☐	Availability After Malfunction
87	VERFM	QMIH	VERFM		☐	VERFM	☐	Availability After Completion of Task
88	ANLZV	QMIH	ANLZV		☐	ANLZV	☐	System Condition Before Malfunction
89	ANLZN	QMIH	ANLZN		☐	ANLZN	☐	System Condition After Malfunction
90	ANLZE	QMIH	ANLZE		☐	ANLZE	☐	System Condition After Completion of Task
91	INSPK	QMIH	INSPK		☐	INSPK	☐	Name of Person Responsible for Technical Inspection
92	DATAN	QMIH	DATAN		☐	DATAN	☐	Date of Technical Inspection
93	INGRP	QMIH	INGRP		☐	INGRP	☐	Planner Group for Customer Service and Plant Maintenance
94	TPLNR	ILOA	TPLNR		☐	TPLNR	☐	Functional Location
95	ABCKZ	ILOA	ABCKZ		☐	ABCKZ	☐	ABC Indicator for Technical Object
96	EQFNR	ILOA	EQFNR		☐	EQFNR	☐	Sort Field
97	SWERK	ILOA	SWERK		☐	SWERK	☐	Maintenance Plant
98	STORT	ILOA	STORT		☐	PMLOC	☐	Location of maintenance object
99	MSGRP	ILOA	MSGRP		☐	RAUMNR	☐	Room
100	BEBER	ILOA	BEBER		☐	BEBER	☐	Organizational Area
101	CR_OBJTY	ILOA	CR_OBJTY		☐	CR_OBJTY	☐	Object types of the CIM resource
102	PPSID	ILOA	PPSID		☐	PPSID	☐	Object ID of PP work center
103	GSBER	ILOA	GSBER		☐	GSBER	☐	Business Area
104	KOKRS	ILOA	KOKRS		☐	KOKRS	☐	Controlling Area
105	KOSTL	ILOA	KOSTL		☐	KOSTL	☐	Cost Center
106	PROID	ILOA	PROID		☐	PS_PSP_PNR	☐	Work Breakdown Structure Element (WBS Element)
107	BUKRS	ILOA	BUKRS		☐	BUKRS	☐	Company Code
108	ANLNR	ILOA	ANLNR		☐	ANLN1	☐	Main Asset Number
109	ANLUN	ILOA	ANLUN		☐	ANLN2	☐	Asset Subnumber
110	DAUFN	ILOA	DAUFN		☐	DAUFN	☐	Standing order number
111	ADRNR_ILOA	ILOA	ADRNR		☐	AD_ADDRNUM	☐	Address number
112	PRIOK	QMEL	PRIOK		☐	PRIOK	☐	Priority
113	OWNER	ILOA	OWNER		☐	ILOM_OWNER	☐	Object reference indicator
114	KDAUF	QMIH	KDAUF		☐	VBELN_VA	☐	Sales Document
115	KDPOS	QMIH	KDPOS		☐	POSNR_VA	☐	Sales Document Item
116	KZLOESCH	QMFE	KZLOESCH		☐	KZLOESCH	☐	Delete Data Record
117	VKBUR	QMEL	VKBUR		☐	VKBUR	☐	Sales office
118	VKGRP	QMEL	VKGRP		☐	VKGRP	☐	Sales group
119	SERIALNR	QMEL	SERIALNR		☐	GERNR	☐	Serial Number
120	DEVICEID	QMEL	DEVICEID		☐	DEVICEID	☐	Additional Device Data
121	POSNR	QMFE	POSNR		☐	QLFDPOS	☐	Sort Number for Item
122	FEQKLAS	QMFE	FEQKLAS		☐	QFEHLKLAS	☐	Defect class
123	PHASE	QMEL	PHASE		☐	QM_PHASE	☐	Notification Processing Phase
124	UII	QMEL	UII		☐	UII_CHAR72	☐	Unique Item Identifier
125	EQUNR_ITEM	QMFE	EQUNR		☐	EQUNR	☐	Equipment Number
126	TPLNR_ITEM	QMFE	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