SAP Table QPRN
Sample drawing of phys. samples
QPRN (Sample drawing of phys. samples) 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 QPRN to other SAP tables.
QPRN table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |||||||||
|
PN_NR
Sample-Drawing Number
|
QPZNR |
NUMC
|
12 | 0 | ||||||||||
|
PLOS
Current or Last Inspection Lot for the Sample
|
QLOT_LATE | QALS |
NUMC
|
12 | 0 | |||||||||
|
MATNR
Material Number
|
MATNR | MARA |
CHAR
|
18 | 0 | |||||||||
|
WERKS
Plant
|
WERKS_D | T001W |
CHAR
|
4 | 0 | |||||||||
|
REVLV
Revision Level
|
REVLV |
CHAR
|
2 | 0 | ||||||||||
|
CHARG
Batch Number
|
CHARG_D | MCH1 |
CHAR
|
10 | 0 | |||||||||
|
KUNNR
Customer (Ship-To Party)
|
QKUNWE | KNA1 |
CHAR
|
10 | 0 | |||||||||
|
LIFNR
Vendor Account Number
|
ELIFN | LFA1 |
CHAR
|
10 | 0 | |||||||||
|
HRSTL
Number of Manufacturer
|
QLIFNR | LFA1 |
CHAR
|
10 | 0 | |||||||||
|
MBLNR
Number of Material Document
|
MBLNR |
CHAR
|
10 | 0 | ||||||||||
|
ZEILE
Item in Material Document
|
MBLPO |
NUMC
|
4 | 0 | ||||||||||
|
MJAHR
Material Document Year
|
MJAHR |
NUMC
|
4 | 0 | ||||||||||
|
AUFNR
Order Number
|
AUFNR | AUFK |
CHAR
|
12 | 0 | |||||||||
|
VERID
Production Version
|
VERID | MKAL |
CHAR
|
4 | 0 | |||||||||
|
SA_AUFNR
Run schedule header number
|
SA_AUFNR | SAFK |
CHAR
|
12 | 0 | |||||||||
|
ANLNA
User who Created the Physical Sample
|
QPRS_ANL |
CHAR
|
12 | 0 | ||||||||||
|
ANLDT
Creation Date of Physical Sample
|
QPRS_ANLDT |
DATS
|
8 | 0 | ||||||||||
|
ANLZT
Time at Which the Physical Sample Was Created
|
QPRS_ANLZT |
TIMS
|
6 | 0 | ||||||||||
|
QMATAUTH
Material Authorization Group for Activities in QM
|
QMATAUTH |
CHAR
|
6 | 0 | ||||||||||
|
KZQUIT
Confirmation Required for Physical-Sample Drawing
|
QKZQUIT |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
SIG_IL_SDR
Digital Signature for Confirmation of Phys.-Sample Drawing
|
SIG_IL_SDR |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
FRGNA
User who Released the Physical Sample
|
QPRS_FRG |
CHAR
|
12 | 0 | ||||||||||
|
FRGDT
Physical Sample Release Date
|
QPRS_FRGDT |
DATS
|
8 | 0 | ||||||||||
|
FRGZT
Time of Physical Sample Release
|
QPRS_FRGZT |
TIMS
|
6 | 0 | ||||||||||
|
PZTXT
Comments on the Physical-Sample Drawing
|
QPZ_TEXT |
CHAR
|
40 | 0 | ||||||||||
|
QMNUM
Notification No
|
QMNUM | QMEL |
CHAR
|
12 | 0 | |||||||||
QPRN foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| QPRN | AUFNR | QPRN | MANDT |
AUFK
Order master data
|
MANDT |
| QPRN | AUFNR | QPRN | AUFNR |
AUFK
Order master data
|
AUFNR |
| QPRN | CHARG | QPRN | MATNR |
MCH1
Batches (if Batch Management Cross-Plant)
|
MATNR |
| QPRN | CHARG | QPRN | CHARG |
MCH1
Batches (if Batch Management Cross-Plant)
|
CHARG |
| QPRN | CHARG | QPRN | MANDT |
MCH1
Batches (if Batch Management Cross-Plant)
|
MANDT |
| QPRN | HRSTL | QPRN | MANDT |
LFA1
Vendor Master (General Section)
|
MANDT |
| QPRN | HRSTL | QPRN | HRSTL |
LFA1
Vendor Master (General Section)
|
LIFNR |
| QPRN | KUNNR | QPRN | MANDT |
KNA1
General Data in Customer Master
|
MANDT |
| QPRN | KUNNR | QPRN | KUNNR |
KNA1
General Data in Customer Master
|
KUNNR |
| QPRN | LIFNR | QPRN | MANDT |
LFA1
Vendor Master (General Section)
|
MANDT |
| QPRN | LIFNR | QPRN | LIFNR |
LFA1
Vendor Master (General Section)
|
LIFNR |
| QPRN | MANDT | QPRN | MANDT |
T000
Clients
|
MANDT |
| QPRN | MATNR | QPRN | MANDT |
MARA
General Material Data
|
MANDT |
| QPRN | MATNR | QPRN | MATNR |
MARA
General Material Data
|
MATNR |
| QPRN | PLOS | QPRN | MANDT |
QALS
Inspection lot record
|
MANDANT |
| QPRN | PLOS | QPRN | PLOS |
QALS
Inspection lot record
|
PRUEFLOS |
| QPRN | QMNUM | QPRN | MANDT |
QMEL
Quality Notification
|
MANDT |
| QPRN | QMNUM | QPRN | QMNUM |
QMEL
Quality Notification
|
QMNUM |
| QPRN | SA_AUFNR | QPRN | SA_AUFNR |
SAFK
Run Schedule Master Data
|
AUFNR |
| QPRN | SA_AUFNR | QPRN | MANDT |
SAFK
Run Schedule Master Data
|
MANDT |
| QPRN | VERID | QPRN | VERID |
MKAL
Production Versions of Material
|
VERID |
| QPRN | VERID | QPRN | MANDT |
MKAL
Production Versions of Material
|
MANDT |
| QPRN | VERID | QPRN | MATNR |
MKAL
Production Versions of Material
|
MATNR |
| QPRN | VERID | QPRN | WERKS |
MKAL
Production Versions of Material
|
WERKS |
| QPRN | WERKS | QPRN | MANDT |
T001W
Plants/Branches
|
MANDT |
| QPRN | WERKS | QPRN | WERKS |
T001W
Plants/Branches
|
WERKS |