SAP Table
QPRVK Sample-drawing procedure
SAP table QPRVK has 3 primary key fields being MANDT,PRZIEHVERF,VERSION.
If you are only analysing data from a single SAP instance you may omit field MANDT in your relationships as it will be the same across the entire dataset. On the other hand, if you are combining data from multiple SAP instances you need to take MANDT into account.
/ Fields
QPRVK columns.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| KeyMANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |
| KeyPRZIEHVERF | Sample-Drawing Procedure | CHAR | 8 | 0 | QPRZIEHVER | ||
| KeyVERSION | Version No. of the Sample-Drawing Procedure | CHAR | 6 | 0 | QVERSNPRZV | ||
| GUELTIGAB | Valid-From Date | DATS | 8 | 0 | DATUV | ||
| SORTFELD | Search Field | CHAR | 40 | 0 | QSORTFELD | ||
| QMASTAUTH | Authorization Group QM Master Data | CHAR | 8 | 0 | TQ01D | QMASTAUTH | |
| GEBANZ | Sample Drawing Based on No. of Containers | CHAR | 1 | 0 | QKZGEBANZ | ||
| KZQUIT | Confirmation Required for Sample Drawing | CHAR | 1 | 0 | QKZQUIT | ||
| 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 | ||
| KZNVPRZV | Sample-drawing Procedure Cannot Be Used | CHAR | 1 | 0 | QKZNVWPRV | ||
| KZVPRZVPL | Sample-Drawing Procedure Is Used in Task List | CHAR | 1 | 0 | QKZVPRZVPL | ||
| DUMMY_QPRVK_INCL_EEW_PS | Dummy function in length 1 | CHAR | 1 | 0 | DUMMY |
/ Relationships
QPRVK foreign keys.
| Table | Field | Check Table | Description | Check Field |
|---|---|---|---|---|
| QPRVK | QMASTAUTH | TQ01D | Authorization groups for QM master data | MANDT |