SAP ABAP View QPRS_SEL_P (Physical Samples for the Insp. Lot/Operation with Valuation)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ QM-IM-SM (Application Component) Sample Management
     ⤷ QPR (Package) QM sample management

Basic Data

View Type	D	Database View
Database View	QPRS_SEL_P
Short Description	Physical Samples for the Insp. Lot/Operation with Valuation
Root table	QPRS	Master record for phys. samples

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	QPRS	QPRS
2	QAPP
3	AFVC
4	QALS

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	QPRS	PLOS2	JL	EQ				0	0
2	QAPP	PRUEFLOS	JR	EQ			AND	0	0
3	QPRS	PHYNR	JL	EQ				0	0
4	QAPP	PHYNR	JR	EQ			AND	0	0
5	QPRS	MANDT	JL	EQ				0	0
6	QAPP	MANDT	JR	EQ			AND	0	0
7	QAPP	VORGLFNR	JL	EQ				0	0
8	AFVC	APLZL	JR	EQ			AND	0	0
9	QAPP	MANDT	JL	EQ				0	0
10	AFVC	MANDT	JR	EQ			AND	0	0
11	QAPP	PRUEFLOS	JL	EQ				0	0
12	QALS	PRUEFLOS	JR	EQ			AND	0	0
13	QALS	AUFPL	JL	EQ				0	0
14	AFVC	AUFPL	JR	EQ			AND	0	0
15	QALS	MANDANT	JL	EQ				0	0
16	QAPP	MANDT	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	QPRS	MANDT		☐	MANDT	☐	Client
2	PHYNR	QPRS	PHYNR		☐	QPHYSPRNR	☐	Physical Sample Number
3	PRTYP	QPRS	PRTYP		☐	QPRTYP	☐	Sample Category
4	PRUEFLOS	QAPP	PRUEFLOS		☐	QPLOS	☐	Inspection Lot Number
5	VORGLFNR	QAPP	VORGLFNR		☐	QLFNKN	☐	Current Node Number from Order Counter APLZL
6	VORNR	AFVC	VORNR		☐	VORNR	☐	Operation/Activity Number
7	PROBENR	QAPP	PROBENR		☐	QPROBENRPP	☐	Sample Number (Based on an Inspection Point)
8	PPSORTKEY	QAPP	PPSORTKEY		☐	QPPSORTKEY	☐	Key Field (Sort Field) for Inspection Point
9	VBEWERTUNG	QAPP	VBEWERTUNG		☐	QBEWERTUNG	☐	Code Valuation
10	AENDERDAT	QAPP	AENDERDAT		☐	AEDAT	☐	Last Changed On
11	AENDERZEIT	QAPP	AENDERZEIT		☐	QZEITAEND	☐	Time at which data record was last changed
12	USERC1	QAPP	USERC1		☐	QUSRCHAR18	☐	User Field for 18 Characters
13	USERC2	QAPP	USERC2		☐	QUSRCHAR10	☐	User Field for 10 Characters
14	USERN1	QAPP	USERN1		☐	QUSRNUMC10	☐	User Field for 10 Digits
15	USERN2	QAPP	USERN2		☐	QUSRNUMC3	☐	User Field for 3 Digits
16	USERD1	QAPP	USERD1		☐	QUSRDATS	☐	User Field for Date
17	USERT1	QAPP	USERT1		☐	QUSRTIMS	☐	User Field for Time

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