SAP ABAP View VIQMAML (Activities (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	VIQMAML
Short Description	Activities (including notification header)
Root table	QMEL	Quality Notification

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	QMEL	QMEL
2	QMIH
3	QMMA
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	QMIH	MANDT	JR	EQ			AND	0	0
3	QMEL	QMNUM	JL	EQ				0	0
4	QMIH	QMNUM	JR	EQ			AND	0	0
5	QMEL	MANDT	JL	EQ				0	0
6	QMMA	MANDT	JR	EQ			AND	0	0
7	QMEL	QMNUM	JL	EQ				0	0
8	QMMA	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	QMEL	MANDT		☐	MANDT	☐	Client
2	QMNUM	QMEL	QMNUM		☐	QMNUM	☐	Message Number
3	MANUM	QMMA	MANUM		☐	AKNUM	☐	Consecutive Number of Activity
4	IWERK	QMIH	IWERK		☐	IWERK	☐	Maintenance Planning Plant
5	ILOAN	QMIH	ILOAN		☐	ILOAN	☐	Location and account assignment for technical object
6	ILOAI	QMIH	ILOAI		☐	ILOAI	☐	ILOA Individual
7	EQUNR	QMIH	EQUNR		☐	EQUNR	☐	Equipment Number
8	BAUTL	QMIH	BAUTL		☐	BAUTL	☐	Assembly
9	EBORT	QMIH	EBORT		☐	EBORT	☐	Installation Point for Subitem
10	MSAUS	QMIH	MSAUS		☐	MSAUS	☐	Breakdown Indicator
11	AUSVN	QMIH	AUSVN		☐	AUSVN	☐	Start of Malfunction (Date)
12	AUSBS	QMIH	AUSBS		☐	AUSBS	☐	End of Malfunction (Date)
13	AUZTV	QMIH	AUZTV		☐	AUZTV	☐	Start of Malfunction (Time)
14	AUZTB	QMIH	AUZTB		☐	AUZTB	☐	End of Malfunction (Time)
15	AUSZT	QMIH	AUSZT		☐	AUSZT	☐	Breakdown Duration
16	MAUEH	QMIH	MAUEH		☐	MAUEH	☐	Unit for Breakdown Duration
17	BTPLN	QMIH	BTPLN		☐	BTPLN	☐	Functional Location Affected
18	BEQUI	QMIH	BEQUI		☐	BEQUI	☐	Equipment Affected
19	AUSWK	QMIH	AUSWK		☐	AUSWK	☐	Effect on Operation
20	VERFV	QMIH	VERFV		☐	VERFV	☐	Availability Before Malfunction
21	VERFN	QMIH	VERFN		☐	VERFN	☐	Availability After Malfunction
22	VERFM	QMIH	VERFM		☐	VERFM	☐	Availability After Completion of Task
23	ANLZV	QMIH	ANLZV		☐	ANLZV	☐	System Condition Before Malfunction
24	ANLZN	QMIH	ANLZN		☐	ANLZN	☐	System Condition After Malfunction
25	ANLZE	QMIH	ANLZE		☐	ANLZE	☐	System Condition After Completion of Task
26	INSPK	QMIH	INSPK		☐	INSPK	☐	Name of Person Responsible for Technical Inspection
27	DATAN	QMIH	DATAN		☐	DATAN	☐	Date of Technical Inspection
28	INGRP	QMIH	INGRP		☐	INGRP	☐	Planner Group for Customer Service and Plant Maintenance
29	QMART	QMEL	QMART		☐	QMART	☐	Message Type
30	QMTXT	QMEL	QMTXT		☐	QMTXT	☐	Short Text
31	ARTPR	QMEL	ARTPR		☐	ARTPR	☐	Priority Type
32	PRIOK	QMEL	PRIOK		☐	PRIOK	☐	Priority
33	MZEIT	QMEL	MZEIT		☐	MZEIT	☐	Notification Time
34	QMDAT	QMEL	QMDAT		☐	QMDAT	☐	Date of Notification
35	QMNAM	QMEL	QMNAM		☐	QMNAM	☐	Name of declarant
36	STRMN	QMEL	STRMN		☐	STRMN	☐	Desired Start Date
37	STRUR	QMEL	STRUR		☐	STRUR	☐	Desired Start Time
38	LTRMN	QMEL	LTRMN		☐	LTRMN	☐	Required Finish Date
39	LTRUR	QMEL	LTRUR		☐	LTRUR	☐	Required End Date-Time
40	WAERS	QMEL	WAERS		☐	WAERS	☐	Currency Key
41	AUFNR	QMEL	AUFNR		☐	AUFNR	☐	Order Number
42	MATNR	QMEL	MATNR		☐	MATNR	☐	Material Number
43	REVLV	QMEL	REVLV		☐	REVLV	☐	Revision level
44	KUNUM	QMEL	KUNUM		☐	QKUNUM	☐	Account Number of Customer
45	FEKNZ	QMEL	FEKNZ		☐	FEKNZ	☐	Error Records Exist
46	MAKNZ	QMEL	MAKNZ		☐	MAKNZ	☐	Task Records Exist
47	QMDAB	QMEL	QMDAB		☐	QMDAB	☐	Date for Completion of Notification
48	QMZAB	QMEL	QMZAB		☐	QMZAB	☐	Completion Time of Notification
49	RBNR	QMEL	RBNR		☐	RBNR	☐	Report layout
50	RBNRI	QMEL	RBNRI		☐	RBNRI	☐	Origin of Notifications Catalog Profile
51	INDTX	QMEL	INDTX		☐	INDLTX	☐	Object Long Text Available
52	KZMLA	QMEL	KZMLA		☐	KZMLA	☐	Primary language indicator for text segment
53	OBJNR	QMEL	OBJNR		☐	QMOBJNR	☐	Object Number for Status Management
54	HERKZ	QMEL	HERKZ		☐	HERKZ	☐	Origin Indicator for Notification
55	BEZDT	QMEL	BEZDT		☐	BEZDT	☐	Notification Reference Date
56	BEZUR	QMEL	BEZUR		☐	BEZUR_D	☐	Notification Reference Time
57	TPLNR	ILOA	TPLNR		☐	TPLNR	☐	Functional Location
58	ABCKZ	ILOA	ABCKZ		☐	ABCKZ	☐	ABC Indicator for Technical Object
59	EQFNR	ILOA	EQFNR		☐	EQFNR	☐	Sort Field
60	SWERK	ILOA	SWERK		☐	SWERK	☐	Maintenance Plant
61	STORT	ILOA	STORT		☐	PMLOC	☐	Location of maintenance object
62	MSGRP	ILOA	MSGRP		☐	RAUMNR	☐	Room
63	BEBER	ILOA	BEBER		☐	BEBER	☐	Organizational Area
64	PPSID	ILOA	PPSID		☐	PPSID	☐	Object ID of PP work center
65	GSBER	ILOA	GSBER		☐	GSBER	☐	Business Area
66	KOKRS	ILOA	KOKRS		☐	KOKRS	☐	Controlling Area
67	KOSTL	ILOA	KOSTL		☐	KOSTL	☐	Cost Center
68	PROID	ILOA	PROID		☐	PS_PSP_PNR	☐	Work Breakdown Structure Element (WBS Element)
69	ANLNR	ILOA	ANLNR		☐	ANLN1	☐	Main Asset Number
70	ANLUN	ILOA	ANLUN		☐	ANLN2	☐	Asset Subnumber
71	DAUFN	ILOA	DAUFN		☐	DAUFN	☐	Standing order number
72	KAUFN	ILOA	AUFNR		☐	ILOM_ORDST	☐	Settlement order
73	BUKRS	ILOA	BUKRS		☐	BUKRS	☐	Company Code
74	CR_OBJTY	ILOA	CR_OBJTY		☐	CR_OBJTY	☐	Object types of the CIM resource
75	ADRNR_ILOA	ILOA	ADRNR		☐	AD_ADDRNUM	☐	Address number
76	ADRNRI	ILOA	ADRNRI		☐	INH_ADRNRI	☐	Data origin for address field
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	ARBPL	QMEL	ARBPL		☐	LGWID	☐	Object ID of the Work Center
81	QMCOD	QMEL	QMCOD		☐	QMCOD	☐	Coding
82	QMGRP	QMEL	QMGRP		☐	QMGRP	☐	Code group - coding
83	QMKAT	QMEL	QMKAT		☐	QMKAT	☐	Catalog type - coding
84	SPART	QMEL	SPART		☐	SPART	☐	Division
85	VKORG	QMEL	VKORG		☐	VKORG	☐	Sales Organization
86	VTWEG	QMEL	VTWEG		☐	VTWEG	☐	Distribution Channel
87	ADRNR	QMEL	ADRNR		☐	CADNR	☐	Addresses: Address Number
88	OWNER	ILOA	OWNER		☐	ILOM_OWNER	☐	Object reference indicator
89	FEART	QMEL	FEART		☐	QFEART	☐	Report Type for Defects Recording
90	KDAUF	QMIH	KDAUF		☐	VBELN_VA	☐	Sales Document
91	KDPOS	QMIH	KDPOS		☐	POSNR_VA	☐	Sales Document Item
92	FENUM	QMMA	FENUM		☐	FELFD	☐	Item Number in Item Record
93	URNUM	QMMA	URNUM		☐	URNUM	☐	Sequential Number for Cause
94	MNKAT	QMMA	MNKAT		☐	MFKAT	☐	Catalog Type - Actions
95	MNGRP	QMMA	MNGRP		☐	MFGRP	☐	Code group - Activities
96	MNCOD	QMMA	MNCOD		☐	MFCOD	☐	Action Code
97	MNVER	QMMA	MNVER		☐	QVERSNR	☐	Version Number
98	MATXT	QMMA	MATXT		☐	MFTEXT	☐	Action Text
99	ERNAM	QMMA	ERNAM		☐	ERNAM	☐	Name of Person who Created the Object
100	ERDAT	QMMA	ERDAT		☐	ERDAT	☐	Date on which the record was created
101	AENAM	QMMA	AENAM		☐	AENAM	☐	Name of Person Who Changed Object
102	AEDAT	QMMA	AEDAT		☐	AEDAT	☐	Last Changed On
103	MAKLS	QMMA	MAKLS		☐	MAKLS	☐	Task Class
104	KLAKZ	QMMA	KLAKZ		☐	KLAKZ	☐	Indicator: Classification exists
105	PSTER	QMMA	PSTER		☐	PSTERMA	☐	Start Date
106	PETER	QMMA	PETER		☐	PETERMA	☐	End Date
107	INDTX_M	QMMA	INDTX		☐	INDLTX	☐	Object Long Text Available
108	KZMLA_M	QMMA	KZMLA		☐	KZMLA	☐	Primary language indicator for text segment
109	MNGFA	QMMA	MNGFA		☐	MNGFA	☐	Quantity factor for actions
110	PSTUR	QMMA	PSTUR		☐	PSTURMA	☐	Start Time of Activity
111	PETUR	QMMA	PETUR		☐	PETURMA	☐	End Time of Activity
112	ERZEIT	QMMA	ERZEIT		☐	ERZEIT	☐	Time, at Which Record Was Added
113	AEZEIT	QMMA	AEZEIT		☐	AEZEIT	☐	Time of Change
114	KZLOESCH	QMMA	KZLOESCH		☐	KZLOESCH	☐	Delete Data Record
115	QMANUM	QMMA	QMANUM		☐	QMANUM	☐	Sort Number for Activity
116	VKBUR	QMEL	VKBUR		☐	VKBUR	☐	Sales office
117	VKGRP	QMEL	VKGRP		☐	VKGRP	☐	Sales group
118	SERIALNR	QMEL	SERIALNR		☐	GERNR	☐	Serial Number
119	DEVICEID	QMEL	DEVICEID		☐	DEVICEID	☐	Additional Device Data
120	PHASE	QMEL	PHASE		☐	QM_PHASE	☐	Notification Processing Phase
121	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