SAP ABAP View IFLO_VS (Functional Location, Versions (View))

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MSE (Application Component) Mobile Service
     ⤷ ILOM (Package) Application Development R/3 Location Management

Basic Data

View Type	D	Database View
Database View	IFLO_VS
Short Description	Functional Location, Versions (View)
Root table	IFLOT_VS	Functional Location (Version Table)

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	IFLOT_VS	IFLOT_VS
2	ILOA_VS
3	IFLOTX_VS

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	ILOA_VS	MANDT	JL	EQ				0	0
2	IFLOT_VS	MANDT	JR	EQ			AND	0	0
3	ILOA_VS	VSNMR	JL	EQ				0	0
4	IFLOT_VS	VSNMR	JR	EQ			AND	0	0
5	ILOA_VS	ILOAN	JL	EQ				0	0
6	IFLOT_VS	ILOAN	JR	EQ			AND	0	0
7	ILOA_VS	TPLNR	JL	EQ				0	0
8	IFLOT_VS	TPLNR	JR	EQ			AND	0	0
9	IFLOT_VS	MANDT	JL	EQ				0	0
10	IFLOTX_VS	MANDT	JR	EQ			AND	0	0
11	IFLOT_VS	VSNMR	JL	EQ				0	0
12	IFLOTX_VS	VSNMR	JR	EQ			AND	0	0
13	IFLOT_VS	TPLNR	JL	EQ				0	0
14	IFLOTX_VS	TPLNR	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	IFLOT_VS	MANDT		☐	MANDT	☐	Client
2	VSNMR	IFLOT_VS	VSNMR		☐	VSNMR	☐	Number or description of a version
3	TPLNR	IFLOT_VS	TPLNR		☐	TPLNR	☐	Functional Location
4	SPRAS	IFLOTX_VS	SPRAS		☐	SPRAS	☐	Language Key
5	*	IFLOTX_VS	*		☐		☐
6	-	IFLOTX_VS	MANDT		☐	MANDT	☐	Client
7	-	IFLOTX_VS	VSNMR		☐	VSNMR	☐	Number or description of a version
8	-	IFLOTX_VS	TPLNR		☐	TPLNR	☐	Functional Location
9	PLTXT	IFLOTX_VS	PLTXT		☐	PLTXT	☐	Description of functional location
10	KZLTX	IFLOTX_VS	KZLTX		☐	ILOM_KZLTX	☐	Indicator: Long text exists
11	KZMLA	IFLOTX_VS	KZMLA		☐	KZMLA	☐	Primary language indicator for text segment
12	PLTXU	IFLOTX_VS	PLTXU		☐	ILOM_PLTXU	☐	Description of functional location in capital letters
13	*	IFLOT_VS	*		☐		☐
14	MLANG	IFLOT_VS	MLANG		☐	MLANG	☐	Primary language for object texts
15	TPLKZ	IFLOT_VS	TPLKZ		☐	TPLKZ	☐	Functional location structure indicators
16	FLTYP	IFLOT_VS	FLTYP		☐	FLTYP	☐	Functional Location Category
17	TPLMA	IFLOT_VS	TPLMA		☐	TPLMA	☐	Superior functional location
18	ERDAT	IFLOT_VS	ERDAT		☐	ICRDT	☐	Date on Which Object Was Created
19	ERNAM	IFLOT_VS	ERNAM		☐	ICRNA	☐	Name of User Who Created the Object
20	AEDAT	IFLOT_VS	AEDAT		☐	IUPDT	☐	Date on which the object was last changed
21	AENAM	IFLOT_VS	AENAM		☐	IUPNA	☐	Name of the User Who Last Changed the Object
22	DATAB	IFLOT_VS	DATAB		☐	ILOM_DATAB	☐	Start-up Date of the Technical Object
23	BEGRU	IFLOT_VS	BEGRU		☐	IAUTG	☐	Authorization Group for Technical Object
24	TRPNR	IFLOT_VS	TRPNR		☐	TRPNR	☐	Reference functional location
25	PSTAE	IFLOT_VS	PSTAE		☐	RESERVE_CHAR_004	☐	SAP Development reserve: Format CHAR, length 4
26	STNAM	IFLOT_VS	STNAM		☐	RESERVE_CHAR_012	☐	SAP Development Reserve: Format CHAR, Length 12
27	LVORM	IFLOT_VS	LVORM		☐	RESERVE_CHAR_001	☐	SAP Development Reserve: Format CHAR, Length 1
28	SUBMT	IFLOT_VS	SUBMT		☐	SUBMT	☐	Construction Type Material of the Object
29	SUBMTI	IFLOT_VS	SUBMTI		☐	INH_SUBMTI	☐	Data origin for construction type field
30	MAPAR	IFLOT_VS	MAPAR		☐	MAPAR	☐	Manufacturer part number
31	MAPARI	IFLOT_VS	MAPARI		☐	RESERVE_CHAR_001	☐	SAP Development Reserve: Format CHAR, Length 1
32	IEQUI	IFLOT_VS	IEQUI		☐	IEQUI	☐	Installation of equipment allowed at the functional location
33	IEQUII	IFLOT_VS	IEQUII		☐	INH_IEQUII	☐	Data origin for equip. inst. allowed field
34	EINZL	IFLOT_VS	EINZL		☐	EINZL	☐	Single equipment installation at functional location
35	EINZLI	IFLOT_VS	EINZLI		☐	INH_BEGRUI	☐	Data origin for authorization group field
36	IWERK	IFLOT_VS	IWERK		☐	IWERK	☐	Maintenance Planning Plant
37	IWERKI	IFLOT_VS	IWERKI		☐	INH_IWERKI	☐	Data origin for planning plant field
38	INGRP	IFLOT_VS	INGRP		☐	INGRP	☐	Planner Group for Customer Service and Plant Maintenance
39	INGRPI	IFLOT_VS	INGRPI		☐	INH_INGRPI	☐	Data origin for maintenance planner group field
40	PM_OBJTY	IFLOT_VS	PM_OBJTY		☐	PM_OBJTY	☐	Object Type of CIM Resources for Work Center
41	LGWID	IFLOT_VS	LGWID		☐	LGWID	☐	Object ID of the Work Center
42	LGWIDI	IFLOT_VS	LGWIDI		☐	INH_LGWIDI	☐	Data Origin for the Field 'Work Center'
43	RBNR	IFLOT_VS	RBNR		☐	RBNR	☐	Report layout
44	RBNR_I	IFLOT_VS	RBNR_I		☐	INH_RBNR_I	☐	Data origin for maintenance catalog field
45	-	IFLOT_VS	ILOAN		☐	ILOAN	☐	Location and account assignment for technical object
46	OBJNR	IFLOT_VS	OBJNR		☐	J_OBJNR	☐	Object number
47	POSNR	IFLOT_VS	POSNR		☐	ILOM_POSNR	☐	Position in superior technical object
48	ISTYP	IFLOT_VS	ISTYP		☐	ILOM_ISTYP	☐	Object category for Industry Solutions (IS)
49	PREMS	IFLOT_VS	PREMS		☐	ILOM_PREMS	☐	Premise
50	EQART	IFLOT_VS	EQART		☐	EQART	☐	Type of Technical Object
51	INVNR	IFLOT_VS	INVNR		☐	INVNR	☐	Inventory number
52	GROES	IFLOT_VS	GROES		☐	GROSS	☐	Size/dimension
53	BRGEW	IFLOT_VS	BRGEW		☐	BRGEW	☐	Gross weight
54	GEWEI	IFLOT_VS	GEWEI		☐	GEWEI	☐	Weight Unit
55	ANSWT	IFLOT_VS	ANSWT		☐	ANSWT	☐	Acquisition Value
56	WAERS	IFLOT_VS	WAERS		☐	WAERS	☐	Currency Key
57	ANSDT	IFLOT_VS	ANSDT		☐	ANDTI	☐	Acquisition date
58	HERST	IFLOT_VS	HERST		☐	HERST	☐	Manufacturer of asset
59	HERLD	IFLOT_VS	HERLD		☐	HERLD	☐	Country of manufacture
60	BAUJJ	IFLOT_VS	BAUJJ		☐	BAUJJ	☐	Year of construction
61	BAUMM	IFLOT_VS	BAUMM		☐	BAUMM	☐	Month of construction
62	TYPBZ	IFLOT_VS	TYPBZ		☐	TYPBZ	☐	Manufacturer model number
63	EMATN	IFLOT_VS	EMATN		☐	EMATN	☐	Material number corresponding to manufacturer part number
64	SERGE	IFLOT_VS	SERGE		☐	SERGE	☐	Manufacturer serial number
65	HANDLE	IFLOT_VS	HANDLE		☐	ITOBTMP_TSEGGUID	☐	SAP Development Reserve: Integration of Date Segment (Key)
66	TSEGTP	IFLOT_VS	TSEGTP		☐	ITOBTMP_TSEGTEMPLA	☐	SAP Development Reserve: Integration Date Segment (Template)
67	FLLB_DUTY	IFLOT_VS	FLLB_DUTY		☐	DIACL_DUTY	☐	Logbook Duty
68	FLLB_HIDE	IFLOT_VS	FLLB_HIDE		☐	DIACL_HIDE	☐	Hide Logbook Display
69	IFLOT_SRTYPE	IFLOT_VS	IFLOT_SRTYPE		☐	ILOM_SR_SRTYPE	☐	Shift Report Type for Object
70	IFLOT_SNTYPE	IFLOT_VS	IFLOT_SNTYPE		☐	ILOM_SN_SNTYPE	☐	Notification Type for Shift Note for Object
71	*	ILOA_VS	*		☐		☐
72	-	ILOA_VS	MANDT		☐	MANDT	☐	Client
73	-	ILOA_VS	VSNMR		☐	VSNMR	☐	Number or description of a version
74	ILOAN	ILOA_VS	ILOAN		☐	ILOAN	☐	Location and account assignment for technical object
75	-	ILOA_VS	TPLNR		☐	TPLNR	☐	Functional Location
76	ABCKZ	ILOA_VS	ABCKZ		☐	ABCKZ	☐	ABC Indicator for Technical Object
77	ABCKZI	ILOA_VS	ABCKZI		☐	INH_ABCKZI	☐	Data origin for ABC indicator field
78	EQFNR	ILOA_VS	EQFNR		☐	EQFNR	☐	Sort Field
79	EQFNRI	ILOA_VS	EQFNRI		☐	INH_EQFNRI	☐	Data origin for sort field
80	SWERK	ILOA_VS	SWERK		☐	SWERK	☐	Maintenance Plant
81	SWERKI	ILOA_VS	SWERKI		☐	INH_SWERKI	☐	Data origin for maintenance plant field
82	STORT	ILOA_VS	STORT		☐	PMLOC	☐	Location of maintenance object
83	STORTI	ILOA_VS	STORTI		☐	INH_STORTI	☐	Data origin for location field
84	MSGRP	ILOA_VS	MSGRP		☐	RAUMNR	☐	Room
85	MSGRPI	ILOA_VS	MSGRPI		☐	INH_MSGRPI	☐	Data origin for room number field
86	BEBER	ILOA_VS	BEBER		☐	BEBER	☐	Organizational Area
87	BEBERI	ILOA_VS	BEBERI		☐	INH_BEBERI	☐	Data origin for company area field
88	CR_OBJTY	ILOA_VS	CR_OBJTY		☐	CR_OBJTY	☐	Object types of the CIM resource
89	PPSID	ILOA_VS	PPSID		☐	PPSID	☐	Object ID of PP work center
90	PPSIDI	ILOA_VS	PPSIDI		☐	INH_PPSIDI	☐	Data origin for PP work center field
91	GSBER	ILOA_VS	GSBER		☐	GSBER	☐	Business Area
92	GSBERI	ILOA_VS	GSBERI		☐	INH_GSBERI	☐	Data origin for business area field
93	KOKRS	ILOA_VS	KOKRS		☐	KOKRS	☐	Controlling Area
94	KOKRSI	ILOA_VS	KOKRSI		☐	INH_KOKRSI	☐	Data origin for controlling area field
95	KOSTL	ILOA_VS	KOSTL		☐	KOSTL	☐	Cost Center
96	KOSTLI	ILOA_VS	KOSTLI		☐	INH_KOSTLI	☐	Data origin for cost center field
97	PROID	ILOA_VS	PROID		☐	PS_PSP_PNR	☐	Work Breakdown Structure Element (WBS Element)
98	PROIDI	ILOA_VS	PROIDI		☐	INH_PROIDI	☐	Data origin for WBS element field
99	BUKRS	ILOA_VS	BUKRS		☐	BUKRS	☐	Company Code
100	BUKRSI	ILOA_VS	BUKRSI		☐	INH_BUKRSI	☐	Data origin for company code field
101	ANLNR	ILOA_VS	ANLNR		☐	ANLN1	☐	Main Asset Number
102	ANLNRI	ILOA_VS	ANLNRI		☐	INH_ANLNRI	☐	Data origin for asset main no./sub-no. fields
103	ANLUN	ILOA_VS	ANLUN		☐	ANLN2	☐	Asset Subnumber
104	ANLUNI	ILOA_VS	ANLUNI		☐	INHER	☐	Data origin indicator
105	DAUFN	ILOA_VS	DAUFN		☐	DAUFN	☐	Standing order number
106	DAUFNI	ILOA_VS	DAUFNI		☐	INH_DAUFNI	☐	Data origin of standing order number field
107	AUFNR	ILOA_VS	AUFNR		☐	ILOM_ORDST	☐	Settlement order
108	AUFNRI	ILOA_VS	AUFNRI		☐	INH_AUFNRI	☐	Data origin for settlement order field
109	-	ILOA_VS	TPLNRI		☐	INH_TPLNRI	☐	Data origin for functional location field
110	VKORG	ILOA_VS	VKORG		☐	VKORG	☐	Sales Organization
111	VKORGI	ILOA_VS	VKORGI		☐	INH_VKORGI	☐	Data origin for sales organization field
112	VTWEG	ILOA_VS	VTWEG		☐	VTWEG	☐	Distribution Channel
113	VTWEGI	ILOA_VS	VTWEGI		☐	INH_VTWEGI	☐	Data origin of distribution channel field
114	SPART	ILOA_VS	SPART		☐	SPART	☐	Division
115	SPARTI	ILOA_VS	SPARTI		☐	INH_SPARTI	☐	Data origin for division field
116	ADRNR	ILOA_VS	ADRNR		☐	AD_ADDRNUM	☐	Address number
117	ADRNRI	ILOA_VS	ADRNRI		☐	INH_ADRNRI	☐	Data origin for address field
118	OWNER	ILOA_VS	OWNER		☐	ILOM_OWNER	☐	Object reference indicator
119	VKBUR	ILOA_VS	VKBUR		☐	VKBUR	☐	Sales office
120	VKGRP	ILOA_VS	VKGRP		☐	VKGRP	☐	Sales group

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