Follow us on LinkedIn for your next SAP project

SAP Table RQMQMEL1

Quality notification - notifications (reporting)

RQMQMEL1 (Quality notification - notifications (reporting)) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link RQMQMEL1 to other SAP tables.

RQMQMEL1 table fields

Field Data element Checktable Datatype Length Decimals Possible values
MANDT
Client
MANDT T000
CLNT
3 0
QMNUM
Notification No
QMNUM
CHAR
12 0
QMART
Notification Type
QMART TQ80
CHAR
2 0
QMTXT
Short Text
QMTXT
CHAR
40 0
ARTPR
Priority Type
ARTPR T356A
CHAR
2 0
PRIOK
Priority
PRIOK T356
CHAR
1 0
ERNAM
Name of Person who Created the Object
ERNAM
CHAR
12 0
ERDAT
Date on Which Record Was Created
ERDAT
DATS
8 0
AENAM
Name of Person Who Changed Object
AENAM
CHAR
12 0
AEDAT
Changed On
AEDAT
DATS
8 0
MZEIT
Time of Notification
MZEIT
TIMS
6 0
QMDAT
Date of Notification
QMDAT
DATS
8 0
QMNAM
Name of Person Reporting Notification
QMNAM
CHAR
12 0
STRMN
Required start date
STRMN
DATS
8 0
STRUR
Required Start Time
STRUR
TIMS
6 0
LTRMN
Required End Date
LTRMN
DATS
8 0
LTRUR
Requested End Time
LTRUR
TIMS
6 0
AUSVN
Start of Malfunction (Date)
AUSVN
DATS
8 0
AUZTV
Start of Malfunction (Time)
AUZTV
TIMS
6 0
AUSBS
End of Malfunction (Date)
AUSBS
DATS
8 0
AUZTB
End of Malfunction (Time)
AUZTB
TIMS
6 0
WAERS
Currency Key
WAERS TCURC
CUKY
5 0
AUFNR
Order Number
AUFNR AUFK
CHAR
12 0
VERID
Production Version
VERID MKAL
CHAR
4 0
RM_MATNR
Material number of the production version
RM_MATNR MKAL
CHAR
18 0
RM_WERKS
Plant of production version
RM_WERKS MKAL
CHAR
4 0
MATNR
Material Number
MATNR MARA
CHAR
18 0
REVLV
Revision Level
REVLV
CHAR
2 0
KUNUM
Account Number of Customer
QKUNUM KNA1
CHAR
10 0
FEKNZ
Error Records Exist
FEKNZ
CHAR
1 0
MAKNZ
Task Records Exist
MAKNZ
CHAR
1 0
OBJNR
Object Number for Status Management
QMOBJNR ONR00
CHAR
22 0
QMDAB
Date for Notification Completion
QMDAB
DATS
8 0
QMZAB
Completion Time of Notification
QMZAB
TIMS
6 0
RBNR
Catalog Profile
RBNR T352B
CHAR
9 0
RBNRI
Origin of Notifications Catalog Profile
RBNRI
CHAR
1 0
INDTX
Object Long Text Available
INDLTX
CHAR
1 0
KZMLA
Primary language indicator for text segment
KZMLA
CHAR
1 0
HERKZ
Origin of Notification
HERKZ
CHAR
2 0
BEZDT
Notification Reference Date
BEZDT
DATS
8 0
BEZUR
Notification Reference Time
BEZUR_D
TIMS
6 0
LIFNUM
Vendor Account Number
LIFNUM LFA1
CHAR
10 0
BUNAME
Author of a Q/PM Notification
BUNAME
CHAR
12 0
VBELN
Sales Order Number
KDAUF VBUK
CHAR
10 0
BSTNK
Customer purchase order number
BSTKD
CHAR
35 0
BSTDK
Customer purchase order date
BSTDK
DATS
8 0
SPART
Division
SPART TSPA
CHAR
2 0
VKORG
Sales Organization
VKORG TVKO
CHAR
4 0
VTWEG
Distribution Channel
VTWEG TVTW
CHAR
2 0
ADRNR
Addresses: Address Number
CADNR
CHAR
10 0
AEZEIT
Time of Change
AEZEIT
TIMS
6 0
ERZEIT
Time, at Which Record Was Added
ERZEIT
TIMS
6 0
MAWERK
Plant for Material
QMAWERKS T001W
CHAR
4 0
QMKAT
Catalog Type - Coding
QMKAT TQ15
CHAR
1 0
QMGRP
Code Group - Coding
QMGRP QPGR
CHAR
8 0
QMCOD
Coding
QMCOD
CHAR
4 0
PRUEFLOS
Inspection Lot Number
QPLOS QALS
NUMC
12 0
CHARG
Batch Number
CHARG_D MCH1
CHAR
10 0
LGORTCHARG
Storage Location of Batch
QLGORTCHAR T001L
CHAR
4 0
LICHN
Vendor Batch Number
LICHN
CHAR
15 0
HERSTELLER
Number of Manufacturer
QLIFNR LFA1
CHAR
10 0
EMATNR
Material Number Corresponding to Manufacturer Part Number
EMATN MARA
CHAR
18 0
EKORG
Purchasing Organization
EKORG T024E
CHAR
4 0
BKGRP
Purchasing Group
BKGRP T024
CHAR
3 0
LGORTVORG
Storage Location for Inspection Lot Stock
QLGORTVORG T001L
CHAR
4 0
FERTAUFNR
Order Number (Production Order)
FERTAUFNR AUFK
CHAR
12 0
FERTAUFPL
Plan Number for Operations in Order (Production Order)
FERTAUFPL
NUMC
10 0
EBELN
Purchasing Document Number
EBELN EKKO
CHAR
10 0
EBELP
Item Number of Purchasing Document
QEBELP EKPO
NUMC
5 0
MJAHR
Material Document Year
MJAHR
NUMC
4 0
MBLNR
Number of Material Document
MBLNR
CHAR
10 0
MBLPO
Item in Material Document
QMBLPO
NUMC
4 0
LS_KDAUF
Sales Order Number
KDAUF VBUK
CHAR
10 0
LS_KDPOS
Item Number in Sales Order
KDPOS
NUMC
6 0
LS_VBELN
Delivery
VBELN_VL VBUK
CHAR
10 0
LS_POSNR
Delivery Item
QPOSNR_VL VBUP
NUMC
6 0
CROBJTY
Object types of the CIM resource
CR_OBJTY
CHAR
2 0
ARBPL
Object ID of the Work Center
LGWID CRID
NUMC
8 0
ARBPLWERK
Plant for Work Center
QARBPWERKS T001W
CHAR
4 0
FEART
Report Type for Defects Recording
QFEART TQ86
CHAR
8 0
PNLKN
Current Node Number from Order Counter APLZL
QLFNKN
NUMC
8 0
MGEIG
Defective Quantity (Internal)
MGEIG
QUAN
13 3
MGFRD
Defective Quantity (External)
MGFRD
QUAN
13 3
MGEIN
Unit of Measure
MGEIN T006
UNIT
3 0
BZMNG
General Reference Quantity
QBZMNG
QUAN
13 3
RKMNG
Complaint Quantity
RKMNG
QUAN
13 3
RGMNG
Return Delivery Quantity
RGMNG
QUAN
13 3
RKDAT
Date of Return Delivery
RKDAT
DATS
8 0
COAUFNR
Order Number (QM Order)
COAUFNR AUFK
CHAR
12 0
QWRNUM
Reference Notification Number
QWRNUM QMEL
CHAR
12 0
REFNUM
External Reference Number
QMEXTNR
CHAR
20 0
KDMAT
Material Number Used by Customer
MATNR_KU
CHAR
35 0
IDNLF
Material Number Used by Vendor
IDNLF
CHAR
35 0
SERIALNR
Serial Number
GERNR
CHAR
18 0
KZLOESCH
Delete Data Record
KZLOESCH
CHAR
1 0
DEVICEID
Additional Device Data
DEVICEID
CHAR
40 0
KTXTGR
Code Group Text for Coding
QMGRPTEXT
CHAR
40 0
KTXTCD
Code Text for Coding
QMCODETEXT
CHAR
80 0
STTXT
System Status for Notification
QMSTTXT
CHAR
40 0
BARBZT
Processing Time
BARBZT
DEC
11 2
MARBEH
Processing Time Unit
MARBEH T006
UNIT
3 0
NAME_LIST
Name for list displays
I_NAME_LST
CHAR
35 0
TEL_NUMBER
First telephone no.: dialling code+number
AD_TLNMBR1
CHAR
30 0
POST_CODE1
City postal code
AD_PSTCD1
CHAR
10 0
CITY1
City
AD_CITY1
CHAR
40 0
CITY2
District
AD_CITY2
CHAR
40 0
COUNTRY
Country Key
LAND1 T005
CHAR
3 0
REGION
Region (State, Province, County)
REGIO T005S
CHAR
3 0
STREET
Street
AD_STREET
CHAR
60 0
ARBPL_I
Work center
ARBPL
CHAR
8 0
VORNR
Operation Number
QVORNR
CHAR
4 0
VORKTEXT
Short Text
QKURZTEXT
CHAR
40 0
FERTVORNR
Operation Number
QVORNR
CHAR
4 0
FERTVORKTX
Short Text
QKURZTEXT
CHAR
40 0
VKBUR
Sales Office
VKBUR
CHAR
4 0
VKGRP
Sales Group
VKGRP
CHAR
3 0
PRIOKX
Priority Text
PRIOKX
CHAR
20 0
MATKTX
Material Description (Short Text)
MAKTX
CHAR
40 0

