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