SAP ABAP View BIW_QALS_2 (QM-BW Inspection Lot Extraction View)

Hierarchy

☛ EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
   ⤷ QM (Application Component) Quality Management
     ⤷ QMBW (Package) QM: BW Extraction

Basic Data

View Type	D	Database View
Database View	BIW_QALS_2
Short Description	QM-BW Inspection Lot Extraction View
Root table	QALS	Inspection lot record

Table

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

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	QALS	MANDANT		☐	MANDT	☐	Client
2	PRUEFLOS	QALS	PRUEFLOS		☐	QPLOS	☐	Inspection Lot Number
3	ENSTEHDAT	QALS	ENSTEHDAT		☐	QENTST	☐	Date of Lot Creation
4	ART	QALS	ART		☐	QPART	☐	Inspection Type
5	WERK	QALS	WERK		☐	WERKS_D	☐	Plant
6	MATNR	QALS	MATNR		☐	MATNR	☐	Material Number
7	EKORG	QALS	EKORG		☐	EKORG	☐	Purchasing organization
8	LIFNR	QALS	LIFNR		☐	ELIFN	☐	Vendor's account number
9	LS_VKORG	QALS	LS_VKORG		☐	VKORG	☐	Sales Organization
10	KUNNR	QALS	KUNNR		☐	QKUNWE	☐	Customer (Ship-To Party)
11	LS_KUNAG	QALS	LS_KUNAG		☐	KUNAG	☐	Sold-to party
12	LS_KDAUF	QALS	LS_KDAUF		☐	KDAUF	☐	Sales Order Number
13	AUFNR	QALS	AUFNR		☐	AUFNR	☐	Order Number
14	LAGORTVORG	QALS	LAGORTVORG		☐	QLGORTVORG	☐	Storage Location for Inspection Lot Stock
15	AUFNR_CO	QALS	AUFNR_CO		☐	QAUFNR_CO	☐	Order Number for Recording Appraisal Costs
16	OBJNR	QALS	OBJNR		☐	J_OBJNR	☐	Object number
17	HERKUNFT	QALS	HERKUNFT		☐	QHERK	☐	Inspection Lot Origin

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	200