SAP ABAP Table VIQMAML (Generated Table for View)

Basic Data

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

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in