SAP ABAP Table /SAPSMOSS/RQMQMEL1 (R/3 Notifications (Reporting))

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ QM-QN (Application Component) Quality Notifications
     ⤷ /SAPSMOSS/01 (Package) Interface R/3 Notifications - SAP OSS

Basic Data

Table Category	INTTAB	Structure
Structure	/SAPSMOSS/RQMQMEL1	Table Relationship Diagram
Short Description	R/3 Notifications (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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	QMNUM	☑	QMNUM	QMNUM	CHAR	12	0	Message Number	*
3	QMART	☐	QMART	QMART	CHAR	2	0	Message Type	TQ80
4	QMTXT	☐	QMTXT	TEXT40	CHAR	40	0	Short Text
5	ARTPR	☐	ARTPR	ARTPR	CHAR	2	0	Priority Type	T356A
6	PRIOK	☐	PRIOK	PRIOK	CHAR	1	0	Priority	T356
7	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
8	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
9	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
10	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
11	MZEIT	☐	MZEIT	UHRZT	TIMS	6	0	Notification Time
12	QMDAT	☐	QMDAT	DATUM	DATS	8	0	Date of Notification
13	QMNAM	☐	QMNAM	USNAM	CHAR	12	0	Name of declarant
14	STRMN	☐	STRMN	DATUM	DATS	8	0	Desired Start Date
15	STRUR	☐	STRUR	UZEIT	TIMS	6	0	Desired Start Time
16	LTRMN	☐	LTRMN	DATUM	DATS	8	0	Required Finish Date
17	LTRUR	☐	LTRUR	UZEIT	TIMS	6	0	Required End Date-Time
18	AUSVN	☐	AUSVN	DATUM	DATS	8	0	Start of Malfunction (Date)
19	AUZTV	☐	AUZTV	UHRZT	TIMS	6	0	Start of Malfunction (Time)
20	AUSBS	☐	AUSBS	DATUM	DATS	8	0	End of Malfunction (Date)
21	AUZTB	☐	AUZTB	UHRZT	TIMS	6	0	End of Malfunction (Time)
22	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
23	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	AUFK
24	VERID	☐	VERID	VERID	CHAR	4	0	Production Version	MKAL
25	RM_MATNR	☐	RM_MATNR	MATNR	CHAR	18	0	Material number of the production version	MKAL
26	RM_WERKS	☐	RM_WERKS	WERKS	CHAR	4	0	Plant of production version	MKAL
27	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
28	REVLV	☐	REVLV	REVLV	CHAR	2	0	Revision level
29	KUNUM	☐	QKUNUM	KUNNR	CHAR	10	0	Account Number of Customer	KNA1
30	FEKNZ	☐	FEKNZ	CHAR1	CHAR	1	0	Error Records Exist
31	MAKNZ	☐	MAKNZ	CHAR1	CHAR	1	0	Task Records Exist
32	OBJNR	☐	QMOBJNR	J_OBJNR	CHAR	22	0	Object Number for Status Management	ONR00
33	QMDAB	☐	QMDAB	DATUM	DATS	8	0	Date for Completion of Notification
34	QMZAB	☐	QMZAB	UZEIT	TIMS	6	0	Completion Time of Notification
35	RBNR	☐	RBNR	RBNR	CHAR	9	0	Report layout	T352B
36	RBNRI	☐	RBNRI	RBNRI	CHAR	1	0	Origin of Notifications Catalog Profile
37	INDTX	☐	INDLTX	CHAR1	CHAR	1	0	Object Long Text Available
38	KZMLA	☐	KZMLA	CHAR1	CHAR	1	0	Primary language indicator for text segment
39	HERKZ	☐	HERKZ	HERKZ	CHAR	2	0	Origin Indicator for Notification
40	BEZDT	☐	BEZDT	DATUM	DATS	8	0	Notification Reference Date
41	BEZUR	☐	BEZUR_D	UZEIT	TIMS	6	0	Notification Reference Time
42	LIFNUM	☐	LIFNUM	LIFNR	CHAR	10	0	Vendor Account Number	LFA1
43	BUNAME	☐	BUNAME	XUBNAME	CHAR	12	0	Author of a Q/PM Notification	*
44	VBELN	☐	KDAUF	VBELN	CHAR	10	0	Sales Order Number	VBUK
45	BSTNK	☐	BSTKD	BSTKD	CHAR	35	0	Customer purchase order number
46	BSTDK	☐	BSTDK	DATUM	DATS	8	0	Customer purchase order date
47	SPART	☐	SPART	SPART	CHAR	2	0	Division	TSPA
48	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
49	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
50	ADRNR	☐	CADNR	CADRNR	CHAR	10	0	Addresses: Address Number	*
51	AEZEIT	☐	AEZEIT	UHRZT	TIMS	6	0	Time of Change
52	ERZEIT	☐	ERZEIT	UHRZT	TIMS	6	0	Time, at Which Record Was Added
53	MAWERK	☐	QMAWERKS	WERKS	CHAR	4	0	Plant for Material	T001W
54	QMKAT	☐	QMKAT	QKATART	CHAR	1	0	Catalog type - coding	TQ15
55	QMGRP	☐	QMGRP	QCODEGRP	CHAR	8	0	Code group - coding	QPGR
56	QMCOD	☐	QMCOD	QCODE	CHAR	4	0	Coding	*
57	PRUEFLOS	☐	QPLOS	QPLOS	NUMC	12	0	Inspection Lot Number	QALS
58	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	MCH1
59	LGORTCHARG	☐	QLGORTCHAR	LGORT	CHAR	4	0	Storage Location of Batch	T001L
60	LICHN	☐	LICHN	LICHN	CHAR	15	0	Vendor Batch Number
61	HERSTELLER	☐	QLIFNR	LIFNR	CHAR	10	0	Number of Manufacturer	LFA1
62	EMATNR	☐	EMATN	MATNR	CHAR	18	0	Material number corresponding to manufacturer part number	MARA
63	EKORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	T024E
64	BKGRP	☐	BKGRP	EKGRP	CHAR	3	0	Purchasing Group	T024
65	LGORTVORG	☐	QLGORTVORG	LGORT	CHAR	4	0	Storage Location for Inspection Lot Stock	T001L
66	FERTAUFNR	☐	FERTAUFNR	AUFNR	CHAR	12	0	Order Number (Production Order)	AUFK
67	FERTAUFPL	☐	FERTAUFPL	AUFPL	NUMC	10	0	Plan Number for Operations in Order (Production Order)
68	EBELN	☐	EBELN	EBELN	CHAR	10	0	Purchasing Document Number	EKKO
69	EBELP	☐	QEBELP	EBELP	NUMC	5	0	Item Number of Purchasing Document	EKPO
70	MJAHR	☐	MJAHR	GJAHR	NUMC	4	0	Year of material document
71	MBLNR	☐	MBLNR	BELNR	CHAR	10	0	Number of Material Document
72	MBLPO	☐	QMBLPO	MBLPO	NUMC	4	0	Item in Material Document
73	LS_KDAUF	☐	KDAUF	VBELN	CHAR	10	0	Sales Order Number	VBUK
74	LS_KDPOS	☐	KDPOS	NUM06	NUMC	6	0	Item number in Sales Order
75	LS_VBELN	☐	VBELN_VL	VBELN	CHAR	10	0	Delivery	VBUK
76	LS_POSNR	☐	QPOSNR_VL	POSNR	NUMC	6	0	Delivery Item	VBUP
77	CROBJTY	☐	CR_OBJTY	CR_OBJTY	CHAR	2	0	Object types of the CIM resource
78	ARBPL	☐	LGWID	CR_OBJID	NUMC	8	0	Object ID of the Work Center	CRID
79	ARBPLWERK	☐	QARBPWERKS	WERKS	CHAR	4	0	Plant for Work Center	T001W
80	FEART	☐	QFEART	QFEART	CHAR	8	0	Report Type for Defects Recording	TQ86
81	PNLKN	☐	QLFNKN	KNTNR	NUMC	8	0	Current Node Number from Order Counter APLZL
82	MGEIG	☐	MGEIG	MENGE	QUAN	13	3	Defective Quantity (Internal)
83	MGFRD	☐	MGFRD	MENGE	QUAN	13	3	Defective Quantity (External)
84	MGEIN	☐	MGEIN	MEINS	UNIT	3	0	Unit of Measure	T006
85	RKMNG	☐	RKMNG	MENGE	QUAN	13	3	Complaint Quantity
86	RGMNG	☐	RGMNG	MENGE	QUAN	13	3	Return Delivery Quantity
87	RKDAT	☐	RKDAT	DATUM	DATS	8	0	Date of Return Delivery
88	COAUFNR	☐	COAUFNR	AUFNR	CHAR	12	0	Order Number (QM Order)	AUFK
89	QWRNUM	☐	QWRNUM	QMNUM	CHAR	12	0	Reference Notification Number	QMEL
90	REFNUM	☐	QMEXTNR	CHAR020	CHAR	20	0	External Reference Number
91	KDMAT	☐	MATNR_KU	IDNEX	CHAR	35	0	Customer Material Number
92	IDNLF	☐	IDNLF	IDNEX	CHAR	35	0	Material Number Used by Vendor
93	SERIALNR	☐	GERNR	GERNR	CHAR	18	0	Serial Number
94	KZLOESCH	☐	KZLOESCH	CHAR1	CHAR	1	0	Delete Data Record
95	DEVICEID	☐	DEVICEID	DEVICEID	CHAR	40	0	Additional Device Data
96	KTXTGR	☐	QMGRPTEXT	QKURZTEXT	CHAR	40	0	Code Group Text for Coding
97	KTXTCD	☐	QMCODETEXT	QTEXT80	CHAR	80	0	Code Text for Coding
98	STTXT	☐	QMSTTXT	TEXT40	CHAR	40	0	System Status for Notification
99	BARBZT	☐	BARBZT	DEC9_2	DEC	11	2	Processing Time
100	MARBEH	☐	MARBEH	MEINS	UNIT	3	0	Processing Time Unit	T006
101	NAME_LIST	☐	I_NAME_LST	NAME	CHAR	35	0	Name for list displays
102	TEL_NUMBER	☐	AD_TLNMBR1	CHAR30	CHAR	30	0	First telephone no.: dialling code+number
103	POST_CODE1	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
104	CITY1	☐	AD_CITY1	TEXT40	CHAR	40	0	City
105	CITY2	☐	AD_CITY2	TEXT40	CHAR	40	0	District
106	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
107	REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
108	STREET	☐	AD_STREET	TEXT60	CHAR	60	0	Street
109	ARBPL_I	☐	ARBPL	ARBPL	CHAR	8	0	Work center
110	VORNR	☐	QVORNR	VORNR	CHAR	4	0	Operation Number
111	VORKTEXT	☐	QKURZTEXT	QKURZTEXT	CHAR	40	0	Short Text
112	FERTVORNR	☐	QVORNR	VORNR	CHAR	4	0	Operation Number
113	FERTVORKTX	☐	QKURZTEXT	QKURZTEXT	CHAR	40	0	Short Text
114	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	*
115	VKGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	*
116	PRIOKX	☐	PRIOKX	TEXT20	CHAR	20	0	Priority Text
117	.INCLUDE	☐				0	0	OSS-Relevant Attributes/Fields
118	/SAPSMOSS/INSTN	☐	/SAPSMOSS/R3INSTN	/SAPSMOSS/R3INSTN	CHAR	10	0	Installation number	/SAPSMOSS/INSTN
119	/SAPSMOSS/MNUMM	☐	/SAPSMOSS/MNUMM	/SAPSMOSS/MNUMM	NUMC	24	0	SAPNet notification number
120	/SAPSMOSS/OSSYS	☐	/SAPSMOSS/OSSYS	/SAPSMOSS/OSSYS	CHAR	10	0	Operating system and version	/SAPSMOSS/OSYS
121	/SAPSMOSS/DBSYS	☐	/SAPSMOSS/DBSYS	/SAPSMOSS/DBSYS	CHAR	10	0	Database system	/SAPSMOSS/DBSY
122	/SAPSMOSS/REL	☐	/SAPSMOSS/R3REL	/SAPSMOSS/R3REL	CHAR	10	0	R/3 Release	/SAPSMOSS/REL
123	/SAPSMOSS/COMP	☐	/SAPSMOSS/R3COMP	/SAPSMOSS/R3COMP	CHAR	20	0	Area
124	/SAPSMOSS/FRONT	☐	/SAPSMOSS/FRONTEND	/SAPSMOSS/FRONTEND	CHAR	10	0	Frontend	/SAPSMOSS/FRNT
125	/SAPSMOSS/SYSTYP	☐	/SAPSMOSS/R3SYSTYPE	/SAPSMOSS/R3SYSTYPE	CHAR	1	0	R/3 System type	/SAPSMOSS/SYST
126	/SAPSMOSS/ADDID	☐	/SAPSMOSS/R3ADDID	/SAPSMOSS/R3ADDID	CHAR	10	0	Add-on ID	/SAPSMOSS/ADDID
127	/SAPSMOSS/ADDREL	☐	/SAPSMOSS/R3ADDREL	/SAPSMOSS/R3ADDREL	CHAR	10	0	Add-On Release	/SAPSMOSS/ADDRL
128	/SAPSMOSS/TSTMP	☐	/SAPSMOSS/NSTSTMP	TZNTIMESTP	NUMC	14	0	SAPNet time stamp
129	/SAPSMOSS/STATUS	☐	/SAPSMOSS/STATUS	/SAPSMOSS/STATUS	CHAR	1	0	Status of R/3 notification in SAPNet	/SAPSMOSS/STAT
130	/SAPSMOSS/ERDAT	☐	/SAPSMOSS/ERDAT	DATUM	DATS	8	0	Date on which notification was completed at SAP
131	/SAPSMOSS/ERZEIT	☐	/SAPSMOSS/ERZEIT	UHRZT	TIMS	6	0	Time when notification was completed at SAP
132	/SAPSMOSS/SYSID	☐	SYSYSID	SYCHAR08	CHAR	8	0	Name of SAP System
133	/SAPSMOSS/MANDT	☐	SYMANDT	MANDT	CLNT	3	0	Client ID	*

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in