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 | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 |
Possible values
|
||||||||
| SIG_IL_SDR | Digital Signature for Confirmation of Phys.-Sample Drawing | SIG_IL_SDR | CHAR | 1 | 0 |
Possible values
|
||||||||
| 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 | CHARG | MCH1 | Batches (if Batch Management Cross-Plant) | CHARG |
| QPRN | CHARG | QPRN | MANDT | MCH1 | Batches (if Batch Management Cross-Plant) | MANDT |
| QPRN | CHARG | QPRN | MATNR | MCH1 | Batches (if Batch Management Cross-Plant) | MATNR |
| 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 | LIFNR | LFA1 | Vendor Master (General Section) | LIFNR |
| QPRN | LIFNR | QPRN | MANDT | LFA1 | Vendor Master (General Section) | MANDT |
| 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 | PLOS | QALS | Inspection lot record | PRUEFLOS |
| QPRN | PLOS | QPRN | MANDT | QALS | Inspection lot record | MANDANT |
| QPRN | QMNUM | QPRN | MANDT | QMEL | Quality Notification | MANDT |
| QPRN | QMNUM | QPRN | QMNUM | QMEL | Quality Notification | QMNUM |
| QPRN | SA_AUFNR | QPRN | MANDT | SAFK | Run Schedule Master Data | MANDT |
| QPRN | SA_AUFNR | QPRN | SA_AUFNR | SAFK | Run Schedule Master Data | AUFNR |
| 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 | VERID | QPRN | VERID | MKAL | Production Versions of Material | VERID |
| QPRN | WERKS | QPRN | MANDT | T001W | Plants/Branches | MANDT |
| QPRN | WERKS | QPRN | WERKS | T001W | Plants/Branches | WERKS |
