SAP ABAP Table QALS_QAVE (View of inspection lot with usage decision)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ QM-QC-IS (Application Component) Information System
     ⤷ QG01 (Package) QM quality inspection analysis

Basic Data

Table Category	INTTAB	Structure
Structure	QALS_QAVE	Table Relationship Diagram
Short Description	View of inspection lot with usage decision

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	MANDANT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
2	PRUEFLOS	☐	QPLOS	QPLOS	NUMC	12	0	Inspection Lot Number	*
3	WERK	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
4	ART	☐	QPART	QPART	CHAR	8	0	Inspection Type	TQ30
5	HERKUNFT	☐	QHERK	QHERK	CHAR	2	0	Inspection Lot Origin	*
6	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	ONR00
7	OBTYP	☐	J_OBTYP	J_OBTYP	CHAR	3	0	Object Category	TJ03
8	INSMK	☐	QVINSMK	QKZ	CHAR	1	0	Quantity Is or Was in Inspection Stock
9	STAT11	☐	KZWES	KZWES	CHAR	1	0	GR blocked stock
10	STAT02	☐	QKZQALT	QKZ	CHAR	1	0	Partial Lots Exist
11	STAT06	☐	QKZPRFKOST	QKZ	CHAR	1	0	Record Appraisal Costs in Individual QM Order
12	STAT07	☐	QKZFERTPRF	QKZ	CHAR	1	0	Inspection with Inspection Points
13	STAT13	☐	QPPKTTYP	QPPKTTYP	CHAR	1	0	Inspection Point Type
14	STAT19	☐	QSTAT19	QKZ	CHAR	1	0	Documentation Required for Inspection Lot
15	KZSKIPLOT	☐	QKZSKIPLOT	QKZ	CHAR	1	0	Lot Skipped
16	EIN	☐	QEINZ	QKZ	CHAR	1	0	Serial Number Management Possible
17	ANZSN	☐	ANZSN	INT4	INT4	10	0	Number of serial numbers
18	ENSTEHDAT	☐	QENTST	DATUM	DATS	8	0	Date of Lot Creation
19	ENTSTEZEIT	☐	QENTSTZEIT	QZEIT	TIMS	6	0	Time of Lot Creation
20	ERSTELLER	☐	QERSTELLER	QAENDERER	CHAR	12	0	Name of User Who Created the Data Record
21	ERSTELDAT	☐	QDATUMERST	DATUM	DATS	8	0	Date on Which the Data Record Was Created
22	ERSTELZEIT	☐	QERSTEZEIT	QZEIT	TIMS	6	0	Time of Lot Creation
23	AENDERER	☐	QAENDERER	QAENDERER	CHAR	12	0	Name of User who Most Recently Changed the Data Record
24	AENDERDAT	☐	QDATUMAEND	DATUM	DATS	8	0	Date on Which Data Record Was Changed
25	AENDERZEIT	☐	QAENDEZEIT	QZEIT	TIMS	6	0	Time of Lot Change
26	PASTRTERM	☐	QPRSTART	DATUM	DATS	8	0	Inspection Start Date
27	PASTRZEIT	☐	QSTARTZEIT	QZEIT	TIMS	6	0	Inspection Start Time
28	PAENDTERM	☐	QPRENDE	DATUM	DATS	8	0	End Date of the Inspection
29	PAENDZEIT	☐	QENDEZEIT	QZEIT	TIMS	6	0	Inspection End Time
30	PLNTY	☐	PLNTY	PLNTY	CHAR	1	0	Task List Type	TCA01
31	PLNNR	☐	PLNNR	PLNNR	CHAR	8	0	Key for Task List Group
32	PPLVERW	☐	PLN_VERWE	PLN_VERWE	CHAR	3	0	Task list usage	T411
33	PLNAL	☐	PLNAL	ALTNR	CHAR	2	0	Group Counter
34	ZAEHL	☐	CIM_COUNT	CIM_COUNT	NUMC	8	0	Internal counter
35	ZKRIZ	☐	DZKRIZ	ZKRIZ	NUMC	7	0	Counter for additional criteria
36	ZAEHL1	☐	CIM_COUNT	CIM_COUNT	NUMC	8	0	Internal counter
37	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	AUFK
38	AUFPL	☐	CO_AUFPL	AUFPL	NUMC	10	0	Routing number of operations in the order
39	KUNNR	☐	QKUNWE	KUNNR	CHAR	10	0	Customer (Ship-To Party)	KNA1
40	VERID	☐	VERID	VERID	CHAR	4	0	Production Version	*
41	LIFNR	☐	ELIFN	LIFNR	CHAR	10	0	Vendor's account number	LFA1
42	HERSTELLER	☐	QLIFNR	LIFNR	CHAR	10	0	Number of Manufacturer	LFA1
43	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
44	REVLV	☐	REVLV	REVLV	CHAR	2	0	Revision level
45	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	MCH1
46	LAGORTCHRG	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
47	EKORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	T024E
48	EBELN	☐	EBELN	EBELN	CHAR	10	0	Purchasing Document Number	EKKO
49	EBELP	☐	EBELP	EBELP	NUMC	5	0	Item Number of Purchasing Document	EKPO
50	BLART	☐	BLART	BLART	CHAR	2	0	Document type	T003
51	MJAHR	☐	MJAHR	GJAHR	NUMC	4	0	Year of material document
52	MBLNR	☐	MBLNR	BELNR	CHAR	10	0	Number of Material Document
53	ZEILE	☐	MBLPO	MBLPO	NUMC	4	0	Item in material document
54	WERKVORG	☐	QWERKVORG	WERKS	CHAR	4	0	Plant Where Stock for Inspection Lot Is Held	T001W
55	LAGORTVORG	☐	QLGORTVORG	LGORT	CHAR	4	0	Storage Location for Inspection Lot Stock	T001L
56	LS_KDAUF	☐	KDAUF	VBELN	CHAR	10	0	Sales Order Number	VBUK
57	LS_KDPOS	☐	KDPOS	NUM06	NUMC	6	0	Item number in Sales Order
58	LS_VBELN	☐	VBELN_VL	VBELN	CHAR	10	0	Delivery	VBUK
59	LS_POSNR	☐	POSNR_VL	POSNR	NUMC	6	0	Delivery Item	VBUP
60	LS_ABRVW	☐	QABRVW	ABRVW	CHAR	3	0	Delivery Category	TVLV
61	LS_KUNAG	☐	KUNAG	KUNNR	CHAR	10	0	Sold-to party	KNA1
62	LS_VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
63	LS_KDMAT	☐	KDMAT	IDNEX	CHAR	35	0	Material belonging to the customer
64	SPRACHE	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
65	KTEXTLOS	☐	QKURZTEXT	QKURZTEXT	CHAR	40	0	Short Text
66	KTEXTMAT	☐	QKTEXTOBJ	QKURZTEXT	CHAR	40	0	Short Text for Inspection Object
67	ZUSMKZAEHL	☐	QZUSMKZHL	INT2	INT2	5	0	Number of Characteristics Recorded Additionally
68	OFFENNLZMK	☐	QOFFENLZMK	INT2	INT2	5	0	Number of Outstanding Short-Term Chars Which Require Conf.
69	OFFEN_LZMK	☐	QOFFELZMK	INT2	INT2	5	0	Number of Outstanding Long-Term Chars Which Require Conf.
70	LOSMENGE	☐	QLOSMENGE	QMENGEPLOS	QUAN	13	3	Inspection Lot Quantity
71	MENGENEINH	☐	QLOSMENGEH	MEINS	UNIT	3	0	Base Unit of Measure for The Inspection Lot Quantity	T006
72	ANZGEB	☐	QANZGEB	QGEBPLOS	QUAN	6	3	QM - No. of Containers
73	GEBEH	☐	QGEBEH	MEINS	UNIT	3	0	Lot Container	*
74	GESSTICHPR	☐	QGESTICH	QMENGEPLOS	QUAN	13	3	Sample Size
75	EINHPROBE	☐	QPROBEMGEH	MEINS	UNIT	3	0	Base Unit of Measure for the Sample Unit	T006
76	STPRVER	☐	QSTPRVER	QSTPRVER	CHAR	8	0	Sampling Procedure	*
77	PRBNAVERF	☐	QPRZIEHVER	QPRZIEHVER	CHAR	8	0	Sample-Drawing Procedure	*
78	LMENGE01	☐	QLMENGE01F	QMENGEPLOS	QUAN	13	3	Quantity Posted to Unrestricted-Use Stock
79	LMENGE02	☐	QLMENGE02F	QMENGEPLOS	QUAN	13	3	Quantity Posted to Scrap
80	LMENGE03	☐	QLMENGE03F	QMENGEPLOS	QUAN	13	3	Quantity Posted to Sample
81	LMENGE04	☐	QLMENGE04F	QMENGEPLOS	QUAN	13	3	Quantity Posted to Blocked Stock
82	LMENGE05	☐	QLMENGE05F	QMENGEPLOS	QUAN	13	3	Quantity Posted to Reserves
83	LMENGE06	☐	QLMENGE06F	QMENGEPLOS	QUAN	13	3	Quantity Posted to Another Material
84	MATNRNEU	☐	QMATNRNEU	MATNR	CHAR	18	0	Material Number to Which the Quantity is Posted	MARA
85	CHARGNEU	☐	QCHARGNEU	CHARG	CHAR	10	0	Batch to Which Goods Are Transferred	MCH1
86	LMENGE07	☐	QLMENGE07F	QMENGEPLOS	QUAN	13	3	Quantity Returned to Vendor
87	LMENGE08	☐	QLMENGE08F	QMENGEPLOS	QUAN	13	3	Other Quantity Posted from Inspection Lot Stock
88	LMENGEZUB	☐	QLMENGEZUB	QMENGEPLOS	QUAN	13	3	Quantity That Must Be Posted
89	LMENGELZ	☐	QLMENGELZ	QMENGEPLOS	QUAN	13	3	Sample Quantity for Long-Term Characteristics
90	LMENGEPR	☐	QLMENGEPR	QMENGEPLOS	QUAN	13	3	Quantity Actually Inspected
91	LMENGEZER	☐	QLMENGEZER	QMENGEPLOS	QUAN	13	3	Quantity Destroyed During Inspection
92	LMENGEIST	☐	QLMENGEIST	QMENGEPLOS	QUAN	13	3	Actual Lot Quantity
93	ANTEIL	☐	QAUSANTEIL	QFLTP16	FLTP	16	16	Share of Scrap in Inspection Lot
94	AUFNR_CO	☐	QAUFNR_CO	AUFNR	CHAR	12	0	Order Number for Recording Appraisal Costs	AUFK
95	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	CSKS
96	ANLN1	☐	ANLN1	ANLN1	CHAR	12	0	Main Asset Number	ANLH
97	ANLN2	☐	ANLN2	ANLN2	CHAR	4	0	Asset Subnumber	ANLA
98	PS_PSP_PNR	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	PRPS
99	NPLNR	☐	NPLNR	AUFNR	CHAR	12	0	Network Number for Account Assignment	AUFK
100	APLZL	☐	CIM_COUNT	CIM_COUNT	NUMC	8	0	Internal counter
101	KDAUF	☐	KDAUF	VBELN	CHAR	10	0	Sales Order Number	VBUK
102	KDPOS	☐	KDPOS	NUM06	NUMC	6	0	Item number in Sales Order
103	PAOBJNR	☐	RKEOBJNR	RKEOBJNR	NUMC	10	0	Profitability Segment Number (CO-PA)
104	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	TKA01
105	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
106	VKATART	☐	QKATART	QKATART	CHAR	1	0	Catalog	TQ15
107	VWERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
108	VAUSWAHLMG	☐	QVMENGE	QAUSWAHLMG	CHAR	8	0	Selected Set of the Usage Decision	QPAM
109	VCODEGRP	☐	QVGRUPPE	QCODEGRP	CHAR	8	0	Code Group of the Usage Decision	QPGR
110	VCODE	☐	QVCODE	QCODE	CHAR	4	0	Usage Decision Code	QPCD
111	VBEWERTUNG	☐	QBEWERTUNG	QBEWERTUNG	CHAR	1	0	Code Valuation
112	DBEWERTUNG	☐	QDBEWERT	QBEWERTUNG	CHAR	1	0	Dynamic Modif. Valuation According to Worst Case Principle
113	VFOLGEAKTI	☐	QFOLGEAKTI	QFOLGEAKTI	CHAR	8	0	Follow-Up Action	TQ07
114	QKENNZAHL	☐	QKENNZAHL	QKENNZAHL	DEC	3	0	Quality Score
115	VNAME	☐	QVNAME	QAENDERER	CHAR	12	0	Person who Made the Usage Decision
116	VDATUM	☐	QVEDATUM	DATUM	DATS	8	0	Date of Code Used for Usage Decision
117	VEZEITERF	☐	QVEZEITERF	QZEIT	TIMS	6	0	Time when Usage Decision Was Recorded
118	VAENAME	☐	QVAENAME	QAENDERER	CHAR	12	0	Person who Changed the Usage Decision
119	VAEDATUM	☐	QVAEDATUM	DATUM	DATS	8	0	Change Date of Usage Decision
120	VEZEITAEN	☐	QVEZEITAEN	QZEIT	TIMS	6	0	Time when Usage Decision Changed
121	STTXT	☐	CO_STTXT	CHAR40	CHAR	40	0	System Status
122	USTXT	☐	CO_ASTTX	CHAR40	CHAR	40	0	Field displaying user status

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	QALS_QAVE	ANLN1	ANLH	ANLN1	REF	C	CN
2	QALS_QAVE	ANLN2	ANLA	ANLN2	REF	C	CN
3	QALS_QAVE	ART	TQ30	ART	KEY	1	CN
4	QALS_QAVE	AUFNR	AUFK	AUFNR	REF	C	CN
5	QALS_QAVE	AUFNR_CO	AUFK	AUFNR	REF	C	CN
6	QALS_QAVE	BLART	T003	BLART	REF	C	CN
7	QALS_QAVE	BUKRS	T001	BUKRS	REF	C	CN
8	QALS_QAVE	CHARG	MCH1	CHARG	REF	C	CN
9	QALS_QAVE	CHARGNEU	MCH1	CHARG	REF	C	CN
10	QALS_QAVE	EBELN	EKKO	EBELN	REF	C	CN
11	QALS_QAVE	EBELP	EKPO	EBELP	REF	C	CN
12	QALS_QAVE	EINHPROBE	T006	MSEHI	REF	C	CN
13	QALS_QAVE	EKORG	T024E	EKORG	REF	C	CN
14	QALS_QAVE	HERSTELLER	LFA1	LIFNR	REF	C	CN
15	QALS_QAVE	KDAUF	VBUK	VBELN	REF	C	CN
16	QALS_QAVE	KOKRS	TKA01	KOKRS	REF	C	CN
17	QALS_QAVE	KOSTL	CSKS	KOSTL	REF	C	CN
18	QALS_QAVE	KUNNR	KNA1	KUNNR	REF	C	CN
19	QALS_QAVE	LAGORTCHRG	T001L	LGORT	REF	C	CN
20	QALS_QAVE	LAGORTVORG	T001L	LGORT	REF	C	CN
21	QALS_QAVE	LIFNR	LFA1	LIFNR	REF	C	CN
22	QALS_QAVE	LS_ABRVW	TVLV	ABRVW	REF	C	CN
23	QALS_QAVE	LS_KDAUF	VBUK	VBELN	REF	C	CN
24	QALS_QAVE	LS_KUNAG	KNA1	KUNNR	REF	C	CN
25	QALS_QAVE	LS_POSNR	VBUP	POSNR	REF	C	CN
26	QALS_QAVE	LS_VBELN	VBUK	VBELN	REF	C	CN
27	QALS_QAVE	LS_VKORG	TVKO	VKORG	REF	C	CN
28	QALS_QAVE	MANDANT	T000	MANDT	KEY	1	CN
29	QALS_QAVE	MATNR	MARA	MATNR	REF	C	CN
30	QALS_QAVE	MATNRNEU	MARA	MATNR	REF	C	CN
31	QALS_QAVE	MENGENEINH	T006	MSEHI	REF	C	CN
32	QALS_QAVE	NPLNR	AUFK	AUFNR	REF	C	CN
33	QALS_QAVE	OBJNR	ONR00	OBJNR	KEY	1	C
34	QALS_QAVE	OBTYP	TJ03	OBTYP	KEY	1	CN
35	QALS_QAVE	PLNTY	TCA01	PLNTY	REF	C	CN
36	QALS_QAVE	PPLVERW	T411	VERWE	REF	C	CN
37	QALS_QAVE	PS_PSP_PNR	PRPS	PSPNR	REF	C	CN
38	QALS_QAVE	SPRACHE	T002	SPRAS	REF	C	CN
39	QALS_QAVE	VAUSWAHLMG	QPAM	AUSWAHLMGE	REF	1	CN
40	QALS_QAVE	VCODE	QPCD	CODE	REF	1	CN
41	QALS_QAVE	VCODEGRP	QPGR	CODEGRUPPE	REF	1	CN
42	QALS_QAVE	VFOLGEAKTI	TQ07	FOLGEAKTI	REF	C	CN
43	QALS_QAVE	VKATART	TQ15	KATALOGART	REF	1	N
44	QALS_QAVE	VWERKS	T001W	WERKS	REF	1	N
45	QALS_QAVE	WERK	T001W	WERKS	KEY	1	CN
46	QALS_QAVE	WERKVORG	T001W	WERKS	REF	C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in