SAP ABAP View V_EQUI_IFLOS (PM technical objects (EQUI, funcational location))

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ IEQM (Package) Application Develoment R/3 Equipment Management

Basic Data

View Type	D	Database View
Database View	V_EQUI_IFLOS
Short Description	PM technical objects (EQUI, funcational location)
Root table	EQUI	Equipment master data

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	EQUI	EQUI
2	EQUZ
3	EQKT
4	ILOA
5	IFLOS

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	EQUI	MANDT	JL	EQ				0	0
6	EQKT	MANDT	JR	EQ			AND	0	0
7	EQUI	EQUNR	JL	EQ				0	0
8	EQKT	EQUNR	JR	EQ			AND	0	0
9	ILOA	MANDT	JL	EQ				0	0
10	EQUZ	MANDT	JR	EQ			AND	0	0
11	ILOA	ILOAN	JL	EQ				0	0
12	EQUZ	ILOAN	JR	EQ			AND	0	0
13	IFLOS	MANDT	JL	EQ				0	0
14	ILOA	MANDT	JR	EQ			AND	0	0
15	IFLOS	TPLNR	JL	EQ				0	0
16	ILOA	TPLNR	JR	EQ			AND	0	0
17	IFLOS	ACTVS		EQ	'X'			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	*	EQUI	*		☐		☐
2	MANDT	EQUI	MANDT		☐	MANDT	☐	Client
3	EQUNR	EQUI	EQUNR		☐	EQUNR	☐	Equipment Number
4	ERDAT	EQUI	ERDAT		☐	ERDAT	☐	Date on which the record was created
5	ERNAM	EQUI	ERNAM		☐	ERNAM	☐	Name of Person who Created the Object
6	EQASP	EQUI	EQASP		☐	EQASP	☐	Language in which the piece of equipment was entered
7	AEDAT	EQUI	AEDAT		☐	AEDAT	☐	Last Changed On
8	AENAM	EQUI	AENAM		☐	AENAM	☐	Name of Person Who Changed Object
9	BEGRU	EQUI	BEGRU		☐	IAUTG	☐	Authorization Group for Technical Object
10	EQTYP	EQUI	EQTYP		☐	EQTYP	☐	Equipment Category
11	EQART	EQUI	EQART		☐	EQART	☐	Type of Technical Object
12	LVORM	EQUI	LVORM		☐	RESERVE_CHAR_001	☐	SAP Development Reserve: Format CHAR, Length 1
13	INVNR	EQUI	INVNR		☐	INVNR	☐	Inventory number
14	GROES	EQUI	GROES		☐	GROSS	☐	Size/dimension
15	BRGEW	EQUI	BRGEW		☐	OBJ_WEIGHT	☐	Weight of object
16	GEWEI	EQUI	GEWEI		☐	WEIGHT_UNIT	☐	Unit of weight
17	ANSDT	EQUI	ANSDT		☐	ANDTI	☐	Acquisition date
18	ANSWT	EQUI	ANSWT		☐	ANSWT	☐	Acquisition Value
19	WAERS	EQUI	WAERS		☐	WAERS	☐	Currency Key
20	ELIEF	EQUI	ELIEF		☐	ELIEF	☐	Vendor number
21	GWLEN	EQUI	GWLEN		☐	GWLEN	☐	Date on which the warranty ends
22	GWLDT	EQUI	GWLDT		☐	GWLDT	☐	Guarantee date
23	WDBWT	EQUI	WDBWT		☐	WDBWT	☐	Equipment replacement value
24	HERST	EQUI	HERST		☐	HERST	☐	Manufacturer of asset
25	HERLD	EQUI	HERLD		☐	HERLD	☐	Country of manufacture
26	HZEIN	EQUI	HZEIN		☐	HZEIN	☐	Manufacturer drawing number
27	SERGE	EQUI	SERGE		☐	SERGE	☐	Manufacturer serial number
28	TYPBZ	EQUI	TYPBZ		☐	TYPBZ	☐	Manufacturer model number
29	BAUJJ	EQUI	BAUJJ		☐	BAUJJ	☐	Year of construction
30	BAUMM	EQUI	BAUMM		☐	BAUMM	☐	Month of construction
31	APLKZ	EQUI	APLKZ		☐	APLKZ	☐	Indicator: Task List Exists
32	AULDT	EQUI	AULDT		☐	AULDT	☐	First delivery date of the equipment
33	INBDT	EQUI	INBDT		☐	ILOM_DATAB	☐	Start-up Date of the Technical Object
34	GERNR	EQUI	GERNR		☐	GERNR	☐	Serial Number
35	-	EQUI	EQLFN		☐	EQLFN	☐	Consecutive numbering of EquipUsagePeriods on same day
36	GWLDV	EQUI	GWLDV		☐	GWLDV	☐	Warranty date for Sales and Distribution
37	EQDAT	EQUI	EQDAT		☐	EQDAT	☐	Date
38	EQBER	EQUI	EQBER		☐	EQBER	☐	Text for Notes
39	EQNUM	EQUI	EQNUM		☐	EQNUM	☐	Numerical Field
40	OBJNR	EQUI	OBJNR		☐	J_OBJNR	☐	Object number
41	EQSNR	EQUI	EQSNR		☐	EQSNR	☐	EQSE Number
42	CUOBJ	EQUI	CUOBJ		☐	CUOBJ	☐	Configuration (internal object number)
43	KRFKZ	EQUI	KRFKZ		☐	KRFKZ	☐	Referenced Configuration
44	KMATN	EQUI	KMATN		☐	KMATN	☐	Configurable Material
45	MATNR	EQUI	MATNR		☐	MATNR	☐	Material Number
46	SERNR	EQUI	SERNR		☐	GERNR	☐	Serial Number
47	WERK	EQUI	WERK		☐	WERKS_D	☐	Plant
48	LAGER	EQUI	LAGER		☐	LGORT_D	☐	Storage location
49	CHARGE	EQUI	CHARGE		☐	CHARG_D	☐	Batch Number
50	KUNDE	EQUI	KUNDE		☐	KUNDSE	☐	Customer to Whom Serial Number was Delivered
51	WARPL	EQUI	WARPL		☐	WARPL	☐	Maintenance Plan
52	IMRC_POINT	EQUI	IMRC_POINT		☐	IMRC_POINT	☐	Measuring Point
53	REVLV	EQUI	REVLV		☐	REVLV	☐	Revision level
54	MGANR	EQUI	MGANR		☐	MGANR	☐	Master warranty number
55	BEGRUI	EQUI	BEGRUI		☐	INH_BEGRUI	☐	Data origin for authorization group field
56	S_EQUI	EQUI	S_EQUI		☐	EQUIP_KNZ	☐	Equipment
57	S_SERIAL	EQUI	S_SERIAL		☐	KZKSD	☐	Serial data when maintaining equipment
58	S_KONFI	EQUI	S_KONFI		☐	KONFKNZ	☐	Configuration supported
59	S_SALE	EQUI	S_SALE		☐	SDKNZ	☐	Sales equipment
60	S_FHM	EQUI	S_FHM		☐	FHMKZ	☐	Equip. category relevant to production resources and tools
61	S_ELSE	EQUI	S_ELSE		☐	ELSE_KNZ	☐	Indicator: Other Data Active
62	S_ISU	EQUI	S_ISU		☐	ISU_KNZ	☐	IS-U data
63	S_EQBS	EQUI	S_EQBS		☐	KZEQBS	☐	EQSI Exists
64	S_FLEET	EQUI	S_FLEET		☐	FLEET_KNZ	☐	Indicator: Fleet object active
65	BSTVP	EQUI	BSTVP		☐	BSTVP	☐	Stock Check for Serial Numbers
66	SPARTE	EQUI	SPARTE		☐	SPARTE	☐	Division
67	HANDLE	EQUI	HANDLE		☐	ITOBTMP_TSEGGUID	☐	SAP Development Reserve: Integration of Date Segment (Key)
68	TSEGTP	EQUI	TSEGTP		☐	ITOBTMP_TSEGTEMPLA	☐	SAP Development Reserve: Integration Date Segment (Template)
69	EMATN	EQUI	EMATN		☐	EMATN	☐	Material number corresponding to manufacturer part number
70	ACT_CHANGE_AA	EQUI	ACT_CHANGE_AA		☐	AAPM_ACT_CHANGE_AA	☐	Change Equipment Master when Changing Asset
71	S_CC	EQUI	S_CC		☐	CCC_KNZ	☐	Configuration Control Data
72	DATLWB	EQUI	DATLWB		☐	DATLWB	☐	Date of Last Goods Movement
73	UII	EQUI	UII		☐	UII_CHAR72	☐	Unique Item Identifier
74	IUID_TYPE	EQUI	IUID_TYPE		☐	IUID_TYPE	☐	Structure Type of UII
75	UII_PLANT	EQUI	UII_PLANT		☐	UII_PLANT	☐	Plant Responsible for UII
76	EQEXT_ACTIVE	EQUI	EQEXT_ACTIVE		☐	/ISDFPS/DE_LM_DB_EQEXT_ACTIVE	☐	Backpack Table /isdfps/lmeqext Active
77	EQUI_SRTYPE	EQUI	EQUI_SRTYPE		☐	COCF_SR_SRTYPE	☐	Shift Report Type
78	EQUI_SNTYPE	EQUI	EQUI_SNTYPE		☐	COCF_SN_SNTYPE	☐	Shift Note Type
79	EQLB_DUTY	EQUI	EQLB_DUTY		☐	DIACL_DUTY	☐	Logbook Duty
80	EQLB_HIDE	EQUI	EQLB_HIDE		☐	DIACL_HIDE	☐	Hide Logbook Display
81	*	EQUZ	*		☐		☐
82	-	EQUZ	MANDT		☐	MANDT	☐	Client
83	-	EQUZ	EQUNR		☐	EQUNR	☐	Equipment Number
84	DATBI	EQUZ	DATBI		☐	DATBI	☐	Valid To Date
85	EQLFN	EQUZ	EQLFN		☐	EQLFN	☐	Consecutive numbering of EquipUsagePeriods on same day
86	EQUZN	EQUZ	EQUZN		☐	EQNNR	☐	Number of next EquipUsagePeriod on same day
87	TIMBI	EQUZ	TIMBI		☐	TIMBI	☐	Equipment usage period time stamp
88	ESTAI	EQUZ	ESTAI		☐	RESERVE_CHAR_001	☐	SAP Development Reserve: Format CHAR, Length 1
89	ESTAE	EQUZ	ESTAE		☐	RESERVE_CHAR_004	☐	SAP Development reserve: Format CHAR, length 4
90	STNAM	EQUZ	STNAM		☐	RESERVE_CHAR_012	☐	SAP Development Reserve: Format CHAR, Length 12
91	DATAB	EQUZ	DATAB		☐	DATAB	☐	Valid-From Date
92	IWERK	EQUZ	IWERK		☐	IWERK	☐	Maintenance Planning Plant
93	IWERKI	EQUZ	IWERKI		☐	INHER	☐	Data origin indicator
94	SUBMT	EQUZ	SUBMT		☐	SUBMT	☐	Construction Type Material of the Object
95	MAPAR	EQUZ	MAPAR		☐	MAPAR	☐	Manufacturer part number
96	HEQUI	EQUZ	HEQUI		☐	HEQUI	☐	Superordinate Equipment
97	HEQNR	EQUZ	HEQNR		☐	HEQNR	☐	Equipment position at InstallLoc (Superior Equip./FunctLoc)
98	INGRP	EQUZ	INGRP		☐	INGRP	☐	Planner Group for Customer Service and Plant Maintenance
99	INGRPI	EQUZ	INGRPI		☐	INHER	☐	Data origin indicator
100	PM_OBJTY	EQUZ	PM_OBJTY		☐	PM_OBJTY	☐	Object Type of CIM Resources for Work Center
101	GEWRK	EQUZ	GEWRK		☐	LGWID	☐	Object ID of the Work Center
102	GEWRKI	EQUZ	GEWRKI		☐	INHER	☐	Data origin indicator
103	TIDNR	EQUZ	TIDNR		☐	TIDNR	☐	Technical identification number
104	TIDNRI	EQUZ	TIDNRI		☐	INHER	☐	Data origin indicator
105	ILOAN	EQUZ	ILOAN		☐	ILOAN	☐	Location and account assignment for technical object
106	KUND1	EQUZ	KUND1		☐	KUND1	☐	Customer No.
107	KUND2	EQUZ	KUND2		☐	KUND2	☐	End customer number
108	KUND3	EQUZ	KUND3		☐	KUND3	☐	Operator
109	LIZNR	EQUZ	LIZNR		☐	LIZNR	☐	Equipment license number
110	RBNR	EQUZ	RBNR		☐	RBNR	☐	Report layout
111	EZDAT	EQUZ	EZDAT		☐	EQDAT	☐	Date
112	EZBER	EQUZ	EZBER		☐	EQBER	☐	Text for Notes
113	EZNUM	EQUZ	EZNUM		☐	EQNUM	☐	Numerical Field
114	RBNR_I	EQUZ	RBNR_I		☐	INHER	☐	Data origin indicator
115	IBLNR	EQUZ	IBLNR		☐	IBLNR	☐	Physical inventory document
116	BLDAT	EQUZ	BLDAT		☐	BLDAT	☐	Document Date in Document
117	PVS_FOCUS	EQUZ	PVS_FOCUS		☐	PVS_GUID_CCC	☐	Internal Identification for PVS Objects
118	PPEGUID	EQUZ	PPEGUID		☐	PVS_GUID_CCC	☐	Internal Identification for PVS Objects
119	TECHS	EQUZ	TECHS		☐	TECHS	☐	Parameter Variant/Standard Variant
120	FUNCID	EQUZ	FUNCID		☐	CCC_FUNCID	☐	Function Identifier
121	FRCFIT	EQUZ	FRCFIT		☐	CCC_FRCFIT	☐	Indicator: Forced Installation/Dismantling
122	FRCRMV	EQUZ	FRCRMV		☐	CCC_FRCRMV	☐	Force Dismantling Flag
123	*	EQKT	*		☐		☐
124	-	EQKT	MANDT		☐	MANDT	☐	Client
125	-	EQKT	EQUNR		☐	EQUNR	☐	Equipment Number
126	SPRAS	EQKT	SPRAS		☐	SPRAS	☐	Language Key
127	EQKTX	EQKT	EQKTX		☐	KTX01	☐	Description of technical object
128	KZLTX	EQKT	KZLTX		☐	KZLTA	☐	Long Text Indicator
129	TXASP	EQKT	TXASP		☐	KZMLA	☐	Primary language indicator for text segment
130	EQKTU	EQKT	EQKTU		☐	EQKTU	☐	Equipment description in capital letters
131	*	ILOA	*		☐		☐
132	-	ILOA	MANDT		☐	MANDT	☐	Client
133	-	ILOA	ILOAN		☐	ILOAN	☐	Location and account assignment for technical object
134	-	ILOA	TPLNR		☐	TPLNR	☐	Functional Location
135	ABCKZ	ILOA	ABCKZ		☐	ABCKZ	☐	ABC Indicator for Technical Object
136	ABCKZI	ILOA	ABCKZI		☐	INH_ABCKZI	☐	Data origin for ABC indicator field
137	EQFNR	ILOA	EQFNR		☐	EQFNR	☐	Sort Field
138	EQFNRI	ILOA	EQFNRI		☐	INH_EQFNRI	☐	Data origin for sort field
139	SWERK	ILOA	SWERK		☐	SWERK	☐	Maintenance Plant
140	SWERKI	ILOA	SWERKI		☐	INH_SWERKI	☐	Data origin for maintenance plant field
141	STORT	ILOA	STORT		☐	PMLOC	☐	Location of maintenance object
142	STORTI	ILOA	STORTI		☐	INH_STORTI	☐	Data origin for location field
143	MSGRP	ILOA	MSGRP		☐	RAUMNR	☐	Room
144	MSGRPI	ILOA	MSGRPI		☐	INH_MSGRPI	☐	Data origin for room number field
145	BEBER	ILOA	BEBER		☐	BEBER	☐	Organizational Area
146	BEBERI	ILOA	BEBERI		☐	INH_BEBERI	☐	Data origin for company area field
147	CR_OBJTY	ILOA	CR_OBJTY		☐	CR_OBJTY	☐	Object types of the CIM resource
148	PPSID	ILOA	PPSID		☐	PPSID	☐	Object ID of PP work center
149	PPSIDI	ILOA	PPSIDI		☐	INH_PPSIDI	☐	Data origin for PP work center field
150	GSBER	ILOA	GSBER		☐	GSBER	☐	Business Area
151	GSBERI	ILOA	GSBERI		☐	INH_GSBERI	☐	Data origin for business area field
152	KOKRS	ILOA	KOKRS		☐	KOKRS	☐	Controlling Area
153	KOKRSI	ILOA	KOKRSI		☐	INH_KOKRSI	☐	Data origin for controlling area field
154	KOSTL	ILOA	KOSTL		☐	KOSTL	☐	Cost Center
155	KOSTLI	ILOA	KOSTLI		☐	INH_KOSTLI	☐	Data origin for cost center field
156	PROID	ILOA	PROID		☐	PS_PSP_PNR	☐	Work Breakdown Structure Element (WBS Element)
157	PROIDI	ILOA	PROIDI		☐	INH_PROIDI	☐	Data origin for WBS element field
158	BUKRS	ILOA	BUKRS		☐	BUKRS	☐	Company Code
159	BUKRSI	ILOA	BUKRSI		☐	INH_BUKRSI	☐	Data origin for company code field
160	ANLNR	ILOA	ANLNR		☐	ANLN1	☐	Main Asset Number
161	ANLNRI	ILOA	ANLNRI		☐	INH_ANLNRI	☐	Data origin for asset main no./sub-no. fields
162	ANLUN	ILOA	ANLUN		☐	ANLN2	☐	Asset Subnumber
163	ANLUNI	ILOA	ANLUNI		☐	INHER	☐	Data origin indicator
164	DAUFN	ILOA	DAUFN		☐	DAUFN	☐	Standing order number
165	DAUFNI	ILOA	DAUFNI		☐	INH_DAUFNI	☐	Data origin of standing order number field
166	AUFNR	ILOA	AUFNR		☐	ILOM_ORDST	☐	Settlement order
167	AUFNRI	ILOA	AUFNRI		☐	INH_AUFNRI	☐	Data origin for settlement order field
168	TPLNRI	ILOA	TPLNRI		☐	INH_TPLNRI	☐	Data origin for functional location field
169	VKORG	ILOA	VKORG		☐	VKORG	☐	Sales Organization
170	VKORGI	ILOA	VKORGI		☐	INH_VKORGI	☐	Data origin for sales organization field
171	VTWEG	ILOA	VTWEG		☐	VTWEG	☐	Distribution Channel
172	VTWEGI	ILOA	VTWEGI		☐	INH_VTWEGI	☐	Data origin of distribution channel field
173	SPART	ILOA	SPART		☐	SPART	☐	Division
174	SPARTI	ILOA	SPARTI		☐	INH_SPARTI	☐	Data origin for division field
175	ADRNR	ILOA	ADRNR		☐	AD_ADDRNUM	☐	Address number
176	ADRNRI	ILOA	ADRNRI		☐	INH_ADRNRI	☐	Data origin for address field
177	OWNER	ILOA	OWNER		☐	ILOM_OWNER	☐	Object reference indicator
178	VKBUR	ILOA	VKBUR		☐	VKBUR	☐	Sales office
179	VKGRP	ILOA	VKGRP		☐	VKGRP	☐	Sales group
180	LVORZ	EQUZ	LVORM		☐	RESERVE_CHAR_001	☐	SAP Development Reserve: Format CHAR, Length 1
181	ERNAZ	EQUZ	ERNAM		☐	ERNAM	☐	Name of Person who Created the Object
182	ERDAZ	EQUZ	ERDAT		☐	ERDAT	☐	Date on which the record was created
183	AENAZ	EQUZ	AENAM		☐	AENAM	☐	Name of Person Who Changed Object
184	AEDAZ	EQUZ	AEDAT		☐	AEDAT	☐	Last Changed On
185	TPLNR	IFLOS	STRNO		☐	ILOM_STRNO	☐	Functional location label
186	ALKEY	IFLOS	ALKEY		☐	ILOM_ALKEY	☐	Labeling system for functional locations
187	VERSN	IFLOS	VERSN		☐	ILOM_VERSN	☐	Version of functional location label
188	TPLNR_INT	IFLOS	TPLNR		☐	TPLNR	☐	Functional Location

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	46C