SAP ABAP Table VQQMELST_L (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	VQQMELST_L	Table Relationship Diagram
Short Description	Generated Table for View

Delivery and Maintenance

Pool/cluster
Delivery Class
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	OBJNR	☑	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	ONR00
3	STAT	☑	J_STATUS	J_STATUS	CHAR	5	0	Object status
4	QMNUM	☑	QMNUM	QMNUM	CHAR	12	0	Message Number
5	QMART	☐	QMART	QMART	CHAR	2	0	Message Type	TQ80
6	QMTXT	☐	QMTXT	TEXT40	CHAR	40	0	Short Text
7	PRIOK	☐	PRIOK	PRIOK	CHAR	1	0	Priority	T356
8	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
9	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
10	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
11	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
12	MZEIT	☐	MZEIT	UHRZT	TIMS	6	0	Notification Time
13	QMDAT	☐	QMDAT	DATUM	DATS	8	0	Date of Notification
14	QMNAM	☐	QMNAM	USNAM	CHAR	12	0	Name of declarant
15	STRMN	☐	STRMN	DATUM	DATS	8	0	Desired Start Date
16	STRUR	☐	STRUR	UZEIT	TIMS	6	0	Desired Start Time
17	LTRMN	☐	LTRMN	DATUM	DATS	8	0	Required Finish Date
18	LTRUR	☐	LTRUR	UZEIT	TIMS	6	0	Required End Date-Time
19	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
20	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
21	REVLV	☐	REVLV	REVLV	CHAR	2	0	Revision level
22	KUNUM	☐	QKUNUM	KUNNR	CHAR	10	0	Account Number of Customer	KNA1
23	QMDAB	☐	QMDAB	DATUM	DATS	8	0	Date for Completion of Notification
24	QMZAB	☐	QMZAB	UZEIT	TIMS	6	0	Completion Time of Notification
25	RBNR	☐	RBNR	RBNR	CHAR	9	0	Report layout	T352B
26	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	AUFK
27	VERID	☐	VERID	VERID	CHAR	4	0	Production Version	MKAL
28	RM_MATNR	☐	RM_MATNR	MATNR	CHAR	18	0	Material number of the production version	MKAL
29	RM_WERKS	☐	RM_WERKS	WERKS	CHAR	4	0	Plant of production version	MKAL
30	SA_AUFNR	☐	SA_AUFNR	SA_AUFNR	CHAR	12	0	Run schedule header number	SAFK
31	ARTPR	☐	ARTPR	ARTPR	CHAR	2	0	Priority Type	T356A
32	FEKNZ	☐	FEKNZ	CHAR1	CHAR	1	0	Error Records Exist
33	MAKNZ	☐	MAKNZ	CHAR1	CHAR	1	0	Task Records Exist
34	RBNRI	☐	RBNRI	RBNRI	CHAR	1	0	Origin of Notifications Catalog Profile
35	INDTX	☐	INDLTX	CHAR1	CHAR	1	0	Object Long Text Available
36	KZMLA	☐	KZMLA	CHAR1	CHAR	1	0	Primary language indicator for text segment
37	HERKZ	☐	HERKZ	HERKZ	CHAR	2	0	Origin Indicator for Notification
38	BEZDT	☐	BEZDT	DATUM	DATS	8	0	Notification Reference Date
39	BEZUR	☐	BEZUR_D	UZEIT	TIMS	6	0	Notification Reference Time
40	LIFNUM	☐	LIFNUM	LIFNR	CHAR	10	0	Vendor Account Number	LFA1
41	BUNAME	☐	BUNAME	XUBNAME	CHAR	12	0	Author of a Q/PM Notification
42	VBELN	☐	KDAUF	VBELN	CHAR	10	0	Sales Order Number	VBUK
43	BSTNK	☐	BSTKD	BSTKD	CHAR	35	0	Customer purchase order number
44	BSTDK	☐	BSTDK	DATUM	DATS	8	0	Customer purchase order date
45	SPART	☐	SPART	SPART	CHAR	2	0	Division	TSPA
46	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
47	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
48	ADRNR	☐	CADNR	CADRNR	CHAR	10	0	Addresses: Address Number
49	KZLOESCH	☐	KZLOESCH	CHAR1	CHAR	1	0	Delete Data Record
50	QMKAT	☐	QMKAT	QKATART	CHAR	1	0	Catalog type - coding	TQ15
51	QMGRP	☐	QMGRP	QCODEGRP	CHAR	8	0	Code group - coding	QPGR
52	QMCOD	☐	QMCOD	QCODE	CHAR	4	0	Coding
53	AEZEIT	☐	AEZEIT	UHRZT	TIMS	6	0	Time of Change
54	ERZEIT	☐	ERZEIT	UHRZT	TIMS	6	0	Time, at Which Record Was Added
55	MAWERK	☐	QMAWERKS	WERKS	CHAR	4	0	Plant for Material	T001W
56	PRUEFLOS	☐	QPLOS	QPLOS	NUMC	12	0	Inspection Lot Number	QALS
57	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	MCH1
58	LGORTCHARG	☐	QLGORTCHAR	LGORT	CHAR	4	0	Storage Location of Batch	T001L
59	LICHN	☐	LICHN	LICHN	CHAR	15	0	Vendor Batch Number
60	HERSTELLER	☐	QLIFNR	LIFNR	CHAR	10	0	Number of Manufacturer	LFA1
61	EKORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	T024E
62	LGORTVORG	☐	QLGORTVORG	LGORT	CHAR	4	0	Storage Location for Inspection Lot Stock	T001L
63	FERTAUFNR	☐	FERTAUFNR	AUFNR	CHAR	12	0	Order Number (Production Order)	AUFK
64	FERTAUFPL	☐	FERTAUFPL	AUFPL	NUMC	10	0	Plan Number for Operations in Order (Production Order)
65	ARBPL	☐	LGWID	CR_OBJID	NUMC	8	0	Object ID of the Work Center	CRID
66	ARBPLWERK	☐	QARBPWERKS	WERKS	CHAR	4	0	Plant for Work Center	T001W
67	FEART	☐	QFEART	QFEART	CHAR	8	0	Report Type for Defects Recording	TQ86
68	PNLKN	☐	QLFNKN	KNTNR	NUMC	8	0	Current Node Number from Order Counter APLZL
69	MGEIG	☐	MGEIG	MENGE	QUAN	13	3	Defective Quantity (Internal)
70	MGFRD	☐	MGFRD	MENGE	QUAN	13	3	Defective Quantity (External)
71	MGEIN	☐	MGEIN	MEINS	UNIT	3	0	Unit of Measure	T006
72	RKMNG	☐	RKMNG	MENGE	QUAN	13	3	Complaint Quantity
73	RGMNG	☐	RGMNG	MENGE	QUAN	13	3	Return Delivery Quantity
74	RKDAT	☐	RKDAT	DATUM	DATS	8	0	Date of Return Delivery
75	COAUFNR	☐	COAUFNR	AUFNR	CHAR	12	0	Order Number (QM Order)	AUFK
76	SERIALNR	☐	GERNR	GERNR	CHAR	18	0	Serial Number
77	EBELN	☐	EBELN	EBELN	CHAR	10	0	Purchasing Document Number	EKKO
78	EBELP	☐	QEBELP	EBELP	NUMC	5	0	Item Number of Purchasing Document	EKPO
79	MJAHR	☐	MJAHR	GJAHR	NUMC	4	0	Year of material document
80	MBLNR	☐	MBLNR	BELNR	CHAR	10	0	Number of Material Document
81	MBLPO	☐	QMBLPO	MBLPO	NUMC	4	0	Item in Material Document
82	LS_KDAUF	☐	KDAUF	VBELN	CHAR	10	0	Sales Order Number	VBUK
83	LS_KDPOS	☐	POSNR	POSNR	NUMC	6	0	Item number of the SD document	VBUP
84	LS_VBELN	☐	VBELN_VL	VBELN	CHAR	10	0	Delivery	VBUK
85	LS_POSNR	☐	QPOSNR_VL	POSNR	NUMC	6	0	Delivery Item	VBUP
86	CROBJTY	☐	CR_OBJTY	CR_OBJTY	CHAR	2	0	Object types of the CIM resource

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VQQMELST_L	ARBPL	CRID	OBJID	REF	C	CN
2	VQQMELST_L	ARBPLWERK	T001W	WERKS
3	VQQMELST_L	ARTPR	T356A	ARTPR	REF	C	CN
4	VQQMELST_L	AUFNR	AUFK	AUFNR	REF	C	CN
5	VQQMELST_L	CHARG	MCH1	CHARG
6	VQQMELST_L	COAUFNR	AUFK	AUFNR
7	VQQMELST_L	EBELN	EKKO	EBELN	REF	C	CN
8	VQQMELST_L	EBELP	EKPO	EBELP
9	VQQMELST_L	EKORG	T024E	EKORG
10	VQQMELST_L	FEART	TQ86	FEART	REF	C	CN
11	VQQMELST_L	FERTAUFNR	AUFK	AUFNR
12	VQQMELST_L	HERSTELLER	LFA1	LIFNR
13	VQQMELST_L	KUNUM	KNA1	KUNNR	REF	C	CN
14	VQQMELST_L	LGORTCHARG	T001L	LGORT
15	VQQMELST_L	LGORTVORG	T001L	LGORT
16	VQQMELST_L	LIFNUM	LFA1	LIFNR
17	VQQMELST_L	LS_KDAUF	VBUK	VBELN	REF	C	CN
18	VQQMELST_L	LS_KDPOS	VBUP	POSNR
19	VQQMELST_L	LS_POSNR	VBUP	POSNR	REF	C	CN
20	VQQMELST_L	LS_VBELN	VBUK	VBELN	REF	C	CN
21	VQQMELST_L	MANDT	T000	MANDT	KEY	1	CN
22	VQQMELST_L	MATNR	MARA	MATNR	REF	C	CN
23	VQQMELST_L	MAWERK	T001W	WERKS
24	VQQMELST_L	MGEIN	T006	MSEHI
25	VQQMELST_L	OBJNR	ONR00	OBJNR	KEY	1	CN
26	VQQMELST_L	PRIOK	T356	PRIOK	REF	C	CN
27	VQQMELST_L	PRUEFLOS	QALS	PRUEFLOS
28	VQQMELST_L	QMART	TQ80	QMART	REF	C	CN
29	VQQMELST_L	QMGRP	QPGR	CODEGRUPPE	REF	C	CN
30	VQQMELST_L	QMKAT	TQ15	KATALOGART
31	VQQMELST_L	RBNR	T352B	RBNR	REF	C	CN
32	VQQMELST_L	RM_MATNR	MKAL	MATNR
33	VQQMELST_L	RM_WERKS	MKAL	WERKS
34	VQQMELST_L	SA_AUFNR	SAFK	AUFNR	KEY	C	CN
35	VQQMELST_L	SPART	TSPA	SPART
36	VQQMELST_L	VBELN	VBUK	VBELN
37	VQQMELST_L	VERID	MKAL	VERID
38	VQQMELST_L	VKORG	TVKO	VKORG
39	VQQMELST_L	VTWEG	TVTW	VTWEG
40	VQQMELST_L	WAERS	TCURC	WAERS	REF	C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in