SAP ABAP Table VIQMSML (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	VIQMSML	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	☑	MANUM	NUM4	NUMC	4	0	Sequential Task Number
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	MNKAT	☐	MAKAT	QKATART	CHAR	1	0	Catalog Type - Tasks	TQ15
76	MNGRP	☐	MAGRP	QCODEGRP	CHAR	8	0	Code group - Tasks	QPGR
77	MNCOD	☐	MNCOD	QCODE	CHAR	4	0	Task code
78	MNVER	☐	QVERSNR	QVERSNR	CHAR	6	0	Version Number
79	FOLGEACT	☐	QMFOLACT	QFOLGEAKTI	CHAR	8	0	Follow-Up Action for Task	TQ07
80	FOLACTPROT	☐	QMFOAPROT	QKZ	CHAR	1	0	Log for Follow-Up Action
81	MATXT	☐	MATXT	TEXT40	CHAR	40	0	Short text for task
82	PSTER	☐	PSTER	DATUM	DATS	8	0	Planned start date
83	PETER	☐	PETER	DATUM	DATS	8	0	Planned finish date
84	OBJNR_M	☐	QMOBJNR	J_OBJNR	CHAR	22	0	Object Number for Status Management	ONR00
85	INDTX_M	☐	INDLTX	CHAR1	CHAR	1	0	Object Long Text Available
86	KZMLA_M	☐	KZMLA	CHAR1	CHAR	1	0	Primary language indicator for text segment
87	PSTUR	☐	PSTUR	UZEIT	TIMS	6	0	Planned Start Time for Task
88	PETUR	☐	PETUR	UZEIT	TIMS	6	0	Planned finish time for task
89	ERLNAM	☐	QMSMERLNAM	USNAM	CHAR	12	0	Person who carried out the task
90	ERLDAT	☐	QMSMERLDAT	DATUM	DATS	8	0	Date on which the task was carried out
91	WDVDAT	☐	QMSMWDVDAT	DATUM	DATS	8	0	Date on which the task was resubmitted
92	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
93	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
94	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
95	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
96	ADRNR_ILOA	☐	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number	ADRC
97	ADRNRI	☐	INH_ADRNRI	INHER	CHAR	1	0	Data origin for address field
98	FENUM	☐	FELFD	FELFD	NUMC	4	0	Item Number in Item Record	QMFE
99	URNUM	☐	URNUM	NUM4	NUMC	4	0	Sequential Number for Cause
100	ERZEIT	☐	ERZEIT	UHRZT	TIMS	6	0	Time, at Which Record Was Added
101	AEZEIT	☐	AEZEIT	UHRZT	TIMS	6	0	Time of Change
102	QSMNUM	☐	QSMNUM	NUMC04	NUMC	4	0	Sort number for task
103	VBELN	☐	KDAUF	VBELN	CHAR	10	0	Sales Order Number	VBUK
104	BSTNK	☐	BSTKD	BSTKD	CHAR	35	0	Customer purchase order number
105	BSTDK	☐	BSTDK	DATUM	DATS	8	0	Customer purchase order date
106	ARBPL	☐	LGWID	CR_OBJID	NUMC	8	0	Object ID of the Work Center
107	QMCOD	☐	QMCOD	QCODE	CHAR	4	0	Coding
108	QMGRP	☐	QMGRP	QCODEGRP	CHAR	8	0	Code group - coding	QPGR
109	QMKAT	☐	QMKAT	QKATART	CHAR	1	0	Catalog type - coding	TQ15
110	SPART	☐	SPART	SPART	CHAR	2	0	Division	TSPA
111	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
112	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
113	ADRNR	☐	CADNR	CADRNR	CHAR	10	0	Addresses: Address Number
114	ERLZEIT	☐	QMSMERLTIM	UZEIT	TIMS	6	0	Time at which the task was completed
115	PARVW	☐	QMSM_PARVW	PARVW	CHAR	2	0	Function of Person Responsible for Task	TPAR
116	PARNR	☐	QMSM_PARNR	I_PARNR	CHAR	12	0	Person responsible for the task (partner number)
117	OWNER	☐	ILOM_OWNER	ILOM_OWNER	CHAR	1	0	Object reference indicator
118	FEART	☐	QFEART	QFEART	CHAR	8	0	Report Type for Defects Recording	TQ86
119	KDAUF	☐	VBELN_VA	VBELN	CHAR	10	0	Sales Document	VBUK
120	KDPOS	☐	POSNR_VA	POSNR	NUMC	6	0	Sales Document Item	VBUP
121	KZLOESCH	☐	KZLOESCH	CHAR1	CHAR	1	0	Delete Data Record
122	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	TVKBZ
123	VKGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	TVBVK
124	SERIALNR	☐	GERNR	GERNR	CHAR	18	0	Serial Number
125	DEVICEID	☐	DEVICEID	DEVICEID	CHAR	40	0	Additional Device Data
126	PHASE	☐	QM_PHASE	QM_PHASE	CHAR	1	0	Notification Processing Phase
127	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	VIQMSML	ABCKZ	T370C	ABCKZ	REF	C	CN
2	VIQMSML	ADRNR_ILOA	ADRC	ADDRNUMBER	REF	1	CN
3	VIQMSML	ANLNR	ANLH	ANLN1	REF	C	CN
4	VIQMSML	ANLUN	ANLA	ANLN2	REF	C	CN
5	VIQMSML	ANLZE	T357Z	ANLAZ	REF	C	CN
6	VIQMSML	ANLZN	T357Z	ANLAZ	REF	C	CN
7	VIQMSML	ANLZV	T357Z	ANLAZ	REF	C	CN
8	VIQMSML	ARTPR	T356A	ARTPR	REF	C	CN
9	VIQMSML	AUFNR	AUFK	AUFNR	REF	C	CN
10	VIQMSML	AUSWK	T357A	AUSWK	REF	C	CN
11	VIQMSML	BAUTL	MARA	MATNR	REF	C	CN
12	VIQMSML	BEBER	T357	BEBER	REF	C	CN
13	VIQMSML	BEQUI	EQUI	EQUNR	REF	C	CN
14	VIQMSML	BTPLN	IFLOT	TPLNR	REF	C	CN
15	VIQMSML	BUKRS	T001	BUKRS	REF	C	CN
16	VIQMSML	DAUFN	AUFK	AUFNR	REF	C	CN
17	VIQMSML	EQUNR	EQUI	EQUNR	REF	C	CN
18	VIQMSML	FEART	TQ86	FEART	REF	C	CN
19	VIQMSML	FENUM	QMFE	FENUM
20	VIQMSML	FOLGEACT	TQ07	FOLGEAKTI		C	CN
21	VIQMSML	GSBER	TGSB	GSBER	REF	C	CN
22	VIQMSML	ILOAN	ILOA	ILOAN	REF	1	CN
23	VIQMSML	INGRP	T024I	INGRP	REF	C	CN
24	VIQMSML	IWERK	T399I	IWERK	REF	C	CN
25	VIQMSML	KAUFN	AUFK	AUFNR	REF	C	CN
26	VIQMSML	KDAUF	VBUK	VBELN
27	VIQMSML	KDPOS	VBUP	POSNR
28	VIQMSML	KOKRS	TKA01	KOKRS	REF	C	CN
29	VIQMSML	KOSTL	CSKS	KOSTL	REF	C	CN
30	VIQMSML	KUNUM	KNA1	KUNNR	REF	C	CN
31	VIQMSML	MANDT	T000	MANDT	KEY	1	CN
32	VIQMSML	MATNR	MARA	MATNR	REF	C	CN
33	VIQMSML	MAUEH	T006	MSEHI	REF	C	CN
34	VIQMSML	MNGRP	QPGR	CODEGRUPPE	REF	C	CN
35	VIQMSML	MNKAT	TQ15	KATALOGART	REF	C	CN
36	VIQMSML	OBJNR	ONR00	OBJNR	REF	C	CN
37	VIQMSML	OBJNR_M	ONR00	OBJNR	REF	C	CN
38	VIQMSML	PARVW	TPAR	PARVW
39	VIQMSML	PPSID	CRID	OBJID	REF	C	CN
40	VIQMSML	PRIOK	T356	PRIOK	REF	C	CN
41	VIQMSML	PROID	PRPS	PSPNR		C	CN
42	VIQMSML	QMART	TQ80	QMART	REF	C	CN
43	VIQMSML	QMGRP	QPGR	CODEGRUPPE	REF	C	CN
44	VIQMSML	QMKAT	TQ15	KATALOGART
45	VIQMSML	RBNR	T352B	RBNR	REF	C	CN
46	VIQMSML	SPART	TSPA	SPART
47	VIQMSML	STORT	T499S	STAND	REF	C	CN
48	VIQMSML	SWERK	T001W	WERKS	REF	1	CN
49	VIQMSML	TPLNR	IFLOT	TPLNR	REF	C	CN
50	VIQMSML	VBELN	VBUK	VBELN
51	VIQMSML	VKBUR	TVKBZ	VKBUR	REF	C	CN
52	VIQMSML	VKGRP	TVBVK	VKGRP	REF	C	CN
53	VIQMSML	VKORG	TVKO	VKORG
54	VIQMSML	VTWEG	TVTW	VTWEG
55	VIQMSML	WAERS	TCURC	WAERS	REF	C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in