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