QMEL table in SAP ERP or S/4HANA stores Quality Notification data. There are total 155 fields in QMEL table. The Quality Notification table is available in all major of SAP S/4HANA versions and is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of QMEL table. It is in Application Development R/3 Work Order Cycle (IWOC) ABAP package and is part of the Maintenance Notifications (PM-WOC-MN) module.
SAP QMEL Table Fields
Following is the list of fields that are available in SAP QMEL table. The primary key fields of Quality Notification table in SAP are MANDT (Client), QMNUM (Notification Number).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT(3) |
| QMNUM | Notification Number | QMNUM | CHAR(12) | |
| QMART | Notification Type | QMART | TQ80 | CHAR(2) |
| QMTXT | Short Text | QMTXT | CHAR(40) | |
| ARTPR | Priority Type | ARTPR | T356A | CHAR(2) |
| PRIOK | Priority | PRIOK | T356 | CHAR(1) |
| ERNAM | Name of Person who Created the Object | ERNAM | CHAR(12) | |
| ERDAT | Date on which the record was created | ERDAT | DATS(8) | |
| AENAM | Name of person who changed object | AENAM | CHAR(12) | |
| AEDAT | Date of Last Change | AEDAT | DATS(8) | |
| MZEIT | Time of Notification | MZEIT | TIMS(6) | |
| QMDAT | Date of Notification | QMDAT | DATS(8) | |
| QMNAM | Name of Person Reporting Notification | QMNAM | CHAR(12) | |
| STRMN | Required start date | STRMN | DATS(8) | |
| STRUR | Required Start Time | STRUR | TIMS(6) | |
| LTRMN | Required End Date | LTRMN | DATS(8) | |
| LTRUR | Requested End Time | LTRUR | TIMS(6) | |
| WAERS | Currency Key | WAERS | TCURC | CUKY(5) |
| AUFNR | Order Number | AUFNR | AUFK | CHAR(12) |
| VERID | Production Version | QM_VERID | MKAL | CHAR(4) |
| RM_MATNR | Material Number of Production Version | RM_MATNR | MKAL | CHAR(40) |
| RM_WERKS | Plant of Production Version | RM_WERKS | MKAL | CHAR(4) |
| SA_AUFNR | Run schedule header number | SA_AUFNR | SAFK | CHAR(12) |
| MATNR | Material Number | MATNR | MARA | CHAR(40) |
| REVLV | Revision Level | REVLV | CHAR(2) | |
| MATKL | Material Group | MATKL | T023 | CHAR(9) |
| PRDHA | Product hierarchy | PRODH_D | T179 | CHAR(18) |
| KZKRI | Indicator: Critical part | KZKRI | CHAR(1) | |
| KZDKZ | Documentation required indicator | KZDKZ | CHAR(1) | |
| KUNUM | Account Number of Customer | QKUNUM | KNA1 | CHAR(10) |
| FEKNZ | Error Records Exist | FEKNZ | CHAR(1) | |
| MAKNZ | Task Records Exist | MAKNZ | CHAR(1) | |
| OBJNR | Object Number for Status Management | QMOBJNR | ONR00 | CHAR(22) |
| QMDAB | Date for Notification Completion | QMDAB | DATS(8) | |
| QMZAB | Completion Time of Notification | QMZAB | TIMS(6) | |
| RBNR | Catalog Profile | RBNR | T352B | CHAR(9) |
| RBNRI | Origin of Notifications Catalog Profile | RBNRI | CHAR(1) | |
| INDTX | Object Long Text Available | INDLTX | CHAR(1) | |
| KZMLA | Primary language indicator for text segment | KZMLA | CHAR(1) | |
| HERKZ | Origin of Notification | HERKZ | CHAR(2) | |
| BEZDT | Notification Reference Date | BEZDT | DATS(8) | |
| BEZUR | Notification Reference Time | BEZUR_D | TIMS(6) | |
| LIFNUM | Supplier Account Number | LIFNUM | LFA1 | CHAR(10) |
| BUNAME | Author of a Q/PM Notification | BUNAME | CHAR(12) | |
| VBELN | Sales Order Number | QM_KDAUF | VBAK | CHAR(10) |
| BSTNK | Customer Reference | BSTKD | CHAR(35) | |
| BSTDK | Customer Reference Date | BSTDK | DATS(8) | |
| SPART | Division | SPART | TSPA | CHAR(2) |
| VKORG | Sales Organization | VKORG | TVKO | CHAR(4) |
| VTWEG | Distribution Channel | VTWEG | TVTW | CHAR(2) |
| ADRNR | Addresses: Address Number | CADNR | CHAR(10) | |
| AEZEIT | Time of Change | AEZEIT | TIMS(6) | |
| ERZEIT | Time at Which Record Was Added | ERZEIT | TIMS(6) | |
| MAWERK | Plant for Material | QMAWERKS | T001W | CHAR(4) |
| QMKAT | Catalog Type – Coding | QMKAT | TQ15 | CHAR(1) |
| QMGRP | Code Group – Coding | QMGRP | QPGR | CHAR(8) |
| QMCOD | Coding | QMCOD | CHAR(4) | |
| AUSWIRK | Key for a Scenario | QSCENARIO | TQ81 | CHAR(4) |
| TEILEV | Usage of Parts | QTEILEV | TQ81V | CHAR(4) |
| PRUEFLOS | Inspection Lot Number | QPLOS | QALS | NUMC(12) |
| CHARG | Batch Number | CHARG_D | MCH1 | CHAR(10) |
| LGORTCHARG | Storage Location of Batch | QLGORTCHAR | T001L | CHAR(4) |
| LICHN | Supplier Batch Number | LICHN | CHAR(15) | |
| HERSTELLER | Number of Manufacturer | QLIFNR | LFA1 | CHAR(10) |
| EMATNR | Material number corresponding to manufacturer part number | EMATN | MARA | CHAR(40) |
| EKORG | Purchasing organization | EKORG | T024E | CHAR(4) |
| BKGRP | Purchasing Group | BKGRP | T024 | CHAR(3) |
| LGORTVORG | Storage Location for Inspection Lot Stock | QLGORTVORG | T001L | CHAR(4) |
| FERTAUFNR | Order Number (Production Order) | FERTAUFNR | AUFK | CHAR(12) |
| FERTAUFPL | Plan Number for Operations in Order (Production Order) | FERTAUFPL | NUMC(10) | |
| EBELN | Purchasing Document Number | QM_EBELN | EKKO | CHAR(10) |
| EBELP | Item Number of Purchasing Document | QEBELP | EKPO | NUMC(5) |
| MJAHR | Material Document Year | QM_MJAHR | NUMC(4) | |
| MBLNR | Number of Material Document | QM_MBLNR | CHAR(10) | |
| MBLPO | Item in Material Document | QMBLPO | NUMC(4) | |
| LS_KDAUF | Sales Order Number | QM_KDAUF | VBAK | CHAR(10) |
| LS_KDPOS | Item number of the SD document | QM_POSNR | VBAP | NUMC(6) |
| LS_VBELN | Delivery | VBELN_VL | LIKP | CHAR(10) |
| LS_POSNR | Delivery Item | QPOSNR_VL | LIPS | NUMC(6) |
| CROBJTY | Object types of the CIM resource | CR_OBJTY | CHAR(2) | |
| ARBPL | Object ID of the Work Center | LGWID | CRID | NUMC(8) |
| ARBPLWERK | Plant for Work Center | QARBPWERKS | T001W | CHAR(4) |
| FEART | Report Type for Defects Recording | QFEART | TQ86 | CHAR(8) |
| PNLKN | Current Node Number from Order Counter | QLFNKN | NUMC(8) | |
| MGEIG | Defective Quantity (Internal) | MGEIG | QUAN(13) | |
| MGFRD | Defective Quantity (External) | MGFRD | QUAN(13) | |
| MGEIN | Unit of Measure | MGEIN | T006 | UNIT(3) |
| BZMNG | General Reference Quantity | QBZMNG | QUAN(13) | |
| RKMNG | Complaint Quantity | RKMNG | QUAN(13) | |
| RGMNG | Return Delivery Quantity | RGMNG | QUAN(13) | |
| RKDAT | Date of Return Delivery | RKDAT | DATS(8) | |
| COAUFNR | Order Number (QM Order) | COAUFNR | AUFK | CHAR(12) |
| QWRNUM | Reference Notification Number | QWRNUM | QMEL | CHAR(12) |
| REFNUM | External Reference Number | QMEXTNR | CHAR(20) | |
| KDMAT | Material Number Used by Customer | MATNR_KU | CHAR(35) | |
| IDNLF | Material Number Used by Supplier | IDNLF | CHAR(35) | |
| SERIALNR | Serial Number | GERNR | CHAR(18) | |
| KZLOESCH | Delete Data Record | KZLOESCH | CHAR(1) | |
| CVP_XBLCK | Business Purpose Completed Flag | CVP_XBLCK | CHAR(1) | |
| PRODDAT | Production Date | QM_QPRODDAT | DATS(8) | |
| DEVICEID | Additional Device Data | DEVICEID | CHAR(40) | |
| VKBUR | Sales office | VKBUR | TVKBZ | CHAR(4) |
| VKGRP | Sales group | VKGRP | TVBVK | CHAR(3) |
| AUTKZ | Data Record Created with Function ‘Create with Copy Model’ | QAUTKZ | CHAR(1) | |
| BEDID | ID of the Capacity Requirements Record | BEDID | NUMC(12) | |
| BEDZL | Internal counter | CIM_COUNT | NUMC(8) | |
| PROFIL_TYP | Object Type | OTYPE | CHAR(2) | |
| PROFIL_ID | Object ID | OBJEKTID | NUMC(8) | |
| HANDLE | Globally unique identifier (linked to time segment, etc) | TSEGGUID | CHAR(22) | |
| TSEGFL | Time segment exists | TSEGEXISTS | CHAR(1) | |
| TSEGTP | Template | TSEGTEMPLA | TTSEGTPLH | CHAR(10) |
| TZONSO | Time Zone for Notification | TZONSO | TTZZ | CHAR(6) |
| TZONID | Origin of Time Zone in Notification | TZONSMID | CHAR(1) | |
| FUNKTION | Keys for Function in Action Box | QNFUNKTION | CHAR(4) | |
| /SAPSMOSS/INSTN | Installation number | /SAPSMOSS/R3INSTN | /SAPSMOSS/INSTN | CHAR(10) |
| /SAPSMOSS/MNUMM | SAPNet notification number | /SAPSMOSS/MNUMM | NUMC(24) | |
| /SAPSMOSS/OSSYS | Operating system and version | /SAPSMOSS/OSSYS | /SAPSMOSS/OSYS | CHAR(10) |
| /SAPSMOSS/DBSYS | Database system | /SAPSMOSS/DBSYS | /SAPSMOSS/DBSY | CHAR(10) |
| /SAPSMOSS/REL | R/3 Release | /SAPSMOSS/R3REL | /SAPSMOSS/REL | CHAR(10) |
| /SAPSMOSS/COMP | Area | /SAPSMOSS/R3COMP | CHAR(20) | |
| /SAPSMOSS/FRONT | Frontend | /SAPSMOSS/FRONTEND | /SAPSMOSS/FRNT | CHAR(10) |
| /SAPSMOSS/SYSTYP | R/3 System type | /SAPSMOSS/R3SYSTYPE | /SAPSMOSS/SYST | CHAR(1) |
| /SAPSMOSS/ADDID | Add-on ID | /SAPSMOSS/R3ADDID | /SAPSMOSS/ADDID | CHAR(10) |
| /SAPSMOSS/ADDREL | Add-On Release | /SAPSMOSS/R3ADDREL | /SAPSMOSS/ADDRL | CHAR(10) |
| /SAPSMOSS/TSTMP | SAPNet time stamp | /SAPSMOSS/NSTSTMP | NUMC(14) | |
| /SAPSMOSS/STATUS | Status of R/3 notification in SAPNet | /SAPSMOSS/STATUS | /SAPSMOSS/STAT | CHAR(1) |
| /SAPSMOSS/ERDAT | Date on which notification was completed at SAP | /SAPSMOSS/ERDAT | DATS(8) | |
| /SAPSMOSS/ERZEIT | Time when notification was completed at SAP | /SAPSMOSS/ERZEIT | TIMS(6) | |
| /SAPSMOSS/SYSID | Name of SAP System | SYSYSID | CHAR(8) | |
| /SAPSMOSS/MANDT | Client ID | SYMANDT | * | CLNT(3) |
| PSP_NR | WBS Element | QM_PS_POSNR | * | NUMC(8) |
| ESTIMATED_COSTS | Estimated Costs for a Claim | PS_COSTS | CURR(13) | |
| CLAIMED_COSTS | Costs Claimed | COSTS_CLAIM | CURR(13) | |
| RESULT_COSTS | Costs Accepted | COSTS_RESULT | CURR(13) | |
| CHANCE | Chance of Completing a Claim | PS_CHANCE | NUMC(2) | |
| OPPONENT | Partner Type | PS_OPPONENT | CHAR(2) | |
| KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | CK_KALNR | NUMC(12) | |
| KALVAR | Costing Variant for Postprocessing with Unit Costing | CK_KALVAR | CHAR(4) | |
| OBJNR_REAL | Object Number of Real CO Account Assignment | J_OBJNR_REAL | ONR00 | CHAR(22) |
| OBJNR_STAT | Auxiliary account assignment 1 | OBJNR_N1 | ONR00 | CHAR(22) |
| DUMMY_QMEL_INCL_EEW_PS | Dummy function in length 1 | DUMMY | CHAR(1) | |
| PHASE | Notification Processing Phase | QM_PHASE | CHAR(1) | |
| CHANGEDDATETIME | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TZNTSTMPS | DEC(15) | |
| /ISDFPS/MHIO_ADDATE | Completion Date for Call Object | MHIO_ADDAT | DATS(8) | |
| /ISDFPS/MHIO_ADTIME | Completion Time for Call Object | MHIO_ADUHR | TIMS(6) | |
| /ISDFPS/USERMODE | Scheduling determined by user | USERMOD | CHAR(1) | |
| /ISDFPS/OBJNR | Object number | J_OBJNR | * | CHAR(22) |
| LOGSYSTEM | Logical System | LOGSYSTEM | * | CHAR(10) |
| /ISDFPS/MEQUI | Master Equipment | /ISDFPS/MEQUI | * | CHAR(18) |
| SHN_OBJTY | Object types of the CIM resource | CR_OBJTY | CHAR(2) | |
| SHN_OBJID | Object ID of the resource | CR_OBJID | * | NUMC(8) |
| SHN_FUNCT_LOC | Functional Location | TPLNR | CHAR(30) | |
| SHN_EQUIPMENT | Equipment Number | EQUNR | CHAR(18) | |
| SHN_ORIGIN | Origin or Use of Shift Note or Report | COCF_SRN_ORIGIN | NUMC(2) | |
| UII | Unique Item Identifier | UII_CHAR72 | CHAR(72) |
