SAP table QPRVK (Sample-drawing procedure)

SAP table QPRVK has 3 primary key fields being MANDT,PRZIEHVERF,VERSION.

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 QPRZIEHVER
VERSION 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

QPRVK foreign key relationships

Table Field Check Table Check Field
0 QPRVK QMASTAUTH TQ01D Authorization groups for QM master data MANDT