SAP ABAP Table VIQMFEL (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	VIQMFEL	Table Relationship Diagram
Short Description	Generated Table for View

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

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

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VIQMFEL	ABCKZ	T370C	ABCKZ	REF	C	CN
2	VIQMFEL	ADRNR_ILOA	ADRC	ADDRNUMBER	REF	1	CN
3	VIQMFEL	ANLNR	ANLH	ANLN1	REF	C	CN
4	VIQMFEL	ANLUN	ANLA	ANLN2	REF	C	CN
5	VIQMFEL	ANLZE	T357Z	ANLAZ	REF	C	CN
6	VIQMFEL	ANLZN	T357Z	ANLAZ	REF	C	CN
7	VIQMFEL	ANLZV	T357Z	ANLAZ	REF	C	CN
8	VIQMFEL	ARBPLWERK	T001W	WERKS
9	VIQMFEL	ARTPR	T356A	ARTPR	REF	C	CN
10	VIQMFEL	AUFNR	AUFK	AUFNR	REF	C	CN
11	VIQMFEL	AUSWK	T357A	AUSWK	REF	C	CN
12	VIQMFEL	BAUTL	MARA	MATNR	REF	C	CN
13	VIQMFEL	BEBER	T357	BEBER	REF	C	CN
14	VIQMFEL	BEQUI	EQUI	EQUNR	REF	C	CN
15	VIQMFEL	BTPLN	IFLOT	TPLNR	REF	C	CN
16	VIQMFEL	BUKRS	T001	BUKRS	REF	C	CN
17	VIQMFEL	DAUFN	AUFK	AUFNR	REF	C	CN
18	VIQMFEL	EQUNR	EQUI	EQUNR	REF	C	CN
19	VIQMFEL	FEART	TQ86	FEART	REF	C	CN
20	VIQMFEL	FEGRP	QPGR	CODEGRUPPE	REF	C	CN
21	VIQMFEL	FEKAT	TQ15	KATALOGART	REF	C	CN
22	VIQMFEL	FEQKLAS	TQ17	FEHLKLASSE
23	VIQMFEL	GSBER	TGSB	GSBER	REF	C	CN
24	VIQMFEL	ILOAN	ILOA	ILOAN	REF	1	CN
25	VIQMFEL	INGRP	T024I	INGRP	REF	C	CN
26	VIQMFEL	IWERK	T399I	IWERK	REF	C	CN
27	VIQMFEL	KDAUF	VBUK	VBELN
28	VIQMFEL	KDPOS	VBUP	POSNR
29	VIQMFEL	KOKRS	TKA01	KOKRS	REF	C	CN
30	VIQMFEL	KOSTL	CSKS	KOSTL	REF	C	CN
31	VIQMFEL	KUNUM	KNA1	KUNNR	REF	C	CN
32	VIQMFEL	LIFNUM	LFA1	LIFNR
33	VIQMFEL	MANDT	T000	MANDT	KEY	1	CN
34	VIQMFEL	MATNR	MARA	MATNR	REF	C	CN
35	VIQMFEL	MAUEH	T006	MSEHI	REF	C	CN
36	VIQMFEL	OBJNR	ONR00	OBJNR	REF	C	CN
37	VIQMFEL	OTGRP	QPGR	CODEGRUPPE	REF	C	CN
38	VIQMFEL	OTKAT	TQ15	KATALOGART	REF	C	CN
39	VIQMFEL	PPSID	CRID	OBJID	REF	C	CN
40	VIQMFEL	PRIOK	T356	PRIOK	REF	C	CN
41	VIQMFEL	PROBENR	QASV	PROBENR
42	VIQMFEL	PROID	PRPS	PSPNR		C	CN
43	VIQMFEL	QMART	TQ80	QMART	REF	C	CN
44	VIQMFEL	QMGRP	QPGR	CODEGRUPPE	REF	C	CN
45	VIQMFEL	QMKAT	TQ15	KATALOGART
46	VIQMFEL	QMNUM	QMEL	QMNUM	KEY	1	CN
47	VIQMFEL	RBNR	T352B	RBNR	REF	C	CN
48	VIQMFEL	SPART	TSPA	SPART
49	VIQMFEL	STORT	T499S	STAND	REF	C	CN
50	VIQMFEL	SWERK	T001W	WERKS	REF	1	CN
51	VIQMFEL	TPLNR	IFLOT	TPLNR	REF	C	CN
52	VIQMFEL	UNITFLBEW	T006	MSEHI
53	VIQMFEL	VBELN	VBUK	VBELN
54	VIQMFEL	VKBUR	TVKBZ	VKBUR	REF	C	CN
55	VIQMFEL	VKGRP	TVBVK	VKGRP	REF	C	CN
56	VIQMFEL	VKORG	TVKO	VKORG
57	VIQMFEL	VTWEG	TVTW	VTWEG
58	VIQMFEL	WAERS	TCURC	WAERS	REF	C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in