RQMQMEL1 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
RQMQMEL1 ARBPL RQMQMEL1 MANDT CRID
CIM Resource - Entities
MANDT
RQMQMEL1 ARBPL RQMQMEL1 CROBJTY CRID
CIM Resource - Entities
OBJTY
RQMQMEL1 ARBPL RQMQMEL1 ARBPL CRID
CIM Resource - Entities
OBJID
RQMQMEL1 ARBPLWERK RQMQMEL1 MANDT T001W
Plants/Branches
MANDT
RQMQMEL1 ARBPLWERK RQMQMEL1 ARBPLWERK T001W
Plants/Branches
WERKS
RQMQMEL1 ARTPR RQMQMEL1 MANDT T356A
Priority type table
MANDT
RQMQMEL1 ARTPR RQMQMEL1 ARTPR T356A
Priority type table
ARTPR
RQMQMEL1 AUFNR RQMQMEL1 MANDT AUFK
Order master data
MANDT
RQMQMEL1 AUFNR RQMQMEL1 AUFNR AUFK
Order master data
AUFNR
RQMQMEL1 BKGRP RQMQMEL1 MANDT T024
Purchasing Groups
MANDT
RQMQMEL1 BKGRP RQMQMEL1 BKGRP T024
Purchasing Groups
EKGRP
RQMQMEL1 CHARG RQMQMEL1 MANDT MCH1
Batches (if Batch Management Cross-Plant)
MANDT
RQMQMEL1 CHARG RQMQMEL1 MATNR MCH1
Batches (if Batch Management Cross-Plant)
MATNR
RQMQMEL1 CHARG RQMQMEL1 CHARG MCH1
Batches (if Batch Management Cross-Plant)
CHARG
RQMQMEL1 COAUFNR RQMQMEL1 MANDT AUFK
Order master data
MANDT
RQMQMEL1 COAUFNR RQMQMEL1 COAUFNR AUFK
Order master data
AUFNR
RQMQMEL1 COUNTRY RQMQMEL MANDT T005
Countries
MANDT
RQMQMEL1 COUNTRY RQMQMEL1 COUNTRY T005
Countries
LAND1
RQMQMEL1 EBELN RQMQMEL1 MANDT EKKO
Purchasing Document Header
MANDT
RQMQMEL1 EBELN RQMQMEL1 EBELN EKKO
Purchasing Document Header
EBELN
RQMQMEL1 EBELP RQMQMEL1 MANDT EKPO
Purchasing Document Item
MANDT
RQMQMEL1 EBELP RQMQMEL1 EBELN EKPO
Purchasing Document Item
EBELN
RQMQMEL1 EBELP RQMQMEL1 EBELP EKPO
Purchasing Document Item
EBELP
RQMQMEL1 EKORG RQMQMEL1 MANDT T024E
Purchasing Organizations
MANDT
RQMQMEL1 EKORG RQMQMEL1 EKORG T024E
Purchasing Organizations
EKORG
RQMQMEL1 EMATNR RQMQMEL1 MANDT MARA
General Material Data
MANDT
RQMQMEL1 EMATNR RQMQMEL1 EMATNR MARA
General Material Data
MATNR
RQMQMEL1 FEART RQMQMEL1 FEART TQ86
Report category for defects recording
FEART
RQMQMEL1 FEART RQMQMEL1 MANDT TQ86
Report category for defects recording
MANDT
RQMQMEL1 FERTAUFNR RQMQMEL1 MANDT AUFK
Order master data
MANDT
RQMQMEL1 FERTAUFNR RQMQMEL1 FERTAUFNR AUFK
Order master data
AUFNR
RQMQMEL1 HERSTELLER RQMQMEL1 MANDT LFA1
Vendor Master (General Section)
MANDT
RQMQMEL1 HERSTELLER RQMQMEL1 HERSTELLER LFA1
Vendor Master (General Section)
LIFNR
RQMQMEL1 KUNUM RQMQMEL1 MANDT KNA1
General Data in Customer Master
MANDT
RQMQMEL1 KUNUM RQMQMEL1 KUNUM KNA1
General Data in Customer Master
KUNNR
RQMQMEL1 LGORTCHARG RQMQMEL1 MANDT T001L
Storage Locations
MANDT
RQMQMEL1 LGORTCHARG RQMQMEL1 MAWERK T001L
Storage Locations
WERKS
RQMQMEL1 LGORTCHARG RQMQMEL1 LGORTCHARG T001L
Storage Locations
LGORT
RQMQMEL1 LGORTVORG RQMQMEL1 LGORTVORG T001L
Storage Locations
LGORT
RQMQMEL1 LGORTVORG RQMQMEL1 MANDT T001L
Storage Locations
MANDT
RQMQMEL1 LGORTVORG RQMQMEL1 MAWERK T001L
Storage Locations
WERKS
RQMQMEL1 LIFNUM RQMQMEL1 MANDT LFA1
Vendor Master (General Section)
MANDT
RQMQMEL1 LIFNUM RQMQMEL1 LIFNUM LFA1
Vendor Master (General Section)
LIFNR
RQMQMEL1 LS_KDAUF RQMQMEL1 MANDT VBUK
Sales Document: Header Status and Administrative Data
MANDT
RQMQMEL1 LS_KDAUF RQMQMEL1 LS_KDAUF VBUK
Sales Document: Header Status and Administrative Data
VBELN
RQMQMEL1 LS_POSNR RQMQMEL1 MANDT VBUP
Sales Document: Item Status
MANDT
RQMQMEL1 LS_POSNR RQMQMEL1 VBELN VBUP
Sales Document: Item Status
VBELN
RQMQMEL1 LS_POSNR RQMQMEL1 LS_POSNR VBUP
Sales Document: Item Status
POSNR
RQMQMEL1 LS_VBELN RQMQMEL1 LS_VBELN VBUK
Sales Document: Header Status and Administrative Data
VBELN
RQMQMEL1 LS_VBELN RQMQMEL1 MANDT VBUK
Sales Document: Header Status and Administrative Data
MANDT
RQMQMEL1 MANDT RQMQMEL1 MANDT T000
Clients
MANDT
RQMQMEL1 MARBEH RQMQMEL MANDT T006
Units of Measurement
MANDT
RQMQMEL1 MARBEH RQMQMEL1 MARBEH T006
Units of Measurement
MSEHI
RQMQMEL1 MATNR RQMQMEL1 MANDT MARA
General Material Data
MANDT
RQMQMEL1 MATNR RQMQMEL1 MATNR MARA
General Material Data
MATNR
RQMQMEL1 MAWERK RQMQMEL1 MANDT T001W
Plants/Branches
MANDT
RQMQMEL1 MAWERK RQMQMEL1 MAWERK T001W
Plants/Branches
WERKS
RQMQMEL1 MGEIN RQMQMEL1 MANDT T006
Units of Measurement
MANDT
RQMQMEL1 MGEIN RQMQMEL1 MGEIN T006
Units of Measurement
MSEHI
RQMQMEL1 OBJNR RQMQMEL1 MANDT ONR00
General Object Number
MANDT
RQMQMEL1 OBJNR RQMQMEL1 OBJNR ONR00
General Object Number
OBJNR
RQMQMEL1 PRIOK RQMQMEL1 ARTPR T356
Priorities
ARTPR
RQMQMEL1 PRIOK RQMQMEL1 PRIOK T356
Priorities
PRIOK
RQMQMEL1 PRIOK RQMQMEL1 MANDT T356
Priorities
MANDT
RQMQMEL1 PRUEFLOS RQMQMEL1 MANDT QALS
Inspection lot record
MANDANT
RQMQMEL1 PRUEFLOS RQMQMEL1 PRUEFLOS QALS
Inspection lot record
PRUEFLOS
RQMQMEL1 QMART RQMQMEL1 MANDT TQ80
Notification Types
MANDT
RQMQMEL1 QMART RQMQMEL1 QMART TQ80
Notification Types
QMART
RQMQMEL1 QMGRP RQMQMEL1 MANDT QPGR
Inspection catalog code groups
MANDT
RQMQMEL1 QMGRP RQMQMEL1 QMKAT QPGR
Inspection catalog code groups
KATALOGART
RQMQMEL1 QMGRP RQMQMEL1 QMGRP QPGR
Inspection catalog code groups
CODEGRUPPE
RQMQMEL1 QMKAT RQMQMEL1 MANDT TQ15
Inspection catalog type index
MANDT
RQMQMEL1 QMKAT RQMQMEL1 QMKAT TQ15
Inspection catalog type index
KATALOGART
RQMQMEL1 QWRNUM RQMQMEL1 MANDT QMEL
Quality Notification
MANDT
RQMQMEL1 QWRNUM RQMQMEL1 QWRNUM QMEL
Quality Notification
QMNUM
RQMQMEL1 RBNR RQMQMEL1 MANDT T352B
Technical report
MANDT
RQMQMEL1 RBNR RQMQMEL1 RBNR T352B
Technical report
RBNR
RQMQMEL1 REGION RQMQMEL MANDT T005S
Taxes: Region (Province) Key
MANDT
RQMQMEL1 REGION RQMQMEL1 COUNTRY T005S
Taxes: Region (Province) Key
LAND1
RQMQMEL1 REGION RQMQMEL1 REGION T005S
Taxes: Region (Province) Key
BLAND
RQMQMEL1 RM_MATNR RQMQMEL1 MANDT MKAL
Production Versions of Material
MANDT
RQMQMEL1 RM_MATNR RQMQMEL1 RM_MATNR MKAL
Production Versions of Material
MATNR
RQMQMEL1 RM_MATNR RQMQMEL1 RM_WERKS MKAL
Production Versions of Material
WERKS
RQMQMEL1 RM_MATNR RQMQMEL1 VERID MKAL
Production Versions of Material
VERID
RQMQMEL1 RM_WERKS RQMQMEL1 RM_MATNR MKAL
Production Versions of Material
MATNR
RQMQMEL1 RM_WERKS RQMQMEL1 RM_WERKS MKAL
Production Versions of Material
WERKS
RQMQMEL1 RM_WERKS RQMQMEL1 VERID MKAL
Production Versions of Material
VERID
RQMQMEL1 RM_WERKS RQMQMEL1 MANDT MKAL
Production Versions of Material
MANDT
RQMQMEL1 SPART RQMQMEL1 MANDT TSPA
Organizational Unit: Sales Divisions
MANDT
RQMQMEL1 SPART RQMQMEL1 SPART TSPA
Organizational Unit: Sales Divisions
SPART
RQMQMEL1 VBELN RQMQMEL1 MANDT VBUK
Sales Document: Header Status and Administrative Data
MANDT
RQMQMEL1 VBELN RQMQMEL1 VBELN VBUK
Sales Document: Header Status and Administrative Data
VBELN
RQMQMEL1 VERID RQMQMEL1 VERID MKAL
Production Versions of Material
VERID
RQMQMEL1 VERID RQMQMEL1 MANDT MKAL
Production Versions of Material
MANDT
RQMQMEL1 VERID RQMQMEL1 MATNR MKAL
Production Versions of Material
MATNR
RQMQMEL1 VERID RQMQMEL1 MAWERK MKAL
Production Versions of Material
WERKS
RQMQMEL1 VKORG RQMQMEL1 MANDT TVKO
Organizational Unit: Sales Organizations
MANDT
RQMQMEL1 VKORG RQMQMEL1 VKORG TVKO
Organizational Unit: Sales Organizations
VKORG
RQMQMEL1 VTWEG RQMQMEL1 MANDT TVTW
Organizational Unit: Distribution Channels
MANDT
RQMQMEL1 VTWEG RQMQMEL1 VTWEG TVTW
Organizational Unit: Distribution Channels
VTWEG
RQMQMEL1 WAERS RQMQMEL1 WAERS TCURC
Currency Codes
WAERS
RQMQMEL1 WAERS RQMQMEL1 MANDT TCURC
Currency Codes
MANDT