QPRS - Master Record for Material Samples

Master Record for Material Samples information is stored in SAP table QPRS.
It is part of development package QPR in software component QM-IM-SM. This development package consists of objects that can be grouped under "QM sample management".

Fields for table QPRS

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6	T000
PHYNR	Material Sample Number	X	QPHYSPRNR	CHAR	24
OBJNR	Object number		J_OBJNR	CHAR	44	ONR00
STSMA	Status Profile for Material Samples		QSTSMA_PRS	CHAR	16	TJ20
PRART	Material Sample Type		QPRART	CHAR	4	TQ40
PRTYP	Sample Category		QPRTYP	CHAR	2	TQ44
PN_NR	Sample-Drawing Number		QPZNR	NUMC	24	QPRN
XMANU	Manually Created Sample		QPRB_MAN	CHAR	2
GBTYP	Material Sample Container		QGEBINDET	CHAR	12	TQ42
MENGE	Size of Material Sample		QPHYSPRUM	QUAN	7
MEINH	Unit of Measure for Material Sample Size		QPHYSPRME	UNIT	6	T006
PLOS2	Current or Last Inspection Lot for the Sample		QLOT_LATE	NUMC	24	QALS
MATNR	Material Number		MATNR	CHAR	80	MARA
WERKS	Plant		WERKS_D	CHAR	8	T001W
REVLV	Revision Level		REVLV	CHAR	4
CHARG	Batch Number		CHARG_D	CHAR	20	MCH1
KTEXT	Short Text for Material Sample		QTEXT_PRS	CHAR	160
QAUTH	Material Authorization Group for Activities in QM		QMATAUTH	CHAR	12	TQ01B
PNVER	Sample-Drawing Procedure		QPRZIEHVER	CHAR	16	QPRVK
PNVEV	Version No. of the Sample-Drawing Procedure		QVERSNPRZV	CHAR	12	QPRVK
PNPOS	Item Number in Sample-Drawing Procedure		QZAEHLPRZV	NUMC	8
GEBEH	Lot Container		QGEBEH	UNIT	6	T006
TPBIS	Highest Partial Sample No. Valid for Instruction		QPROBNRBIS	NUMC	6
LGORT	Storage location		LGORT_D	CHAR	8	T001L
ABORT	Material Sample Location		QAUFBEWORT	CHAR	24	TQ41
ABDAU	Storage Duration of the Material Sample in Days		QAUFBDAUER	DEC	3
ABDAT	Storage Deadline for Sample		QAUFBDATUM	DATS	16
ABINF	Storage Information for the Material Sample		QAUFBINFO	CHAR	160
AENNA	Last User Who Changed the Sample Record		QPRS_AEN	CHAR	24
AENDT	System Date When Sample Changed		QPRS_AENDT	DATS	16
AENZT	System Time When Sample Record Changed		QPRS_AENZT	TIMS	12
VENUM	Internal Handling Unit Number		VENUM	CHAR	20
VEPOS	Handling Unit Item		VEPOS	NUMC	12
.INCLUDE				CI_QPRS	0
.INCLUDE				QPRS_ADDON	0
ADDON_DUMMY	Dummy Field for ADDON Structures in QM		QDUMMY	CHAR	2
.INCLU--AP				QSTQPRS0001	0
PRIMPACK	Primary Packaging (Stability Study)		QPRIMPACK	CHAR	16	TQ45
STABICON	Storage Condition		QSTABICON	CHAR	16	TQ43
EINGDT	Date of Receipt of Initial Sample for Stability Study		QST_EINGDT	DATS	16
EINLDT	Storage Date of Sample for Storage Condition		QST_EINLDT	DATS	16
AUSLDT	Date of Removal from Storage of Sample for Storage Condition		QST_AUSLDT	DATS	16
ENTORT	Location of Sample Drawing (Functional Location)		QPRSENTORT	CHAR	60
INFEORT	Description of Sample-Drawing Location		QPRSINFEORT	CHAR	120
ENTDATUM	Date of Sample Drawing		QPRSENTDATUM	DATS	16
ENTZEIT	Time of Sample Drawing		QPRSENTZEIT	TIMS	12
BEARBEITER	Processor Responsible for the Sample, Sample Taker		QPRSBEARBEITER	CHAR	40
LABOR	Work Center (Laboratory)		QLABOR	CHAR	16
.INCLUDE	EXT			QPRS_INCL_EEW_PS	0
DUMMY_QPRS_INCL_EEW_PS	Dummy function in length 1		DUMMY	CHAR	2