SAP ABAP Table MGV_QPRS_SEL_L (Generated Table for View MGV_QPRS_SEL_L)

Basic Data

Table Category	VIEW	General view structure
General view structure	MGV_QPRS_SEL_L	Table Relationship Diagram
Short Description	Generated Table for View MGV_QPRS_SEL_L

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	PHYNR	☑	QPHYSPRNR	QPHYSPRNR	CHAR	12	0	Physical Sample Number	*
3	PRART	☐	QPRART	QPRART	CHAR	2	0	Physical-Sample Type	TQ40
4	PRTYP	☐	QPRTYP	QPRTYP	CHAR	1	0	Sample Category	TQ44
5	XMANU	☐	QPRB_MAN	QKZ	CHAR	1	0	Manually Created Sample
6	PLOS2	☐	QLOT_LATE	QPLOS	NUMC	12	0	Current or Last Inspection Lot for the Sample	QALS
7	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
8	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
9	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	MCH1
10	AENDT	☐	QPRS_AENDT	DATUM	DATS	8	0	Date the Physical Sample Was Changed
11	AENNA	☐	QPRS_AEN	QAENDERER	CHAR	12	0	Last User who Changed the Physical-Sample Record
12	GBTYP	☐	QGEBINDET	QGEBINDET	CHAR	6	0	Physical-Sample Container	TQ42
13	MENGE	☐	QPHYSPRUM	QMENGEPLOS	QUAN	13	3	Size of the Physical Sample
14	MEINH	☐	QPHYSPRME	MEINS	UNIT	3	0	Unit of Measure for Physical Sample Size	T006
15	MATNR_EXT	☐	MGV_MATNR_EXTERNAL	MATNR_EXT	CHAR	40	0	Material Number
16	MATNR_VERS	☐	MGV_MATNR_VERSION	MATNR_VERS	CHAR	10	0	Version Number for MATNR Field

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	MGV_QPRS_SEL_L	CHARG	MCH1	CHARG	REF	C	CN
2	MGV_QPRS_SEL_L	GBTYP	TQ42	GEBINDETYP
3	MGV_QPRS_SEL_L	MANDT	T000	MANDT	KEY	1	CN
4	MGV_QPRS_SEL_L	MATNR	MARA	MATNR	REF	C	CN
5	MGV_QPRS_SEL_L	MEINH	T006	MSEHI
6	MGV_QPRS_SEL_L	PLOS2	QALS	PRUEFLOS
7	MGV_QPRS_SEL_L	PRART	TQ40	PRART	KEY	1	CN
8	MGV_QPRS_SEL_L	PRTYP	TQ44	PRTYP	REF	1	CN
9	MGV_QPRS_SEL_L	WERKS	T001W	WERKS	KEY	1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in