SAP ABAP View QPRS_SEL_Q (Selection of Samples for Phys.-Sample Drawing/Notification)

Hierarchy

☛ EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
   ⤷ QM-IM (Application Component) Quality Inspection
     ⤷ QSTABI (Package) Stability Study

Basic Data

View Type	D	Database View
Database View	QPRS_SEL_Q
Short Description	Selection of Samples for Phys.-Sample Drawing/Notification
Root table	QPRS	Master record for phys. samples

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	QPRS	QPRS
2	QPRN

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	QPRN	MANDT	JL	EQ				0	0
2	QPRS	MANDT	JR	EQ			AND	0	0
3	QPRN	PN_NR	JL	EQ				0	0
4	QPRS	PN_NR	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	QPRN	MANDT		☐	MANDT	☐	Client
2	PN_NR	QPRN	PN_NR		☐	QPZNR	☐	Sample-Drawing Number
3	QMNUM	QPRN	QMNUM		☐	QMNUM	☐	Message Number
4	PHYNR	QPRS	PHYNR		☐	QPHYSPRNR	☐	Physical Sample Number
5	PRART	QPRS	PRART		☐	QPRART	☐	Physical-Sample Type
6	PRTYP	QPRS	PRTYP		☐	QPRTYP	☐	Sample Category
7	GBTYP	QPRS	GBTYP		☐	QGEBINDET	☐	Physical-Sample Container
8	MENGE	QPRS	MENGE		☐	QPHYSPRUM	☐	Size of the Physical Sample
9	MEINH	QPRS	MEINH		☐	QPHYSPRME	☐	Unit of Measure for Physical Sample Size
10	MATNR	QPRS	MATNR		☐	MATNR	☐	Material Number
11	WERKS	QPRS	WERKS		☐	WERKS_D	☐	Plant
12	REVLV	QPRS	REVLV		☐	REVLV	☐	Revision level
13	CHARG	QPRS	CHARG		☐	CHARG_D	☐	Batch Number
14	KTEXT	QPRS	KTEXT		☐	QTEXT_PRS	☐	Short Text for Physical Sample
15	LGORT	QPRS	LGORT		☐	LGORT_D	☐	Storage location
16	ABORT	QPRS	ABORT		☐	QAUFBEWORT	☐	Storage Location for a Physical Sample
17	ABDAU	QPRS	ABDAU		☐	QAUFBDAUER	☐	Storage Duration of the Physical Sample in Days
18	ABDAT	QPRS	ABDAT		☐	QAUFBDATUM	☐	Storage Deadline for Physical Sample
19	ABINF	QPRS	ABINF		☐	QAUFBINFO	☐	Storage Information for the Physical Sample
20	PRIMPACK	QPRS	PRIMPACK		☐	QPRIMPACK	☐	Primary Packaging (Stability Study)
21	STABICON	QPRS	STABICON		☐	QSTABICON	☐	Storage Condition
22	EINGDT	QPRS	EINGDT		☐	QST_EINGDT	☐	Date of Receipt of Initial Sample for Stability Study
23	EINLDT	QPRS	EINLDT		☐	QST_EINLDT	☐	Storage Date of Sample for Storage Condition
24	AUSLDT	QPRS	AUSLDT		☐	QST_AUSLDT	☐	Date of Removal from Storage of Sample for Storage Condition

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	20050411
SAP Release Created in	110