SAP Table

QMEL Quality Notification

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

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

/ Fields

QMEL columns.

Field Description Data Type Length Decimals Checktable Data Element
KeyMANDT Client CLNT 3 0 T000 MANDT
KeyQMNUM 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
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
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
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
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
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
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
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
UII Unique Item Identifier CHAR 72 0 UII_CHAR72
/ Relationships

QMEL foreign keys.

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