SAP table RQMQMEL1 (Quality notification - notifications (reporting))

SAP table RQMQMEL1 has 2 primary key fields being MANDT,QMNUM.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

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

RQMQMEL1 foreign key relationships

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