SAP ABAP Table QMSM (Quality notification - 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	TRANSP	Transparent table
Transparent table	QMSM	Table Relationship Diagram
Short Description	Quality notification - tasks

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	.INCLUDE	☐				0	0	Append Fields for Task (Notes and Memos)
47	/SAPSMOSS/NOTE	☐	/SAPSMOSS/NOTE	/SAPSMOSS/NOTE	NUMC	7	0	Note number
48	/SAPSMOSS/REPORT	☐	/SAPSMOSS/MEMOREPORT	/SAPSMOSS/MEMOREPORT	CHAR	35	0	Note created by
49	/SAPSMOSS/MTSTMP	☐	/SAPSMOSS/MEMOTSTMP	TZNTIMESTP	NUMC	14	0	Time stamp (date + time)
50	ABC_TEMPL	☐	ABC_TEMPL	ABC_TEMPL	CHAR	10	0	Template	COTPL
51	.INCLU--AP	☐				0	0	8D-report effect fields
52	EFFECTPERC	☐	QN8D_EFFECTPERC		NUMC	3	0	Effect in Percentage
53	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	QMSM	ABC_TEMPL	COTPL	TEMPLATE	REF	C	CN
2	QMSM	FENUM	QMFE	FENUM
3	QMSM	FOLGEACT	TQ07	FOLGEAKTI		C	CN
4	QMSM	MANDT	T000	MANDT	KEY	1	CN
5	QMSM	MMGEIN	T006	MSEHI
6	QMSM	MNGRP	QPGR	CODEGRUPPE	REF	C	CN
7	QMSM	MNKAT	TQ15	KATALOGART	REF	C	CN
8	QMSM	OBJNR	ONR00	OBJNR	REF	C	CN
9	QMSM	PARVW	TPAR	PARVW
10	QMSM	QMNUM	QMEL	QMNUM	KEY	1	CN
11	QMSM	TSEGTP	TTSEGTPLH	TEPL	REF	1	CN
12	QMSM	TZONSM	TTZZ	TZONE	REF	1	CN
13	QMSM	TZONSO	TTZZ	TZONE	REF	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in