SAP table QMEL (Quality Notification)

SAP table QMEL 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
WAERS Currency Key CUKY 5 0 TCURC WAERS
AUFNR Order Number CHAR 12 0 AUFK AUFNR
VERID Production Version CHAR 4 0 MKAL QM_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
SA_AUFNR Run schedule header number CHAR 12 0 SAFK SA_AUFNR
MATNR Material Number CHAR 40 0 MARA MATNR
REVLV Revision Level CHAR 2 0 REVLV
MATKL Material Group CHAR 9 0 T023 MATKL
PRDHA Product hierarchy CHAR 18 0 T179 PRODH_D
KZKRI Indicator: Critical part CHAR 1 0 KZKRI
KZDKZ Documentation required indicator CHAR 1 0 KZDKZ
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 VBAK QM_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
AUSWIRK Key for a Scenario CHAR 4 0 TQ81 QSCENARIO
TEILEV Usage of Parts CHAR 4 0 TQ81V QTEILEV
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 QM_EBELN
EBELP Item Number of Purchasing Document NUMC 5 0 EKPO QEBELP
MJAHR Material Document Year NUMC 4 0 QM_MJAHR
MBLNR Number of Material Document CHAR 10 0 QM_MBLNR
MBLPO Item in Material Document NUMC 4 0 QMBLPO
LS_KDAUF Sales Order Number CHAR 10 0 VBAK QM_KDAUF
LS_KDPOS Item number of the SD document NUMC 6 0 VBAP QM_POSNR
LS_VBELN Delivery CHAR 10 0 LIKP VBELN_VL
LS_POSNR Delivery Item NUMC 6 0 LIPS 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
CVP_XBLCK Business Purpose Completed Flag CHAR 1 0 CVP_XBLCK
not blocked
X blocked
PRODDAT Production Date DATS 8 0 QM_QPRODDAT
DEVICEID Additional Device Data CHAR 40 0 DEVICEID
VKBUR Sales office CHAR 4 0 TVKBZ VKBUR
VKGRP Sales group CHAR 3 0 TVBVK VKGRP
AUTKZ Data Record Created with Function 'Create with Copy Model' CHAR 1 0 QAUTKZ
BEDID ID of the Capacity Requirements Record NUMC 12 0 BEDID
BEDZL Internal counter NUMC 8 0 CIM_COUNT
PROFIL_TYP Object Type CHAR 2 0 OTYPE
PROFIL_ID Object ID NUMC 8 0 OBJEKTID
HANDLE Globally unique identifier (linked to time segment, etc) CHAR 22 0 TSEGGUID
TSEGFL Time segment exists CHAR 1 0 TSEGEXISTS
TSEGTP Template CHAR 10 0 TTSEGTPLH TSEGTEMPLA
TZONSO Time Zone for Notification CHAR 6 0 TTZZ TZONSO
TZONID Origin of Time Zone in Notification CHAR 1 0 TZONSMID
Time zone for user (SY-ZONLO)
1 Equipment
2 Functional location
3 Plant
4 Customer
5 Vendor
FUNKTION Keys for Function in Action Box CHAR 4 0 QNFUNKTION
/SAPSMOSS/INSTN Installation number CHAR 10 0 /SAPSMOSS/INSTN /SAPSMOSS/R3INSTN
/SAPSMOSS/MNUMM SAPNet notification number NUMC 24 0 /SAPSMOSS/MNUMM
/SAPSMOSS/OSSYS Operating system and version CHAR 10 0 /SAPSMOSS/OSYS /SAPSMOSS/OSSYS
/SAPSMOSS/DBSYS Database system CHAR 10 0 /SAPSMOSS/DBSY /SAPSMOSS/DBSYS
/SAPSMOSS/REL R/3 Release CHAR 10 0 /SAPSMOSS/REL /SAPSMOSS/R3REL
/SAPSMOSS/COMP Area CHAR 20 0 /SAPSMOSS/R3COMP
/SAPSMOSS/FRONT Frontend CHAR 10 0 /SAPSMOSS/FRNT /SAPSMOSS/FRONTEND
/SAPSMOSS/SYSTYP R/3 System type CHAR 1 0 /SAPSMOSS/SYST /SAPSMOSS/R3SYSTYPE
/SAPSMOSS/ADDID Add-on ID CHAR 10 0 /SAPSMOSS/ADDID /SAPSMOSS/R3ADDID
/SAPSMOSS/ADDREL Add-On Release CHAR 10 0 /SAPSMOSS/ADDRL /SAPSMOSS/R3ADDREL
/SAPSMOSS/TSTMP SAPNet time stamp NUMC 14 0 /SAPSMOSS/NSTSTMP
/SAPSMOSS/STATUS Status of R/3 notification in SAPNet CHAR 1 0 /SAPSMOSS/STAT /SAPSMOSS/STATUS
/SAPSMOSS/ERDAT Date on which notification was completed at SAP DATS 8 0 /SAPSMOSS/ERDAT
/SAPSMOSS/ERZEIT Time when notification was completed at SAP TIMS 6 0 /SAPSMOSS/ERZEIT
/SAPSMOSS/SYSID Name of SAP System CHAR 8 0 SYSYSID
/SAPSMOSS/MANDT Client ID CLNT 3 0 * SYMANDT
PSP_NR WBS Element NUMC 8 0 * QM_PS_POSNR
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
CHANCE Chance of Completing a Claim NUMC 2 0 PS_CHANCE
01 Very Low
02 Short
03 Medium
04 High
05 Very high
OPPONENT Partner Type CHAR 2 0 PS_OPPONENT
KALNR Cost Estimate Number for Cost Est. w/o Qty Structure NUMC 12 0 CK_KALNR
KALVAR Costing Variant for Postprocessing with Unit Costing CHAR 4 0 CK_KALVAR
OBJNR_REAL Object Number of Real CO Account Assignment CHAR 22 0 ONR00 J_OBJNR_REAL
OBJNR_STAT Auxiliary account assignment 1 CHAR 22 0 ONR00 OBJNR_N1
DUMMY_QMEL_INCL_EEW_PS Dummy function in length 1 CHAR 1 0 DUMMY
PHASE Notification Processing Phase CHAR 1 0 QM_PHASE
1 Outstanding
2 Postponed
3 In Process
4 Completed
5 Deletion Flag
CHANGEDDATETIME UTC Time Stamp in Short Form (YYYYMMDDhhmmss) DEC 15 0 TZNTSTMPS
/ISDFPS/MHIO_ADDATE Completion Date for Call Object DATS 8 0 MHIO_ADDAT
/ISDFPS/MHIO_ADTIME Completion Time for Call Object TIMS 6 0 MHIO_ADUHR
/ISDFPS/USERMODE Scheduling determined by user CHAR 1 0 USERMOD
/ISDFPS/OBJNR Object number CHAR 22 0 * J_OBJNR
LOGSYSTEM Logical System CHAR 10 0 * LOGSYSTEM
/ISDFPS/MEQUI Master Equipment CHAR 18 0 * /ISDFPS/MEQUI
SHN_OBJTY 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
SHN_OBJID Object ID of the resource NUMC 8 0 * CR_OBJID
SHN_FUNCT_LOC Functional Location CHAR 30 0 TPLNR
SHN_EQUIPMENT Equipment Number CHAR 18 0 EQUNR
SHN_ORIGIN Origin or Use of Shift Note or Report NUMC 2 0 COCF_SRN_ORIGIN
01 Work Center/Hierarchy
02 Functional Location/Equipment
UII Unique Item Identifier CHAR 72 0 UII_CHAR72

