SAP ABAP View MGV_QPRS (Matnr_Ext, copy Tab QPRS)

Hierarchy

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

Basic Data

View Type	D	Database View
Database View	MGV_QPRS
Short Description	Matnr_Ext, copy Tab QPRS
Root table	QPRS	Master record for phys. samples

Table

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

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	QPRS	MANDT	JL	EQ				0	0
2	MATERIALID	MANDT	JR	EQ			AND	0	0
3	QPRS	MATNR	JL	EQ				0	0
4	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	ADDON_DUMMY	QPRS	ADDON_DUMMY		☐	QDUMMY	☐	Dummy Field for ADDON Structures in QM
35	PRIMPACK	QPRS	PRIMPACK		☐	QPRIMPACK	☐	Primary Packaging (Stability Study)
36	STABICON	QPRS	STABICON		☐	QSTABICON	☐	Storage Condition
37	EINGDT	QPRS	EINGDT		☐	QST_EINGDT	☐	Date of Receipt of Initial Sample for Stability Study
38	EINLDT	QPRS	EINLDT		☐	QST_EINLDT	☐	Storage Date of Sample for Storage Condition
39	AUSLDT	QPRS	AUSLDT		☐	QST_AUSLDT	☐	Date of Removal from Storage of Sample for Storage Condition
40	ENTORT	QPRS	ENTORT		☐	QPRSENTORT	☐	Location of Sample Drawing (Functional Location)
41	INFEORT	QPRS	INFEORT		☐	QPRSINFEORT	☐	Description of Sample-Drawing Location
42	ENTDATUM	QPRS	ENTDATUM		☐	QPRSENTDATUM	☐	Date of Sample Drawing
43	ENTZEIT	QPRS	ENTZEIT		☐	QPRSENTZEIT	☐	Time of Sample Drawing
44	BEARBEITER	QPRS	BEARBEITER		☐	QPRSBEARBEITER	☐	Processor Responsible for the Sample, Sample Taker
45	LABOR	QPRS	LABOR		☐	QLABOR	☐	Work Center (Laboratory)
46	MATNR_EXT	MATERIALID	MATNR_EXT		☐	MATNR_EXT	☐	External Long Material Number
47	MATNR_VERS	MATERIALID	MATNR_VERS		☐	MATNR_VERS	☐	Material Version Number

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	46C