SAP ABAP Table QPRS_SEL_Q (Generated Table for View QPRS_SEL_Q)

Basic Data

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

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	PN_NR	☑	QPZNR	NUMC12	NUMC	12	0	Sample-Drawing Number
3	QMNUM	☑	QMNUM	QMNUM	CHAR	12	0	Message Number	QMEL
4	PHYNR	☑	QPHYSPRNR	QPHYSPRNR	CHAR	12	0	Physical Sample Number
5	PRART	☐	QPRART	QPRART	CHAR	2	0	Physical-Sample Type	TQ40
6	PRTYP	☐	QPRTYP	QPRTYP	CHAR	1	0	Sample Category	TQ44
7	GBTYP	☐	QGEBINDET	QGEBINDET	CHAR	6	0	Physical-Sample Container	TQ42
8	MENGE	☐	QPHYSPRUM	QMENGEPLOS	QUAN	13	3	Size of the Physical Sample
9	MEINH	☐	QPHYSPRME	MEINS	UNIT	3	0	Unit of Measure for Physical Sample Size	T006
10	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
11	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
12	REVLV	☐	REVLV	REVLV	CHAR	2	0	Revision level
13	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	MCH1
14	KTEXT	☐	QTEXT_PRS	TEXT80	CHAR	80	0	Short Text for Physical Sample
15	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
16	ABORT	☐	QAUFBEWORT	QAUFBEWORT	CHAR	12	0	Storage Location for a Physical Sample	TQ41
17	ABDAU	☐	QAUFBDAUER	DEC5	DEC	5	0	Storage Duration of the Physical Sample in Days
18	ABDAT	☐	QAUFBDATUM	DATUM	DATS	8	0	Storage Deadline for Physical Sample
19	ABINF	☐	QAUFBINFO	TEXT80	CHAR	80	0	Storage Information for the Physical Sample
20	PRIMPACK	☐	QPRIMPACK	QPRIMPACK	CHAR	8	0	Primary Packaging (Stability Study)	TQ45
21	STABICON	☐	QSTABICON	QSTABICON	CHAR	8	0	Storage Condition	TQ43
22	EINGDT	☐	QST_EINGDT	DATUM	DATS	8	0	Date of Receipt of Initial Sample for Stability Study
23	EINLDT	☐	QST_EINLDT	DATUM	DATS	8	0	Storage Date of Sample for Storage Condition
24	AUSLDT	☐	QST_AUSLDT	DATUM	DATS	8	0	Date of Removal from Storage of Sample for Storage Condition

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	QPRS_SEL_Q	ABORT	TQ41	AUFBEWORT	KEY	C	CN
2	QPRS_SEL_Q	CHARG	MCH1	CHARG	REF	C	CN
3	QPRS_SEL_Q	GBTYP	TQ42	GEBINDETYP
4	QPRS_SEL_Q	LGORT	T001L	LGORT	REF	C	CN
5	QPRS_SEL_Q	MANDT	T000	MANDT	KEY	1	CN
6	QPRS_SEL_Q	MATNR	MARA	MATNR	REF	C	CN
7	QPRS_SEL_Q	MEINH	T006	MSEHI
8	QPRS_SEL_Q	PRART	TQ40	PRART	KEY	1	CN
9	QPRS_SEL_Q	PRIMPACK	TQ45	PRIMPACK	REF	1	CN
10	QPRS_SEL_Q	PRTYP	TQ44	PRTYP	REF	1	CN
11	QPRS_SEL_Q	QMNUM	QMEL	QMNUM	REF	C	CN
12	QPRS_SEL_Q	STABICON	TQ43	STABICON	REF	1	CN
13	QPRS_SEL_Q	WERKS	T001W	WERKS	KEY	1	CN

History

Last changed by/on	SAP	20050411
SAP Release Created in