SAP ABAP View BIW_EQUI_EAML (QM/PM/CS-BW Extraction View for Equipment Linear Data)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ PM-EQM (Application Component) Technical Objects
     ⤷ EAML (Package) EAM: Linear Feature Extension - unswitched

Basic Data

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

Table

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

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	EAML_D_LFE_DATA	MANDT	JL	EQ				0	0
10	EQUZ	MANDT	JR	EQ			AND	0	0
11	EAML_D_LFE_DATA	TABKEY	JL	EQ				0	0
12	EQUZ	EQUNR	JR	EQ			AND	0	0
13	EQUZ	EQLFN		EQ	'001'		AND	0	0
14	EAML_D_LFE_DATA	OBART		EQ	'IE'			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	EQLFN	EQUZ	EQLFN		☐	EQLFN	☐	Consecutive numbering of EquipUsagePeriods on same day
5	OBART	EAML_D_LFE_DATA	OBART		☐	EAML_OBART	☐	Object Type for Linear Data
6	DATEFROM	EQUZ	DATAB		☐	DATAB	☐	Valid-From Date
7	EQART	EQUI	EQART		☐	EQART	☐	Type of Technical Object
8	INVNR	EQUI	INVNR		☐	INVNR	☐	Inventory number
9	IWERK	EQUZ	IWERK		☐	IWERK	☐	Maintenance Planning Plant
10	INGRP	EQUZ	INGRP		☐	INGRP	☐	Planner Group for Customer Service and Plant Maintenance
11	ABCKZ	ILOA	ABCKZ		☐	ABCKZ	☐	ABC Indicator for Technical Object
12	KOKRS	ILOA	KOKRS		☐	KOKRS	☐	Controlling Area
13	KOSTL	ILOA	KOSTL		☐	KOSTL	☐	Cost Center
14	TPLNR	ILOA	TPLNR		☐	TPLNR	☐	Functional Location
15	SWERK	ILOA	SWERK		☐	SWERK	☐	Maintenance Plant
16	STORT	ILOA	STORT		☐	PMLOC	☐	Location of maintenance object
17	BEBER	ILOA	BEBER		☐	BEBER	☐	Organizational Area
18	MSGRP	ILOA	MSGRP		☐	RAUMNR	☐	Room
19	ADRNR	ILOA	ADRNR		☐	AD_ADDRNUM	☐	Address number
20	BUKRS	ILOA	BUKRS		☐	BUKRS	☐	Company Code
21	ANLNR	ILOA	ANLNR		☐	ANLN1	☐	Main Asset Number
22	ANLUN	ILOA	ANLUN		☐	ANLN2	☐	Asset Subnumber
23	MATNR	EQUI	MATNR		☐	MATNR	☐	Material Number
24	WERK	EQUI	WERK		☐	WERKS_D	☐	Plant
25	ANSWT	EQUI	ANSWT		☐	ANSWT	☐	Acquisition Value
26	WAERS	EQUI	WAERS		☐	WAERS	☐	Currency Key
27	ANSDT	EQUI	ANSDT		☐	ANDTI	☐	Acquisition date
28	ERDAT	EQUI	ERDAT		☐	ERDAT	☐	Date on which the record was created
29	AEDAT	EQUI	AEDAT		☐	AEDAT	☐	Last Changed On
30	INBDT	EQUI	INBDT		☐	ILOM_DATAB	☐	Start-up Date of the Technical Object
31	PROID	ILOA	PROID		☐	PS_PSP_PNR	☐	Work Breakdown Structure Element (WBS Element)
32	EQTYP	EQUI	EQTYP		☐	EQTYP	☐	Equipment Category
33	GEWRK	EQUZ	GEWRK		☐	LGWID	☐	Object ID of the Work Center
34	AUFNR	ILOA	AUFNR		☐	ILOM_ORDST	☐	Settlement order
35	START_POINT	EAML_D_LFE_DATA	START_POINT		☐	EAML_START_POINT_SI	☐	Start Point in SI Unit
36	END_POINT	EAML_D_LFE_DATA	END_POINT		☐	EAML_END_POINT_SI	☐	End Point in SI Unit
37	LINEAR_LENGTH	EAML_D_LFE_DATA	LINEAR_LENGTH		☐	EAML_LINEAR_LENGTH_SI	☐	Length in SI Unit
38	LINEAR_UNIT	EAML_D_LFE_DATA	LINEAR_UNIT		☐	EAML_LINEAR_UNIT	☐	Unit of Measurement for Linear Data

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	606