SAP ABAP Table QPRVP (Sample-drawing items)

Hierarchy

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

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	QPRVP	Table Relationship Diagram
Short Description	Sample-drawing items

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	PRZIEHVERF	☑	QPRZIEHVER	QPRZIEHVER	CHAR	8	0	Sample-Drawing Procedure	QPRVK
3	VERSION	☑	QVERSNPRZV	QVERSNR	CHAR	6	0	Version No. of the Sample-Drawing Procedure
4	POSNRPRZV	☑	QZAEHLPRZV	NUM4	NUMC	4	0	Item Number in Sample-Drawing Procedure
5	LOSGEBEH	☐	QGEBEH	MEINS	UNIT	3	0	Lot Container	T006
6	PROBNRPL	☐	QPROBNRBIS	QPROBEPL	NUMC	3	0	Highest Partial Sample No. Valid for Instruction
7	GEBINDE1	☐	QGEBINDE1	QGEBINDET	CHAR	6	0	Physical-Sample Container for Drawing Primary Sample	TQ42
8	STPRPLAN1	☐	QSTPRPLAN1	QSTPRPLAN	CHAR	3	0	Sampling Scheme for Primary Sample Stage of Sample Drawing	QDPK
9	PRSCHAERF1	☐	QPRSCHAER1	QPRSCHAERF	NUMC	3	0	Insp. Severity in Samp.-Draw. Proc. at Primary Sample Stage	QDEP
10	AQLWERT1	☐	QAQLWERT1	QAQLWERT	DEC	7	3	AQL Value in Primary Sample Stage
11	PRANZ1	☐	QPRANZ1	QANZAHL1	INT1	3	0	Fixed No. of Physical Samples for Primary Sample Stage
12	FAKTORPR1	☐	QFAKTORPR1	QANZAHL1	INT1	3	0	Factor for Determining the Sample Size of a Primary Sample
13	FORMEL1	☐	QFORMELP	QFORMEL	CHAR	60	0	Formula Field for the Number of Samples
14	GEBINDER	☐	QGEBINDER	QGEBINDET	CHAR	6	0	Physical-Sample Container for Reserve Sample	TQ42
15	ANZRUECKL	☐	QANZRUECKL	QANZAHL1	INT1	3	0	Number of Reserve Samples
16	UMFRUECKL	☐	QUMFRUECKL	QMENGEPLOS	QUAN	13	3	Size of Reserve Sample
17	MERUECKL	☐	QMERUECKL	MEINS	UNIT	3	0	Unit of Measure for Reserve Sample	T006
18	GEBINDE2	☐	QGEBINDE2	QGEBINDET	CHAR	6	0	Physical-Sample Container for Drawing Pooled Sample	TQ42
19	STPRPLAN2	☐	QSTPRPLAN2	QSTPRPLAN	CHAR	3	0	Sampling Scheme for Pooled Sample Stage of Sample Drawing	QDPK
20	PRSCHAERF2	☐	QPRSCHAER2	QPRSCHAERF	NUMC	3	0	Insp. Severity of Samp.-Proc. at Pooled Sample Stage	QDEP
21	AQLWERT2	☐	QAQLWERT2	QAQLWERT	DEC	7	3	AQL Value in Pooled Sample Stage
22	PRANZ2	☐	QPRANZ2	QANZAHL1	INT1	3	0	Fixed No. of Physical Samples for Pooled Sample Stage
23	FAKTORPR2	☐	QFAKTORPR2	QANZAHL1	INT1	3	0	Factor for Determining the Sample Size of a Pooled Sample
24	FORMEL2	☐	QFORMELP	QFORMEL	CHAR	60	0	Formula Field for the Number of Samples
25	ERSTELLER	☐	QERSTELLER	QAENDERER	CHAR	12	0	Name of User Who Created the Data Record
26	AENDERER	☐	QAENDERER	QAENDERER	CHAR	12	0	Name of User who Most Recently Changed the Data Record
27	DATUMERST	☐	QDATUMERST	DATUM	DATS	8	0	Date on Which the Data Record Was Created
28	ZEITERST	☐	QERSTZEIT	QZEIT	TIMS	6	0	Time Data Record Was Created
29	DATUMAEND	☐	QDATUMAEND	DATUM	DATS	8	0	Date on Which Data Record Was Changed
30	ZEITAEND	☐	QAENZEIT	QZEIT	TIMS	6	0	Time of Last Data Record Change

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	QPRVP	GEBINDE1	TQ42	GEBINDETYP	REF	1	CN
2	QPRVP	GEBINDE2	TQ42	GEBINDETYP	REF	1	CN
3	QPRVP	GEBINDER	TQ42	GEBINDETYP	REF	C	CN
4	QPRVP	LOSGEBEH	T006	MSEHI	REF	C	CN
5	QPRVP	MANDT	T000	MANDT	KEY	1	CN
6	QPRVP	MERUECKL	T006	MSEHI	REF	1	CN
7	QPRVP	PRSCHAERF1	QDEP	PRSCHAERFE
8	QPRVP	PRSCHAERF2	QDEP	PRSCHAERFE
9	QPRVP	PRZIEHVERF	QPRVK	PRZIEHVERF	KEY	1	CN
10	QPRVP	STPRPLAN1	QDPK	STPRPLAN	REF	1	CN
11	QPRVP	STPRPLAN2	QDPK	STPRPLAN	REF	1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in