SAP ABAP Table QIWL (Transfer table for QM subsystems)

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	TRANSP	Transparent table
Transparent table	QIWL	Table Relationship Diagram
Short Description	Transfer table for QM subsystems

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDANT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	SUBSYS	☑	QEIFSUBSYS	QEIFSUBSYS	CHAR	6	0	Subsystem Identifier for QM Subsystem Interface	QISUB
3	PRUEFLOS	☑	QPLOS	QPLOS	NUMC	12	0	Inspection Lot Number	QALS
4	PLNFL	☑	PLNFOLGE	PLNFOLGE	CHAR	6	0	Sequence
5	VORNR	☑	VORNR	VORNR	CHAR	4	0	Operation/Activity Number
6	PRPLATZ	☐	QPRPLATZ	ARBPL	CHAR	8	0	Work Center
7	PRPLATZWRK	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
8	EINFUEGDAT	☐	QEIFEINDAT	DATUM	DATS	8	0	Date Inspection Lot Was Entered in Worklist Table
9	EINFUEGTIM	☐	QEIFEINTIM	QZEIT	TIMS	6	0	Time Inspection Lot Was Entered in Worklist Table
10	AENDERDAT	☐	QEIFCHADAT	DATUM	DATS	8	0	Change Date of an Inspection Lot Entry in Worklist Table
11	AENDERTIM	☐	QEIFCHATIM	QZEIT	TIMS	6	0	Change Time of an Inspection Lot Entry in Worklist Table
12	SENDATERST	☐	QEIFSENDER	DATUM	DATS	8	0	Date of First Transfer
13	SENTIMERST	☐	QEIFSETIER	QZEIT	TIMS	6	0	Time of First Transfer
14	SENDATKOR	☐	QEIFSENDKR	DATUM	DATS	8	0	Date of Correction Transfer
15	SENTIMKOR	☐	QEIFSETIKR	QZEIT	TIMS	6	0	Time of correction transmission
16	SENDSTAT	☐	QEIFSTAREC	QEIFSTAREC	CHAR	1	0	Transfer Status of QM Subsystem
17	PRUEFSTAT	☐	QEIFSTAINS	QEIFSTAINS	CHAR	1	0	Status of Inspection for QM Subsystem
18	ART	☐	QPART	QPART	CHAR	8	0	Inspection Type	TQ30
19	ENSTEHDAT	☐	QEIFENTST	DATUM	DATS	8	0	Date Inspection Lot Was Created for QM Subsystem Interface
20	HERKUNFT	☐	QHERK	QHERK	CHAR	2	0	Inspection Lot Origin	*
21	VORGWERK	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
22	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
23	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	MCH1
24	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	AUFK
25	LIFNR	☐	ELIFN	LIFNR	CHAR	10	0	Vendor's account number	LFA1
26	KUNNR	☐	EKUNN	KUNNR	CHAR	10	0	Account number of customer	KNA1
27	MBLNR	☐	MBLNR	BELNR	CHAR	10	0	Number of Material Document

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	QIWL	ART	TQ30	ART	REF	1	CN
2	QIWL	AUFNR	AUFK	AUFNR	REF	C	CN
3	QIWL	CHARG	MCH1	CHARG	REF	C	CN
4	QIWL	KUNNR	KNA1	KUNNR	REF	C	CN
5	QIWL	LIFNR	LFA1	LIFNR	REF	C	CN
6	QIWL	MANDANT	T000	MANDT	KEY	1	CN
7	QIWL	MATNR	MARA	MATNR	REF	C	CN
8	QIWL	PRPLATZWRK	T001W	WERKS	REF	1	CN
9	QIWL	PRUEFLOS	QALS	PRUEFLOS	KEY	1	CN
10	QIWL	SUBSYS	QISUB	SUBSYS	KEY	1	CN
11	QIWL	VORGWERK	T001W	WERKS	REF	C	CN

History

Last changed by/on	SAP	20020219
SAP Release Created in