SAP ABAP View MGV_QPRS_SEL_N (Physical Samples Using Sample-Drawing for the Inspection Lot)

Hierarchy

☛ ECC-DIMP (Software Component) DIMP
   ⤷ LO-MD-MM (Application Component) Material Master
     ⤷ MGV_MATNR_LAMA (Package) LAMA: Material number conversion (long mat. no.)

Basic Data

View Type	D	Database View
Database View	MGV_QPRS_SEL_N
Short Description	Physical Samples Using Sample-Drawing for the Inspection Lot
Root table	QPRN	Sample drawing of phys. samples

Table

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

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			AND	0	0
5	QPRS	MANDT	JL	EQ				0	0
6	MATERIALID	MANDT	JR	EQ			AND	0	0
7	QPRS	MATNR	JL	EQ				0	0
8	MATERIALID	MATNR_INT	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	OBJNR	QPRS	OBJNR		☐	J_OBJNR	☐	Object number
4	STSMA	QPRS	STSMA		☐	QSTSMA_PRS	☐	Status Profile for Physical Samples
5	PRART	QPRS	PRART		☐	QPRART	☐	Physical-Sample Type
6	PRTYP	QPRS	PRTYP		☐	QPRTYP	☐	Sample Category
7	PN_NR	QPRS	PN_NR		☐	QPZNR	☐	Sample-Drawing Number
8	XMANU	QPRS	XMANU		☐	QPRB_MAN	☐	Manually Created Sample
9	GBTYP	QPRS	GBTYP		☐	QGEBINDET	☐	Physical-Sample Container
10	MENGE	QPRS	MENGE		☐	QPHYSPRUM	☐	Size of the Physical Sample
11	MEINH	QPRS	MEINH		☐	QPHYSPRME	☐	Unit of Measure for Physical Sample Size
12	PLOS2	QPRS	PLOS2		☐	QLOT_LATE	☐	Current or Last Inspection Lot for the Sample
13	MATNR	QPRS	MATNR		☐	MATNR	☐	Material Number
14	WERKS	QPRS	WERKS		☐	WERKS_D	☐	Plant
15	REVLV	QPRS	REVLV		☐	REVLV	☐	Revision level
16	CHARG	QPRS	CHARG		☐	CHARG_D	☐	Batch Number
17	KTEXT	QPRS	KTEXT		☐	QTEXT_PRS	☐	Short Text for Physical Sample
18	QAUTH	QPRS	QAUTH		☐	QMATAUTH	☐	Material authorization group for activities in QM
19	PNVER	QPRS	PNVER		☐	QPRZIEHVER	☐	Sample-Drawing Procedure
20	PNVEV	QPRS	PNVEV		☐	QVERSNPRZV	☐	Version No. of the Sample-Drawing Procedure
21	PNPOS	QPRS	PNPOS		☐	QZAEHLPRZV	☐	Item Number in Sample-Drawing Procedure
22	GEBEH	QPRS	GEBEH		☐	QGEBEH	☐	Lot Container
23	TPBIS	QPRS	TPBIS		☐	QPROBNRBIS	☐	Highest Partial Sample No. Valid for Instruction
24	LGORT	QPRS	LGORT		☐	LGORT_D	☐	Storage location
25	ABORT	QPRS	ABORT		☐	QAUFBEWORT	☐	Storage Location for a Physical Sample
26	ABDAU	QPRS	ABDAU		☐	QAUFBDAUER	☐	Storage Duration of the Physical Sample in Days
27	ABDAT	QPRS	ABDAT		☐	QAUFBDATUM	☐	Storage Deadline for Physical Sample
28	ABINF	QPRS	ABINF		☐	QAUFBINFO	☐	Storage Information for the Physical Sample
29	AENNA	QPRS	AENNA		☐	QPRS_AEN	☐	Last User who Changed the Physical-Sample Record
30	AENDT	QPRS	AENDT		☐	QPRS_AENDT	☐	Date the Physical Sample Was Changed
31	AENZT	QPRS	AENZT		☐	QPRS_AENZT	☐	Time at Which Physical-Sample Record Changed
32	VENUM	QPRS	VENUM		☐	VENUM	☐	Internal Handling Unit Number
33	VEPOS	QPRS	VEPOS		☐	VEPOS	☐	Handling Unit Item
34	MATNR_EXT	MATERIALID	MATNR_EXT		☐	MGV_MATNR_EXTERNAL	☑	Material Number
35	MATNR_VERS	MATERIALID	MATNR_VERS		☐	MGV_MATNR_VERSION	☑	Version Number for MATNR Field

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	20070918
SAP Release Created in	600