SAP ABAP Table RQMQMEL2 (General Notification - Header Data)

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	RQMQMEL2	Table Relationship Diagram
Short Description	General Notification - Header Data

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
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	QMNUM	☐	QMNUM	QMNUM	CHAR	12	0	Message Number	*
4	QMART	☐	QMART	QMART	CHAR	2	0	Message Type	TQ80
5	QMTXT	☐	QMTXT	TEXT40	CHAR	40	0	Short Text
6	ARTPR	☐	ARTPR	ARTPR	CHAR	2	0	Priority Type	T356A
7	PRIOK	☐	PRIOK	PRIOK	CHAR	1	0	Priority	T356
8	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
9	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
10	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
11	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
12	MZEIT	☐	MZEIT	UHRZT	TIMS	6	0	Notification Time
13	QMDAT	☐	QMDAT	DATUM	DATS	8	0	Date of Notification
14	QMNAM	☐	QMNAM	USNAM	CHAR	12	0	Name of declarant
15	STRMN	☐	STRMN	DATUM	DATS	8	0	Desired Start Date
16	STRUR	☐	STRUR	UZEIT	TIMS	6	0	Desired Start Time
17	LTRMN	☐	LTRMN	DATUM	DATS	8	0	Required Finish Date
18	LTRUR	☐	LTRUR	UZEIT	TIMS	6	0	Required End Date-Time
19	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
20	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	AUFK
21	VERID	☐	VERID	VERID	CHAR	4	0	Production Version	MKAL
22	RM_MATNR	☐	RM_MATNR	MATNR	CHAR	18	0	Material number of the production version	MKAL
23	RM_WERKS	☐	RM_WERKS	WERKS	CHAR	4	0	Plant of production version	MKAL
24	SA_AUFNR	☐	SA_AUFNR	SA_AUFNR	CHAR	12	0	Run schedule header number	SAFK
25	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
26	REVLV	☐	REVLV	REVLV	CHAR	2	0	Revision level
27	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	T023
28	PRDHA	☐	PRODH_D	PRODH	CHAR	18	0	Product Hierarchy	T179
29	KZKRI	☐	KZKRI	XFELD	CHAR	1	0	Indicator: Critical part
30	KZDKZ	☐	KZDKZ	XFELD	CHAR	1	0	Documentation required indicator
31	KUNUM	☐	QKUNUM	KUNNR	CHAR	10	0	Account Number of Customer	KNA1
32	FEKNZ	☐	FEKNZ	CHAR1	CHAR	1	0	Error Records Exist
33	MAKNZ	☐	MAKNZ	CHAR1	CHAR	1	0	Task Records Exist
34	OBJNR	☐	QMOBJNR	J_OBJNR	CHAR	22	0	Object Number for Status Management	ONR00
35	QMDAB	☐	QMDAB	DATUM	DATS	8	0	Date for Completion of Notification
36	QMZAB	☐	QMZAB	UZEIT	TIMS	6	0	Completion Time of Notification
37	RBNR	☐	RBNR	RBNR	CHAR	9	0	Report layout	T352B
38	RBNRI	☐	RBNRI	RBNRI	CHAR	1	0	Origin of Notifications Catalog Profile
39	INDTX	☐	INDLTX	CHAR1	CHAR	1	0	Object Long Text Available
40	KZMLA	☐	KZMLA	CHAR1	CHAR	1	0	Primary language indicator for text segment
41	HERKZ	☐	HERKZ	HERKZ	CHAR	2	0	Origin Indicator for Notification
42	BEZDT	☐	BEZDT	DATUM	DATS	8	0	Notification Reference Date
43	BEZUR	☐	BEZUR_D	UZEIT	TIMS	6	0	Notification Reference Time
44	LIFNUM	☐	LIFNUM	LIFNR	CHAR	10	0	Vendor Account Number	LFA1
45	BUNAME	☐	BUNAME	XUBNAME	CHAR	12	0	Author of a Q/PM Notification	*
46	VBELN	☐	KDAUF	VBELN	CHAR	10	0	Sales Order Number	VBUK
47	BSTNK	☐	BSTKD	BSTKD	CHAR	35	0	Customer purchase order number
48	BSTDK	☐	BSTDK	DATUM	DATS	8	0	Customer purchase order date
49	SPART	☐	SPART	SPART	CHAR	2	0	Division	TSPA
50	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
51	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
52	ADRNR	☐	CADNR	CADRNR	CHAR	10	0	Addresses: Address Number	*
53	AEZEIT	☐	AEZEIT	UHRZT	TIMS	6	0	Time of Change
54	ERZEIT	☐	ERZEIT	UHRZT	TIMS	6	0	Time, at Which Record Was Added
55	MAWERK	☐	QMAWERKS	WERKS	CHAR	4	0	Plant for Material	T001W
56	QMKAT	☐	QMKAT	QKATART	CHAR	1	0	Catalog type - coding	TQ15
57	QMGRP	☐	QMGRP	QCODEGRP	CHAR	8	0	Code group - coding	QPGR
58	QMCOD	☐	QMCOD	QCODE	CHAR	4	0	Coding	*
59	AUSWIRK	☐	QSCENARIO	QSCENARIO	CHAR	4	0	Key for a Scenario	TQ81
60	TEILEV	☐	QTEILEV	QTEILEV	CHAR	4	0	Usage of Parts	TQ81V
61	PRUEFLOS	☐	QPLOS	QPLOS	NUMC	12	0	Inspection Lot Number	QALS
62	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	MCH1
63	LGORTCHARG	☐	QLGORTCHAR	LGORT	CHAR	4	0	Storage Location of Batch	T001L
64	LICHN	☐	LICHN	LICHN	CHAR	15	0	Vendor Batch Number
65	HERSTELLER	☐	QLIFNR	LIFNR	CHAR	10	0	Number of Manufacturer	LFA1
66	EMATNR	☐	EMATN	MATNR	CHAR	18	0	Material number corresponding to manufacturer part number	MARA
67	EKORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	T024E
68	BKGRP	☐	BKGRP	EKGRP	CHAR	3	0	Purchasing Group	T024
69	LGORTVORG	☐	QLGORTVORG	LGORT	CHAR	4	0	Storage Location for Inspection Lot Stock	T001L
70	FERTAUFNR	☐	FERTAUFNR	AUFNR	CHAR	12	0	Order Number (Production Order)	AUFK
71	FERTAUFPL	☐	FERTAUFPL	AUFPL	NUMC	10	0	Plan Number for Operations in Order (Production Order)
72	EBELN	☐	EBELN	EBELN	CHAR	10	0	Purchasing Document Number	EKKO
73	EBELP	☐	QEBELP	EBELP	NUMC	5	0	Item Number of Purchasing Document	EKPO
74	MJAHR	☐	MJAHR	GJAHR	NUMC	4	0	Year of material document
75	MBLNR	☐	MBLNR	BELNR	CHAR	10	0	Number of Material Document
76	MBLPO	☐	QMBLPO	MBLPO	NUMC	4	0	Item in Material Document
77	LS_KDAUF	☐	KDAUF	VBELN	CHAR	10	0	Sales Order Number	VBUK
78	LS_KDPOS	☐	POSNR	POSNR	NUMC	6	0	Item number of the SD document	VBUP
79	LS_VBELN	☐	VBELN_VL	VBELN	CHAR	10	0	Delivery	VBUK
80	LS_POSNR	☐	QPOSNR_VL	POSNR	NUMC	6	0	Delivery Item	VBUP
81	CROBJTY	☐	CR_OBJTY	CR_OBJTY	CHAR	2	0	Object types of the CIM resource
82	ARBPL	☐	LGWID	CR_OBJID	NUMC	8	0	Object ID of the Work Center	CRID
83	ARBPLWERK	☐	QARBPWERKS	WERKS	CHAR	4	0	Plant for Work Center	T001W
84	FEART	☐	QFEART	QFEART	CHAR	8	0	Report Type for Defects Recording	TQ86
85	PNLKN	☐	QLFNKN	KNTNR	NUMC	8	0	Current Node Number from Order Counter APLZL
86	MGEIG	☐	MGEIG	MENGE	QUAN	13	3	Defective Quantity (Internal)
87	MGFRD	☐	MGFRD	MENGE	QUAN	13	3	Defective Quantity (External)
88	MGEIN	☐	MGEIN	MEINS	UNIT	3	0	Unit of Measure	T006
89	BZMNG	☐	QBZMNG	MENGE	QUAN	13	3	General Reference Quantity
90	RKMNG	☐	RKMNG	MENGE	QUAN	13	3	Complaint Quantity
91	RGMNG	☐	RGMNG	MENGE	QUAN	13	3	Return Delivery Quantity
92	RKDAT	☐	RKDAT	DATUM	DATS	8	0	Date of Return Delivery
93	COAUFNR	☐	COAUFNR	AUFNR	CHAR	12	0	Order Number (QM Order)	AUFK
94	QWRNUM	☐	QWRNUM	QMNUM	CHAR	12	0	Reference Notification Number	QMEL
95	REFNUM	☐	QMEXTNR	CHAR020	CHAR	20	0	External Reference Number
96	KDMAT	☐	MATNR_KU	IDNEX	CHAR	35	0	Customer Material Number
97	IDNLF	☐	IDNLF	IDNEX	CHAR	35	0	Material Number Used by Vendor
98	SERIALNR	☐	GERNR	GERNR	CHAR	18	0	Serial Number
99	KZLOESCH	☐	KZLOESCH	CHAR1	CHAR	1	0	Delete Data Record
100	PRODDAT	☐	QPRODDAT	DATUM	DATS	8	0	Production Date
101	DEVICEID	☐	DEVICEID	DEVICEID	CHAR	40	0	Additional Device Data
102	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	TVKBZ
103	VKGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	TVBVK
104	AUTKZ	☐	QAUTKZ	QKZ	CHAR	1	0	Data Record Created with Function 'Create with Copy Model'
105	BEDID	☐	BEDID	BEDID	NUMC	12	0	ID of the capacity requirements record	*
106	BEDZL	☐	CIM_COUNT	CIM_COUNT	NUMC	8	0	Internal counter
107	PROFIL_TYP	☐	OTYPE	OTYPE	CHAR	2	0	Object Type	*
108	PROFIL_ID	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
109	HANDLE	☐	TSEGGUID	SYSUUID_22	CHAR	22	0	Globally unique identifier (linked to time segment, etc)
110	TSEGFL	☐	TSEGEXISTS	FLAG	CHAR	1	0	Time segment exists
111	TSEGTP	☐	TSEGTEMPLA	TSEGTEMPLA	CHAR	10	0	Template	TTSEGTPLH
112	TZONSO	☐	TZONSO	TZNZONE	CHAR	6	0	Time zone for notification	TTZZ
113	TZONID	☐	TZONSMID	TZONSMID	CHAR	1	0	Origin of Time Zone in Notification
114	FUNKTION	☐	QNFUNKTION	CHAR4	CHAR	4	0	Keys for Function in Action Box
115	.INCLUDE	☐				0	0
116	.INCLUDE	☐				0	0	OSS-Relevant Attributes/Fields
117	/SAPSMOSS/INSTN	☐	/SAPSMOSS/R3INSTN	/SAPSMOSS/R3INSTN	CHAR	10	0	Installation number	/SAPSMOSS/INSTN
118	/SAPSMOSS/MNUMM	☐	/SAPSMOSS/MNUMM	/SAPSMOSS/MNUMM	NUMC	24	0	SAPNet notification number
119	/SAPSMOSS/OSSYS	☐	/SAPSMOSS/OSSYS	/SAPSMOSS/OSSYS	CHAR	10	0	Operating system and version	/SAPSMOSS/OSYS
120	/SAPSMOSS/DBSYS	☐	/SAPSMOSS/DBSYS	/SAPSMOSS/DBSYS	CHAR	10	0	Database system	/SAPSMOSS/DBSY
121	/SAPSMOSS/REL	☐	/SAPSMOSS/R3REL	/SAPSMOSS/R3REL	CHAR	10	0	R/3 Release	/SAPSMOSS/REL
122	/SAPSMOSS/COMP	☐	/SAPSMOSS/R3COMP	/SAPSMOSS/R3COMP	CHAR	20	0	Area
123	/SAPSMOSS/FRONT	☐	/SAPSMOSS/FRONTEND	/SAPSMOSS/FRONTEND	CHAR	10	0	Frontend	/SAPSMOSS/FRNT
124	/SAPSMOSS/SYSTYP	☐	/SAPSMOSS/R3SYSTYPE	/SAPSMOSS/R3SYSTYPE	CHAR	1	0	R/3 System type	/SAPSMOSS/SYST
125	/SAPSMOSS/ADDID	☐	/SAPSMOSS/R3ADDID	/SAPSMOSS/R3ADDID	CHAR	10	0	Add-on ID	/SAPSMOSS/ADDID
126	/SAPSMOSS/ADDREL	☐	/SAPSMOSS/R3ADDREL	/SAPSMOSS/R3ADDREL	CHAR	10	0	Add-On Release	/SAPSMOSS/ADDRL
127	/SAPSMOSS/TSTMP	☐	/SAPSMOSS/NSTSTMP	TZNTIMESTP	NUMC	14	0	SAPNet time stamp
128	/SAPSMOSS/STATUS	☐	/SAPSMOSS/STATUS	/SAPSMOSS/STATUS	CHAR	1	0	Status of R/3 notification in SAPNet	/SAPSMOSS/STAT
129	/SAPSMOSS/ERDAT	☐	/SAPSMOSS/ERDAT	DATUM	DATS	8	0	Date on which notification was completed at SAP
130	/SAPSMOSS/ERZEIT	☐	/SAPSMOSS/ERZEIT	UHRZT	TIMS	6	0	Time when notification was completed at SAP
131	/SAPSMOSS/SYSID	☐	SYSYSID	SYCHAR08	CHAR	8	0	Name of SAP System
132	/SAPSMOSS/MANDT	☐	SYMANDT	MANDT	CLNT	3	0	Client ID	*
133	.INCLUDE	☐				0	0	Additional Claim Management Data
134	PSP_NR	☐	PS_POSNR	PS_POSNR	NUMC	8	0	WBS Element	*
135	ESTIMATED_COSTS	☐	PS_COSTS	WERTV7	CURR	13	2	Estimated Costs for a Claim
136	CLAIMED_COSTS	☐	COSTS_CLAIM	WERTV7	CURR	13	2	Costs Claimed
137	RESULT_COSTS	☐	COSTS_RESULT	WERTV7	CURR	13	2	Costs Accepted
138	CHANCE	☐	PS_CHANCE	PS_CHANCE	NUMC	2	0	Chance of Completing a Claim
139	OPPONENT	☐	PS_OPPONENT	OPPONENT	CHAR	2	0	Partner Type
140	KALNR	☐	CK_KALNR	CK_KALNR	NUMC	12	0	Cost Estimate Number for Cost Est. w/o Qty Structure	*
141	KALVAR	☐	CK_KALVAR	KLVAR	CHAR	4	0	Costing Variant for Postprocessing with Unit Costing	*
142	OBJNR_REAL	☐	J_OBJNR_REAL	J_OBJNR	CHAR	22	0	Object number of real CO account assignment	ONR00
143	OBJNR_STAT	☐	OBJNR_N1	J_OBJNR	CHAR	22	0	Auxiliary account assignment 1	ONR00
144	PHASE	☐	QM_PHASE	QM_PHASE	CHAR	1	0	Notification Processing Phase
145	.INCLU--AP	☐				0	0	Fields for /ISDFPS/ Enhancements
146	/ISDFPS/OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	*
147	LOGSYSTEM	☐	LOGSYSTEM	LOGSYS	CHAR	10	0	Logical System	*
148	/ISDFPS/MEQUI	☐	/ISDFPS/MEQUI	EQUNR	CHAR	18	0	Master Equipment	*
149	.INCLU--AP	☐				0	0	QMEL Append: Reference Work Center/Hierarchy Shift Note
150	SHN_OBJTY	☐	CR_OBJTY	CR_OBJTY	CHAR	2	0	Object types of the CIM resource
151	SHN_OBJID	☐	CR_OBJID	CR_OBJID	NUMC	8	0	Object ID of the resource	*
152	SHN_FUNCT_LOC	☐	TPLNR	TPLNR	CHAR	30	0	Functional Location	*
153	SHN_EQUIPMENT	☐	EQUNR	EQUNR	CHAR	18	0	Equipment Number	*
154	SHN_ORIGIN	☐	COCF_SRN_ORIGIN	COCF_SRN_ORIGIN	NUMC	2	0	Origin or Use of Shift Note or Report
155	.INCLU--AP	☐				0	0	IUID Append
156	UII	☐	UII_CHAR72	UII_CHAR72	CHAR	72	0	Unique Item Identifier
157	KTXTGR	☐	QMGRPTEXT	QKURZTEXT	CHAR	40	0	Code Group Text for Coding
158	KTXTCD	☐	QMCODETEXT	QTEXT80	CHAR	80	0	Code Text for Coding
159	STTXT	☐	QMSTTXT	TEXT40	CHAR	40	0	System Status for Notification
160	POSID	☐	PS_POSID	PS_POSID	CHAR	24	0	Work Breakdown Structure Element (WBS Element)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	RQMQMEL2	/SAPSMOSS/ADDID	/SAPSMOSS/ADDID	R3ADDID
2	RQMQMEL2	/SAPSMOSS/ADDREL	/SAPSMOSS/ADDRL	R3ADDREL
3	RQMQMEL2	/SAPSMOSS/DBSYS	/SAPSMOSS/DBSY	DBSYS	REF	1	CN
4	RQMQMEL2	/SAPSMOSS/FRONT	/SAPSMOSS/FRNT	FRONTEND	REF
5	RQMQMEL2	/SAPSMOSS/INSTN	/SAPSMOSS/INSTN	R3INSTN	REF	1	CN
6	RQMQMEL2	/SAPSMOSS/OSSYS	/SAPSMOSS/OSYS	OSSYS	REF	1	CN
7	RQMQMEL2	/SAPSMOSS/REL	/SAPSMOSS/REL	R3REL	REF	1	CN
8	RQMQMEL2	/SAPSMOSS/STATUS	/SAPSMOSS/STAT	STATUS
9	RQMQMEL2	/SAPSMOSS/SYSTYP	/SAPSMOSS/SYST	R3SYSTYPE	REF	1	CN
10	RQMQMEL2	ARBPL	CRID	OBJID	REF	C	CN
11	RQMQMEL2	ARBPLWERK	T001W	WERKS
12	RQMQMEL2	ARTPR	T356A	ARTPR	REF	C	CN
13	RQMQMEL2	AUFNR	AUFK	AUFNR	REF	C	CN
14	RQMQMEL2	AUSWIRK	TQ81	AUSWIRK	KEY
15	RQMQMEL2	BKGRP	T024	EKGRP
16	RQMQMEL2	CHARG	MCH1	CHARG
17	RQMQMEL2	COAUFNR	AUFK	AUFNR
18	RQMQMEL2	EBELN	EKKO	EBELN	REF	C	CN
19	RQMQMEL2	EBELP	EKPO	EBELP
20	RQMQMEL2	EKORG	T024E	EKORG
21	RQMQMEL2	EMATNR	MARA	MATNR		C	CN
22	RQMQMEL2	FEART	TQ86	FEART	REF	C	CN
23	RQMQMEL2	FERTAUFNR	AUFK	AUFNR
24	RQMQMEL2	HERSTELLER	LFA1	LIFNR
25	RQMQMEL2	KUNUM	KNA1	KUNNR	REF	C	CN
26	RQMQMEL2	LGORTCHARG	T001L	LGORT
27	RQMQMEL2	LGORTVORG	T001L	LGORT
28	RQMQMEL2	LIFNUM	LFA1	LIFNR
29	RQMQMEL2	LS_KDAUF	VBUK	VBELN	REF	C	CN
30	RQMQMEL2	LS_KDPOS	VBUP	POSNR
31	RQMQMEL2	LS_POSNR	VBUP	POSNR	REF	C	CN
32	RQMQMEL2	LS_VBELN	VBUK	VBELN	REF	C	CN
33	RQMQMEL2	MANDT	T000	MANDT	KEY	1	CN
34	RQMQMEL2	MATKL	T023	MATKL
35	RQMQMEL2	MATNR	MARA	MATNR	REF	C	CN
36	RQMQMEL2	MAWERK	T001W	WERKS
37	RQMQMEL2	MGEIN	T006	MSEHI
38	RQMQMEL2	OBJNR	ONR00	OBJNR	REF	C	CN
39	RQMQMEL2	OBJNR_REAL	ONR00	OBJNR	REF	C	CN
40	RQMQMEL2	OBJNR_STAT	ONR00	OBJNR	REF	C	CN
41	RQMQMEL2	PRDHA	T179	PRODH
42	RQMQMEL2	PRIOK	T356	PRIOK	REF	C	CN
43	RQMQMEL2	PRUEFLOS	QALS	PRUEFLOS
44	RQMQMEL2	QMART	TQ80	QMART	REF	C	CN
45	RQMQMEL2	QMGRP	QPGR	CODEGRUPPE	REF	C	CN
46	RQMQMEL2	QMKAT	TQ15	KATALOGART
47	RQMQMEL2	QWRNUM	QMEL	QMNUM
48	RQMQMEL2	RBNR	T352B	RBNR	REF	C	CN
49	RQMQMEL2	RM_MATNR	MKAL	MATNR
50	RQMQMEL2	RM_WERKS	MKAL	WERKS
51	RQMQMEL2	SA_AUFNR	SAFK	AUFNR	KEY	C	CN
52	RQMQMEL2	SPART	TSPA	SPART
53	RQMQMEL2	TEILEV	TQ81V	TEILEV
54	RQMQMEL2	TSEGTP	TTSEGTPLH	TEPL	REF	1	CN
55	RQMQMEL2	TZONSO	TTZZ	TZONE	REF	1	CN
56	RQMQMEL2	VBELN	VBUK	VBELN
57	RQMQMEL2	VERID	MKAL	VERID
58	RQMQMEL2	VKBUR	TVKBZ	VKBUR
59	RQMQMEL2	VKGRP	TVBVK	VKGRP
60	RQMQMEL2	VKORG	TVKO	VKORG
61	RQMQMEL2	VTWEG	TVTW	VTWEG
62	RQMQMEL2	WAERS	TCURC	WAERS	REF	C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in	46C