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
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
01 General maintenance notification
02 Malfunction report
03 Activity report
04 Problem notification
05 Activity report (service)
06 General notification (service)
Q1 Customer complaint
Q2 Complaint against vendor
Q3 Internal problem message
R3 SAP notification to SAP support line
C1 Internal claim
C2 External claim
G1 General notification
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
A Work center
AA Work center alias
FH Production resources/tools
H Hierarchy
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 CHARG MCH1 Batches (if Batch Management Cross-Plant) CHARG
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 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 EBELN EKKO Purchasing Document Header EBELN
RQMQMEL1 EBELN RQMQMEL1 MANDT EKKO Purchasing Document Header MANDT
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 MANDT TQ86 Report category for defects recording MANDT
RQMQMEL1 FEART RQMQMEL1 FEART TQ86 Report category for defects recording FEART
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 KUNUM KNA1 General Data in Customer Master KUNNR
RQMQMEL1 KUNUM RQMQMEL1 MANDT KNA1 General Data in Customer Master MANDT
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 MANDT T001L Storage Locations MANDT
RQMQMEL1 LGORTVORG RQMQMEL1 MAWERK T001L Storage Locations WERKS
RQMQMEL1 LGORTVORG RQMQMEL1 LGORTVORG T001L Storage Locations LGORT
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 VBELN VBUP Sales Document: Item Status VBELN
RQMQMEL1 LS_POSNR RQMQMEL1 LS_POSNR VBUP Sales Document: Item Status POSNR
RQMQMEL1 LS_POSNR RQMQMEL1 MANDT VBUP Sales Document: Item Status MANDT
RQMQMEL1 LS_VBELN RQMQMEL1 MANDT VBUK Sales Document: Header Status and Administrative Data MANDT
RQMQMEL1 LS_VBELN RQMQMEL1 LS_VBELN VBUK Sales Document: Header Status and Administrative Data VBELN
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 MAWERK T001W Plants/Branches WERKS
RQMQMEL1 MAWERK RQMQMEL1 MANDT T001W Plants/Branches MANDT
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 MANDT T356 Priorities MANDT
RQMQMEL1 PRIOK RQMQMEL1 ARTPR T356 Priorities ARTPR
RQMQMEL1 PRIOK RQMQMEL1 PRIOK T356 Priorities PRIOK
RQMQMEL1 PRUEFLOS RQMQMEL1 PRUEFLOS QALS Inspection lot record PRUEFLOS
RQMQMEL1 PRUEFLOS RQMQMEL1 MANDT QALS Inspection lot record MANDANT
RQMQMEL1 QMART RQMQMEL1 QMART TQ80 Notification Types QMART
RQMQMEL1 QMART RQMQMEL1 MANDT TQ80 Notification Types MANDT
RQMQMEL1 QMGRP RQMQMEL1 QMGRP QPGR Inspection catalog code groups CODEGRUPPE
RQMQMEL1 QMGRP RQMQMEL1 MANDT QPGR Inspection catalog code groups MANDT
RQMQMEL1 QMGRP RQMQMEL1 QMKAT QPGR Inspection catalog code groups KATALOGART
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 RQMQMEL1 REGION T005S Taxes: Region (Province) Key BLAND
RQMQMEL1 REGION RQMQMEL MANDT T005S Taxes: Region (Province) Key MANDT
RQMQMEL1 REGION RQMQMEL1 COUNTRY T005S Taxes: Region (Province) Key LAND1
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 MANDT MKAL Production Versions of Material MANDT
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 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 MATNR MKAL Production Versions of Material MATNR
RQMQMEL1 VERID RQMQMEL1 MAWERK MKAL Production Versions of Material WERKS
RQMQMEL1 VERID RQMQMEL1 VERID MKAL Production Versions of Material VERID
RQMQMEL1 VERID RQMQMEL1 MANDT MKAL Production Versions of Material MANDT
RQMQMEL1 VKORG RQMQMEL1 VKORG TVKO Organizational Unit: Sales Organizations VKORG
RQMQMEL1 VKORG RQMQMEL1 MANDT TVKO Organizational Unit: Sales Organizations MANDT
RQMQMEL1 VTWEG RQMQMEL1 MANDT TVTW Organizational Unit: Distribution Channels MANDT
RQMQMEL1 VTWEG RQMQMEL1 VTWEG TVTW Organizational Unit: Distribution Channels VTWEG
RQMQMEL1 WAERS RQMQMEL1 MANDT TCURC Currency Codes MANDT
RQMQMEL1 WAERS RQMQMEL1 WAERS TCURC Currency Codes WAERS