SAPFree referencePDF, Excel, Word exportSAP ECC 6.0All SAP ECC 6.0 tools

SAP QM Sample Management Tables: QPRVK, QPRVP, QPRS and Related Objects

This reference maps the SAP ECC 6.0 QM sample management objects: the sample-drawing procedure (QPRVK, QPRVP), physical sample drawings (QPRN), physical samples (QPRS) and their links to inspection lots, inspection points and sampling procedures. It also lists the transactions that maintain each object.

Download:

Object	Type	Description	Key / main fields	Links to	Use
QPRVK	Table	Sample-drawing procedure header	MANDT, PRZIEHVERF, VERSION; GUELTIGAB valid-from, QMASTAUTH auth group, KZQUIT confirmation required, GEBANZ drawing by number of containers	QPRVKT, QPRVP, QALS, QPRS	Find which procedures exist and whether confirmation of the drawing is required
QPRVKT	Table	Sample-drawing procedure texts	MANDT, PRZIEHVERF, VERSION, SPRACHE; KURZTEXT	QPRVK	Short text of a procedure in each language
QPRVP	Table	Sample-drawing procedure items	MANDT, PRZIEHVERF, VERSION, POSNRPRZV; STPRPLAN1/2 sampling scheme, AQLWERT1/2 AQL, PRANZ1/2 fixed number of samples, FAKTORPR1/2, ANZRUECKL reserve samples	QPRVK, QDPK (sampling scheme), TQ42 (container)	How many primary, pooled and reserve samples each item draws
QPRS	Table	Physical sample master record	MANDT, PHYNR; PRART sample type, PN_NR drawing number, MENGE/MEINH sample size, PLOS2 lot, MATNR, WERKS, CHARG, PNVER/PNVEV procedure and version, ABORT, ABDAT storage deadline, ENTDATUM/ENTZEIT drawing date and time	QPRN, QALS, QPRVK, TQ40, TQ41	The physical sample itself: what, how much, where it is stored and until when
QPRN	Table	Physical-sample drawing	MANDT, PN_NR; PLOS lot, MATNR, WERKS, CHARG, MBLNR/MJAHR/ZEILE, AUFNR, KZQUIT, FRGNA/FRGDT release	QALS, QPRS, AUFK, MKPF	One drawing event that produces one or more physical samples; confirmation and release data
QALS	Table	Inspection lot record	PRUEFLOS; PRBNAVERF and PRBNAVV sample-drawing procedure and version, STPRVER sampling procedure, STAT12 confirmation required, STAT13 inspection point type (3 = physical sample)	QPRVK, QPRN, QPRS, QAMV	Link from the lot to the sample-drawing procedure that the task list proposed
QAPP	Table	Inspection point	PRUEFLOS, VORGLFNR, PROBENR; PHYNR physical sample number	QALS, QPRS, QASV	In sample management, each physical sample becomes an inspection point for results recording
QAMV	Table	Characteristic specifications for inspection processing	PRUEFLOS, VORGLFNR, MERKNR; STICHPRVER sampling procedure	QALS, QDSV, QASV	Which sampling procedure each lot characteristic uses
QASV	Table	Sample specifications for inspection processing	PRUEFLOS, VORGLFNR, MERKNR, PROBENR; PRSTUFE inspection stage, PRSCHAERFE severity	QALS, QDPS, QDEP	Calculated sample size per characteristic and partial sample
PLKO	Table	Task list header	PLNTY, PLNNR, PLNAL; QPRZIEHVER and QVERSNPRZV sample-drawing procedure and version, QKZRASTER inspection points indicator	QPRVK	Where the sample-drawing procedure is assigned in the inspection plan header (QP01/QP02)
PLMK	Table	Inspection plan characteristics	PLNTY, PLNNR, PLNKN, MERKNR; STICHPRVER sampling procedure, PROBENR partial sample number	QDSV, PLKO	Characteristic-level sampling procedure and partial sample assignment
QDSV	Table	Sampling procedure	STICHPRVER; STICHPRART sampling type, BEWERTMOD valuation mode, STPRPLAN sampling scheme, AQLWERT, PROZUMF, KZRAST inspection points (incl. sample management)	QDPK, QDEP, PLMK, QAMV	Statistical sample size and valuation per characteristic (not the physical drawing)
QDPK	Table	Sampling scheme header	STPRPLAN	QDSV, QPRVP	Scheme (for example an AQL-based scheme) referenced by sampling procedures and drawing items
QPV1 / QPV2 / QPV3	Transaction	Create / change / display sample-drawing procedure	Procedure and version	QPRVK, QPRVP	Maintain procedures that drive physical-sample creation
QPR1 / QPR2 / QPR3	Transaction	Create / change / display physical sample	PHYNR	QPRS	Manual physical samples or correction of generated ones
QPR4	Transaction	Confirm physical-sample drawing	PN_NR	QPRN, QALS	Required before results recording when the procedure demands confirmation (KZQUIT)
QDV1 / QDV2 / QDV3	Transaction	Create / change / display sampling procedure	STICHPRVER	QDSV	Maintain statistical sampling procedures
QA03 / QA32	Transaction	Display inspection lot / inspection lot worklist	PRUEFLOS	QALS	See the sample tab of a lot and the drawing that belongs to it

