QMEL SAP (Quality Notification) Table details
Dictionary Type: Table
Description: Quality Notification
Description: Quality Notification
Table field list including key, data, relationships and ABAP select examples
QMEL is a standard SAP Table which is used to store Quality Notification data and is available within R/3 SAP systems depending on the version and release level.
The QMEL table consists of various fields, each holding specific information or linking keys about Quality Notification data available in SAP. These include QMNUM (Notification No), QMART (Notification Type), QMTXT (Short Text), ARTPR (Priority Type).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP QMEL table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
QMNUM | Notification No | QMNUM | CHAR | 12 | ALPHA | QMNUM | IQM | ||
QMART | Notification Type | QMART | CHAR | 2 | TQ80 | QMART | QMR | ||
QMTXT | Short Text | QMTXT | CHAR | 40 | TEXT40 | ||||
ARTPR | Priority Type | ARTPR | CHAR | 2 | T356A | ARTPR | |||
PRIOK | Priority | PRIOK | CHAR | 1 | T356 | PRIOK | PRIOK | ||
ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12 | USNAM | ||||
ERDAT | Date on Which Record Was Created | ERDAT | DATS | 8 | DATUM | ||||
AENAM | Name of Person Who Changed Object | AENAM | CHAR | 12 | USNAM | ||||
AEDAT | Changed On | AEDAT | DATS | 8 | DATUM | ||||
MZEIT | Time of Notification | MZEIT | TIMS | 6 | UHRZT | ||||
QMDAT | Date of Notification | QMDAT | DATS | 8 | DATUM | ||||
QMNAM | Name of Person Reporting Notification | QMNAM | CHAR | 12 | USNAM | ||||
STRMN | Required start date | STRMN | DATS | 8 | DATUM | ||||
STRUR | Required Start Time | STRUR | TIMS | 6 | UZEIT | ||||
LTRMN | Required End Date | LTRMN | DATS | 8 | DATUM | ||||
LTRUR | Requested End Time | LTRUR | TIMS | 6 | UZEIT | ||||
WAERS | Currency Key | WAERS | CUKY | 5 | TCURC | WAERS | FWS | ||
AUFNR | Order Number | AUFNR | CHAR | 12 | AUFK | ALPHA | AUFNR | ANR | |
VERID | Production Version | VERID | CHAR | 4 | MKAL | VERID | VER | ||
RM_MATNR | Material number of the production version | RM_MATNR | CHAR | 18 | MKAL | MATN1 | MATNR | MAT | MAT1 |
RM_WERKS | Plant of production version | RM_WERKS | CHAR | 4 | MKAL | WERKS | WRK | H_T001W | |
SA_AUFNR | Run schedule header number | SA_AUFNR | CHAR | 12 | SAFK | ALPHA | SA_AUFNR | ||
MATNR | Material Number | MATNR | CHAR | 18 | MARA | MATN1 | MATNR | MAT | S_MAT1 |
REVLV | Revision Level | REVLV | CHAR | 2 | NUMCV | REVLV | RVS | ||
MATKL | Material Group | MATKL | CHAR | 9 | T023 | MATKL | MKL | S_WBWG | |
PRDHA | Product hierarchy | PRODH_D | CHAR | 18 | T179 | PRODH | VPR | ||
KZKRI | Indicator: Critical part | KZKRI | CHAR | 1 | XFELD | ||||
KZDKZ | Documentation required indicator | KZDKZ | CHAR | 1 | XFELD | ||||
KUNUM | Account Number of Customer | QKUNUM | CHAR | 10 | KNA1 | ALPHA | KUNNR | KUN | |
FEKNZ | Error Records Exist | FEKNZ | CHAR | 1 | CHAR1 | ||||
MAKNZ | Task Records Exist | MAKNZ | CHAR | 1 | CHAR1 | ||||
OBJNR | Object Number for Status Management | QMOBJNR | CHAR | 22 | ONR00 | J_OBJNR | |||
QMDAB | Date for Notification Completion | QMDAB | DATS | 8 | DATUM | ||||
QMZAB | Completion Time of Notification | QMZAB | TIMS | 6 | UZEIT | ||||
RBNR | Catalog Profile | RBNR | CHAR | 9 | T352B | RBNR | |||
RBNRI | Origin of Notifications Catalog Profile | RBNRI | CHAR | 1 | RBNRI | ||||
INDTX | Object Long Text Available | INDLTX | CHAR | 1 | CHAR1 | ||||
KZMLA | Primary language indicator for text segment | KZMLA | CHAR | 1 | CHAR1 | ||||
HERKZ | Origin of Notification | HERKZ | CHAR | 2 | HERKZ | ||||
BEZDT | Notification Reference Date | BEZDT | DATS | 8 | DATUM | ||||
BEZUR | Notification Reference Time | BEZUR_D | TIMS | 6 | UZEIT | ||||
LIFNUM | Vendor Account Number | LIFNUM | CHAR | 10 | LFA1 | ALPHA | LIFNR | LIF | |
BUNAME | Author of a Q/PM Notification | BUNAME | CHAR | 12 | Assigned to domain | XUBNAME | XUS | ||
VBELN | Sales Order Number | KDAUF | CHAR | 10 | VBUK | ALPHA | VBELN | AUN | |
BSTNK | Customer purchase order number | BSTKD | CHAR | 35 | BSTKD | ||||
BSTDK | Customer purchase order date | BSTDK | DATS | 8 | DATUM | ||||
SPART | Division | SPART | CHAR | 2 | TSPA | SPART | SPA | C_SPART | |
VKORG | Sales Organization | VKORG | CHAR | 4 | TVKO | VKORG | VKO | C_VKORG | |
VTWEG | Distribution Channel | VTWEG | CHAR | 2 | TVTW | VTWEG | VTW | C_VTWEG | |
ADRNR | Addresses: Address Number | CADNR | CHAR | 10 | Assigned to domain | ALPHA | CADRNR | ||
AEZEIT | Time of Change | AEZEIT | TIMS | 6 | UHRZT | ||||
ERZEIT | Time, at Which Record Was Added | ERZEIT | TIMS | 6 | UHRZT | ||||
MAWERK | Plant for Material | QMAWERKS | CHAR | 4 | T001W | WERKS | WRK | ||
QMKAT | Catalog Type - Coding | QMKAT | CHAR | 1 | TQ15 | QKATART | |||
QMGRP | Code Group - Coding | QMGRP | CHAR | 8 | QPGR | QCODEGRP | |||
QMCOD | Coding | QMCOD | CHAR | 4 | Assigned to domain | QCODE | |||
AUSWIRK | Key for a Scenario | QSCENARIO | CHAR | 4 | TQ81 | QSCENARIO | |||
TEILEV | Usage of Parts | QTEILEV | CHAR | 4 | TQ81V | QTEILEV | |||
PRUEFLOS | Inspection Lot Number | QPLOS | NUMC | 12 | QALS | QPLOS | QLS | QALS | |
CHARG | Batch Number | CHARG_D | CHAR | 10 | MCH1 | CHARG | CHA | ||
LGORTCHARG | Storage Location of Batch | QLGORTCHAR | CHAR | 4 | T001L | LGORT | LAG | ||
LICHN | Vendor Batch Number | LICHN | CHAR | 15 | LICHN | ||||
HERSTELLER | Number of Manufacturer | QLIFNR | CHAR | 10 | LFA1 | ALPHA | LIFNR | LIF | |
EMATNR | Material Number Corresponding to Manufacturer Part Number | EMATN | CHAR | 18 | MARA | MATN1 | MATNR | HTN | |
EKORG | Purchasing Organization | EKORG | CHAR | 4 | T024E | EKORG | EKO | ||
BKGRP | Purchasing Group | BKGRP | CHAR | 3 | T024 | EKGRP | EKG | ||
LGORTVORG | Storage Location for Inspection Lot Stock | QLGORTVORG | CHAR | 4 | T001L | LGORT | |||
FERTAUFNR | Order Number (Production Order) | FERTAUFNR | CHAR | 12 | AUFK | ALPHA | AUFNR | ANR | |
FERTAUFPL | Plan Number for Operations in Order (Production Order) | FERTAUFPL | NUMC | 10 | AUFPL | ||||
EBELN | Purchasing Document Number | EBELN | CHAR | 10 | EKKO | ALPHA | EBELN | BES | MEKK_C |
EBELP | Item Number of Purchasing Document | QEBELP | NUMC | 5 | EKPO | EBELP | BSP | ||
MJAHR | Material Document Year | MJAHR | NUMC | 4 | GJAHR | GJAHR | MJA | ||
MBLNR | Number of Material Document | MBLNR | CHAR | 10 | ALPHA | BELNR | MBN | ||
MBLPO | Item in Material Document | QMBLPO | NUMC | 4 | MBLPO | POS | |||
LS_KDAUF | Sales Order Number | KDAUF | CHAR | 10 | VBUK | ALPHA | VBELN | AUN | |
LS_KDPOS | Item number of the SD document | POSNR | NUMC | 6 | VBUP | POSNR | |||
LS_VBELN | Delivery | VBELN_VL | CHAR | 10 | VBUK | ALPHA | VBELN | VL | |
LS_POSNR | Delivery Item | QPOSNR_VL | NUMC | 6 | VBUP | POSNR | |||
CROBJTY | Object types of the CIM resource | CR_OBJTY | CHAR | 2 | CR_OBJTY | ||||
ARBPL | Object ID of the Work Center | LGWID | NUMC | 8 | CRID | CR_OBJID | |||
ARBPLWERK | Plant for Work Center | QARBPWERKS | CHAR | 4 | T001W | WERKS | WRK | ||
FEART | Report Type for Defects Recording | QFEART | CHAR | 8 | TQ86 | QFEART | QFE | ||
PNLKN | Current Node Number from Order Counter APLZL | QLFNKN | NUMC | 8 | KNTNR | ||||
MGEIG | Defective Quantity (Internal) | MGEIG | QUAN | 13(3) | MENGE | ||||
MGFRD | Defective Quantity (External) | MGFRD | QUAN | 13(3) | MENGE | ||||
MGEIN | Unit of Measure | MGEIN | UNIT | 3 | T006 | CUNIT | MEINS | ||
BZMNG | General Reference Quantity | QBZMNG | QUAN | 13(3) | MENGE | ||||
RKMNG | Complaint Quantity | RKMNG | QUAN | 13(3) | MENGE | ||||
RGMNG | Return Delivery Quantity | RGMNG | QUAN | 13(3) | MENGE | ||||
RKDAT | Date of Return Delivery | RKDAT | DATS | 8 | DATUM | ||||
COAUFNR | Order Number (QM Order) | COAUFNR | CHAR | 12 | AUFK | ALPHA | AUFNR | ANR | |
QWRNUM | Reference Notification Number | QWRNUM | CHAR | 12 | QMEL | ALPHA | QMNUM | IQM | |
REFNUM | External Reference Number | QMEXTNR | CHAR | 20 | CHAR020 | ||||
KDMAT | Material Number Used by Customer | MATNR_KU | CHAR | 35 | IDNEX | ||||
IDNLF | Material Number Used by Vendor | IDNLF | CHAR | 35 | IDNEX | ||||
SERIALNR | Serial Number | GERNR | CHAR | 18 | GERNR | GERNR | SER | ||
KZLOESCH | Delete Data Record | KZLOESCH | CHAR | 1 | CHAR1 | ||||
PRODDAT | Production Date | QPRODDAT | DATS | 8 | DATUM | ||||
DEVICEID | Additional Device Data | DEVICEID | CHAR | 40 | DEVICEID | ||||
VKBUR | Sales Office | VKBUR | CHAR | 4 | TVKBZ | VKBUR | VKB | ||
VKGRP | Sales Group | VKGRP | CHAR | 3 | TVBVK | VKGRP | VKG | ||
AUTKZ | Data Record Created with Function 'Create with Copy Model' | QAUTKZ | CHAR | 1 | QKZ | ||||
BEDID | ID of the capacity requirements record | BEDID | NUMC | 12 | Assigned to domain | BEDID | |||
BEDZL | Internal counter | CIM_COUNT | NUMC | 8 | CIM_COUNT | ||||
PROFIL_TYP | Object Type | OTYPE | CHAR | 2 | Assigned to domain | OTYPE | POT | ||
PROFIL_ID | Object ID | OBJEKTID | NUMC | 8 | NUM08 | PON | |||
HANDLE | Globally unique identifier (linked to time segment, etc) | TSEGGUID | CHAR | 22 | SYSUUID_22 | ||||
TSEGFL | Time segment exists | TSEGEXISTS | CHAR | 1 | FLAG | ||||
TSEGTP | Template | TSEGTEMPLA | CHAR | 10 | TTSEGTPLH | TMPLA | TSEGTEMPLA | ||
TZONSO | Time Zone for Notification | TZONSO | CHAR | 6 | TTZZ | TZNZONE | |||
TZONID | Origin of Time Zone in Notification | TZONSMID | CHAR | 1 | TZONSMID | ||||
FUNKTION | Keys for Function in Action Box | QNFUNKTION | CHAR | 4 | CHAR4 | ||||
/SAPSMOSS/INSTN | Installation number | /SAPSMOSS/R3INSTN | CHAR | 10 | /SAPSMOSS/INSTN | /SAPSMOSS/R3INSTN | |||
/SAPSMOSS/MNUMM | SAPNet notification number | /SAPSMOSS/MNUMM | NUMC | 24 | /SAPSMOSS/MNUMM | ||||
/SAPSMOSS/OSSYS | Operating system and version | /SAPSMOSS/OSSYS | CHAR | 10 | /SAPSMOSS/OSYS | /SAPSMOSS/OSSYS | |||
/SAPSMOSS/DBSYS | Database system | /SAPSMOSS/DBSYS | CHAR | 10 | /SAPSMOSS/DBSY | /SAPSMOSS/DBSYS | |||
/SAPSMOSS/REL | R/3 Release | /SAPSMOSS/R3REL | CHAR | 10 | /SAPSMOSS/REL | /SAPSMOSS/R3REL | |||
/SAPSMOSS/COMP | Area | /SAPSMOSS/R3COMP | CHAR | 20 | /SAPSMOSS/R3COMP | ||||
/SAPSMOSS/FRONT | Frontend | /SAPSMOSS/FRONTEND | CHAR | 10 | /SAPSMOSS/FRNT | /SAPSMOSS/FRONTEND | |||
/SAPSMOSS/SYSTYP | R/3 System type | /SAPSMOSS/R3SYSTYPE | CHAR | 1 | /SAPSMOSS/SYST | /SAPSMOSS/R3SYSTYPE | |||
/SAPSMOSS/ADDID | Add-on ID | /SAPSMOSS/R3ADDID | CHAR | 10 | /SAPSMOSS/ADDID | /SAPSMOSS/R3ADDID | |||
/SAPSMOSS/ADDREL | Add-On Release | /SAPSMOSS/R3ADDREL | CHAR | 10 | /SAPSMOSS/ADDRL | /SAPSMOSS/R3ADDREL | |||
/SAPSMOSS/TSTMP | SAPNet time stamp | /SAPSMOSS/NSTSTMP | NUMC | 14 | TZNTIMESTP | ||||
/SAPSMOSS/STATUS | Status of R/3 notification in SAPNet | /SAPSMOSS/STATUS | CHAR | 1 | /SAPSMOSS/STAT | /SAPSMOSS/STATUS | |||
/SAPSMOSS/ERDAT | Date on which notification was completed at SAP | /SAPSMOSS/ERDAT | DATS | 8 | DATUM | ||||
/SAPSMOSS/ERZEIT | Time when notification was completed at SAP | /SAPSMOSS/ERZEIT | TIMS | 6 | UHRZT | ||||
/SAPSMOSS/SYSID | Name of SAP System | SYSYSID | CHAR | 8 | SYCHAR08 | ||||
/SAPSMOSS/MANDT | Client ID | SYMANDT | CLNT | 3 | Assigned to domain | MANDT | |||
PSP_NR | WBS Element | PS_POSNR | NUMC | 8 | Assigned to domain | ABPSP | PS_POSNR | ||
ESTIMATED_COSTS | Estimated Costs for a Claim | PS_COSTS | CURR | 13(2) | WERTV7 | ||||
CLAIMED_COSTS | Costs Claimed | COSTS_CLAIM | CURR | 13(2) | WERTV7 | ||||
RESULT_COSTS | Costs Accepted | COSTS_RESULT | CURR | 13(2) | WERTV7 | ||||
CHANCE | Chance of Completing a Claim | PS_CHANCE | NUMC | 2 | PS_CHANCE | ||||
OPPONENT | Partner Type | PS_OPPONENT | CHAR | 2 | OPPONENT | ||||
KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | CK_KALNR | NUMC | 12 | Assigned to domain | CK_KALNR | KNR | ||
KALVAR | Costing Variant for Postprocessing with Unit Costing | CK_KALVAR | CHAR | 4 | Assigned to domain | KLVAR | |||
OBJNR_REAL | Object number of real CO account assignment | J_OBJNR_REAL | CHAR | 22 | ONR00 | J_OBJNR | ONR | ||
OBJNR_STAT | Auxiliary account assignment 1 | OBJNR_N1 | CHAR | 22 | ONR00 | J_OBJNR | |||
PHASE | Notification Processing Phase | QM_PHASE | CHAR | 1 | QM_PHASE | ||||
.INCLU--AP | 0 | ||||||||
/ISDFPS/OBJNR | Object number | J_OBJNR | CHAR | 22 | Assigned to domain | J_OBJNR | ONR | ||
LOGSYSTEM | Logical System | LOGSYSTEM | CHAR | 10 | Assigned to domain | ALPHA | LOGSYS | ||
/ISDFPS/MEQUI | Master Equipment | /ISDFPS/MEQUI | CHAR | 18 | Assigned to domain | ALPHA | EQUNR | ||
.INCLU--AP | 0 | ||||||||
SHN_OBJTY | Object types of the CIM resource | CR_OBJTY | CHAR | 2 | CR_OBJTY | ||||
SHN_OBJID | Object ID of the resource | CR_OBJID | NUMC | 8 | Assigned to domain | CR_OBJID | |||
SHN_FUNCT_LOC | Functional Location | TPLNR | CHAR | 30 | Assigned to domain | TPLNR | TPLNR | IFL | IFLM |
SHN_EQUIPMENT | Equipment Number | EQUNR | CHAR | 18 | Assigned to domain | ALPHA | EQUNR | EQN | EQUI |
SHN_ORIGIN | Origin or Use of Shift Note or Report | COCF_SRN_ORIGIN | NUMC | 2 | COCF_SRN_ORIGIN | ||||
.INCLU--AP | 0 | ||||||||
UII | Unique Item Identifier | UII_CHAR72 | CHAR | 72 | UII_CHAR72 | UII | H_UII |
Key field | Non-key field |
How do I retrieve data from SAP table QMEL using ABAP code
The following ABAP code Example will allow you to do a basic selection on QMEL to SELECT all data from the tableDATA: WA_QMEL TYPE QMEL.
SELECT SINGLE *
FROM QMEL
INTO CORRESPONDING FIELDS OF WA_QMEL
WHERE...
How to access SAP table QMEL
Within an ECC or HANA version of SAP you can also view further information about QMEL and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects