SAP ABAP Table QFKPR (Header record for defects recording)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ QF (Package) QM defects recording

Basic Data

Table Category	INTTAB	Structure
Structure	QFKPR	Table Relationship Diagram
Short Description	Header record for defects recording

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	PRUEFLOS	☐	QPLOS	QPLOS	NUMC	12	0	Inspection Lot Number	*
2	AUFPL	☐	CO_AUFPL	AUFPL	NUMC	10	0	Routing number of operations in the order
3	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
4	REVLV	☐	REVLV	REVLV	CHAR	2	0	Revision level
5	RKMNG	☐	RKMNG	MENGE	QUAN	13	3	Complaint Quantity
6	BZMNG	☐	BZMNG	MENG13	QUAN	13	3	Quantity for delivery costs
7	MGEIN	☐	MGEIN	MEINS	UNIT	3	0	Unit of Measure	*
8	KTEXTMAT	☐	QKTEXTMAT	QKURZTEXT	CHAR	40	0	Material short text
9	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	*
10	LICHN	☐	LICHN	LICHN	CHAR	15	0	Vendor Batch Number
11	ART	☐	QPART	QPART	CHAR	8	0	Inspection Type	*
12	FEART	☐	QFEART	QFEART	CHAR	8	0	Report Type for Defects Recording	TQ86
13	RPROFIL	☐	QRPROFIL	QRPROFIL	CHAR	4	0	Confirmation Profile	*
14	RBNR	☐	RBNR	RBNR	CHAR	9	0	Report layout	*
15	QMART	☐	QMART	QMART	CHAR	2	0	Message Type	*
16	QMTYP	☐	QMTYP	QMTYP	CHAR	2	0	Message Category	*
17	OBJNR_LOS	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	*
18	HERKUNFT	☐	QHERK	QHERK	CHAR	2	0	Inspection Lot Origin	*
19	IHAUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	*
20	FERTAUFPL	☐	FERTAUFPL	AUFPL	NUMC	10	0	Plan Number for Operations in Order (Production Order)
21	FERTAUFNR	☐	FERTAUFNR	AUFNR	CHAR	12	0	Order Number (Production Order)	*
22	VERID	☐	VERID	VERID	CHAR	4	0	Production Version	MKAL
23	SA_AUFNR	☐	SA_AUFNR	SA_AUFNR	CHAR	12	0	Run schedule header number	SAFK
24	MJAHR	☐	MJAHR	GJAHR	NUMC	4	0	Year of material document
25	MBLNR	☐	MBLNR	BELNR	CHAR	10	0	Number of Material Document
26	MBLPO	☐	MBLPO	MBLPO	NUMC	4	0	Item in material document
27	EBELN	☐	EBELN	EBELN	CHAR	10	0	Purchasing Document Number	*
28	EBELP	☐	EBELP	EBELP	NUMC	5	0	Item Number of Purchasing Document	*
29	LS_KDAUF	☐	KDAUF	VBELN	CHAR	10	0	Sales Order Number	*
30	LS_KDPOS	☐	KDPOS	NUM06	NUMC	6	0	Item number in Sales Order
31	LS_VBELN	☐	VBELN_VL	VBELN	CHAR	10	0	Delivery	*
32	LS_POSNR	☐	POSNR_VL	POSNR	NUMC	6	0	Delivery Item	*
33	WERK	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
34	LIFNUM	☐	LIFNUM	LIFNR	CHAR	10	0	Vendor Account Number	*
35	HERSTELLER	☐	QLIFNR	LIFNR	CHAR	10	0	Number of Manufacturer	*
36	EMATNR	☐	EMATNR	MATNR	CHAR	18	0	Material number	*
37	EKORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	*
38	BKGRP	☐	BKGRP	EKGRP	CHAR	3	0	Purchasing Group	*
39	IDNLF	☐	IDNLF	IDNEX	CHAR	35	0	Material Number Used by Vendor
40	KUNUM	☐	KUNUM	KUNNR	CHAR	10	0	Customer Number	*
41	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	*
42	SERNP	☐	SERAIL	SERAIL	CHAR	4	0	Serial Number Profile	*
43	ACT_ANZSN	☐	ANZSN	INT4	INT4	10	0	Number of serial numbers
44	REQ_SERNR	☐	QKZMUSER	QKZ	CHAR	1	0	External Numbering of Units to Be Inspected is required
45	OPT_SERNR	☐	QKZKASER	QKZ	CHAR	1	0	External Numbering of Units to Be Inspected is Optional
46	NO_SERNR	☐	QKZNOSER	QKZ	CHAR	1	0	No External Numbering of Units to Be Inspected
47	FLG_PRFPKT	☐	QKZFERTPRF	QKZ	CHAR	1	0	Inspection with Inspection Points
48	TPLNR	☐	TPLNR	TPLNR	CHAR	30	0	Functional Location	*
49	EQUNR	☐	EQUNR	EQUNR	CHAR	18	0	Equipment Number	*
50	PHYNR	☐	QPHYSPRNR	QPHYSPRNR	CHAR	12	0	Physical Sample Number	*
51	PRUEFER	☐	QPRUEFER	QPRUEFER	CHAR	12	0	Name of the Inspector
52	PRUEFDATUV	☐	QPRUEFDATV	DATUM	DATS	8	0	Inspection Start Date
53	PRUEFZEITV	☐	QPRUEFZTV	QZEIT	TIMS	6	0	Starting Time of the Inspection
54	LGORTCHARG	☐	QLGORTCHAR	LGORT	CHAR	4	0	Storage Location of Batch	*
55	LGORTVORG	☐	QLGORTVORG	LGORT	CHAR	4	0	Storage Location for Inspection Lot Stock	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	QFKPR	FEART	TQ86	FEART
2	QFKPR	SA_AUFNR	SAFK	AUFNR
3	QFKPR	VERID	MKAL	VERID

History

Last changed by/on	SAP	20040819
SAP Release Created in