QMEL - Quality Notification

Quality Notification information is stored in SAP table QMEL.
It is part of development package IWOC in software component PM-WOC-MN. This development package consists of objects that can be grouped under "Application Development R/3 Work Order Cycle".

Fields for table QMEL

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