SAP ABAP Table QAIVC (Insp. lot operation header data for download to QM subsystem)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ QEIF (Package) QM interfaces inspection processing

Basic Data

Table Category	INTTAB	Structure
Structure	QAIVC	Table Relationship Diagram
Short Description	Insp. lot operation header data for download to QM subsystem

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	SATZART	☑	QEIFART	QEIFART	CHAR	3	0	Record Types for QM Interface - Subsystems
2	PRUEFLOS	☑	QPLOS	QPLOS	NUMC	12	0	Inspection Lot Number	QALS
3	PLNFL	☑	PLNFOLGE	PLNFOLGE	CHAR	6	0	Sequence
4	VORNR	☑	VORNR	VORNR	CHAR	4	0	Operation/Activity Number
5	WERK	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
6	ART	☐	QPART	QPART	CHAR	8	0	Inspection Type	TQ30
7	HERKUNFT	☐	QHERK	QHERK	CHAR	2	0	Inspection Lot Origin	*
8	ENTSTEHDAT	☐	QEIFENTST	DATUM	DATS	8	0	Date Inspection Lot Was Created for QM Subsystem Interface
9	ERSTELLER	☐	QERSTELLER	QAENDERER	CHAR	12	0	Name of User Who Created the Data Record
10	AENDERER	☐	QAENDERER	QAENDERER	CHAR	12	0	Name of User who Most Recently Changed the Data Record
11	AENDERDAT	☐	QEIFAEDAT	DATUM	DATS	8	0	Date Inspection Lot Was Last Changed
12	KZVESUBSYS	☐	QEIFVESUBS	QKZ	CHAR	1	0	Indicator: Should Usage Decision Be Made in Subsystem
13	VKATART	☐	QKATART	QKATART	CHAR	1	0	Catalog	TQ15
14	VWERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
15	VAUSWAHLMG	☐	QVMENGE	QAUSWAHLMG	CHAR	8	0	Selected Set of the Usage Decision	QPAM
16	PPVEKATART	☐	QKATART	QKATART	CHAR	1	0	Catalog	*
17	PPVEWERK	☐	QPPVEWERK	WERKS	CHAR	4	0	Plant of Selected Set for Inspection Point Valuation	*
18	PPVEMENGE	☐	QPPVEMENGE	QAUSWAHLMG	CHAR	8	0	Selected Set for Inspection Point Valuation	*
19	PPVECODGRA	☐	QPPVECODGR	QCODEGRP	CHAR	8	0	Code Group for Inspection Point Valuation	*
20	PPVECODEA	☐	QPPVECODA	QCODE	CHAR	4	0	Code for Inspection Point Valuation (Accepted)	*
21	PPVECODGRR	☐	QPPVECODGR	QCODEGRP	CHAR	8	0	Code Group for Inspection Point Valuation	*
22	PPVECODER	☐	QPPVECODR	QCODE	CHAR	4	0	Code for Inspection Point Valuation (Rejected)	*
23	PLNTY	☐	PLNTY	PLNTY	CHAR	1	0	Task List Type	TCA01
24	PLNNR	☐	PLNNR	PLNNR	CHAR	8	0	Key for Task List Group
25	PPLVERW	☐	PLN_VERWE	PLN_VERWE	CHAR	3	0	Task list usage	T411
26	PLNAL	☐	PLNAL	ALTNR	CHAR	2	0	Group Counter
27	ZAEHL	☐	QEIFZAEHL	CIM_COUNT	NUMC	8	0	Continuous Counter for Differentiating Database Entries
28	PLANKTEXT	☐	PLANTEXT	TEXT40	CHAR	40	0	Task list description
29	DATUV	☐	QEIFDATUV	DATUM	DATS	8	0	Valid-From Date for Insp. Plan Header (QM Subsys. Interface)
30	PASTRTERM	☐	QEIFSTARTP	DATUM	DATS	8	0	Inspection Start Date (QM Subsystem Interface)
31	PAENDTERM	☐	QEIFENDPR	DATUM	DATS	8	0	End of Inspection Date (QM Subsystem Interface)
32	KUNNR	☐	EKUNN	KUNNR	CHAR	10	0	Account number of customer	KNA1
33	NAME1KUN	☐	QEIFNAM1KU	NAME	CHAR	35	0	Name of Customer for QM Subsystem Interface
34	LIFNR	☐	ELIFN	LIFNR	CHAR	10	0	Vendor's account number	LFA1
35	NAME1LIF	☐	QEIFNAM1LI	NAME	CHAR	35	0	Name of Vendor for QM Subsystem Interface
36	HERSTELLER	☐	QLIFNR	LIFNR	CHAR	10	0	Number of Manufacturer	LFA1
37	NAME1HER	☐	QEIFNAM1HE	NAME	CHAR	35	0	Name of Manufacturer for QM Subsystem Interface
38	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
39	KTEXTMAT	☐	QKTEXTMAT	QKURZTEXT	CHAR	40	0	Material short text
40	KTEXTLOS	☐	QKURZTEXT	QKURZTEXT	CHAR	40	0	Short Text
41	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	MCH1
42	LAGORTCHRG	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
43	LICHN	☐	LICHN	LICHN	CHAR	15	0	Vendor Batch Number
44	IDNLF	☐	IDNLF	IDNEX	CHAR	35	0	Material Number Used by Vendor
45	KDMAT	☐	KDMAT	IDNEX	CHAR	35	0	Material belonging to the customer
46	POSTX	☐	KDPTX	TEXT40	CHAR	40	0	Customer description of material
47	WERKVORG	☐	QWERKVORG	WERKS	CHAR	4	0	Plant Where Stock for Inspection Lot Is Held	T001W
48	LAGORTVORG	☐	QLGORTVORG	LGORT	CHAR	4	0	Storage Location for Inspection Lot Stock	T001L
49	LOSMENGE	☐	QEIFLOSMG	CHAR17	CHAR	17	0	Lot Quantity as Character String for QM Subsystem Interface
50	MENGENEINH	☐	QEIFMASS	MEINS	UNIT	3	0	Base Unit of Measure for the Inspection Lot	T006
51	GESSTICHPR	☐	QEIFGSTICH	CHAR17	CHAR	17	0	Sample Size for Interface Between QM and Subsystem
52	EINHPROBE	☐	QEIFMASSPR	MEINS	UNIT	3	0	Sample Unit of Measure	T006
53	EBELN	☐	EBELN	EBELN	CHAR	10	0	Purchasing Document Number	EKKO
54	EBELP	☐	EBELP	EBELP	NUMC	5	0	Item Number of Purchasing Document	EKPO
55	MJAHR	☐	MJAHR	GJAHR	NUMC	4	0	Year of material document
56	MBLNR	☐	MBLNR	BELNR	CHAR	10	0	Number of Material Document
57	ZEILE	☐	MBLPO	MBLPO	NUMC	4	0	Item in material document
58	BUDAT	☐	QEIFBUDAT	DATUM	DATS	8	0	Posting Date in Document for QM Interface - Subsystem
59	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	AUFK
60	KDAUF	☐	KDAUF	VBELN	CHAR	10	0	Sales Order Number	VBUK
61	KDPOS	☐	KDPOS	NUM06	NUMC	6	0	Item number in Sales Order
62	VORKTXT	☐	LTXA1	TEXT40	CHAR	40	0	Operation short text
63	PRPLATZ	☐	QPRPLATZ	ARBPL	CHAR	8	0	Work Center
64	PRPLATZWRK	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
65	PRPLATZTXT	☐	QKURZTEXT	QKURZTEXT	CHAR	40	0	Short Text
66	SUBSYS	☐	QEIFSUBSYS	QEIFSUBSYS	CHAR	6	0	Subsystem Identifier for QM Subsystem Interface	QISUB
67	QKZPRZEIT	☐	QKZPRZEIT	QKZ	CHAR	1	0	Interval = Time (Time-Related)
68	QKZPRMENG	☐	QKZPRMENG	QKZ	CHAR	1	0	Creation Cycle = Quantity (Quantity-Reference)
69	QKZPRFREI	☐	QKZPRFREI	QKZ	CHAR	1	0	Interval Without Reference to Time or Quantity
70	QRASTZEHT	☐	QRASTZEHT	MEINS	UNIT	3	0	Time Unit	T006
71	QRASTZFAK	☐	QEIFRASTZF	NUM6	NUMC	6	0	Time Factor
72	QRASTMENG	☐	QEIFRASTMG	CHAR17	CHAR	17	0	Quantity Between Two Inspections
73	QRASTEREH	☐	QRASTEREH	MEINS	UNIT	3	0	Grid Unit of Measure	T006
74	PPKTTYP	☐	QPPKTTYP	QPPKTTYP	CHAR	1	0	Inspection Point Type
75	KZEQUNR	☐	QKZUSRAKT	QKZUSRAKT	CHAR	1	0	Field Active
76	SWEQUNR	☐	QUSRSLW	QUSRSLW	CHAR	20	0	Keyword for User Field
77	KZTPLNR	☐	QKZUSRAKT	QKZUSRAKT	CHAR	1	0	Field Active
78	SWTPLNR	☐	QUSRSLW	QUSRSLW	CHAR	20	0	Keyword for User Field
79	KZPHYNR	☐	QKZUSRAKT	QKZUSRAKT	CHAR	1	0	Field Active
80	SWPHYNR	☐	QUSRSLW	QUSRSLW	CHAR	20	0	Keyword for User Field
81	KZUSERC1	☐	QKZUSRAKT	QKZUSRAKT	CHAR	1	0	Field Active
82	SWUSERC1	☐	QUSRSLW	QUSRSLW	CHAR	20	0	Keyword for User Field
83	KZUSERC2	☐	QKZUSRAKT	QKZUSRAKT	CHAR	1	0	Field Active
84	SWUSERC2	☐	QUSRSLW	QUSRSLW	CHAR	20	0	Keyword for User Field
85	KZUSERN1	☐	QKZUSRAKT	QKZUSRAKT	CHAR	1	0	Field Active
86	SWUSERN1	☐	QUSRSLW	QUSRSLW	CHAR	20	0	Keyword for User Field
87	KZUSERN2	☐	QKZUSRAKT	QKZUSRAKT	CHAR	1	0	Field Active
88	SWUSERN2	☐	QUSRSLW	QUSRSLW	CHAR	20	0	Keyword for User Field
89	KZUSERD1	☐	QKZUSRAKT	QKZUSRAKT	CHAR	1	0	Field Active
90	SWUSERD1	☐	QUSRSLW	QUSRSLW	CHAR	20	0	Keyword for User Field
91	KZUSERT1	☐	QKZUSRAKT	QKZUSRAKT	CHAR	1	0	Field Active
92	SWUSERT1	☐	QUSRSLW	QUSRSLW	CHAR	20	0	Keyword for User Field
93	TEILLOSPFL	☐	QEIFTLPFL	QKZ	CHAR	1	0	Partial Lot Assignment Required for an Insp. Point
94	CHARGPFL	☐	XCHPF	XFELD	CHAR	1	0	Batch management requirement indicator
95	QUANTITIES	☐	QIBPQUANT	XFELD	CHAR	1	0	Quantities Must Be Assigned
96	EVALUATION	☐	QIBPEVAL	XFELD	CHAR	1	0	Valuation Required
97	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
98	KZKORRTRAN	☐	QEIFKORRTR	QKZ	CHAR	1	0	Correction Transfer Was Carried Out
99	PRUEFSTAT	☐	QEIFSTAINS	QEIFSTAINS	CHAR	1	0	Status of Inspection for QM Subsystem
100	EINHVORG	☐	VORME	MEINS	UNIT	3	0	Unit of measure for activity	*
101	RUECKMPP	☐	QKZ	QKZ	CHAR	1	0	X and Blank (Indicator)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	QAIVC	ART	TQ30	ART	KEY	1	CN
2	QAIVC	AUFNR	AUFK	AUFNR	KEY	1	CN
3	QAIVC	CHARG	MCH1	CHARG	KEY	1	CN
4	QAIVC	EBELN	EKKO	EBELN
5	QAIVC	EBELP	EKPO	EBELP	KEY	1	CN
6	QAIVC	EINHPROBE	T006	MSEHI	KEY	1	CN
7	QAIVC	HERSTELLER	LFA1	LIFNR	KEY	1	CN
8	QAIVC	KDAUF	VBUK	VBELN	KEY	1	CN
9	QAIVC	KUNNR	KNA1	KUNNR	KEY	1	CN
10	QAIVC	LAGORTCHRG	T001L	LGORT
11	QAIVC	LAGORTVORG	T001L	LGORT	KEY	1	CN
12	QAIVC	LIFNR	LFA1	LIFNR	KEY	1	CN
13	QAIVC	MATNR	MARA	MATNR	KEY	1	CN
14	QAIVC	MENGENEINH	T006	MSEHI	KEY	1	CN
15	QAIVC	PLNTY	TCA01	PLNTY	KEY	1	CN
16	QAIVC	PPLVERW	T411	VERWE	KEY	1	CN
17	QAIVC	PRPLATZWRK	T001W	WERKS	KEY	1	CN
18	QAIVC	PRUEFLOS	QALS	PRUEFLOS	KEY	1	CN
19	QAIVC	QRASTEREH	T006	MSEHI	KEY	1	CN
20	QAIVC	QRASTZEHT	T006	MSEHI	KEY	1	CN
21	QAIVC	SUBSYS	QISUB	SUBSYS	KEY	1	CN
22	QAIVC	VAUSWAHLMG	QPAM	AUSWAHLMGE	KEY	1	CN
23	QAIVC	VKATART	TQ15	KATALOGART	KEY	1	CN
24	QAIVC	VWERKS	T001W	WERKS	KEY	1	CN
25	QAIVC	WERK	T001W	WERKS	KEY	1	CN
26	QAIVC	WERKVORG	T001W	WERKS	KEY	1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in