SAP ABAP Table LQPRS (List Output Structure for Physical Samples)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ QM-IM-SM (Application Component) Sample Management
     ⤷ QPR (Package) QM sample management

Basic Data

Table Category	INTTAB	Structure
Structure	LQPRS	Table Relationship Diagram
Short Description	List Output Structure for Physical Samples

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	.INCLUDE	☐				0	0	Master record for phys. samples
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	PHYNR	☐	QPHYSPRNR	QPHYSPRNR	CHAR	12	0	Physical Sample Number	*
4	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	ONR00
5	STSMA	☐	QSTSMA_PRS	J_STSMA	CHAR	8	0	Status Profile for Physical Samples	TJ20
6	PRART	☐	QPRART	QPRART	CHAR	2	0	Physical-Sample Type	TQ40
7	PRTYP	☐	QPRTYP	QPRTYP	CHAR	1	0	Sample Category	TQ44
8	PN_NR	☐	QPZNR	NUMC12	NUMC	12	0	Sample-Drawing Number	QPRN
9	XMANU	☐	QPRB_MAN	QKZ	CHAR	1	0	Manually Created Sample
10	GBTYP	☐	QGEBINDET	QGEBINDET	CHAR	6	0	Physical-Sample Container	TQ42
11	MENGE	☐	QPHYSPRUM	QMENGEPLOS	QUAN	13	3	Size of the Physical Sample
12	MEINH	☐	QPHYSPRME	MEINS	UNIT	3	0	Unit of Measure for Physical Sample Size	T006
13	PLOS2	☐	QLOT_LATE	QPLOS	NUMC	12	0	Current or Last Inspection Lot for the Sample	QALS
14	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
15	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
16	REVLV	☐	REVLV	REVLV	CHAR	2	0	Revision level
17	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	MCH1
18	KTEXT	☐	QTEXT_PRS	TEXT80	CHAR	80	0	Short Text for Physical Sample
19	QAUTH	☐	QMATAUTH	QMATAUTH	CHAR	6	0	Material authorization group for activities in QM	TQ01B
20	PNVER	☐	QPRZIEHVER	QPRZIEHVER	CHAR	8	0	Sample-Drawing Procedure	QPRVK
21	PNVEV	☐	QVERSNPRZV	QVERSNR	CHAR	6	0	Version No. of the Sample-Drawing Procedure	QPRVK
22	PNPOS	☐	QZAEHLPRZV	NUM4	NUMC	4	0	Item Number in Sample-Drawing Procedure
23	GEBEH	☐	QGEBEH	MEINS	UNIT	3	0	Lot Container	T006
24	TPBIS	☐	QPROBNRBIS	QPROBEPL	NUMC	3	0	Highest Partial Sample No. Valid for Instruction
25	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
26	ABORT	☐	QAUFBEWORT	QAUFBEWORT	CHAR	12	0	Storage Location for a Physical Sample	TQ41
27	ABDAU	☐	QAUFBDAUER	DEC5	DEC	5	0	Storage Duration of the Physical Sample in Days
28	ABDAT	☐	QAUFBDATUM	DATUM	DATS	8	0	Storage Deadline for Physical Sample
29	ABINF	☐	QAUFBINFO	TEXT80	CHAR	80	0	Storage Information for the Physical Sample
30	AENNA	☐	QPRS_AEN	QAENDERER	CHAR	12	0	Last User who Changed the Physical-Sample Record
31	AENDT	☐	QPRS_AENDT	DATUM	DATS	8	0	Date the Physical Sample Was Changed
32	AENZT	☐	QPRS_AENZT	QZEIT	TIMS	6	0	Time at Which Physical-Sample Record Changed
33	VENUM	☐	VENUM	VENUM	CHAR	10	0	Internal Handling Unit Number	*
34	VEPOS	☐	VEPOS	VEPOS	NUMC	6	0	Handling Unit Item	*
35	.INCLUDE	☐				0	0
36	.INCLUDE	☐				0	0	PLM ADDON for Sample Master Record
37	ADDON_DUMMY	☐	QDUMMY	QDUMMY	CHAR	1	0	Dummy Field for ADDON Structures in QM
38	.INCLU--AP	☐				0	0	Addon Fields for Stability Study
39	PRIMPACK	☐	QPRIMPACK	QPRIMPACK	CHAR	8	0	Primary Packaging (Stability Study)	TQ45
40	STABICON	☐	QSTABICON	QSTABICON	CHAR	8	0	Storage Condition	TQ43
41	EINGDT	☐	QST_EINGDT	DATUM	DATS	8	0	Date of Receipt of Initial Sample for Stability Study
42	EINLDT	☐	QST_EINLDT	DATUM	DATS	8	0	Storage Date of Sample for Storage Condition
43	AUSLDT	☐	QST_AUSLDT	DATUM	DATS	8	0	Date of Removal from Storage of Sample for Storage Condition
44	ENTORT	☐	QPRSENTORT	TPLNR	CHAR	30	0	Location of Sample Drawing (Functional Location)	*
45	INFEORT	☐	QPRSINFEORT	CHAR60	CHAR	60	0	Description of Sample-Drawing Location
46	ENTDATUM	☐	QPRSENTDATUM	DATUM	DATS	8	0	Date of Sample Drawing
47	ENTZEIT	☐	QPRSENTZEIT	QZEIT	TIMS	6	0	Time of Sample Drawing
48	BEARBEITER	☐	QPRSBEARBEITER	CHAR20	CHAR	20	0	Processor Responsible for the Sample, Sample Taker
49	LABOR	☐	QLABOR	QPLEXT_PRPLATZ	CHAR	8	0	Work Center (Laboratory)
50	KUNNR	☐	QKUNWE	KUNNR	CHAR	10	0	Customer (Ship-To Party)	KNA1
51	LIFNR	☐	ELIFN	LIFNR	CHAR	10	0	Vendor's account number	LFA1
52	HRSTL	☐	QLIFNR	LIFNR	CHAR	10	0	Number of Manufacturer	LFA1
53	MBLNR	☐	MBLNR	BELNR	CHAR	10	0	Number of Material Document
54	ZEILE	☐	MBLPO	MBLPO	NUMC	4	0	Item in material document
55	MJAHR	☐	MJAHR	GJAHR	NUMC	4	0	Year of material document
56	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	AUFK
57	VERID	☐	VERID	VERID	CHAR	4	0	Production Version	MKAL
58	SA_AUFNR	☐	SA_AUFNR	SA_AUFNR	CHAR	12	0	Run schedule header number	SAFK
59	KZQUIT	☐	QKZQUIT	QKZ	CHAR	1	0	Confirmation Required for Physical-Sample Drawing
60	SIG_IL_SDR	☐	SIG_IL_SDR	SIG_IL_SDR	CHAR	1	0	Digital Signature for Confirmation of Phys.-Sample Drawing
61	FRGNA	☐	QPRS_FRG	QAENDERER	CHAR	12	0	User who Released the Physical Sample
62	FRGDT	☐	QPRS_FRGDT	DATUM	DATS	8	0	Physical Sample Release Date
63	FRGZT	☐	QPRS_FRGZT	QZEIT	TIMS	6	0	Time of Physical Sample Release
64	PZTXT	☐	QPZ_TEXT	TEXT40	CHAR	40	0	Comments on the Physical-Sample Drawing
65	TXTMAT	☐	QTXTMAT	QKURZTEXT	CHAR	40	0	Material short text
66	TXTLIEF	☐	QTXTLIEF	QKURZTEXT	CHAR	40	0	Name of Vendor
67	TXTHERST	☐	QTXTHERST	QKURZTEXT	CHAR	40	0	Name of Manufacturer
68	TXTKUNDE	☐	QTXTKUNDE	QKURZTEXT	CHAR	40	0	Customer Name
69	STATU	☐	QPRSSTATUS	CHAR40	CHAR	40	0	Internal Status of Physical-Sample Record
70	ANWKZ	☐	CO_ASTEX	KREUZ	CHAR	1	0	User status active
71	ANWST	☐	QPRS_ANWST	CHAR40	CHAR	40	0	User Status of the Physical-Sample Record

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	LQPRS	ABORT	TQ41	AUFBEWORT	KEY	C	CN
2	LQPRS	AUFNR	AUFK	AUFNR
3	LQPRS	CHARG	MCH1	CHARG	REF	C	CN
4	LQPRS	GBTYP	TQ42	GEBINDETYP
5	LQPRS	GEBEH	T006	MSEHI
6	LQPRS	HRSTL	LFA1	LIFNR
7	LQPRS	KUNNR	KNA1	KUNNR
8	LQPRS	LGORT	T001L	LGORT	REF	C	CN
9	LQPRS	LIFNR	LFA1	LIFNR
10	LQPRS	MANDT	T000	MANDT	KEY	1	CN
11	LQPRS	MATNR	MARA	MATNR	REF	C	CN
12	LQPRS	MEINH	T006	MSEHI
13	LQPRS	OBJNR	ONR00	OBJNR	KEY	1	C
14	LQPRS	PLOS2	QALS	PRUEFLOS
15	LQPRS	PNVER	QPRVK	PRZIEHVERF
16	LQPRS	PNVEV	QPRVK	VERSION
17	LQPRS	PN_NR	QPRN	PN_NR	KEY	1	CN
18	LQPRS	PRART	TQ40	PRART	KEY	1	CN
19	LQPRS	PRIMPACK	TQ45	PRIMPACK	REF	1	CN
20	LQPRS	PRTYP	TQ44	PRTYP	REF	1	CN
21	LQPRS	QAUTH	TQ01B	QMATAUTH	REF	C	CN
22	LQPRS	SA_AUFNR	SAFK	AUFNR
23	LQPRS	STABICON	TQ43	STABICON	REF	1	CN
24	LQPRS	STSMA	TJ20	STSMA	REF	C	CN
25	LQPRS	VERID	MKAL	VERID	REF	C	CN
26	LQPRS	WERKS	T001W	WERKS	KEY	1	CN

History

Last changed by/on	SAP	20050411
SAP Release Created in