SAP Table QPRVP
Sample-drawing items
QPRVP (Sample-drawing items) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link QPRVP to other SAP tables.
Source: QPRVP (Sample-drawing items)
QPRVP table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||
|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||
| PRZIEHVERF | Sample-Drawing Procedure | QPRZIEHVER | QPRVK | CHAR | 8 | 0 | ||
| VERSION | Version No. of the Sample-Drawing Procedure | QVERSNPRZV | CHAR | 6 | 0 | |||
| POSNRPRZV | Item Number in Sample-Drawing Procedure | QZAEHLPRZV | NUMC | 4 | 0 | |||
| LOSGEBEH | Lot Container | QGEBEH | T006 | UNIT | 3 | 0 | ||
| PROBNRPL | Highest Partial Sample No. Valid for Instruction | QPROBNRBIS | NUMC | 3 | 0 | |||
| GEBINDE1 | Physical-Sample Container for Drawing Primary Sample | QGEBINDE1 | TQ42 | CHAR | 6 | 0 | ||
| STPRPLAN1 | Sampling Scheme for Primary Sample Stage of Sample Drawing | QSTPRPLAN1 | QDPK | CHAR | 3 | 0 | ||
| PRSCHAERF1 | Insp. Severity in Samp.-Draw. Proc. at Primary Sample Stage | QPRSCHAER1 | QDEP | NUMC | 3 | 0 | ||
| AQLWERT1 | AQL Value in Primary Sample Stage | QAQLWERT1 | DEC | 7 | 3 | |||
| PRANZ1 | Fixed No. of Physical Samples for Primary Sample Stage | QPRANZ1 | INT1 | 3 | 0 | |||
| FAKTORPR1 | Factor for Determining the Sample Size of a Primary Sample | QFAKTORPR1 | INT1 | 3 | 0 | |||
| FORMEL1 | Formula Field for the Number of Samples | QFORMELP | CHAR | 60 | 0 | |||
| GEBINDER | Physical-Sample Container for Reserve Sample | QGEBINDER | TQ42 | CHAR | 6 | 0 | ||
| ANZRUECKL | Number of Reserve Samples | QANZRUECKL | INT1 | 3 | 0 | |||
| UMFRUECKL | Size of Reserve Sample | QUMFRUECKL | QUAN | 13 | 3 | |||
| MERUECKL | Unit of Measure for Reserve Sample | QMERUECKL | T006 | UNIT | 3 | 0 | ||
| GEBINDE2 | Physical-Sample Container for Drawing Pooled Sample | QGEBINDE2 | TQ42 | CHAR | 6 | 0 | ||
| STPRPLAN2 | Sampling Scheme for Pooled Sample Stage of Sample Drawing | QSTPRPLAN2 | QDPK | CHAR | 3 | 0 | ||
| PRSCHAERF2 | Insp. Severity of Samp.-Proc. at Pooled Sample Stage | QPRSCHAER2 | QDEP | NUMC | 3 | 0 | ||
| AQLWERT2 | AQL Value in Pooled Sample Stage | QAQLWERT2 | DEC | 7 | 3 | |||
| PRANZ2 | Fixed No. of Physical Samples for Pooled Sample Stage | QPRANZ2 | INT1 | 3 | 0 | |||
| FAKTORPR2 | Factor for Determining the Sample Size of a Pooled Sample | QFAKTORPR2 | INT1 | 3 | 0 | |||
| FORMEL2 | Formula Field for the Number of Samples | QFORMELP | CHAR | 60 | 0 | |||
| ERSTELLER | Name of User Who Created the Data Record | QERSTELLER | CHAR | 12 | 0 | |||
| AENDERER | Name of User who Most Recently Changed the Data Record | QAENDERER | CHAR | 12 | 0 | |||
| DATUMERST | Date on Which the Data Record Was Created | QDATUMERST | DATS | 8 | 0 | |||
| ZEITERST | Time Data Record Was Created | QERSTZEIT | TIMS | 6 | 0 | |||
| DATUMAEND | Date on Which Data Record Was Changed | QDATUMAEND | DATS | 8 | 0 | |||
| ZEITAEND | Time of Last Data Record Change | QAENZEIT | TIMS | 6 | 0 | |||
QPRVP foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| QPRVP | GEBINDE1 | QPRVP | MANDT | TQ42 | Physical sample containers | MANDT |
| QPRVP | GEBINDE1 | QPRVP | GEBINDE1 | TQ42 | Physical sample containers | GEBINDETYP |
| QPRVP | GEBINDE2 | QPRVP | GEBINDE2 | TQ42 | Physical sample containers | GEBINDETYP |
| QPRVP | GEBINDE2 | QPRVP | MANDT | TQ42 | Physical sample containers | MANDT |
| QPRVP | GEBINDER | QPRVP | GEBINDER | TQ42 | Physical sample containers | GEBINDETYP |
| QPRVP | GEBINDER | QPRVP | MANDT | TQ42 | Physical sample containers | MANDT |
| QPRVP | LOSGEBEH | QPRVP | LOSGEBEH | T006 | Units of Measurement | MSEHI |
| QPRVP | LOSGEBEH | QPRVP | MANDT | T006 | Units of Measurement | MANDT |
| QPRVP | MANDT | QPRVP | MANDT | T000 | Clients | MANDT |
| QPRVP | MERUECKL | QPRVP | MERUECKL | T006 | Units of Measurement | MSEHI |
| QPRVP | MERUECKL | QPRVP | MANDT | T006 | Units of Measurement | MANDT |
| QPRVP | PRSCHAERF1 | QPRVP | MANDT | QDEP | Allowed inspection severities | MANDT |
| QPRVP | PRSCHAERF1 | QPRVP | PRSCHAERF1 | QDEP | Allowed inspection severities | PRSCHAERFE |
| QPRVP | PRSCHAERF2 | QPRVP | MANDT | QDEP | Allowed inspection severities | MANDT |
| QPRVP | PRSCHAERF2 | QPRVP | PRSCHAERF2 | QDEP | Allowed inspection severities | PRSCHAERFE |
| QPRVP | PRZIEHVERF | QPRVP | VERSION | QPRVK | Sample-drawing procedure | VERSION |
| QPRVP | PRZIEHVERF | QPRVP | PRZIEHVERF | QPRVK | Sample-drawing procedure | PRZIEHVERF |
| QPRVP | PRZIEHVERF | QPRVP | MANDT | QPRVK | Sample-drawing procedure | MANDT |
| QPRVP | STPRPLAN1 | QPRVP | STPRPLAN1 | QDPK | Sampling scheme header | STPRPLAN |
| QPRVP | STPRPLAN1 | QPRVP | MANDT | QDPK | Sampling scheme header | MANDT |
| QPRVP | STPRPLAN2 | QPRVP | STPRPLAN2 | QDPK | Sampling scheme header | STPRPLAN |
| QPRVP | STPRPLAN2 | QPRVP | MANDT | QDPK | Sampling scheme header | MANDT |
