SAP ABAP Table RQPRS (Screen fields for processing the sample master record)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ QM-IM-SM (Application Component) Sample Management
     ⤷ QPR (Package) QM sample management

Basic Data

Table Category	INTTAB	Structure
Structure	RQPRS	Table Relationship Diagram
Short Description	Screen fields for processing the sample master record

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	PHYNR	☐	QPHYSPRNR	QPHYSPRNR	CHAR	12	0	Physical Sample Number	QPRS
2	STATU	☐	QPRSSTATUS	CHAR40	CHAR	40	0	Internal Status of Physical-Sample Record
3	ANWKZ	☐	CO_ASTEX	KREUZ	CHAR	1	0	User status active
4	ANWST	☐	QPRS_ANWST	CHAR40	CHAR	40	0	User Status of the Physical-Sample Record
5	PRART	☐	QPRART	QPRART	CHAR	2	0	Physical-Sample Type	TQ40
6	PRTYP	☐	QPRTYP	QPRTYP	CHAR	1	0	Sample Category	TQ44
7	KTEXT	☐	QTEXT_PRS	TEXT80	CHAR	80	0	Short Text for Physical Sample
8	PLOS2	☐	QLOT_LATE	QPLOS	NUMC	12	0	Current or Last Inspection Lot for the Sample	QALS
9	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
10	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
11	REVLV	☐	REVLV	REVLV	CHAR	2	0	Revision level
12	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	MCH1
13	KUNNR	☐	QKUNWE	KUNNR	CHAR	10	0	Customer (Ship-To Party)	KNA1
14	LIFNR	☐	ELIFN	LIFNR	CHAR	10	0	Vendor's account number	LFA1
15	HRSTL	☐	QLIFNR	LIFNR	CHAR	10	0	Number of Manufacturer	LFA1
16	MBLNR	☐	MBLNR	BELNR	CHAR	10	0	Number of Material Document	MSEG
17	ZEILE	☐	MBLPO	MBLPO	NUMC	4	0	Item in material document	MSEG
18	MJAHR	☐	MJAHR	GJAHR	NUMC	4	0	Year of material document	MSEG
19	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	AUFK
20	VERID	☐	VERID	VERID	CHAR	4	0	Production Version	MKAL
21	SA_AUFNR	☐	SA_AUFNR	SA_AUFNR	CHAR	12	0	Run schedule header number	SAFK
22	PN_NR	☐	QPZNR	NUMC12	NUMC	12	0	Sample-Drawing Number	QPRN
23	PNVER	☐	QPRZIEHVER	QPRZIEHVER	CHAR	8	0	Sample-Drawing Procedure	QPRVK
24	PNVEV	☐	QVERSNPRZV	QVERSNR	CHAR	6	0	Version No. of the Sample-Drawing Procedure
25	MENGE	☐	QPHYSPRUM	QMENGEPLOS	QUAN	13	3	Size of the Physical Sample
26	MEINH	☐	QPHYSPRME	MEINS	UNIT	3	0	Unit of Measure for Physical Sample Size	T006
27	ANZGB	☐	QANZGEB	QGEBPLOS	QUAN	6	3	QM - No. of Containers
28	GEBEH	☐	QGEBEH	MEINS	UNIT	3	0	Lot Container	T006
29	GBTYP	☐	QGEBINDET	QGEBINDET	CHAR	6	0	Physical-Sample Container	TQ42
30	PZTXT	☐	QPZ_TEXT	TEXT40	CHAR	40	0	Comments on the Physical-Sample Drawing
31	XMANU	☐	QPRB_MAN	QKZ	CHAR	1	0	Manually Created Sample
32	ALORT	☐	QAUFBLGORT	LGORT	CHAR	4	0	Actual Storage Location for the Physical Sample	T001L
33	ABORT	☐	QAUFBEWORT	QAUFBEWORT	CHAR	12	0	Storage Location for a Physical Sample	TQ41
34	ABDAU	☐	QAUFBDAUER	DEC5	DEC	5	0	Storage Duration of the Physical Sample in Days
35	ABDAT	☐	QAUFBDATUM	DATUM	DATS	8	0	Storage Deadline for Physical Sample
36	ABINF	☐	QAUFBINFO	TEXT80	CHAR	80	0	Storage Information for the Physical Sample
37	AUFBX	☐	QAUFB_KZ	QKZ	CHAR	1	0	Sample Was Stored
38	PRNVX	☐	QPRNV_KZ	QKZ	CHAR	1	0	Physical Sample No Longer Exists
39	LOEKZ	☐	QLOE_KZ	QKZ	CHAR	1	0	Deletion Flag
40	ANLNA	☐	QPRS_ANL	QAENDERER	CHAR	12	0	User who Created the Physical Sample
41	ANLDT	☐	QPRS_ANLDT	DATUM	DATS	8	0	Creation Date of Physical Sample
42	ANLZT	☐	QPRS_ANLZT	QZEIT	TIMS	6	0	Time at Which the Physical Sample Was Created
43	FRGNA	☐	QPRS_FRG	QAENDERER	CHAR	12	0	User who Released the Physical Sample
44	FRGDT	☐	QPRS_FRGDT	DATUM	DATS	8	0	Physical Sample Release Date
45	FRGZT	☐	QPRS_FRGZT	QZEIT	TIMS	6	0	Time of Physical Sample Release
46	XPR_O	☐	QXPROBE_O	QKZ	CHAR	1	0	New Sample Without Copy Model
47	XPR_M	☐	QXPROBE_M	QKZ	CHAR	1	0	New Sample with Copy Model
48	XPNRN	☐	QXPN_NR_N	QKZ	CHAR	1	0	New Sample-Drawing Without Copy Model
49	XPNRR	☐	QXPN_NR_R	QKZ	CHAR	1	0	New Physical-Sample Drawing with Copy Model
50	XPNRE	☐	QXPN_NR_E	QKZ	CHAR	1	0	Extend Physical-Sample Drawing
51	VENUM	☐	VENUM	VENUM	CHAR	10	0	Internal Handling Unit Number	VEKP
52	VEPOS	☐	VEPOS	VEPOS	NUMC	6	0	Handling Unit Item	VEPO
53	EXIDV	☐	EXIDV	EXIDV	CHAR	20	0	External Handling Unit Identification
54	QAUTH	☐	QMATAUTH	QMATAUTH	CHAR	6	0	Material authorization group for activities in QM	*
55	KTEXTMAT	☐	QKTEXTMAT	QKURZTEXT	CHAR	40	0	Material short text
56	KTEXTLIEF	☐	QTXTLIEF	QKURZTEXT	CHAR	40	0	Name of Vendor
57	KTEXTHERST	☐	QTXTHERST	QKURZTEXT	CHAR	40	0	Name of Manufacturer
58	KTEXTKUNDE	☐	QTXTKUNDE	QKURZTEXT	CHAR	40	0	Customer Name
59	.INCLUDE	☐				0	0	PLM ADDON for Sample Master Record
60	ADDON_DUMMY	☐	QDUMMY	QDUMMY	CHAR	1	0	Dummy Field for ADDON Structures in QM
61	.INCLU--AP	☐				0	0	Addon Fields for Stability Study
62	PRIMPACK	☐	QPRIMPACK	QPRIMPACK	CHAR	8	0	Primary Packaging (Stability Study)	TQ45
63	STABICON	☐	QSTABICON	QSTABICON	CHAR	8	0	Storage Condition	TQ43
64	EINGDT	☐	QST_EINGDT	DATUM	DATS	8	0	Date of Receipt of Initial Sample for Stability Study
65	EINLDT	☐	QST_EINLDT	DATUM	DATS	8	0	Storage Date of Sample for Storage Condition
66	AUSLDT	☐	QST_AUSLDT	DATUM	DATS	8	0	Date of Removal from Storage of Sample for Storage Condition
67	ENTORT	☐	QPRSENTORT	TPLNR	CHAR	30	0	Location of Sample Drawing (Functional Location)	*
68	INFEORT	☐	QPRSINFEORT	CHAR60	CHAR	60	0	Description of Sample-Drawing Location
69	ENTDATUM	☐	QPRSENTDATUM	DATUM	DATS	8	0	Date of Sample Drawing
70	ENTZEIT	☐	QPRSENTZEIT	QZEIT	TIMS	6	0	Time of Sample Drawing
71	BEARBEITER	☐	QPRSBEARBEITER	CHAR20	CHAR	20	0	Processor Responsible for the Sample, Sample Taker
72	KTEXTTPL	☐	PLTXT	TEXT40	CHAR	40	0	Description of functional location
73	LABOR	☐	QLABOR	QPLEXT_PRPLATZ	CHAR	8	0	Work Center (Laboratory)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	RQPRS	ABORT	TQ41	AUFBEWORT	KEY	C	CN
2	RQPRS	ALORT	T001L	LGORT	KEY	C	CN
3	RQPRS	AUFNR	AUFK	AUFNR
4	RQPRS	CHARG	MCH1	CHARG
5	RQPRS	GBTYP	TQ42	GEBINDETYP
6	RQPRS	GEBEH	T006	MSEHI
7	RQPRS	HRSTL	LFA1	LIFNR
8	RQPRS	KUNNR	KNA1	KUNNR
9	RQPRS	LIFNR	LFA1	LIFNR
10	RQPRS	MATNR	MARA	MATNR
11	RQPRS	MBLNR	MSEG	MBLNR
12	RQPRS	MEINH	T006	MSEHI
13	RQPRS	MJAHR	MSEG	MJAHR
14	RQPRS	PHYNR	QPRS	PHYNR
15	RQPRS	PLOS2	QALS	PRUEFLOS
16	RQPRS	PNVER	QPRVK	PRZIEHVERF
17	RQPRS	PN_NR	QPRN	PN_NR
18	RQPRS	PRART	TQ40	PRART
19	RQPRS	PRIMPACK	TQ45	PRIMPACK	REF	1	CN
20	RQPRS	PRTYP	TQ44	PRTYP	REF	1	CN
21	RQPRS	SA_AUFNR	SAFK	AUFNR
22	RQPRS	STABICON	TQ43	STABICON	REF	1	CN
23	RQPRS	VENUM	VEKP	VENUM
24	RQPRS	VEPOS	VEPO	VEPOS
25	RQPRS	VERID	MKAL	VERID
26	RQPRS	WERKS	T001W	WERKS
27	RQPRS	ZEILE	MSEG	ZEILE

History

Last changed by/on	SAP	20050411
SAP Release Created in