SAP ABAP Table MCQMSMB (Communication Structure: Notification Tasks)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ QM-QC-IS (Application Component) Information System
     ⤷ QG04 (Package) QM/BW Connection

Basic Data

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

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in