SAP ABAP View BIW_EQUI (QM/PM/CS-BW Extraction View for Equipment)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ QM-QC-IS (Application Component) Information System
     ⤷ QG04 (Package) QM/BW Connection

Basic Data

View Type	D	Database View
Database View	BIW_EQUI
Short Description	QM/PM/CS-BW Extraction View for Equipment
Root table	EQUI	Equipment master data

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	EQUI	EQUI
2	EQUZ
3	ILOA

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	EQUI	MANDT	JL	EQ				0	0
2	EQUZ	MANDT	JR	EQ			AND	0	0
3	EQUI	EQUNR	JL	EQ				0	0
4	EQUZ	EQUNR	JR	EQ			AND	0	0
5	ILOA	MANDT	JL	EQ				0	0
6	EQUZ	MANDT	JR	EQ			AND	0	0
7	ILOA	ILOAN	JL	EQ				0	0
8	EQUZ	ILOAN	JR	EQ			AND	0	0
9	EQUZ	EQLFN		EQ	'001'			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	EQUI	MANDT		☐	MANDT	☐	Client
2	EQUNR	EQUI	EQUNR		☐	EQUNR	☐	Equipment Number
3	DATETO	EQUZ	DATBI		☐	DATBI	☐	Valid To Date
4	DATEFROM	EQUZ	DATAB		☐	DATAB	☐	Valid-From Date
5	EQART	EQUI	EQART		☐	EQART	☐	Type of Technical Object
6	INVNR	EQUI	INVNR		☐	INVNR	☐	Inventory number
7	IWERK	EQUZ	IWERK		☐	IWERK	☐	Maintenance Planning Plant
8	INGRP	EQUZ	INGRP		☐	INGRP	☐	Planner Group for Customer Service and Plant Maintenance
9	ABCKZ	ILOA	ABCKZ		☐	ABCKZ	☐	ABC Indicator for Technical Object
10	KOKRS	ILOA	KOKRS		☐	KOKRS	☐	Controlling Area
11	KOSTL	ILOA	KOSTL		☐	KOSTL	☐	Cost Center
12	TPLNR	ILOA	TPLNR		☐	TPLNR	☐	Functional Location
13	SWERK	ILOA	SWERK		☐	SWERK	☐	Maintenance Plant
14	STORT	ILOA	STORT		☐	PMLOC	☐	Location of maintenance object
15	BEBER	ILOA	BEBER		☐	BEBER	☐	Organizational Area
16	MSGRP	ILOA	MSGRP		☐	RAUMNR	☐	Room
17	ADRNR	ILOA	ADRNR		☐	AD_ADDRNUM	☐	Address number
18	BUKRS	ILOA	BUKRS		☐	BUKRS	☐	Company Code
19	ANLNR	ILOA	ANLNR		☐	ANLN1	☐	Main Asset Number
20	MATNR	EQUI	MATNR		☐	MATNR	☐	Material Number
21	WERK	EQUI	WERK		☐	WERKS_D	☐	Plant
22	ANSWT	EQUI	ANSWT		☐	ANSWT	☐	Acquisition Value
23	WAERS	EQUI	WAERS		☐	WAERS	☐	Currency Key
24	ANSDT	EQUI	ANSDT		☐	ANDTI	☐	Acquisition date
25	ERDAT	EQUI	ERDAT		☐	ERDAT	☐	Date on which the record was created
26	AEDAT	EQUI	AEDAT		☐	AEDAT	☐	Last Changed On
27	INBDT	EQUI	INBDT		☐	ILOM_DATAB	☐	Start-up Date of the Technical Object
28	PROID	ILOA	PROID		☐	PS_PSP_PNR	☐	Work Breakdown Structure Element (WBS Element)
29	EQTYP	EQUI	EQTYP		☐	EQTYP	☐	Equipment Category
30	GEWRK	EQUZ	GEWRK		☐	LGWID	☐	Object ID of the Work Center
31	AUFNR	ILOA	AUFNR		☐	ILOM_ORDST	☐	Settlement order
32	PPSID	ILOA	PPSID		☐	PPSID	☐	Object ID of PP work center

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

History

Last changed by/on	SAP	20130529
SAP Release Created in