Field names come from the ECC 6.0 data dictionary. Confirm in SE11 on your system, especially if you run industry add-ons (for example stability study fields in QPRS). Use SE16N with the key fields above to trace a lot to its samples: QALS-PRUEFLOS to QPRN-PLOS to QPRS-PN_NR to QAPP-PHYNR.

Get a lot-to-sample report spec

Tell us your inspection types and we send a reviewed field list and join path for a sample tracking report on your ECC system.

Optional. The tool and every export work without this. No spam.

Was this tool useful?

Sampling procedure vs sample-drawing procedure

SAP QM has two similarly named objects that do different jobs. The sampling procedure (QDV1, table QDSV) is statistical: it decides how many units of each characteristic are inspected and how results are valued, and it is assigned per characteristic in PLMK. The sample-drawing procedure (QPV1, tables QPRVK and QPRVP) is physical: it decides how many physical samples are drawn from the lot, in which containers, and whether drawing must be confirmed. It is assigned in the inspection plan header and copied to QALS when the lot is created.

Sample size per characteristic: QDSV, result in QASV.
Number of physical samples: QPRVP, result in QPRN and QPRS.
Results per physical sample: inspection points in QAPP with PHYNR.

Worked example: tracing a lot to its samples

A goods receipt creates inspection lot 010000004711. In SE16N, QALS shows PRBNAVERF = RAW01 and PRBNAVV = 000001, the sample-drawing procedure from the plan. QPRN with PLOS = 010000004711 returns drawing number 000000001203, and QPRS with PN_NR = 000000001203 returns three physical samples with their sizes in MENGE and MEINH, storage location in ABORT and deadline in ABDAT. QAPP for the lot shows one inspection point per sample, with PHYNR filled, which is where results are recorded in QE51N.

How to use the table

Search by table name, field name or transaction. The keys column lists the fields you need for joins and the most useful attributes; the links column names the parent or child tables. Export to Excel when you are writing a functional spec or an ABAP report so the developer has the joins in one place. When a field you need is not listed, open the table in SE11 rather than guessing: QPRS in particular carries many optional fields for stability studies and handling units.

Gotchas

QALS does not have a field called PRZIEHVERF; the lot stores the procedure in PRBNAVERF and the version in PRBNAVV, both checked against QPRVK. QPRS stores the procedure as PNVER and PNVEV. If KZQUIT is set in the procedure, results recording is blocked until the drawing is confirmed with QPR4, which is a frequent cause of lots that seem stuck. Physical samples are only created automatically when the inspection type and plan are set up for sample management.

Frequently Asked Questions

Which SAP table stores the sample-drawing procedure?

QPRVK holds the header of the sample-drawing procedure, keyed by PRZIEHVERF and VERSION, with texts in QPRVKT. The items, including sampling scheme, AQL and number of primary, pooled and reserve samples, are in QPRVP. Maintain them with QPV1, QPV2 and QPV3.

Where are physical samples stored in SAP QM?

Physical samples are in QPRS, keyed by PHYNR. Each sample references the drawing number PN_NR in QPRN, the inspection lot, material, plant and batch, the sample size in MENGE and MEINH, and the storage location and deadline. Display or change them with QPR3 and QPR2.

What is the difference between QDV1 and QPV1?

QDV1 creates a sampling procedure, which defines the statistical sample size and valuation per inspection characteristic. QPV1 creates a sample-drawing procedure, which defines how many physical samples are drawn from a lot and whether the drawing must be confirmed. A lot can use both at the same time.

How do I link an inspection lot to its physical samples?

Read QPRN where PLOS equals the lot number to get the drawing number PN_NR, then read QPRS where PN_NR matches to get each PHYNR. For results, read QAPP where PRUEFLOS equals the lot; the PHYNR field on each inspection point identifies the physical sample.

If you want quality engineers to ask SAP QM about lots, samples and results in plain English on your own servers, we can set that up over your ECC system.

Talk to an Expert Explore More Free Tools