SAP ABAP Table QPRS_SEL_N (Generated Table for View QPRS_SEL_N)

Basic Data

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

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	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	ONR00
4	STSMA	☐	QSTSMA_PRS	J_STSMA	CHAR	8	0	Status Profile for Physical Samples	TJ20
5	PRART	☐	QPRART	QPRART	CHAR	2	0	Physical-Sample Type	TQ40
6	PRTYP	☐	QPRTYP	QPRTYP	CHAR	1	0	Sample Category	TQ44
7	PN_NR	☐	QPZNR	NUMC12	NUMC	12	0	Sample-Drawing Number	QPRN
8	XMANU	☐	QPRB_MAN	QKZ	CHAR	1	0	Manually Created Sample
9	GBTYP	☐	QGEBINDET	QGEBINDET	CHAR	6	0	Physical-Sample Container	TQ42
10	MENGE	☐	QPHYSPRUM	QMENGEPLOS	QUAN	13	3	Size of the Physical Sample
11	MEINH	☐	QPHYSPRME	MEINS	UNIT	3	0	Unit of Measure for Physical Sample Size	T006
12	PLOS2	☐	QLOT_LATE	QPLOS	NUMC	12	0	Current or Last Inspection Lot for the Sample	QALS
13	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
14	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
15	REVLV	☐	REVLV	REVLV	CHAR	2	0	Revision level
16	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	MCH1
17	KTEXT	☐	QTEXT_PRS	TEXT80	CHAR	80	0	Short Text for Physical Sample
18	QAUTH	☐	QMATAUTH	QMATAUTH	CHAR	6	0	Material authorization group for activities in QM	TQ01B
19	PNVER	☐	QPRZIEHVER	QPRZIEHVER	CHAR	8	0	Sample-Drawing Procedure	QPRVK
20	PNVEV	☐	QVERSNPRZV	QVERSNR	CHAR	6	0	Version No. of the Sample-Drawing Procedure	QPRVK
21	PNPOS	☐	QZAEHLPRZV	NUM4	NUMC	4	0	Item Number in Sample-Drawing Procedure
22	GEBEH	☐	QGEBEH	MEINS	UNIT	3	0	Lot Container	T006
23	TPBIS	☐	QPROBNRBIS	QPROBEPL	NUMC	3	0	Highest Partial Sample No. Valid for Instruction
24	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
25	ABORT	☐	QAUFBEWORT	QAUFBEWORT	CHAR	12	0	Storage Location for a Physical Sample	TQ41
26	ABDAU	☐	QAUFBDAUER	DEC5	DEC	5	0	Storage Duration of the Physical Sample in Days
27	ABDAT	☐	QAUFBDATUM	DATUM	DATS	8	0	Storage Deadline for Physical Sample
28	ABINF	☐	QAUFBINFO	TEXT80	CHAR	80	0	Storage Information for the Physical Sample
29	AENNA	☐	QPRS_AEN	QAENDERER	CHAR	12	0	Last User who Changed the Physical-Sample Record
30	AENDT	☐	QPRS_AENDT	DATUM	DATS	8	0	Date the Physical Sample Was Changed
31	AENZT	☐	QPRS_AENZT	QZEIT	TIMS	6	0	Time at Which Physical-Sample Record Changed
32	VENUM	☐	VENUM	VENUM	CHAR	10	0	Internal Handling Unit Number
33	VEPOS	☐	VEPOS	VEPOS	NUMC	6	0	Handling Unit Item

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	QPRS_SEL_N	ABORT	TQ41	AUFBEWORT	KEY	C	CN
2	QPRS_SEL_N	CHARG	MCH1	CHARG	REF	C	CN
3	QPRS_SEL_N	GBTYP	TQ42	GEBINDETYP
4	QPRS_SEL_N	GEBEH	T006	MSEHI
5	QPRS_SEL_N	LGORT	T001L	LGORT	REF	C	CN
6	QPRS_SEL_N	MANDT	T000	MANDT	KEY	1	CN
7	QPRS_SEL_N	MATNR	MARA	MATNR	REF	C	CN
8	QPRS_SEL_N	MEINH	T006	MSEHI
9	QPRS_SEL_N	OBJNR	ONR00	OBJNR	KEY	1	C
10	QPRS_SEL_N	PLOS2	QALS	PRUEFLOS
11	QPRS_SEL_N	PNVER	QPRVK	PRZIEHVERF
12	QPRS_SEL_N	PNVEV	QPRVK	VERSION
13	QPRS_SEL_N	PN_NR	QPRN	PN_NR	REF	1	CN
14	QPRS_SEL_N	PRART	TQ40	PRART	KEY	1	CN
15	QPRS_SEL_N	PRTYP	TQ44	PRTYP	REF	1	CN
16	QPRS_SEL_N	QAUTH	TQ01B	QMATAUTH	REF	C	CN
17	QPRS_SEL_N	STSMA	TJ20	STSMA	REF	C	CN
18	QPRS_SEL_N	WERKS	T001W	WERKS	KEY	1	CN

History

Last changed by/on	SAP	20050411
SAP Release Created in