SAP ABAP Table QAILS (Requirement for downloading an inspLot operation header rec.)

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	QAILS	Table Relationship Diagram
Short Description	Requirement for downloading an inspLot operation header rec.

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	LOSNR_VON	☐	QPLOS	QPLOS	NUMC	12	0	Inspection Lot Number	QALS
3	LOSNR_BIS	☐	QPLOS	QPLOS	NUMC	12	0	Inspection Lot Number	QALS
4	PLNFL	☐	PLNFOLGE	PLNFOLGE	CHAR	6	0	Sequence
5	VORNR_VON	☐	VORNR	VORNR	CHAR	4	0	Operation/Activity Number
6	VORNR_BIS	☐	VORNR	VORNR	CHAR	4	0	Operation/Activity Number
7	VORGWERK	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
8	SUBSYS	☐	QEIFSUBSYS	QEIFSUBSYS	CHAR	6	0	Subsystem Identifier for QM Subsystem Interface	QISUB
9	PRPLATZ	☐	QPRPLATZ	ARBPL	CHAR	8	0	Work Center
10	PRPLATZWRK	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
11	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
12	DATUM_VON	☐	QEIFENTST	DATUM	DATS	8	0	Date Inspection Lot Was Created for QM Subsystem Interface
13	DATUM_BIS	☐	QEIFENTST	DATUM	DATS	8	0	Date Inspection Lot Was Created for QM Subsystem Interface
14	PRUEFSTAT	☐	QEIFSTAINS	QEIFSTAINS	CHAR	1	0	Status of Inspection for QM Subsystem
15	ART	☐	QPART	QPART	CHAR	8	0	Inspection Type	TQ30
16	HERKUNFT	☐	QHERK	QHERK	CHAR	2	0	Inspection Lot Origin	*
17	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	MCH1
18	AUFNR_VON	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	AUFK
19	AUFNR_BIS	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	AUFK
20	LIFNR	☐	ELIFN	LIFNR	CHAR	10	0	Vendor's account number	LFA1
21	KUNNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	KNA1
22	MBLNR	☐	MBLNR	BELNR	CHAR	10	0	Number of Material Document
23	MAXLOSANZ	☐	QEIFMAXANZ	NUMC4	NUMC	4	0	Maximum Number of Lots to be Transferred to a Subsystem

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	QAILS	ART	TQ30	ART	KEY	1	CN
2	QAILS	AUFNR_BIS	AUFK	AUFNR	KEY	1	CN
3	QAILS	AUFNR_VON	AUFK	AUFNR	KEY	1	CN
4	QAILS	CHARG	MCH1	CHARG	KEY	1	CN
5	QAILS	KUNNR	KNA1	KUNNR	KEY	1	CN
6	QAILS	LIFNR	LFA1	LIFNR	KEY	1	CN
7	QAILS	LOSNR_BIS	QALS	PRUEFLOS	KEY	1	CN
8	QAILS	LOSNR_VON	QALS	PRUEFLOS	KEY	1	CN
9	QAILS	MATNR	MARA	MATNR	KEY	1	CN
10	QAILS	PRPLATZWRK	T001W	WERKS	KEY	1	CN
11	QAILS	SUBSYS	QISUB	SUBSYS	KEY	1	CN
12	QAILS	VORGWERK	T001W	WERKS	KEY	1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in