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

Hierarchy

☛ EA-DFPS (Software Component) SAP Enterprise Extension Defense Forces & Public Security
   ⤷ IS-DFS (Application Component) Defense Forces and Public Security
     ⤷ /ISDFPS/BI_CONTENT (Package) BI Content Defense (Extractors And So On)

Basic Data

View Type	D	Database View
Database View	/ISDFPS/V_BI_EQU
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
4	EQBS

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	EQUI	MANDT	JL	EQ				0	0
10	EQBS	MANDT	JR	EQ			AND	0	0
11	EQUI	EQUNR	JL	EQ				0	0
12	EQBS	EQUNR	JR	EQ			AND	0	0
13	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	LAGER	EQUI	LAGER		☐	LGORT_D	☐	Storage location
29	CHARGE	EQUI	CHARGE		☐	CHARG_D	☐	Batch Number
30	EQTYP	EQUI	EQTYP		☐	EQTYP	☐	Equipment Category
31	B_WERK	EQBS	B_WERK		☐	WERKS_D	☐	Plant
32	B_LAGER	EQBS	B_LAGER		☐	LGORT_D	☐	Storage location
33	B_CHARGE	EQBS	B_CHARGE		☐	B_CHARGE	☐	Batch Number

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	470