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 | Possible values | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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 | ||||||||
|
||||||||||||
|
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 | MANDT |
MCH1
Batches (if Batch Management Cross-Plant)
|
MANDT |
| QPRS | CHARG | QPRS | MATNR |
MCH1
Batches (if Batch Management Cross-Plant)
|
MATNR |
| QPRS | CHARG | QPRS | CHARG |
MCH1
Batches (if Batch Management Cross-Plant)
|
CHARG |
| 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 | MANDT |
T001L
Storage Locations
|
MANDT |
| QPRS | LGORT | QPRS | WERKS |
T001L
Storage Locations
|
WERKS |
| QPRS | LGORT | QPRS | LGORT |
T001L
Storage Locations
|
LGORT |
| 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 | MANDT |
T006
Units of Measurement
|
MANDT |
| QPRS | MEINH | QPRS | MEINH |
T006
Units of Measurement
|
MSEHI |
| QPRS | OBJNR | QPRS | OBJNR |
ONR00
General Object Number
|
OBJNR |
| QPRS | OBJNR | QPRS | MANDT |
ONR00
General Object Number
|
MANDT |
| 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 | PNVEV |
QPRVK
Sample-drawing procedure
|
VERSION |
| QPRS | PNVEV | QPRS | MANDT |
QPRVK
Sample-drawing procedure
|
MANDT |
| QPRS | PNVEV | QPRS | PNVER |
QPRVK
Sample-drawing procedure
|
PRZIEHVERF |
| QPRS | PN_NR | QPRS | MANDT |
QPRN
Sample drawing of phys. samples
|
MANDT |
| QPRS | PN_NR | QPRS | PN_NR |
QPRN
Sample drawing of phys. samples
|
PN_NR |
| QPRS | PRART | QPRS | PRART |
TQ40
Definition of sample types
|
PRART |
| QPRS | PRART | QPRS | MANDT |
TQ40
Definition of sample types
|
MANDT |
| QPRS | PRIMPACK | SYST | MANDT |
TQ45
Primary Packaging (Stability Study)
|
MANDT |
| QPRS | PRIMPACK | QPRS | PRIMPACK |
TQ45
Primary Packaging (Stability Study)
|
PRIMPACK |
| 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 | WERKS |
T001W
Plants/Branches
|
WERKS |
| QPRS | WERKS | QPRS | MANDT |
T001W
Plants/Branches
|
MANDT |