QPRS

Master Record for Material Samples | #transactional | Component: Sample Management
Column Name Description
MANDT FK Client
PHYNR Material Sample Number
Column Name Description
Column Name Description
📏 Unit of Measure for Material Sample Size (MEINH):
MENGE Size of Material Sample
Column Name Description
ABDAT Storage Deadline for Sample
AENDT System Date When Sample Changed
AENZT System Time When Sample Record Changed
EINGDT Date of Receipt of Initial Sample for Stability Study
EINLDT Storage Date of Sample for Storage Condition
AUSLDT Date of Removal from Storage of Sample for Storage Condition
ENTDATUM Date of Sample Drawing
ENTZEIT Time of Sample Drawing
Column Name Description
XMANU Manually Created Sample Show values
Column Name Description Domain name
REVLV Revision Level REVLV
KTEXT Short Text for Material Sample TEXT80
PNPOS Item Number in Sample-Drawing Procedure NUM4
TPBIS Highest Partial Sample No. Valid for Instruction QPROBEPL
ABDAU Storage Duration of the Material Sample in Days DEC5
ABINF Storage Information for the Material Sample TEXT80
AENNA Last User Who Changed the Sample Record QAENDERER
VENUM Internal Handling Unit Number VENUM
VEPOS Handling Unit Item VEPOS
ADDON_DUMMY Dummy Field for ADDON Structures in QM QDUMMY
ENTORT Location of Sample Drawing (Functional Location) TPLNR
INFEORT Description of Sample-Drawing Location CHAR60
BEARBEITER Processor Responsible for the Sample, Sample Taker CHAR20
LABOR Work Center (Laboratory) QPLEXT_PRPLATZ
DUMMY_QPRS_INCL_EEW_PS Dummy function in length 1 DUMMY
Master Data Relations Join Conditions
Material Sample Location
  • Plant
  • Client
  • Material Sample Location
  • QPRS.WERKS == TQ41.WERKS
  • QPRS.MANDT == TQ41.MANDT
  • QPRS.ABORT == TQ41.AUFBEWORT
Batch Number
  • Material Number
  • Client
  • Batch Number
  • QPRS.MATNR == MCH1.MATNR
  • QPRS.MANDT == MCH1.MANDT
  • QPRS.CHARG == MCH1.CHARG
Material Sample Container
  • QPRS.MANDT == TQ42.MANDT
  • QPRS.GBTYP == TQ42.GEBINDETYP
Lot Container
  • QPRS.MANDT == T006.MANDT
  • QPRS.GEBEH == T006.MSEHI
Storage location
  • Storage location
  • Client
  • Plant
  • QPRS.LGORT == T001L.LGORT
  • QPRS.MANDT == T001L.MANDT
  • QPRS.WERKS == T001L.WERKS
Client QPRS.MANDT == T000.MANDT
Material Number
  • Material Number
  • Client
  • QPRS.MATNR == MARA.MATNR
  • QPRS.MANDT == MARA.MANDT
Unit of Measure for Material Sample Size
  • QPRS.MANDT == T006.MANDT
  • QPRS.MEINH == T006.MSEHI
Sample-Drawing Procedure
  • Sample-Drawing Procedure
  • Version No. of the Sample-Drawing Procedure
  • Client
  • QPRS.PNVER == QPRVK.PRZIEHVERF
  • QPRS.PNVEV == QPRVK.VERSION
  • QPRS.MANDT == QPRVK.MANDT
Version No. of the Sample-Drawing Procedure
  • Sample-Drawing Procedure
  • Version No. of the Sample-Drawing Procedure
  • Client
  • QPRS.PNVER == QPRVK.PRZIEHVERF
  • QPRS.PNVEV == QPRVK.VERSION
  • QPRS.MANDT == QPRVK.MANDT
Physical-sample type
  • Material Sample Type
  • Client
  • QPRS.PRART == TQ40.PRART
  • QPRS.MANDT == TQ40.MANDT
Primary Packaging (Stability Study)
  • Primary Packaging (Stability Study)
  • Client
  • QPRS.PRIMPACK == TQ45.PRIMPACK
  • QPRS.MANDT == TQ45.MANDT
Sample Category QPRS.PRTYP == TQ44.PRTYP
Material Authorization Group for Activities in QM
  • QPRS.MANDT == TQ01B.MANDT
  • QPRS.QAUTH == TQ01B.QMATAUTH
Storage Condition
  • QPRS.MANDT == TQ43.MANDT
  • QPRS.STABICON == TQ43.STABICON
Status Profile for Material Samples
  • QPRS.MANDT == TJ20.MANDT
  • QPRS.STSMA == TJ20.STSMA
Plant
  • QPRS.MANDT == T001W.MANDT
  • QPRS.WERKS == T001W.WERKS