SAP ABAP Table RQMQMEL1 (Quality notification - notifications (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	RQMQMEL1	Table Relationship Diagram
Short Description	Quality notification - 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	BZMNG	☐	QBZMNG	MENGE	QUAN	13	3	General Reference Quantity
86	RKMNG	☐	RKMNG	MENGE	QUAN	13	3	Complaint Quantity
87	RGMNG	☐	RGMNG	MENGE	QUAN	13	3	Return Delivery Quantity
88	RKDAT	☐	RKDAT	DATUM	DATS	8	0	Date of Return Delivery
89	COAUFNR	☐	COAUFNR	AUFNR	CHAR	12	0	Order Number (QM Order)	AUFK
90	QWRNUM	☐	QWRNUM	QMNUM	CHAR	12	0	Reference Notification Number	QMEL
91	REFNUM	☐	QMEXTNR	CHAR020	CHAR	20	0	External Reference Number
92	KDMAT	☐	MATNR_KU	IDNEX	CHAR	35	0	Customer Material Number
93	IDNLF	☐	IDNLF	IDNEX	CHAR	35	0	Material Number Used by Vendor
94	SERIALNR	☐	GERNR	GERNR	CHAR	18	0	Serial Number
95	KZLOESCH	☐	KZLOESCH	CHAR1	CHAR	1	0	Delete Data Record
96	DEVICEID	☐	DEVICEID	DEVICEID	CHAR	40	0	Additional Device Data
97	KTXTGR	☐	QMGRPTEXT	QKURZTEXT	CHAR	40	0	Code Group Text for Coding
98	KTXTCD	☐	QMCODETEXT	QTEXT80	CHAR	80	0	Code Text for Coding
99	STTXT	☐	QMSTTXT	TEXT40	CHAR	40	0	System Status for Notification
100	BARBZT	☐	BARBZT	DEC9_2	DEC	11	2	Processing Time
101	MARBEH	☐	MARBEH	MEINS	UNIT	3	0	Processing Time Unit	T006
102	NAME_LIST	☐	I_NAME_LST	NAME	CHAR	35	0	Name for list displays
103	TEL_NUMBER	☐	AD_TLNMBR1	CHAR30	CHAR	30	0	First telephone no.: dialling code+number
104	POST_CODE1	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
105	CITY1	☐	AD_CITY1	TEXT40	CHAR	40	0	City
106	CITY2	☐	AD_CITY2	TEXT40	CHAR	40	0	District
107	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
108	REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
109	STREET	☐	AD_STREET	TEXT60	CHAR	60	0	Street
110	ARBPL_I	☐	ARBPL	ARBPL	CHAR	8	0	Work center
111	VORNR	☐	QVORNR	VORNR	CHAR	4	0	Operation Number
112	VORKTEXT	☐	QKURZTEXT	QKURZTEXT	CHAR	40	0	Short Text
113	FERTVORNR	☐	QVORNR	VORNR	CHAR	4	0	Operation Number
114	FERTVORKTX	☐	QKURZTEXT	QKURZTEXT	CHAR	40	0	Short Text
115	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	*
116	VKGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	*
117	PRIOKX	☐	PRIOKX	TEXT20	CHAR	20	0	Priority Text
118	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	RQMQMEL1	ARBPL	CRID	OBJID	REF	C	CN
2	RQMQMEL1	ARBPLWERK	T001W	WERKS
3	RQMQMEL1	ARTPR	T356A	ARTPR
4	RQMQMEL1	AUFNR	AUFK	AUFNR
5	RQMQMEL1	BKGRP	T024	EKGRP
6	RQMQMEL1	CHARG	MCH1	CHARG
7	RQMQMEL1	COAUFNR	AUFK	AUFNR
8	RQMQMEL1	COUNTRY	T005	LAND1
9	RQMQMEL1	EBELN	EKKO	EBELN	REF	C	CN
10	RQMQMEL1	EBELP	EKPO	EBELP
11	RQMQMEL1	EKORG	T024E	EKORG
12	RQMQMEL1	EMATNR	MARA	MATNR		C	CN
13	RQMQMEL1	FEART	TQ86	FEART
14	RQMQMEL1	FERTAUFNR	AUFK	AUFNR
15	RQMQMEL1	HERSTELLER	LFA1	LIFNR
16	RQMQMEL1	KUNUM	KNA1	KUNNR
17	RQMQMEL1	LGORTCHARG	T001L	LGORT
18	RQMQMEL1	LGORTVORG	T001L	LGORT
19	RQMQMEL1	LIFNUM	LFA1	LIFNR
20	RQMQMEL1	LS_KDAUF	VBUK	VBELN	REF	C	CN
21	RQMQMEL1	LS_POSNR	VBUP	POSNR	REF	C	CN
22	RQMQMEL1	LS_VBELN	VBUK	VBELN	REF	C	CN
23	RQMQMEL1	MANDT	T000	MANDT
24	RQMQMEL1	MARBEH	T006	MSEHI
25	RQMQMEL1	MATNR	MARA	MATNR
26	RQMQMEL1	MAWERK	T001W	WERKS
27	RQMQMEL1	MGEIN	T006	MSEHI
28	RQMQMEL1	OBJNR	ONR00	OBJNR
29	RQMQMEL1	PRIOK	T356	PRIOK
30	RQMQMEL1	PRUEFLOS	QALS	PRUEFLOS
31	RQMQMEL1	QMART	TQ80	QMART
32	RQMQMEL1	QMGRP	QPGR	CODEGRUPPE	REF	C	CN
33	RQMQMEL1	QMKAT	TQ15	KATALOGART
34	RQMQMEL1	QWRNUM	QMEL	QMNUM
35	RQMQMEL1	RBNR	T352B	RBNR
36	RQMQMEL1	REGION	T005S	BLAND
37	RQMQMEL1	RM_MATNR	MKAL	MATNR
38	RQMQMEL1	RM_WERKS	MKAL	WERKS
39	RQMQMEL1	SPART	TSPA	SPART
40	RQMQMEL1	VBELN	VBUK	VBELN
41	RQMQMEL1	VERID	MKAL	VERID	KEY	C	CN
42	RQMQMEL1	VKORG	TVKO	VKORG
43	RQMQMEL1	VTWEG	TVTW	VTWEG
44	RQMQMEL1	WAERS	TCURC	WAERS

History

Last changed by/on	SAP	20130529
SAP Release Created in