SAP ABAP Table QPRN (Sample drawing of phys. 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	TRANSP	Transparent table
Transparent table	QPRN	Table Relationship Diagram
Short Description	Sample drawing of phys. samples

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	PN_NR	☑	QPZNR	NUMC12	NUMC	12	0	Sample-Drawing Number
3	PLOS	☐	QLOT_LATE	QPLOS	NUMC	12	0	Current or Last Inspection Lot for the Sample	QALS
4	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
5	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
6	REVLV	☐	REVLV	REVLV	CHAR	2	0	Revision level
7	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	MCH1
8	KUNNR	☐	QKUNWE	KUNNR	CHAR	10	0	Customer (Ship-To Party)	KNA1
9	LIFNR	☐	ELIFN	LIFNR	CHAR	10	0	Vendor's account number	LFA1
10	HRSTL	☐	QLIFNR	LIFNR	CHAR	10	0	Number of Manufacturer	LFA1
11	MBLNR	☐	MBLNR	BELNR	CHAR	10	0	Number of Material Document
12	ZEILE	☐	MBLPO	MBLPO	NUMC	4	0	Item in material document
13	MJAHR	☐	MJAHR	GJAHR	NUMC	4	0	Year of material document
14	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	AUFK
15	VERID	☐	VERID	VERID	CHAR	4	0	Production Version	MKAL
16	SA_AUFNR	☐	SA_AUFNR	SA_AUFNR	CHAR	12	0	Run schedule header number	SAFK
17	ANLNA	☐	QPRS_ANL	QAENDERER	CHAR	12	0	User who Created the Physical Sample
18	ANLDT	☐	QPRS_ANLDT	DATUM	DATS	8	0	Creation Date of Physical Sample
19	ANLZT	☐	QPRS_ANLZT	QZEIT	TIMS	6	0	Time at Which the Physical Sample Was Created
20	QMATAUTH	☐	QMATAUTH	QMATAUTH	CHAR	6	0	Material authorization group for activities in QM	*
21	KZQUIT	☐	QKZQUIT	QKZ	CHAR	1	0	Confirmation Required for Physical-Sample Drawing
22	SIG_IL_SDR	☐	SIG_IL_SDR	SIG_IL_SDR	CHAR	1	0	Digital Signature for Confirmation of Phys.-Sample Drawing
23	FRGNA	☐	QPRS_FRG	QAENDERER	CHAR	12	0	User who Released the Physical Sample
24	FRGDT	☐	QPRS_FRGDT	DATUM	DATS	8	0	Physical Sample Release Date
25	FRGZT	☐	QPRS_FRGZT	QZEIT	TIMS	6	0	Time of Physical Sample Release
26	PZTXT	☐	QPZ_TEXT	TEXT40	CHAR	40	0	Comments on the Physical-Sample Drawing
27	QMNUM	☐	QMNUM	QMNUM	CHAR	12	0	Message Number	QMEL

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	QPRN	AUFNR	AUFK	AUFNR
2	QPRN	CHARG	MCH1	CHARG
3	QPRN	HRSTL	LFA1	LIFNR
4	QPRN	KUNNR	KNA1	KUNNR
5	QPRN	LIFNR	LFA1	LIFNR
6	QPRN	MANDT	T000	MANDT	KEY	1	CN
7	QPRN	MATNR	MARA	MATNR
8	QPRN	PLOS	QALS	PRUEFLOS
9	QPRN	QMNUM	QMEL	QMNUM	REF	C	CN
10	QPRN	SA_AUFNR	SAFK	AUFNR
11	QPRN	VERID	MKAL	VERID	REF	C	CN
12	QPRN	WERKS	T001W	WERKS

History

Last changed by/on	SAP	20020219
SAP Release Created in