SAP ABAP Table QMEL (Quality Notification)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MSE (Application Component) Mobile Service
     ⤷ IWOC (Package) Application Development R/3 Work Order Cycle

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	QMEL	Table Relationship Diagram
Short Description	Quality Notification

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	QMNUM	☑	QMNUM	QMNUM	CHAR	12	0	Message Number
3	QMART	☐	QMART	QMART	CHAR	2	0	Message Type	TQ80
4	QMTXT	☐	QMTXT	TEXT40	CHAR	40	0	Short Text
5	ARTPR	☐	ARTPR	ARTPR	CHAR	2	0	Priority Type	T356A
6	PRIOK	☐	PRIOK	PRIOK	CHAR	1	0	Priority	T356
7	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
8	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
9	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
10	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
11	MZEIT	☐	MZEIT	UHRZT	TIMS	6	0	Notification Time
12	QMDAT	☐	QMDAT	DATUM	DATS	8	0	Date of Notification
13	QMNAM	☐	QMNAM	USNAM	CHAR	12	0	Name of declarant
14	STRMN	☐	STRMN	DATUM	DATS	8	0	Desired Start Date
15	STRUR	☐	STRUR	UZEIT	TIMS	6	0	Desired Start Time
16	LTRMN	☐	LTRMN	DATUM	DATS	8	0	Required Finish Date
17	LTRUR	☐	LTRUR	UZEIT	TIMS	6	0	Required End Date-Time
18	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
19	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	AUFK
20	VERID	☐	VERID	VERID	CHAR	4	0	Production Version	MKAL
21	RM_MATNR	☐	RM_MATNR	MATNR	CHAR	18	0	Material number of the production version	MKAL
22	RM_WERKS	☐	RM_WERKS	WERKS	CHAR	4	0	Plant of production version	MKAL
23	SA_AUFNR	☐	SA_AUFNR	SA_AUFNR	CHAR	12	0	Run schedule header number	SAFK
24	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
25	REVLV	☐	REVLV	REVLV	CHAR	2	0	Revision level
26	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	T023
27	PRDHA	☐	PRODH_D	PRODH	CHAR	18	0	Product Hierarchy	T179
28	KZKRI	☐	KZKRI	XFELD	CHAR	1	0	Indicator: Critical part
29	KZDKZ	☐	KZDKZ	XFELD	CHAR	1	0	Documentation required indicator
30	KUNUM	☐	QKUNUM	KUNNR	CHAR	10	0	Account Number of Customer	KNA1
31	FEKNZ	☐	FEKNZ	CHAR1	CHAR	1	0	Error Records Exist
32	MAKNZ	☐	MAKNZ	CHAR1	CHAR	1	0	Task Records Exist
33	OBJNR	☐	QMOBJNR	J_OBJNR	CHAR	22	0	Object Number for Status Management	ONR00
34	QMDAB	☐	QMDAB	DATUM	DATS	8	0	Date for Completion of Notification
35	QMZAB	☐	QMZAB	UZEIT	TIMS	6	0	Completion Time of Notification
36	RBNR	☐	RBNR	RBNR	CHAR	9	0	Report layout	T352B
37	RBNRI	☐	RBNRI	RBNRI	CHAR	1	0	Origin of Notifications Catalog Profile
38	INDTX	☐	INDLTX	CHAR1	CHAR	1	0	Object Long Text Available
39	KZMLA	☐	KZMLA	CHAR1	CHAR	1	0	Primary language indicator for text segment
40	HERKZ	☐	HERKZ	HERKZ	CHAR	2	0	Origin Indicator for Notification
41	BEZDT	☐	BEZDT	DATUM	DATS	8	0	Notification Reference Date
42	BEZUR	☐	BEZUR_D	UZEIT	TIMS	6	0	Notification Reference Time
43	LIFNUM	☐	LIFNUM	LIFNR	CHAR	10	0	Vendor Account Number	LFA1
44	BUNAME	☐	BUNAME	XUBNAME	CHAR	12	0	Author of a Q/PM Notification	*
45	VBELN	☐	KDAUF	VBELN	CHAR	10	0	Sales Order Number	VBUK
46	BSTNK	☐	BSTKD	BSTKD	CHAR	35	0	Customer purchase order number
47	BSTDK	☐	BSTDK	DATUM	DATS	8	0	Customer purchase order date
48	SPART	☐	SPART	SPART	CHAR	2	0	Division	TSPA
49	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
50	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
51	ADRNR	☐	CADNR	CADRNR	CHAR	10	0	Addresses: Address Number	*
52	AEZEIT	☐	AEZEIT	UHRZT	TIMS	6	0	Time of Change
53	ERZEIT	☐	ERZEIT	UHRZT	TIMS	6	0	Time, at Which Record Was Added
54	MAWERK	☐	QMAWERKS	WERKS	CHAR	4	0	Plant for Material	T001W
55	QMKAT	☐	QMKAT	QKATART	CHAR	1	0	Catalog type - coding	TQ15
56	QMGRP	☐	QMGRP	QCODEGRP	CHAR	8	0	Code group - coding	QPGR
57	QMCOD	☐	QMCOD	QCODE	CHAR	4	0	Coding	*
58	AUSWIRK	☐	QSCENARIO	QSCENARIO	CHAR	4	0	Key for a Scenario	TQ81
59	TEILEV	☐	QTEILEV	QTEILEV	CHAR	4	0	Usage of Parts	TQ81V
60	PRUEFLOS	☐	QPLOS	QPLOS	NUMC	12	0	Inspection Lot Number	QALS
61	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	MCH1
62	LGORTCHARG	☐	QLGORTCHAR	LGORT	CHAR	4	0	Storage Location of Batch	T001L
63	LICHN	☐	LICHN	LICHN	CHAR	15	0	Vendor Batch Number
64	HERSTELLER	☐	QLIFNR	LIFNR	CHAR	10	0	Number of Manufacturer	LFA1
65	EMATNR	☐	EMATN	MATNR	CHAR	18	0	Material number corresponding to manufacturer part number	MARA
66	EKORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	T024E
67	BKGRP	☐	BKGRP	EKGRP	CHAR	3	0	Purchasing Group	T024
68	LGORTVORG	☐	QLGORTVORG	LGORT	CHAR	4	0	Storage Location for Inspection Lot Stock	T001L
69	FERTAUFNR	☐	FERTAUFNR	AUFNR	CHAR	12	0	Order Number (Production Order)	AUFK
70	FERTAUFPL	☐	FERTAUFPL	AUFPL	NUMC	10	0	Plan Number for Operations in Order (Production Order)
71	EBELN	☐	EBELN	EBELN	CHAR	10	0	Purchasing Document Number	EKKO
72	EBELP	☐	QEBELP	EBELP	NUMC	5	0	Item Number of Purchasing Document	EKPO
73	MJAHR	☐	MJAHR	GJAHR	NUMC	4	0	Year of material document
74	MBLNR	☐	MBLNR	BELNR	CHAR	10	0	Number of Material Document
75	MBLPO	☐	QMBLPO	MBLPO	NUMC	4	0	Item in Material Document
76	LS_KDAUF	☐	KDAUF	VBELN	CHAR	10	0	Sales Order Number	VBUK
77	LS_KDPOS	☐	POSNR	POSNR	NUMC	6	0	Item number of the SD document	VBUP
78	LS_VBELN	☐	VBELN_VL	VBELN	CHAR	10	0	Delivery	VBUK
79	LS_POSNR	☐	QPOSNR_VL	POSNR	NUMC	6	0	Delivery Item	VBUP
80	CROBJTY	☐	CR_OBJTY	CR_OBJTY	CHAR	2	0	Object types of the CIM resource
81	ARBPL	☐	LGWID	CR_OBJID	NUMC	8	0	Object ID of the Work Center	CRID
82	ARBPLWERK	☐	QARBPWERKS	WERKS	CHAR	4	0	Plant for Work Center	T001W
83	FEART	☐	QFEART	QFEART	CHAR	8	0	Report Type for Defects Recording	TQ86
84	PNLKN	☐	QLFNKN	KNTNR	NUMC	8	0	Current Node Number from Order Counter APLZL
85	MGEIG	☐	MGEIG	MENGE	QUAN	13	3	Defective Quantity (Internal)
86	MGFRD	☐	MGFRD	MENGE	QUAN	13	3	Defective Quantity (External)
87	MGEIN	☐	MGEIN	MEINS	UNIT	3	0	Unit of Measure	T006
88	BZMNG	☐	QBZMNG	MENGE	QUAN	13	3	General Reference Quantity
89	RKMNG	☐	RKMNG	MENGE	QUAN	13	3	Complaint Quantity
90	RGMNG	☐	RGMNG	MENGE	QUAN	13	3	Return Delivery Quantity
91	RKDAT	☐	RKDAT	DATUM	DATS	8	0	Date of Return Delivery
92	COAUFNR	☐	COAUFNR	AUFNR	CHAR	12	0	Order Number (QM Order)	AUFK
93	QWRNUM	☐	QWRNUM	QMNUM	CHAR	12	0	Reference Notification Number	QMEL
94	REFNUM	☐	QMEXTNR	CHAR020	CHAR	20	0	External Reference Number
95	KDMAT	☐	MATNR_KU	IDNEX	CHAR	35	0	Customer Material Number
96	IDNLF	☐	IDNLF	IDNEX	CHAR	35	0	Material Number Used by Vendor
97	SERIALNR	☐	GERNR	GERNR	CHAR	18	0	Serial Number
98	KZLOESCH	☐	KZLOESCH	CHAR1	CHAR	1	0	Delete Data Record
99	PRODDAT	☐	QPRODDAT	DATUM	DATS	8	0	Production Date
100	DEVICEID	☐	DEVICEID	DEVICEID	CHAR	40	0	Additional Device Data
101	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	TVKBZ
102	VKGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	TVBVK
103	AUTKZ	☐	QAUTKZ	QKZ	CHAR	1	0	Data Record Created with Function 'Create with Copy Model'
104	BEDID	☐	BEDID	BEDID	NUMC	12	0	ID of the capacity requirements record	*
105	BEDZL	☐	CIM_COUNT	CIM_COUNT	NUMC	8	0	Internal counter
106	PROFIL_TYP	☐	OTYPE	OTYPE	CHAR	2	0	Object Type	*
107	PROFIL_ID	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
108	HANDLE	☐	TSEGGUID	SYSUUID_22	CHAR	22	0	Globally unique identifier (linked to time segment, etc)
109	TSEGFL	☐	TSEGEXISTS	FLAG	CHAR	1	0	Time segment exists
110	TSEGTP	☐	TSEGTEMPLA	TSEGTEMPLA	CHAR	10	0	Template	TTSEGTPLH
111	TZONSO	☐	TZONSO	TZNZONE	CHAR	6	0	Time zone for notification	TTZZ
112	TZONID	☐	TZONSMID	TZONSMID	CHAR	1	0	Origin of Time Zone in Notification
113	FUNKTION	☐	QNFUNKTION	CHAR4	CHAR	4	0	Keys for Function in Action Box
114	.INCLUDE	☐				0	0
115	.INCLUDE	☐				0	0	OSS-Relevant Attributes/Fields
116	/SAPSMOSS/INSTN	☐	/SAPSMOSS/R3INSTN	/SAPSMOSS/R3INSTN	CHAR	10	0	Installation number	/SAPSMOSS/INSTN
117	/SAPSMOSS/MNUMM	☐	/SAPSMOSS/MNUMM	/SAPSMOSS/MNUMM	NUMC	24	0	SAPNet notification number
118	/SAPSMOSS/OSSYS	☐	/SAPSMOSS/OSSYS	/SAPSMOSS/OSSYS	CHAR	10	0	Operating system and version	/SAPSMOSS/OSYS
119	/SAPSMOSS/DBSYS	☐	/SAPSMOSS/DBSYS	/SAPSMOSS/DBSYS	CHAR	10	0	Database system	/SAPSMOSS/DBSY
120	/SAPSMOSS/REL	☐	/SAPSMOSS/R3REL	/SAPSMOSS/R3REL	CHAR	10	0	R/3 Release	/SAPSMOSS/REL
121	/SAPSMOSS/COMP	☐	/SAPSMOSS/R3COMP	/SAPSMOSS/R3COMP	CHAR	20	0	Area
122	/SAPSMOSS/FRONT	☐	/SAPSMOSS/FRONTEND	/SAPSMOSS/FRONTEND	CHAR	10	0	Frontend	/SAPSMOSS/FRNT
123	/SAPSMOSS/SYSTYP	☐	/SAPSMOSS/R3SYSTYPE	/SAPSMOSS/R3SYSTYPE	CHAR	1	0	R/3 System type	/SAPSMOSS/SYST
124	/SAPSMOSS/ADDID	☐	/SAPSMOSS/R3ADDID	/SAPSMOSS/R3ADDID	CHAR	10	0	Add-on ID	/SAPSMOSS/ADDID
125	/SAPSMOSS/ADDREL	☐	/SAPSMOSS/R3ADDREL	/SAPSMOSS/R3ADDREL	CHAR	10	0	Add-On Release	/SAPSMOSS/ADDRL
126	/SAPSMOSS/TSTMP	☐	/SAPSMOSS/NSTSTMP	TZNTIMESTP	NUMC	14	0	SAPNet time stamp
127	/SAPSMOSS/STATUS	☐	/SAPSMOSS/STATUS	/SAPSMOSS/STATUS	CHAR	1	0	Status of R/3 notification in SAPNet	/SAPSMOSS/STAT
128	/SAPSMOSS/ERDAT	☐	/SAPSMOSS/ERDAT	DATUM	DATS	8	0	Date on which notification was completed at SAP
129	/SAPSMOSS/ERZEIT	☐	/SAPSMOSS/ERZEIT	UHRZT	TIMS	6	0	Time when notification was completed at SAP
130	/SAPSMOSS/SYSID	☐	SYSYSID	SYCHAR08	CHAR	8	0	Name of SAP System
131	/SAPSMOSS/MANDT	☐	SYMANDT	MANDT	CLNT	3	0	Client ID	*
132	.INCLUDE	☐				0	0	Additional Claim Management Data
133	PSP_NR	☐	PS_POSNR	PS_POSNR	NUMC	8	0	WBS Element	*
134	ESTIMATED_COSTS	☐	PS_COSTS	WERTV7	CURR	13	2	Estimated Costs for a Claim
135	CLAIMED_COSTS	☐	COSTS_CLAIM	WERTV7	CURR	13	2	Costs Claimed
136	RESULT_COSTS	☐	COSTS_RESULT	WERTV7	CURR	13	2	Costs Accepted
137	CHANCE	☐	PS_CHANCE	PS_CHANCE	NUMC	2	0	Chance of Completing a Claim
138	OPPONENT	☐	PS_OPPONENT	OPPONENT	CHAR	2	0	Partner Type
139	KALNR	☐	CK_KALNR	CK_KALNR	NUMC	12	0	Cost Estimate Number for Cost Est. w/o Qty Structure	*
140	KALVAR	☐	CK_KALVAR	KLVAR	CHAR	4	0	Costing Variant for Postprocessing with Unit Costing	*
141	OBJNR_REAL	☐	J_OBJNR_REAL	J_OBJNR	CHAR	22	0	Object number of real CO account assignment	ONR00
142	OBJNR_STAT	☐	OBJNR_N1	J_OBJNR	CHAR	22	0	Auxiliary account assignment 1	ONR00
143	PHASE	☐	QM_PHASE	QM_PHASE	CHAR	1	0	Notification Processing Phase
144	.INCLU--AP	☐				0	0	Fields for /ISDFPS/ Enhancements
145	/ISDFPS/OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	*
146	LOGSYSTEM	☐	LOGSYSTEM	LOGSYS	CHAR	10	0	Logical System	*
147	/ISDFPS/MEQUI	☐	/ISDFPS/MEQUI	EQUNR	CHAR	18	0	Master Equipment	*
148	.INCLU--AP	☐				0	0	QMEL Append: Reference Work Center/Hierarchy Shift Note
149	SHN_OBJTY	☐	CR_OBJTY	CR_OBJTY	CHAR	2	0	Object types of the CIM resource
150	SHN_OBJID	☐	CR_OBJID	CR_OBJID	NUMC	8	0	Object ID of the resource	*
151	SHN_FUNCT_LOC	☐	TPLNR	TPLNR	CHAR	30	0	Functional Location	*
152	SHN_EQUIPMENT	☐	EQUNR	EQUNR	CHAR	18	0	Equipment Number	*
153	SHN_ORIGIN	☐	COCF_SRN_ORIGIN	COCF_SRN_ORIGIN	NUMC	2	0	Origin or Use of Shift Note or Report
154	.INCLU--AP	☐				0	0	IUID Append
155	UII	☐	UII_CHAR72	UII_CHAR72	CHAR	72	0	Unique Item Identifier

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	QMEL	/SAPSMOSS/ADDID	/SAPSMOSS/ADDID	R3ADDID
2	QMEL	/SAPSMOSS/ADDREL	/SAPSMOSS/ADDRL	R3ADDREL
3	QMEL	/SAPSMOSS/DBSYS	/SAPSMOSS/DBSY	DBSYS	REF	1	CN
4	QMEL	/SAPSMOSS/FRONT	/SAPSMOSS/FRNT	FRONTEND	REF
5	QMEL	/SAPSMOSS/INSTN	/SAPSMOSS/INSTN	R3INSTN	REF	1	CN
6	QMEL	/SAPSMOSS/OSSYS	/SAPSMOSS/OSYS	OSSYS	REF	1	CN
7	QMEL	/SAPSMOSS/REL	/SAPSMOSS/REL	R3REL	REF	1	CN
8	QMEL	/SAPSMOSS/STATUS	/SAPSMOSS/STAT	STATUS
9	QMEL	/SAPSMOSS/SYSTYP	/SAPSMOSS/SYST	R3SYSTYPE	REF	1	CN
10	QMEL	ARBPL	CRID	OBJID	REF	C	CN
11	QMEL	ARBPLWERK	T001W	WERKS
12	QMEL	ARTPR	T356A	ARTPR	REF	C	CN
13	QMEL	AUFNR	AUFK	AUFNR	REF	C	CN
14	QMEL	AUSWIRK	TQ81	AUSWIRK	KEY
15	QMEL	BKGRP	T024	EKGRP
16	QMEL	CHARG	MCH1	CHARG
17	QMEL	COAUFNR	AUFK	AUFNR
18	QMEL	EBELN	EKKO	EBELN	REF	C	CN
19	QMEL	EBELP	EKPO	EBELP
20	QMEL	EKORG	T024E	EKORG
21	QMEL	EMATNR	MARA	MATNR		C	CN
22	QMEL	FEART	TQ86	FEART	REF	C	CN
23	QMEL	FERTAUFNR	AUFK	AUFNR
24	QMEL	HERSTELLER	LFA1	LIFNR
25	QMEL	KUNUM	KNA1	KUNNR	REF	C	CN
26	QMEL	LGORTCHARG	T001L	LGORT
27	QMEL	LGORTVORG	T001L	LGORT
28	QMEL	LIFNUM	LFA1	LIFNR
29	QMEL	LS_KDAUF	VBUK	VBELN	REF	C	CN
30	QMEL	LS_KDPOS	VBUP	POSNR
31	QMEL	LS_POSNR	VBUP	POSNR	REF	C	CN
32	QMEL	LS_VBELN	VBUK	VBELN	REF	C	CN
33	QMEL	MANDT	T000	MANDT	KEY	1	CN
34	QMEL	MATKL	T023	MATKL
35	QMEL	MATNR	MARA	MATNR	REF	C	CN
36	QMEL	MAWERK	T001W	WERKS
37	QMEL	MGEIN	T006	MSEHI
38	QMEL	OBJNR	ONR00	OBJNR	REF	C	CN
39	QMEL	OBJNR_REAL	ONR00	OBJNR	REF	C	CN
40	QMEL	OBJNR_STAT	ONR00	OBJNR	REF	C	CN
41	QMEL	PRDHA	T179	PRODH
42	QMEL	PRIOK	T356	PRIOK	REF	C	CN
43	QMEL	PRUEFLOS	QALS	PRUEFLOS
44	QMEL	QMART	TQ80	QMART	REF	C	CN
45	QMEL	QMGRP	QPGR	CODEGRUPPE	REF	C	CN
46	QMEL	QMKAT	TQ15	KATALOGART
47	QMEL	QWRNUM	QMEL	QMNUM
48	QMEL	RBNR	T352B	RBNR	REF	C	CN
49	QMEL	RM_MATNR	MKAL	MATNR
50	QMEL	RM_WERKS	MKAL	WERKS
51	QMEL	SA_AUFNR	SAFK	AUFNR	KEY	C	CN
52	QMEL	SPART	TSPA	SPART
53	QMEL	TEILEV	TQ81V	TEILEV
54	QMEL	TSEGTP	TTSEGTPLH	TEPL	REF	1	CN
55	QMEL	TZONSO	TTZZ	TZONE	REF	1	CN
56	QMEL	VBELN	VBUK	VBELN
57	QMEL	VERID	MKAL	VERID
58	QMEL	VKBUR	TVKBZ	VKBUR	REF	C	CN
59	QMEL	VKGRP	TVBVK	VKGRP	REF	C	CN
60	QMEL	VKORG	TVKO	VKORG
61	QMEL	VTWEG	TVTW	VTWEG
62	QMEL	WAERS	TCURC	WAERS	REF	C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in