QMEL SAP (Quality Notification) Table details

Dictionary Type: Table
Description: Quality Notification




ABAP Code to SELECT data from QMEL
Related tables to QMEL
Access table QMEL




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
MANDTClient MANDTCLNT3T000MANDT
QMNUMNotification No QMNUMCHAR12ALPHAQMNUMIQM
QMARTNotification Type QMARTCHAR2TQ80QMARTQMR
QMTXTShort Text QMTXTCHAR40TEXT40
ARTPRPriority Type ARTPRCHAR2T356AARTPR
PRIOKPriority PRIOKCHAR1T356PRIOKPRIOK
ERNAMName of Person who Created the Object ERNAMCHAR12USNAM
ERDATDate on Which Record Was Created ERDATDATS8DATUM
AENAMName of Person Who Changed Object AENAMCHAR12USNAM
AEDATChanged On AEDATDATS8DATUM
MZEITTime of Notification MZEITTIMS6UHRZT
QMDATDate of Notification QMDATDATS8DATUM
QMNAMName of Person Reporting Notification QMNAMCHAR12USNAM
STRMNRequired start date STRMNDATS8DATUM
STRURRequired Start Time STRURTIMS6UZEIT
LTRMNRequired End Date LTRMNDATS8DATUM
LTRURRequested End Time LTRURTIMS6UZEIT
WAERSCurrency Key WAERSCUKY5TCURCWAERSFWS
AUFNROrder Number AUFNRCHAR12AUFKALPHAAUFNRANR
VERIDProduction Version VERIDCHAR4MKALVERIDVER
RM_MATNRMaterial number of the production version RM_MATNRCHAR18MKALMATN1MATNRMATMAT1
RM_WERKSPlant of production version RM_WERKSCHAR4MKALWERKSWRKH_T001W
SA_AUFNRRun schedule header number SA_AUFNRCHAR12SAFKALPHASA_AUFNR
MATNRMaterial Number MATNRCHAR18MARAMATN1MATNRMATS_MAT1
REVLVRevision Level REVLVCHAR2NUMCVREVLVRVS
MATKLMaterial Group MATKLCHAR9T023MATKLMKLS_WBWG
PRDHAProduct hierarchy PRODH_DCHAR18T179PRODHVPR
KZKRIIndicator: Critical part KZKRICHAR1XFELD
KZDKZDocumentation required indicator KZDKZCHAR1XFELD
KUNUMAccount Number of Customer QKUNUMCHAR10KNA1ALPHAKUNNRKUN
FEKNZError Records Exist FEKNZCHAR1CHAR1
MAKNZTask Records Exist MAKNZCHAR1CHAR1
OBJNRObject Number for Status Management QMOBJNRCHAR22ONR00J_OBJNR
QMDABDate for Notification Completion QMDABDATS8DATUM
QMZABCompletion Time of Notification QMZABTIMS6UZEIT
RBNRCatalog Profile RBNRCHAR9T352BRBNR
RBNRIOrigin of Notifications Catalog Profile RBNRICHAR1RBNRI
INDTXObject Long Text Available INDLTXCHAR1CHAR1
KZMLAPrimary language indicator for text segment KZMLACHAR1CHAR1
HERKZOrigin of Notification HERKZCHAR2HERKZ
BEZDTNotification Reference Date BEZDTDATS8DATUM
BEZURNotification Reference Time BEZUR_DTIMS6UZEIT
LIFNUMVendor Account Number LIFNUMCHAR10LFA1ALPHALIFNRLIF
BUNAMEAuthor of a Q/PM Notification BUNAMECHAR12Assigned to domainXUBNAMEXUS
VBELNSales Order Number KDAUFCHAR10VBUKALPHAVBELNAUN
BSTNKCustomer purchase order number BSTKDCHAR35BSTKD
BSTDKCustomer purchase order date BSTDKDATS8DATUM
SPARTDivision SPARTCHAR2TSPASPARTSPAC_SPART
VKORGSales Organization VKORGCHAR4TVKOVKORGVKOC_VKORG
VTWEGDistribution Channel VTWEGCHAR2TVTWVTWEGVTWC_VTWEG
ADRNRAddresses: Address Number CADNRCHAR10Assigned to domainALPHACADRNR
AEZEITTime of Change AEZEITTIMS6UHRZT
ERZEITTime, at Which Record Was Added ERZEITTIMS6UHRZT
MAWERKPlant for Material QMAWERKSCHAR4T001WWERKSWRK
QMKATCatalog Type - Coding QMKATCHAR1TQ15QKATART
QMGRPCode Group - Coding QMGRPCHAR8QPGRQCODEGRP
QMCODCoding QMCODCHAR4Assigned to domainQCODE
AUSWIRKKey for a Scenario QSCENARIOCHAR4TQ81QSCENARIO
TEILEVUsage of Parts QTEILEVCHAR4TQ81VQTEILEV
PRUEFLOSInspection Lot Number QPLOSNUMC12QALSQPLOSQLSQALS
CHARGBatch Number CHARG_DCHAR10MCH1CHARGCHA
LGORTCHARGStorage Location of Batch QLGORTCHARCHAR4T001LLGORTLAG
LICHNVendor Batch Number LICHNCHAR15LICHN
HERSTELLERNumber of Manufacturer QLIFNRCHAR10LFA1ALPHALIFNRLIF
EMATNRMaterial Number Corresponding to Manufacturer Part Number EMATNCHAR18MARAMATN1MATNRHTN
EKORGPurchasing Organization EKORGCHAR4T024EEKORGEKO
BKGRPPurchasing Group BKGRPCHAR3T024EKGRPEKG
LGORTVORGStorage Location for Inspection Lot Stock QLGORTVORGCHAR4T001LLGORT
FERTAUFNROrder Number (Production Order) FERTAUFNRCHAR12AUFKALPHAAUFNRANR
FERTAUFPLPlan Number for Operations in Order (Production Order) FERTAUFPLNUMC10AUFPL
EBELNPurchasing Document Number EBELNCHAR10EKKOALPHAEBELNBESMEKK_C
EBELPItem Number of Purchasing Document QEBELPNUMC5EKPOEBELPBSP
MJAHRMaterial Document Year MJAHRNUMC4GJAHRGJAHRMJA
MBLNRNumber of Material Document MBLNRCHAR10ALPHABELNRMBN
MBLPOItem in Material Document QMBLPONUMC4MBLPOPOS
LS_KDAUFSales Order Number KDAUFCHAR10VBUKALPHAVBELNAUN
LS_KDPOSItem number of the SD document POSNRNUMC6VBUPPOSNR
LS_VBELNDelivery VBELN_VLCHAR10VBUKALPHAVBELNVL
LS_POSNRDelivery Item QPOSNR_VLNUMC6VBUPPOSNR
CROBJTYObject types of the CIM resource CR_OBJTYCHAR2CR_OBJTY
ARBPLObject ID of the Work Center LGWIDNUMC8CRIDCR_OBJID
ARBPLWERKPlant for Work Center QARBPWERKSCHAR4T001WWERKSWRK
FEARTReport Type for Defects Recording QFEARTCHAR8TQ86QFEARTQFE
PNLKNCurrent Node Number from Order Counter APLZL QLFNKNNUMC8KNTNR
MGEIGDefective Quantity (Internal) MGEIGQUAN13(3) MENGE
MGFRDDefective Quantity (External) MGFRDQUAN13(3) MENGE
MGEINUnit of Measure MGEINUNIT3T006CUNITMEINS
BZMNGGeneral Reference Quantity QBZMNGQUAN13(3) MENGE
RKMNGComplaint Quantity RKMNGQUAN13(3) MENGE
RGMNGReturn Delivery Quantity RGMNGQUAN13(3) MENGE
RKDATDate of Return Delivery RKDATDATS8DATUM
COAUFNROrder Number (QM Order) COAUFNRCHAR12AUFKALPHAAUFNRANR
QWRNUMReference Notification Number QWRNUMCHAR12QMELALPHAQMNUMIQM
REFNUMExternal Reference Number QMEXTNRCHAR20CHAR020
KDMATMaterial Number Used by Customer MATNR_KUCHAR35IDNEX
IDNLFMaterial Number Used by Vendor IDNLFCHAR35IDNEX
SERIALNRSerial Number GERNRCHAR18GERNRGERNRSER
KZLOESCHDelete Data Record KZLOESCHCHAR1CHAR1
PRODDATProduction Date QPRODDATDATS8DATUM
DEVICEIDAdditional Device Data DEVICEIDCHAR40DEVICEID
VKBURSales Office VKBURCHAR4TVKBZVKBURVKB
VKGRPSales Group VKGRPCHAR3TVBVKVKGRPVKG
AUTKZData Record Created with Function 'Create with Copy Model' QAUTKZCHAR1QKZ
BEDIDID of the capacity requirements record BEDIDNUMC12Assigned to domainBEDID
BEDZLInternal counter CIM_COUNTNUMC8CIM_COUNT
PROFIL_TYPObject Type OTYPECHAR2Assigned to domainOTYPEPOT
PROFIL_IDObject ID OBJEKTIDNUMC8NUM08PON
HANDLEGlobally unique identifier (linked to time segment, etc) TSEGGUIDCHAR22SYSUUID_22
TSEGFLTime segment exists TSEGEXISTSCHAR1FLAG
TSEGTPTemplate TSEGTEMPLACHAR10TTSEGTPLHTMPLATSEGTEMPLA
TZONSOTime Zone for Notification TZONSOCHAR6TTZZTZNZONE
TZONIDOrigin of Time Zone in Notification TZONSMIDCHAR1TZONSMID
FUNKTIONKeys for Function in Action Box QNFUNKTIONCHAR4CHAR4
/SAPSMOSS/INSTNInstallation number /SAPSMOSS/R3INSTNCHAR10/SAPSMOSS/INSTN/SAPSMOSS/R3INSTN
/SAPSMOSS/MNUMMSAPNet notification number /SAPSMOSS/MNUMMNUMC24/SAPSMOSS/MNUMM
/SAPSMOSS/OSSYSOperating system and version /SAPSMOSS/OSSYSCHAR10/SAPSMOSS/OSYS/SAPSMOSS/OSSYS
/SAPSMOSS/DBSYSDatabase system /SAPSMOSS/DBSYSCHAR10/SAPSMOSS/DBSY/SAPSMOSS/DBSYS
/SAPSMOSS/RELR/3 Release /SAPSMOSS/R3RELCHAR10/SAPSMOSS/REL/SAPSMOSS/R3REL
/SAPSMOSS/COMPArea /SAPSMOSS/R3COMPCHAR20/SAPSMOSS/R3COMP
/SAPSMOSS/FRONTFrontend /SAPSMOSS/FRONTENDCHAR10/SAPSMOSS/FRNT/SAPSMOSS/FRONTEND
/SAPSMOSS/SYSTYPR/3 System type /SAPSMOSS/R3SYSTYPECHAR1/SAPSMOSS/SYST/SAPSMOSS/R3SYSTYPE
/SAPSMOSS/ADDIDAdd-on ID /SAPSMOSS/R3ADDIDCHAR10/SAPSMOSS/ADDID/SAPSMOSS/R3ADDID
/SAPSMOSS/ADDRELAdd-On Release /SAPSMOSS/R3ADDRELCHAR10/SAPSMOSS/ADDRL/SAPSMOSS/R3ADDREL
/SAPSMOSS/TSTMPSAPNet time stamp /SAPSMOSS/NSTSTMPNUMC14TZNTIMESTP
/SAPSMOSS/STATUSStatus of R/3 notification in SAPNet /SAPSMOSS/STATUSCHAR1/SAPSMOSS/STAT/SAPSMOSS/STATUS
/SAPSMOSS/ERDATDate on which notification was completed at SAP /SAPSMOSS/ERDATDATS8DATUM
/SAPSMOSS/ERZEITTime when notification was completed at SAP /SAPSMOSS/ERZEITTIMS6UHRZT
/SAPSMOSS/SYSIDName of SAP System SYSYSIDCHAR8SYCHAR08
/SAPSMOSS/MANDTClient ID SYMANDTCLNT3Assigned to domainMANDT
PSP_NRWBS Element PS_POSNRNUMC8Assigned to domainABPSPPS_POSNR
ESTIMATED_COSTSEstimated Costs for a Claim PS_COSTSCURR13(2) WERTV7
CLAIMED_COSTSCosts Claimed COSTS_CLAIMCURR13(2) WERTV7
RESULT_COSTSCosts Accepted COSTS_RESULTCURR13(2) WERTV7
CHANCEChance of Completing a Claim PS_CHANCENUMC2PS_CHANCE
OPPONENTPartner Type PS_OPPONENTCHAR2OPPONENT
KALNRCost Estimate Number for Cost Est. w/o Qty Structure CK_KALNRNUMC12Assigned to domainCK_KALNRKNR
KALVARCosting Variant for Postprocessing with Unit Costing CK_KALVARCHAR4Assigned to domainKLVAR
OBJNR_REALObject number of real CO account assignment J_OBJNR_REALCHAR22ONR00J_OBJNRONR
OBJNR_STATAuxiliary account assignment 1 OBJNR_N1CHAR22ONR00J_OBJNR
PHASENotification Processing Phase QM_PHASECHAR1QM_PHASE
.INCLU--AP 0
/ISDFPS/OBJNRObject number J_OBJNRCHAR22Assigned to domainJ_OBJNRONR
LOGSYSTEMLogical System LOGSYSTEMCHAR10Assigned to domainALPHALOGSYS
/ISDFPS/MEQUIMaster Equipment /ISDFPS/MEQUICHAR18Assigned to domainALPHAEQUNR
.INCLU--AP 0
SHN_OBJTYObject types of the CIM resource CR_OBJTYCHAR2CR_OBJTY
SHN_OBJIDObject ID of the resource CR_OBJIDNUMC8Assigned to domainCR_OBJID
SHN_FUNCT_LOCFunctional Location TPLNRCHAR30Assigned to domainTPLNRTPLNRIFLIFLM
SHN_EQUIPMENTEquipment Number EQUNRCHAR18Assigned to domainALPHAEQUNREQNEQUI
SHN_ORIGINOrigin or Use of Shift Note or Report COCF_SRN_ORIGINNUMC2COCF_SRN_ORIGIN
.INCLU--AP 0
UIIUnique Item Identifier UII_CHAR72CHAR72UII_CHAR72UIIH_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 table
DATA: 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 as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!