SAP ABAP Table RQMQMSM1 (General notification - Tasks (reporting))

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ QQM (Package) QM quality notification

Basic Data

Table Category	INTTAB	Structure
Structure	RQMQMSM1	Table Relationship Diagram
Short Description	General notification - Tasks (reporting)

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	KTXTCD	☐	SMCODETEXT	QTEXT80	CHAR	80	0	Code Text for Task
56	KTXTGR	☐	SMGRPTEXT	QKURZTEXT	CHAR	40	0	Code Group Text for Task
57	QSMSTTXT	☐	QSMSTTXT	TEXT40	CHAR	40	0	Task Status
58	QMART	☐	QMART	QMART	CHAR	2	0	Message Type	TQ80
59	QMTXT	☐	QMTXT	TEXT40	CHAR	40	0	Short Text
60	ARTPR	☐	ARTPR	ARTPR	CHAR	2	0	Priority Type	T356A
61	PRIOK	☐	PRIOK	PRIOK	CHAR	1	0	Priority	T356
62	STTXT	☐	QMSTTXT	TEXT40	CHAR	40	0	System Status for Notification
63	MZEIT	☐	MZEIT	UHRZT	TIMS	6	0	Notification Time
64	QMDAT	☐	QMDAT	DATUM	DATS	8	0	Date of Notification
65	QMNAM	☐	QMNAM	USNAM	CHAR	12	0	Name of declarant
66	STRMN	☐	STRMN	DATUM	DATS	8	0	Desired Start Date
67	STRUR	☐	STRUR	UZEIT	TIMS	6	0	Desired Start Time
68	LTRMN	☐	LTRMN	DATUM	DATS	8	0	Required Finish Date
69	LTRUR	☐	LTRUR	UZEIT	TIMS	6	0	Required End Date-Time
70	QMDAB	☐	QMDAB	DATUM	DATS	8	0	Date for Completion of Notification
71	QMZAB	☐	QMZAB	UZEIT	TIMS	6	0	Completion Time of Notification
72	BARBZT	☐	BARBZT	DEC9_2	DEC	11	2	Processing Time
73	MARBEH	☐	MARBEH	MEINS	UNIT	3	0	Processing Time Unit	T006
74	MAWERK	☐	QMAWERKS	WERKS	CHAR	4	0	Plant for Material	T001W
75	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
76	REVLV	☐	REVLV	REVLV	CHAR	2	0	Revision level
77	KUNUM	☐	QKUNUM	KUNNR	CHAR	10	0	Account Number of Customer	KNA1
78	RBNR	☐	RBNR	RBNR	CHAR	9	0	Report layout	T352B
79	LIFNUM	☐	LIFNUM	LIFNR	CHAR	10	0	Vendor Account Number	LFA1
80	BUNAME	☐	BUNAME	XUBNAME	CHAR	12	0	Author of a Q/PM Notification	*
81	ADRNR	☐	CADNR	CADRNR	CHAR	10	0	Addresses: Address Number	*
82	COAUFNR	☐	COAUFNR	AUFNR	CHAR	12	0	Order Number (QM Order)	AUFK
83	NAME_LIST	☐	I_NAME_LST	NAME	CHAR	35	0	Name for list displays
84	TEL_NUMBER	☐	AD_TLNMBR1	CHAR30	CHAR	30	0	First telephone no.: dialling code+number
85	POST_CODE1	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
86	CITY1	☐	AD_CITY1	TEXT40	CHAR	40	0	City
87	CITY2	☐	AD_CITY2	TEXT40	CHAR	40	0	District
88	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
89	REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
90	STREET	☐	AD_STREET	TEXT60	CHAR	60	0	Street
91	PARNAM_INT	☐	I_NAME_INT	NAME	CHAR	35	0	List name of internal employee resp.for carrying out job
92	PRIOKX	☐	PRIOKX	TEXT20	CHAR	20	0	Priority Text
93	HERSTELLER	☐	QLIFNR	LIFNR	CHAR	10	0	Number of Manufacturer	*
94	MATKTX	☐	MAKTX	TEXT40	CHAR	40	0	Material description

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	RQMQMSM1	ABC_TEMPL	COTPL	TEMPLATE	REF	C	CN
2	RQMQMSM1	ARTPR	T356A	ARTPR	REF	C	CN
3	RQMQMSM1	COAUFNR	AUFK	AUFNR
4	RQMQMSM1	FENUM	QMFE	FENUM
5	RQMQMSM1	FOLGEACT	TQ07	FOLGEAKTI		C	CN
6	RQMQMSM1	KUNUM	KNA1	KUNNR	REF	C	CN
7	RQMQMSM1	LIFNUM	LFA1	LIFNR
8	RQMQMSM1	MANDT	T000	MANDT	KEY	1	CN
9	RQMQMSM1	MARBEH	T006	MSEHI
10	RQMQMSM1	MATNR	MARA	MATNR	REF	C	CN
11	RQMQMSM1	MAWERK	T001W	WERKS
12	RQMQMSM1	MMGEIN	T006	MSEHI
13	RQMQMSM1	MNGRP	QPGR	CODEGRUPPE	REF	C	CN
14	RQMQMSM1	MNKAT	TQ15	KATALOGART	REF	C	CN
15	RQMQMSM1	OBJNR	ONR00	OBJNR	REF	C	CN
16	RQMQMSM1	PARVW	TPAR	PARVW
17	RQMQMSM1	PRIOK	T356	PRIOK
18	RQMQMSM1	QMART	TQ80	QMART	REF	C	CN
19	RQMQMSM1	QMNUM	QMEL	QMNUM	KEY	1	CN
20	RQMQMSM1	RBNR	T352B	RBNR	REF	C	CN
21	RQMQMSM1	TSEGTP	TTSEGTPLH	TEPL	REF	1	CN
22	RQMQMSM1	TZONSM	TTZZ	TZONE	REF	1	CN
23	RQMQMSM1	TZONSO	TTZZ	TZONE	REF	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in