SAP ABAP View QALSVE_V1 (Overview data: Inspection lot and usage decision for QMIS)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ QM-QC-IS (Application Component) Information System
     ⤷ QG02 (Package) QM quality information system

Basic Data

View Type	D	Database View
Database View	QALSVE_V1
Short Description	Overview data: Inspection lot and usage decision for QMIS
Root table	QALS	Inspection lot record

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	QALS	QALS
2	QAVE

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	QALS	MANDANT	JL	EQ				0	0
2	QAVE	MANDANT	JR	EQ			AND	0	0
3	QALS	PRUEFLOS	JL	EQ				0	0
4	QAVE	PRUEFLOS	JR	EQ			AND	0	0
5	QAVE	KZART		EQ	'L'		AND	0	0
6	QALS	STAFO	NOT	EQ	' '			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDANT	QALS	MANDANT		☐	MANDT	☐	Client
2	PRUEFLOS	QALS	PRUEFLOS		☐	QPLOS	☐	Inspection Lot Number
3	OBJNR	QALS	OBJNR		☐	J_OBJNR	☐	Object number
4	WERK	QALS	WERK		☐	WERKS_D	☐	Plant
5	STAT02	QALS	STAT02		☐	QKZQALT	☐	Partial Lots Exist
6	ENSTEHDAT	QALS	ENSTEHDAT		☐	QENTST	☐	Date of Lot Creation
7	LOSMENGE	QALS	LOSMENGE		☐	QLOSMENGE	☐	Inspection Lot Quantity
8	MENGENEINH	QALS	MENGENEINH		☐	QLOSMENGEH	☐	Base Unit of Measure for The Inspection Lot Quantity
9	KZSKIPLOT	QALS	KZSKIPLOT		☐	QKZSKIPLOT	☐	Lot Skipped
10	MATNR	QALS	MATNR		☐	MATNR	☐	Material Number
11	CHARG	QALS	CHARG		☐	CHARG_D	☐	Batch Number
12	XCHPF	QALS	XCHPF		☐	XCHPF	☐	Batch management requirement indicator
13	VKATART	QAVE	VKATART		☐	QKATART	☐	Catalog
14	VCODEGRP	QAVE	VCODEGRP		☐	QVGRUPPE	☐	Code Group of the Usage Decision
15	VCODE	QAVE	VCODE		☐	QVCODE	☐	Usage Decision Code
16	QKENNZAHL	QAVE	QKENNZAHL		☐	QKENNZAHL	☐	Quality Score
17	ART	QALS	ART		☐	QPART	☐	Inspection Type
18	HERKUNFT	QALS	HERKUNFT		☐	QHERK	☐	Inspection Lot Origin
19	LIFNR	QALS	LIFNR		☐	ELIFN	☐	Vendor's account number
20	EKORG	QALS	EKORG		☐	EKORG	☐	Purchasing organization
21	KUNNR	QALS	KUNNR		☐	QKUNWE	☐	Customer (Ship-To Party)
22	LS_VKORG	QALS	LS_VKORG		☐	VKORG	☐	Sales Organization
23	VBEWERTUNG	QAVE	VBEWERTUNG		☐	QBEWERTUNG	☐	Code Valuation

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

History

Last changed by/on	SAP	20130529
SAP Release Created in