SAP ABAP Table QAIVC_O1 (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_O1	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	PLNTY	☐	PLNTY	PLNTY	CHAR	1	0	Task List Type	TCA01
17	PLNNR	☐	PLNNR	PLNNR	CHAR	8	0	Key for Task List Group
18	PPLVERW	☐	PLN_VERWE	PLN_VERWE	CHAR	3	0	Task list usage	T411
19	PLNAL	☐	PLNAL	ALTNR	CHAR	2	0	Group Counter
20	ZAEHL	☐	QEIFZAEHL	CIM_COUNT	NUMC	8	0	Continuous Counter for Differentiating Database Entries
21	PLANKTEXT	☐	PLANTEXT	TEXT40	CHAR	40	0	Task list description
22	DATUV	☐	QEIFDATUV	DATUM	DATS	8	0	Valid-From Date for Insp. Plan Header (QM Subsys. Interface)
23	PASTRTERM	☐	QEIFSTARTP	DATUM	DATS	8	0	Inspection Start Date (QM Subsystem Interface)
24	PAENDTERM	☐	QEIFENDPR	DATUM	DATS	8	0	End of Inspection Date (QM Subsystem Interface)
25	KUNNR	☐	EKUNN	KUNNR	CHAR	10	0	Account number of customer	KNA1
26	NAME1KUN	☐	QEIFNAM1KU	NAME	CHAR	35	0	Name of Customer for QM Subsystem Interface
27	LIFNR	☐	ELIFN	LIFNR	CHAR	10	0	Vendor's account number	LFA1
28	NAME1LIF	☐	QEIFNAM1LI	NAME	CHAR	35	0	Name of Vendor for QM Subsystem Interface
29	HERSTELLER	☐	QLIFNR	LIFNR	CHAR	10	0	Number of Manufacturer	LFA1
30	NAME1HER	☐	QEIFNAM1HE	NAME	CHAR	35	0	Name of Manufacturer for QM Subsystem Interface
31	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
32	KTEXTMAT	☐	QKTEXTMAT	QKURZTEXT	CHAR	40	0	Material short text
33	KTEXTLOS	☐	QKURZTEXT	QKURZTEXT	CHAR	40	0	Short Text
34	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	MCH1
35	LAGORTCHRG	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
36	LICHN	☐	LICHN	LICHN	CHAR	15	0	Vendor Batch Number
37	IDNLF	☐	IDNLF22	IDNEX22	CHAR	22	0	Material number used by vendor
38	KDMAT	☐	KDMAT22	IDNEX22	CHAR	22	0	Material belonging to the customer
39	POSTX	☐	KDPTX	TEXT40	CHAR	40	0	Customer description of material
40	WERKVORG	☐	QWERKVORG	WERKS	CHAR	4	0	Plant Where Stock for Inspection Lot Is Held	T001W
41	LAGORTVORG	☐	QLGORTVORG	LGORT	CHAR	4	0	Storage Location for Inspection Lot Stock	T001L
42	LOSMENGE	☐	QEIFLOSMG	CHAR17	CHAR	17	0	Lot Quantity as Character String for QM Subsystem Interface
43	MENGENEINH	☐	QEIFMASS	MEINS	UNIT	3	0	Base Unit of Measure for the Inspection Lot	T006
44	GESSTICHPR	☐	QEIFGSTICH	CHAR17	CHAR	17	0	Sample Size for Interface Between QM and Subsystem
45	EINHPROBE	☐	QEIFMASSPR	MEINS	UNIT	3	0	Sample Unit of Measure	T006
46	EBELN	☐	EBELN	EBELN	CHAR	10	0	Purchasing Document Number	EKKO
47	EBELP	☐	EBELP	EBELP	NUMC	5	0	Item Number of Purchasing Document	EKPO
48	MJAHR	☐	MJAHR	GJAHR	NUMC	4	0	Year of material document
49	MBLNR	☐	MBLNR	BELNR	CHAR	10	0	Number of Material Document
50	ZEILE	☐	MBLPO	MBLPO	NUMC	4	0	Item in material document
51	BUDAT	☐	QEIFBUDAT	DATUM	DATS	8	0	Posting Date in Document for QM Interface - Subsystem
52	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	AUFK
53	KDAUF	☐	KDAUF	VBELN	CHAR	10	0	Sales Order Number	VBUK
54	KDPOS	☐	KDPOS	NUM06	NUMC	6	0	Item number in Sales Order
55	VORKTXT	☐	LTXA1	TEXT40	CHAR	40	0	Operation short text
56	PRPLATZ	☐	QPRPLATZ	ARBPL	CHAR	8	0	Work Center
57	PRPLATZWRK	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
58	PRPLATZTXT	☐	QKURZTEXT	QKURZTEXT	CHAR	40	0	Short Text
59	SUBSYS	☐	QEIFSUBSYS	QEIFSUBSYS	CHAR	6	0	Subsystem Identifier for QM Subsystem Interface	QISUB
60	QKZPRZEIT	☐	QKZPRZEIT	QKZ	CHAR	1	0	Interval = Time (Time-Related)
61	QKZPRMENG	☐	QKZPRMENG	QKZ	CHAR	1	0	Creation Cycle = Quantity (Quantity-Reference)
62	QKZPRFREI	☐	QKZPRFREI	QKZ	CHAR	1	0	Interval Without Reference to Time or Quantity
63	QRASTZEHT	☐	QRASTZEHT	MEINS	UNIT	3	0	Time Unit	T006
64	QRASTZFAK	☐	QEIFRASTZF	NUM6	NUMC	6	0	Time Factor
65	QRASTMENG	☐	QEIFRASTMG	CHAR17	CHAR	17	0	Quantity Between Two Inspections
66	QRASTEREH	☐	QRASTEREH	MEINS	UNIT	3	0	Grid Unit of Measure	T006
67	KZUSERC1	☐	QKZUSRAKT	QKZUSRAKT	CHAR	1	0	Field Active
68	SWUSERC1	☐	QUSRSLW	QUSRSLW	CHAR	20	0	Keyword for User Field
69	KZUSERC2	☐	QKZUSRAKT	QKZUSRAKT	CHAR	1	0	Field Active
70	SWUSERC2	☐	QUSRSLW	QUSRSLW	CHAR	20	0	Keyword for User Field
71	KZUSERN1	☐	QKZUSRAKT	QKZUSRAKT	CHAR	1	0	Field Active
72	SWUSERN1	☐	QUSRSLW	QUSRSLW	CHAR	20	0	Keyword for User Field
73	KZUSERN2	☐	QKZUSRAKT	QKZUSRAKT	CHAR	1	0	Field Active
74	SWUSERN2	☐	QUSRSLW	QUSRSLW	CHAR	20	0	Keyword for User Field
75	KZUSERD1	☐	QKZUSRAKT	QKZUSRAKT	CHAR	1	0	Field Active
76	SWUSERD1	☐	QUSRSLW	QUSRSLW	CHAR	20	0	Keyword for User Field
77	KZUSERT1	☐	QKZUSRAKT	QKZUSRAKT	CHAR	1	0	Field Active
78	SWUSERT1	☐	QUSRSLW	QUSRSLW	CHAR	20	0	Keyword for User Field
79	TEILLOSPFL	☐	QEIFTLPFL	QKZ	CHAR	1	0	Partial Lot Assignment Required for an Insp. Point
80	CHARGPFL	☐	XCHPF	XFELD	CHAR	1	0	Batch management requirement indicator
81	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
82	KZKORRTRAN	☐	QEIFKORRTR	QKZ	CHAR	1	0	Correction Transfer Was Carried Out
83	PRUEFSTAT	☐	QEIFSTAINS	QEIFSTAINS	CHAR	1	0	Status of Inspection for QM Subsystem
84	EINHVORG	☐	VORME	MEINS	UNIT	3	0	Unit of measure for activity	*
85	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_O1	ART	TQ30	ART	KEY	1	CN
2	QAIVC_O1	AUFNR	AUFK	AUFNR	KEY	1	CN
3	QAIVC_O1	CHARG	MCH1	CHARG	KEY	1	CN
4	QAIVC_O1	EBELN	EKKO	EBELN
5	QAIVC_O1	EBELP	EKPO	EBELP	KEY	1	CN
6	QAIVC_O1	EINHPROBE	T006	MSEHI	KEY	1	CN
7	QAIVC_O1	HERSTELLER	LFA1	LIFNR	KEY	1	CN
8	QAIVC_O1	KDAUF	VBUK	VBELN	KEY	1	CN
9	QAIVC_O1	KUNNR	KNA1	KUNNR	KEY	1	CN
10	QAIVC_O1	LAGORTCHRG	T001L	LGORT
11	QAIVC_O1	LAGORTVORG	T001L	LGORT	KEY	1	CN
12	QAIVC_O1	LIFNR	LFA1	LIFNR	KEY	1	CN
13	QAIVC_O1	MATNR	MARA	MATNR	KEY	1	CN
14	QAIVC_O1	MENGENEINH	T006	MSEHI	KEY	1	CN
15	QAIVC_O1	PLNTY	TCA01	PLNTY	KEY	1	CN
16	QAIVC_O1	PPLVERW	T411	VERWE	KEY	1	CN
17	QAIVC_O1	PRPLATZWRK	T001W	WERKS	KEY	1	CN
18	QAIVC_O1	PRUEFLOS	QALS	PRUEFLOS	KEY	1	CN
19	QAIVC_O1	QRASTEREH	T006	MSEHI	KEY	1	CN
20	QAIVC_O1	QRASTZEHT	T006	MSEHI	KEY	1	CN
21	QAIVC_O1	SUBSYS	QISUB	SUBSYS	KEY	1	CN
22	QAIVC_O1	VAUSWAHLMG	QPAM	AUSWAHLMGE	KEY	1	CN
23	QAIVC_O1	VKATART	TQ15	KATALOGART	KEY	1	CN
24	QAIVC_O1	VWERKS	T001W	WERKS	KEY	1	CN
25	QAIVC_O1	WERK	T001W	WERKS	KEY	1	CN
26	QAIVC_O1	WERKVORG	T001W	WERKS	KEY	1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in