QMEL foreign key relationships

Table Field Check Table Check Field
0 QMEL ARBPL CRID CIM Resource - Entities MANDT
0 QMEL ARBPL CRID CIM Resource - Entities OBJID
1 QMEL ARBPLWERK T001W Plants/Branches MANDT
1 QMEL ARBPLWERK T001W Plants/Branches WERKS
0 QMEL ARTPR T356A Priority type table MANDT
0 QMEL ARTPR T356A Priority type table ARTPR
1 QMEL AUFNR AUFK Order master data AUFNR
0 QMEL AUSWIRK TQ81 Notification Scenario MANDT
0 QMEL AUSWIRK TQ81 Notification Scenario AUSWIRK
1 QMEL BKGRP T024 Purchasing Groups EKGRP
0 QMEL CHARG MCH1 Batches (if Batch Management Cross-Plant) MANDT
1 QMEL COAUFNR AUFK Order master data AUFNR
0 QMEL EBELN EKKO Purchasing Document Header EBELN
1 QMEL EBELP EKPO Purchasing Document Item MANDT
1 QMEL EBELP EKPO Purchasing Document Item EBELN
0 QMEL EKORG T024E Purchasing Organizations EKORG
1 QMEL EMATNR MARA General Material Data MANDT
1 QMEL EMATNR MARA General Material Data MATNR
0 QMEL FEART TQ86 Report category for defects recording MANDT
1 QMEL FERTAUFNR AUFK Order master data AUFNR
0 QMEL HERSTELLER LFA1 Supplier Master (General Section) MANDT
0 QMEL HERSTELLER LFA1 Supplier Master (General Section) LIFNR
1 QMEL KUNUM KNA1 General Data in Customer Master MANDT
1 QMEL KUNUM KNA1 General Data in Customer Master KUNNR
0 QMEL LGORTCHARG T001L Storage Locations MANDT
0 QMEL LGORTCHARG T001L Storage Locations WERKS
1 QMEL LGORTVORG T001L Storage Locations MANDT
1 QMEL LGORTVORG T001L Storage Locations WERKS
0 QMEL LIFNUM LFA1 Supplier Master (General Section) MANDT
0 QMEL LIFNUM LFA1 Supplier Master (General Section) LIFNR
1 QMEL LS_KDAUF VBAK Sales Document: Header Data MANDT
1 QMEL LS_KDAUF VBAK Sales Document: Header Data VBELN
0 QMEL LS_KDPOS VBAP Sales Document: Item Data VBELN
0 QMEL LS_KDPOS VBAP Sales Document: Item Data POSNR
1 QMEL LS_POSNR LIPS SD document: Delivery: Item data MANDT
1 QMEL LS_POSNR LIPS SD document: Delivery: Item data VBELN
1 QMEL LS_POSNR LIPS SD document: Delivery: Item data POSNR
0 QMEL LS_VBELN LIKP SD Document: Delivery Header Data MANDT
0 QMEL LS_VBELN LIKP SD Document: Delivery Header Data VBELN
1 QMEL MATKL T023 Material Groups MATKL
0 QMEL MATNR MARA General Material Data MANDT
0 QMEL MATNR MARA General Material Data MATNR
1 QMEL MAWERK T001W Plants/Branches MANDT
1 QMEL MAWERK T001W Plants/Branches WERKS
0 QMEL MGEIN T006 Units of Measurement MANDT
0 QMEL MGEIN T006 Units of Measurement MSEHI
1 QMEL OBJNR ONR00 General Object Number MANDT
0 QMEL OBJNR_REAL ONR00 General Object Number MANDT
0 QMEL OBJNR_REAL ONR00 General Object Number OBJNR
1 QMEL OBJNR_STAT ONR00 General Object Number MANDT
1 QMEL OBJNR_STAT ONR00 General Object Number OBJNR
0 QMEL PRDHA T179 Materials: Product Hierarchies PRODH
1 QMEL PRIOK T356 Priorities MANDT
1 QMEL PRIOK T356 Priorities ARTPR
0 QMEL PRUEFLOS QALS Inspection lot record MANDANT
1 QMEL QMART TQ80 Notification Types MANDT
1 QMEL QMART TQ80 Notification Types QMART
0 QMEL QMGRP QPGR Inspection catalog code groups MANDT
0 QMEL QMGRP QPGR Inspection catalog code groups KATALOGART
1 QMEL QMKAT TQ15 Inspection catalog type index KATALOGART
0 QMEL QWRNUM QMEL Quality Notification MANDT
0 QMEL QWRNUM QMEL Quality Notification QMNUM
1 QMEL RBNR T352B Technical report MANDT
0 QMEL RM_MATNR MKAL Production Versions of Material WERKS
0 QMEL RM_MATNR MKAL Production Versions of Material VERID
1 QMEL RM_WERKS MKAL Production Versions of Material WERKS
1 QMEL RM_WERKS MKAL Production Versions of Material VERID
0 QMEL SA_AUFNR SAFK Run Schedule Master Data MANDT
0 QMEL SA_AUFNR SAFK Run Schedule Master Data AUFNR
1 QMEL SPART TSPA Organizational Unit: Sales Divisions MANDT
1 QMEL SPART TSPA Organizational Unit: Sales Divisions SPART
0 QMEL TEILEV TQ81V Usage of parts MANDT
0 QMEL TEILEV TQ81V Usage of parts TEILEV
1 QMEL TSEGTP TTSEGTPLH Time Segment Template Header TEPL
0 QMEL TZONSO TTZZ Time zones TZONE
1 QMEL VBELN VBAK Sales Document: Header Data MANDT
1 QMEL VBELN VBAK Sales Document: Header Data VBELN
0 QMEL VERID MKAL Production Versions of Material WERKS
0 QMEL VERID MKAL Production Versions of Material VERID
1 QMEL VKBUR TVKBZ Org.Unit: Sales Office: Assignment to Organizational Unit MANDT
1 QMEL VKBUR TVKBZ Org.Unit: Sales Office: Assignment to Organizational Unit VKORG
1 QMEL VKBUR TVKBZ Org.Unit: Sales Office: Assignment to Organizational Unit VTWEG
1 QMEL VKBUR TVKBZ Org.Unit: Sales Office: Assignment to Organizational Unit SPART
0 QMEL VKGRP TVBVK Organizational Unit: Sales Groups per Sales Office MANDT
1 QMEL VKORG TVKO Organizational Unit: Sales Organizations MANDT
1 QMEL VKORG TVKO Organizational Unit: Sales Organizations VKORG
0 QMEL VTWEG TVTW Organizational Unit: Distribution Channels MANDT
0 QMEL VTWEG TVTW Organizational Unit: Distribution Channels VTWEG
1 QMEL WAERS TCURC Currency Codes MANDT
1 QMEL WAERS TCURC Currency Codes WAERS