SAP ABAP Table VIQMSM (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	VIQMSM	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	MANUM	☑	MANUM	NUM4	NUMC	4	0	Sequential Task Number
4	MNKAT	☐	MAKAT	QKATART	CHAR	1	0	Catalog Type - Tasks	TQ15
5	MNGRP	☐	MAGRP	QCODEGRP	CHAR	8	0	Code group - Tasks	QPGR
6	MNCOD	☐	MNCOD	QCODE	CHAR	4	0	Task code
7	MNVER	☐	QVERSNR	QVERSNR	CHAR	6	0	Version Number
8	FOLGEACT	☐	QMFOLACT	QFOLGEAKTI	CHAR	8	0	Follow-Up Action for Task	TQ07
9	FOLACTPROT	☐	QMFOAPROT	QKZ	CHAR	1	0	Log for Follow-Up Action
10	MATXT	☐	MATXT	TEXT40	CHAR	40	0	Short text for task
11	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
12	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
13	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
14	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
15	PSTER	☐	PSTER	DATUM	DATS	8	0	Planned start date
16	PETER	☐	PETER	DATUM	DATS	8	0	Planned finish date
17	OBJNR	☐	QMOBJNR	J_OBJNR	CHAR	22	0	Object Number for Status Management	ONR00
18	INDTX	☐	INDLTX	CHAR1	CHAR	1	0	Object Long Text Available
19	KZMLA	☐	KZMLA	CHAR1	CHAR	1	0	Primary language indicator for text segment
20	PSTUR	☐	PSTUR	UZEIT	TIMS	6	0	Planned Start Time for Task
21	PETUR	☐	PETUR	UZEIT	TIMS	6	0	Planned finish time for task
22	ERLNAM	☐	QMSMERLNAM	USNAM	CHAR	12	0	Person who carried out the task
23	ERLDAT	☐	QMSMERLDAT	DATUM	DATS	8	0	Date on which the task was carried out
24	ERLZEIT	☐	QMSMERLTIM	UZEIT	TIMS	6	0	Time at which the task was completed
25	WDVDAT	☐	QMSMWDVDAT	DATUM	DATS	8	0	Date on which the task was resubmitted
26	FENUM	☐	FELFD	FELFD	NUMC	4	0	Item Number in Item Record	QMFE
27	URNUM	☐	URNUM	NUM4	NUMC	4	0	Sequential Number for Cause
28	ERZEIT	☐	ERZEIT	UHRZT	TIMS	6	0	Time, at Which Record Was Added
29	AEZEIT	☐	AEZEIT	UHRZT	TIMS	6	0	Time of Change
30	PARVW	☐	QMSM_PARVW	PARVW	CHAR	2	0	Function of Person Responsible for Task	TPAR
31	PARNR	☐	QMSM_PARNR	I_PARNR	CHAR	12	0	Person responsible for the task (partner number)
32	MMENGE	☐	QSMMNG	MENGE	QUAN	13	3	Quantity
33	MMGEIN	☐	QMGEIN	MEINS	UNIT	3	0	Unit of Measure for Item	T006
34	BAUTL	☐	QMSM_BAUTL	MATNR	CHAR	18	0	Assembly Affected by the Task
35	KZLOESCH	☐	KZLOESCH	CHAR1	CHAR	1	0	Delete Data Record
36	QSMNUM	☐	QSMNUM	NUMC04	NUMC	4	0	Sort number for task
37	AUTKZ	☐	QAUTKZ	QKZ	CHAR	1	0	Data Record Created with Function 'Create with Copy Model'
38	HANDLE	☐	TSEGGUID	SYSUUID_22	CHAR	22	0	Globally unique identifier (linked to time segment, etc)
39	TSEGFL	☐	TSEGEXISTS	FLAG	CHAR	1	0	Time segment exists
40	TSEGTP	☐	TSEGTEMPLA	TSEGTEMPLA	CHAR	10	0	Template	TTSEGTPLH
41	TZONSO	☐	TZONSO	TZNZONE	CHAR	6	0	Time zone for notification	TTZZ
42	TZONSM	☐	TZONSM	TZNZONE	CHAR	6	0	Time Zone for Task	TTZZ
43	TZONID	☐	TZONSMID	TZONSMID	CHAR	1	0	Origin of Time Zone in Notification
44	KZACTIONBOX	☐	QNKZACTIONBOX	QKZ	CHAR	1	0	Created Using Action Box
45	FUNKTION	☐	QNFUNKTION	CHAR4	CHAR	4	0	Keys for Function in Action Box
46	/SAPSMOSS/NOTE	☐	/SAPSMOSS/NOTE	/SAPSMOSS/NOTE	NUMC	7	0	Note number
47	/SAPSMOSS/REPORT	☐	/SAPSMOSS/MEMOREPORT	/SAPSMOSS/MEMOREPORT	CHAR	35	0	Note created by
48	/SAPSMOSS/MTSTMP	☐	/SAPSMOSS/MEMOTSTMP	TZNTIMESTP	NUMC	14	0	Time stamp (date + time)
49	ABC_TEMPL	☐	ABC_TEMPL	ABC_TEMPL	CHAR	10	0	Template	COTPL
50	EFFECTPERC	☐	QN8D_EFFECTPERC		NUMC	3	0	Effect in Percentage
51	EFFECTTEXT	☐	QN8D_EFFECTTEXT	CHAR40K	CHAR	40	0	Effect Text

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VIQMSM	ABC_TEMPL	COTPL	TEMPLATE	REF	C	CN
2	VIQMSM	FENUM	QMFE	FENUM
3	VIQMSM	FOLGEACT	TQ07	FOLGEAKTI		C	CN
4	VIQMSM	MANDT	T000	MANDT	KEY	1	CN
5	VIQMSM	MMGEIN	T006	MSEHI
6	VIQMSM	MNGRP	QPGR	CODEGRUPPE	REF	C	CN
7	VIQMSM	MNKAT	TQ15	KATALOGART	REF	C	CN
8	VIQMSM	OBJNR	ONR00	OBJNR	REF	C	CN
9	VIQMSM	PARVW	TPAR	PARVW
10	VIQMSM	QMNUM	QMEL	QMNUM	KEY	1	CN
11	VIQMSM	TSEGTP	TTSEGTPLH	TEPL	REF	1	CN
12	VIQMSM	TZONSM	TTZZ	TZONE	REF	1	CN
13	VIQMSM	TZONSO	TTZZ	TZONE	REF	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in