SAP table QPRVP (Sample-drawing items)
SAP table QPRVP has 4 primary key fields being MANDT,PRZIEHVERF,VERSION,POSNRPRZV.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| MANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |
| PRZIEHVERF | Sample-Drawing Procedure | CHAR | 8 | 0 | QPRVK | QPRZIEHVER | |
| VERSION | Version No. of the Sample-Drawing Procedure | CHAR | 6 | 0 | QVERSNPRZV | ||
| POSNRPRZV | Item Number in Sample-Drawing Procedure | NUMC | 4 | 0 | QZAEHLPRZV | ||
| LOSGEBEH | Lot Container | UNIT | 3 | 0 | T006 | QGEBEH | |
| PROBNRPL | Highest Partial Sample No. Valid for Instruction | NUMC | 3 | 0 | QPROBNRBIS | ||
| GEBINDE1 | Sample Container for Drawing Primary Sample | CHAR | 6 | 0 | TQ42 | QGEBINDE1 | |
| STPRPLAN1 | Sampling Scheme for Primary Sample Stage of Sample Drawing | CHAR | 3 | 0 | QDPK | QSTPRPLAN1 | |
| PRSCHAERF1 | Insp. Severity in Samp.-Draw. Proc. at Primary Sample Stage | NUMC | 3 | 0 | QDEP | QPRSCHAER1 | |
| AQLWERT1 | AQL Value in Primary Sample Stage | DEC | 7 | 3 | QAQLWERT1 | ||
| PRANZ1 | Fixed No. of Samples for Primary Sample Stage | INT1 | 3 | 0 | QPRANZ1 | ||
| FAKTORPR1 | Factor for Determining the Sample Size of a Primary Sample | INT1 | 3 | 0 | QFAKTORPR1 | ||
| FORMEL1 | Formula Field for the Number of Samples | CHAR | 60 | 0 | QFORMELP | ||
| GEBINDER | Sample Container for Reserve Sample | CHAR | 6 | 0 | TQ42 | QGEBINDER | |
| ANZRUECKL | Number of Reserve Samples | INT1 | 3 | 0 | QANZRUECKL | ||
| UMFRUECKL | Size of Reserve Sample | QUAN | 13 | 3 | QUMFRUECKL | ||
| MERUECKL | Unit of Measure for Reserve Sample | UNIT | 3 | 0 | T006 | QMERUECKL | |
| GEBINDE2 | Sample Container for Drawing Pooled Sample | CHAR | 6 | 0 | TQ42 | QGEBINDE2 | |
| STPRPLAN2 | Sampling Scheme for Pooled Sample Stage of Sample Drawing | CHAR | 3 | 0 | QDPK | QSTPRPLAN2 | |
| PRSCHAERF2 | Insp. Severity of Samp.-Proc. at Pooled Sample Stage | NUMC | 3 | 0 | QDEP | QPRSCHAER2 | |
| AQLWERT2 | AQL Value in Pooled Sample Stage | DEC | 7 | 3 | QAQLWERT2 | ||
| PRANZ2 | Fixed No. of Samples for Pooled Sample Stage | INT1 | 3 | 0 | QPRANZ2 | ||
| FAKTORPR2 | Factor for Determining the Sample Size of a Pooled Sample | INT1 | 3 | 0 | QFAKTORPR2 | ||
| FORMEL2 | Formula Field for the Number of Samples | CHAR | 60 | 0 | QFORMELP | ||
| ERSTELLER | Name of User Who Created the Data Record | CHAR | 12 | 0 | QERSTELLER | ||
| AENDERER | Name of User Who Last Changed Data Record | CHAR | 12 | 0 | QAENDERER | ||
| DATUMERST | System Date on Which Data Record Was Created | DATS | 8 | 0 | QDATUMERST | ||
| ZEITERST | System Time at Which Data Record Was Created | TIMS | 6 | 0 | QZEITERSTL | ||
| DATUMAEND | System Date on Which Data Record Was Changed | DATS | 8 | 0 | QDATUMAEND | ||
| ZEITAEND | System Time at Which Data Record Was Changed | TIMS | 6 | 0 | QZEITAEND |
QPRVP foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 QPRVP | GEBINDE1 | TQ42 | Physical sample containers | MANDT |
| 1 QPRVP | GEBINDE2 | TQ42 | Physical sample containers | MANDT |
| 0 QPRVP | GEBINDER | TQ42 | Physical sample containers | MANDT |
| 1 QPRVP | LOSGEBEH | T006 | Units of Measurement | MANDT |
| 0 QPRVP | MERUECKL | T006 | Units of Measurement | MANDT |
| 1 QPRVP | PRSCHAERF1 | QDEP | Allowed inspection severities | MANDT |
| 0 QPRVP | PRSCHAERF2 | QDEP | Allowed inspection severities | MANDT |
| 1 QPRVP | PRZIEHVERF | QPRVK | Sample-drawing procedure | MANDT |
| 1 QPRVP | PRZIEHVERF | QPRVK | Sample-drawing procedure | VERSION |
| 0 QPRVP | STPRPLAN1 | QDPK | Sampling scheme header | MANDT |
| 0 QPRVP | STPRPLAN1 | QDPK | Sampling scheme header | STPRPLAN |
| 1 QPRVP | STPRPLAN2 | QDPK | Sampling scheme header | MANDT |
| 1 QPRVP | STPRPLAN2 | QDPK | Sampling scheme header | STPRPLAN |