SAP ABAP Table WQMSM (Work Table for Tasks)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MSE (Application Component) Mobile Service
     ⤷ IWOC (Package) Application Development R/3 Work Order Cycle

Basic Data

Table Category	INTTAB	Structure
Structure	WQMSM	Table Relationship Diagram
Short Description	Work Table for Tasks

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	.INCLUDE	☐				0	0	Quality notification - tasks
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	QMNUM	☐	QMNUM	QMNUM	CHAR	12	0	Message Number	QMEL
4	MANUM	☐	MANUM	NUM4	NUMC	4	0	Sequential Task Number
5	MNKAT	☐	MAKAT	QKATART	CHAR	1	0	Catalog Type - Tasks	TQ15
6	MNGRP	☐	MAGRP	QCODEGRP	CHAR	8	0	Code group - Tasks	QPGR
7	MNCOD	☐	MNCOD	QCODE	CHAR	4	0	Task code	*
8	MNVER	☐	QVERSNR	QVERSNR	CHAR	6	0	Version Number
9	FOLGEACT	☐	QMFOLACT	QFOLGEAKTI	CHAR	8	0	Follow-Up Action for Task	TQ07
10	FOLACTPROT	☐	QMFOAPROT	QKZ	CHAR	1	0	Log for Follow-Up Action
11	MATXT	☐	MATXT	TEXT40	CHAR	40	0	Short text for task
12	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
13	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
14	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
15	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
16	PSTER	☐	PSTER	DATUM	DATS	8	0	Planned start date
17	PETER	☐	PETER	DATUM	DATS	8	0	Planned finish date
18	OBJNR	☐	QMOBJNR	J_OBJNR	CHAR	22	0	Object Number for Status Management	ONR00
19	INDTX	☐	INDLTX	CHAR1	CHAR	1	0	Object Long Text Available
20	KZMLA	☐	KZMLA	CHAR1	CHAR	1	0	Primary language indicator for text segment
21	PSTUR	☐	PSTUR	UZEIT	TIMS	6	0	Planned Start Time for Task
22	PETUR	☐	PETUR	UZEIT	TIMS	6	0	Planned finish time for task
23	ERLNAM	☐	QMSMERLNAM	USNAM	CHAR	12	0	Person who carried out the task
24	ERLDAT	☐	QMSMERLDAT	DATUM	DATS	8	0	Date on which the task was carried out
25	ERLZEIT	☐	QMSMERLTIM	UZEIT	TIMS	6	0	Time at which the task was completed
26	WDVDAT	☐	QMSMWDVDAT	DATUM	DATS	8	0	Date on which the task was resubmitted
27	FENUM	☐	FELFD	FELFD	NUMC	4	0	Item Number in Item Record	QMFE
28	URNUM	☐	URNUM	NUM4	NUMC	4	0	Sequential Number for Cause
29	ERZEIT	☐	ERZEIT	UHRZT	TIMS	6	0	Time, at Which Record Was Added
30	AEZEIT	☐	AEZEIT	UHRZT	TIMS	6	0	Time of Change
31	PARVW	☐	QMSM_PARVW	PARVW	CHAR	2	0	Function of Person Responsible for Task	TPAR
32	PARNR	☐	QMSM_PARNR	I_PARNR	CHAR	12	0	Person responsible for the task (partner number)
33	MMENGE	☐	QSMMNG	MENGE	QUAN	13	3	Quantity
34	MMGEIN	☐	QMGEIN	MEINS	UNIT	3	0	Unit of Measure for Item	T006
35	BAUTL	☐	QMSM_BAUTL	MATNR	CHAR	18	0	Assembly Affected by the Task	*
36	KZLOESCH	☐	KZLOESCH	CHAR1	CHAR	1	0	Delete Data Record
37	QSMNUM	☐	QSMNUM	NUMC04	NUMC	4	0	Sort number for task
38	AUTKZ	☐	QAUTKZ	QKZ	CHAR	1	0	Data Record Created with Function 'Create with Copy Model'
39	HANDLE	☐	TSEGGUID	SYSUUID_22	CHAR	22	0	Globally unique identifier (linked to time segment, etc)
40	TSEGFL	☐	TSEGEXISTS	FLAG	CHAR	1	0	Time segment exists
41	TSEGTP	☐	TSEGTEMPLA	TSEGTEMPLA	CHAR	10	0	Template	TTSEGTPLH
42	TZONSO	☐	TZONSO	TZNZONE	CHAR	6	0	Time zone for notification	TTZZ
43	TZONSM	☐	TZONSM	TZNZONE	CHAR	6	0	Time Zone for Task	TTZZ
44	TZONID	☐	TZONSMID	TZONSMID	CHAR	1	0	Origin of Time Zone in Notification
45	KZACTIONBOX	☐	QNKZACTIONBOX	QKZ	CHAR	1	0	Created Using Action Box
46	FUNKTION	☐	QNFUNKTION	CHAR4	CHAR	4	0	Keys for Function in Action Box
47	.INCLUDE	☐				0	0	Append Fields for Task (Notes and Memos)
48	/SAPSMOSS/NOTE	☐	/SAPSMOSS/NOTE	/SAPSMOSS/NOTE	NUMC	7	0	Note number
49	/SAPSMOSS/REPORT	☐	/SAPSMOSS/MEMOREPORT	/SAPSMOSS/MEMOREPORT	CHAR	35	0	Note created by
50	/SAPSMOSS/MTSTMP	☐	/SAPSMOSS/MEMOTSTMP	TZNTIMESTP	NUMC	14	0	Time stamp (date + time)
51	ABC_TEMPL	☐	ABC_TEMPL	ABC_TEMPL	CHAR	10	0	Template	COTPL
52	.INCLU--AP	☐				0	0	8D-report effect fields
53	EFFECTPERC	☐	QN8D_EFFECTPERC		NUMC	3	0	Effect in Percentage
54	EFFECTTEXT	☐	QN8D_EFFECTTEXT	CHAR40K	CHAR	40	0	Effect Text
55	AEKNZ	☐	AEKNZ	FLAG	CHAR	1	0	Change indicator
56	PRTKZ	☐	PRTKZ	XFELD	CHAR	1	0	Print Indicator
57	TXTGR	☐	QKTEXTGR	QKURZTEXT	CHAR	40	0	Code Group Description
58	TXTCD	☐	TXTCDSM	TEXT40	CHAR	40	0	Task Code Short Text
59	TXTCDGR	☐	QTXTCDGRSM	QTEXT80	CHAR	80	0	Short Text for Task Code
60	STTXT	☐	QMSTTXT	TEXT40	CHAR	40	0	System Status for Notification
61	ASTEX	☐	QMASTEX	KREUZ	CHAR	1	0	User Status Active
62	ASTXT	☐	CO_ASTTX	CHAR40	CHAR	40	0	Field displaying user status
63	KZQMSM	☐	QKZQMSM	CHAR1	CHAR	1	0	Indicator: Task Completed
64	FOLGEACTXT	☐	QKURZTEXT	QKURZTEXT	CHAR	40	0	Short Text

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in