SAP table QPRN (Sample Drawing of Material Samples)

SAP table QPRN has 2 primary key fields being MANDT,PN_NR.

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
PN_NR Sample-Drawing Number NUMC 12 0 QPZNR
PLOS Current or Last Inspection Lot for the Sample NUMC 12 0 QALS QLOT_LATE
MATNR Material Number CHAR 40 0 MARA MATNR
WERKS Plant CHAR 4 0 T001W WERKS_D
REVLV Revision Level CHAR 2 0 REVLV
CHARG Batch Number CHAR 10 0 MCH1 CHARG_D
CVP_XBLCK Business Purpose Completed Flag CHAR 1 0 CVP_XBLCK
not blocked
X blocked
KUNNR Customer (Ship-To Party) CHAR 10 0 KNA1 QKUNWE
LIFNR Vendor's account number CHAR 10 0 LFA1 ELIFN
HRSTL Number of Manufacturer CHAR 10 0 LFA1 QLIFNR
MBLNR Number of Material Document CHAR 10 0 MBLNR
ZEILE Item in Material Document NUMC 4 0 MBLPO
MJAHR Material Document Year NUMC 4 0 MJAHR
AUFNR Order Number CHAR 12 0 AUFK AUFNR
VERID Production Version CHAR 4 0 MKAL VERID
SA_AUFNR Run schedule header number CHAR 12 0 SAFK SA_AUFNR
ANLNA User Who Created the Material Sample CHAR 12 0 QPRS_ANL
ANLDT System Date When Material Sample Was Created DATS 8 0 QPRS_ANLDT
ANLZT Time at Which Material Sample Was Created TIMS 6 0 QPRS_ANLZT
QMATAUTH Material Authorization Group for Activities in QM CHAR 6 0 QMATAUTH
KZQUIT Confirmation Required for Sample Drawing CHAR 1 0 QKZQUIT
SIG_IL_SDR Digital Signature for Confirmation of Sample Drawing CHAR 1 0 SIG_IL_SDR
Not Required
1 Required for Confirmation of Sample Drawing
2 Req. for Conf. of Sample Drawing 'New' Digital Sig.
FRGNA User Who Released the Material Sample CHAR 12 0 QPRS_FRG
FRGDT Material Sample Release Date DATS 8 0 QPRS_FRGDT
FRGZT Time of Material Sample Release TIMS 6 0 QPRS_FRGZT
PZTXT Comments on Sample Drawing CHAR 40 0 QPZ_TEXT
QMNUM Notification Number CHAR 12 0 QMEL QMNUM

QPRN foreign key relationships

Table Field Check Table Check Field
0 QPRN AUFNR AUFK Order master data AUFNR
1 QPRN CHARG MCH1 Batches (if Batch Management Cross-Plant) MANDT
0 QPRN HRSTL LFA1 Supplier Master (General Section) MANDT
0 QPRN HRSTL LFA1 Supplier Master (General Section) LIFNR
1 QPRN KUNNR KNA1 General Data in Customer Master MANDT
1 QPRN KUNNR KNA1 General Data in Customer Master KUNNR
0 QPRN LIFNR LFA1 Supplier Master (General Section) MANDT
0 QPRN LIFNR LFA1 Supplier Master (General Section) LIFNR
1 QPRN MATNR MARA General Material Data MANDT
1 QPRN MATNR MARA General Material Data MATNR
0 QPRN PLOS QALS Inspection lot record MANDANT
1 QPRN QMNUM QMEL Quality Notification MANDT
1 QPRN QMNUM QMEL Quality Notification QMNUM
0 QPRN SA_AUFNR SAFK Run Schedule Master Data MANDT
0 QPRN SA_AUFNR SAFK Run Schedule Master Data AUFNR
1 QPRN VERID MKAL Production Versions of Material WERKS
1 QPRN VERID MKAL Production Versions of Material VERID
0 QPRN WERKS T001W Plants/Branches MANDT
0 QPRN WERKS T001W Plants/Branches WERKS