SAP table QPRS (Master Record for Material Samples)
SAP table QPRS has 2 primary key fields being MANDT,PHYNR.
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 | |
| PHYNR | Material Sample Number | CHAR | 12 | 0 | QPHYSPRNR | ||
| OBJNR | Object number | CHAR | 22 | 0 | ONR00 | J_OBJNR | |
| STSMA | Status Profile for Material Samples | CHAR | 8 | 0 | TJ20 | QSTSMA_PRS | |
| PRART | Material Sample Type | CHAR | 2 | 0 | TQ40 | QPRART | |
| PRTYP | Sample Category | CHAR | 1 | 0 | TQ44 | QPRTYP | |
| PN_NR | Sample-Drawing Number | NUMC | 12 | 0 | QPRN | QPZNR | |
| XMANU | Manually Created Sample | CHAR | 1 | 0 | QPRB_MAN | ||
| GBTYP | Material Sample Container | CHAR | 6 | 0 | TQ42 | QGEBINDET | |
| MENGE | Size of Material Sample | QUAN | 13 | 3 | QPHYSPRUM | ||
| MEINH | Unit of Measure for Material Sample Size | UNIT | 3 | 0 | T006 | QPHYSPRME | |
| PLOS2 | 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 | |
| KTEXT | Short Text for Material Sample | CHAR | 80 | 0 | QTEXT_PRS | ||
| QAUTH | Material Authorization Group for Activities in QM | CHAR | 6 | 0 | TQ01B | QMATAUTH | |
| PNVER | Sample-Drawing Procedure | CHAR | 8 | 0 | QPRVK | QPRZIEHVER | |
| PNVEV | Version No. of the Sample-Drawing Procedure | CHAR | 6 | 0 | QPRVK | QVERSNPRZV | |
| PNPOS | Item Number in Sample-Drawing Procedure | NUMC | 4 | 0 | QZAEHLPRZV | ||
| GEBEH | Lot Container | UNIT | 3 | 0 | T006 | QGEBEH | |
| TPBIS | Highest Partial Sample No. Valid for Instruction | NUMC | 3 | 0 | QPROBNRBIS | ||
| LGORT | Storage location | CHAR | 4 | 0 | T001L | LGORT_D | |
| ABORT | Material Sample Location | CHAR | 12 | 0 | TQ41 | QAUFBEWORT | |
| ABDAU | Storage Duration of the Material Sample in Days | DEC | 5 | 0 | QAUFBDAUER | ||
| ABDAT | Storage Deadline for Sample | DATS | 8 | 0 | QAUFBDATUM | ||
| ABINF | Storage Information for the Material Sample | CHAR | 80 | 0 | QAUFBINFO | ||
| AENNA | Last User Who Changed the Sample Record | CHAR | 12 | 0 | QPRS_AEN | ||
| AENDT | System Date When Sample Changed | DATS | 8 | 0 | QPRS_AENDT | ||
| AENZT | System Time When Sample Record Changed | TIMS | 6 | 0 | QPRS_AENZT | ||
| VENUM | Internal Handling Unit Number | CHAR | 10 | 0 | VENUM | ||
| VEPOS | Handling Unit Item | NUMC | 6 | 0 | VEPOS | ||
| ADDON_DUMMY | Dummy Field for ADDON Structures in QM | CHAR | 1 | 0 | QDUMMY | ||
| PRIMPACK | Primary Packaging (Stability Study) | CHAR | 8 | 0 | TQ45 | QPRIMPACK | |
| STABICON | Storage Condition | CHAR | 8 | 0 | TQ43 | QSTABICON | |
| EINGDT | Date of Receipt of Initial Sample for Stability Study | DATS | 8 | 0 | QST_EINGDT | ||
| EINLDT | Storage Date of Sample for Storage Condition | DATS | 8 | 0 | QST_EINLDT | ||
| AUSLDT | Date of Removal from Storage of Sample for Storage Condition | DATS | 8 | 0 | QST_AUSLDT | ||
| ENTORT | Location of Sample Drawing (Functional Location) | CHAR | 30 | 0 | QPRSENTORT | ||
| INFEORT | Description of Sample-Drawing Location | CHAR | 60 | 0 | QPRSINFEORT | ||
| ENTDATUM | Date of Sample Drawing | DATS | 8 | 0 | QPRSENTDATUM | ||
| ENTZEIT | Time of Sample Drawing | TIMS | 6 | 0 | QPRSENTZEIT | ||
| BEARBEITER | Processor Responsible for the Sample, Sample Taker | CHAR | 20 | 0 | QPRSBEARBEITER | ||
| LABOR | Work Center (Laboratory) | CHAR | 8 | 0 | QLABOR | ||
| DUMMY_QPRS_INCL_EEW_PS | Dummy function in length 1 | CHAR | 1 | 0 | DUMMY |
QPRS foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 QPRS | ABORT | TQ41 | Storage Locations for Material Samples | MANDT |
| 0 QPRS | ABORT | TQ41 | Storage Locations for Material Samples | WERKS |
| 0 QPRS | ABORT | TQ41 | Storage Locations for Material Samples | AUFBEWORT |
| 1 QPRS | CHARG | MCH1 | Batches (if Batch Management Cross-Plant) | MANDT |
| 0 QPRS | GBTYP | TQ42 | Physical sample containers | MANDT |
| 1 QPRS | GEBEH | T006 | Units of Measurement | MANDT |
| 1 QPRS | GEBEH | T006 | Units of Measurement | MSEHI |
| 0 QPRS | LGORT | T001L | Storage Locations | MANDT |
| 0 QPRS | LGORT | T001L | Storage Locations | WERKS |
| 1 QPRS | MATNR | MARA | General Material Data | MANDT |
| 1 QPRS | MATNR | MARA | General Material Data | MATNR |
| 0 QPRS | MEINH | T006 | Units of Measurement | MANDT |
| 0 QPRS | MEINH | T006 | Units of Measurement | MSEHI |
| 1 QPRS | OBJNR | ONR00 | General Object Number | MANDT |
| 0 QPRS | PLOS2 | QALS | Inspection lot record | MANDANT |
| 1 QPRS | PNVER | QPRVK | Sample-drawing procedure | MANDT |
| 1 QPRS | PNVER | QPRVK | Sample-drawing procedure | VERSION |
| 0 QPRS | PNVEV | QPRVK | Sample-drawing procedure | MANDT |
| 0 QPRS | PNVEV | QPRVK | Sample-drawing procedure | VERSION |
| 1 QPRS | PN_NR | QPRN | Sample Drawing of Material Samples | MANDT |
| 1 QPRS | PN_NR | QPRN | Sample Drawing of Material Samples | PN_NR |
| 0 QPRS | PRART | TQ40 | Definition of sample types | MANDT |
| 0 QPRS | PRART | TQ40 | Definition of sample types | PRART |
| 1 QPRS | PRIMPACK | TQ45 | Primary Packaging (Stability Study) | MANDT |
| 0 QPRS | PRTYP | TQ44 | Phys. sample types | PRTYP |
| 1 QPRS | QAUTH | TQ01B | Material authorization groups in quality management | MANDT |
| 1 QPRS | QAUTH | TQ01B | Material authorization groups in quality management | QMATAUTH |
| 0 QPRS | STSMA | TJ20 | Status profiles | MANDT |
| 0 QPRS | STSMA | TJ20 | Status profiles | STSMA |
| 1 QPRS | WERKS | T001W | Plants/Branches | MANDT |
| 1 QPRS | WERKS | T001W | Plants/Branches | WERKS |