SAP ABAP View IFLO (Functional Location (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
Short Description	Functional Location (View)
Root table	IFLOT	Functional Location (Table)

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	IFLOT	IFLOT
2	ILOA
3	IFLOTX

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	ILOA	MANDT	JL	EQ				0	0
2	IFLOT	MANDT	JR	EQ			AND	0	0
3	ILOA	ILOAN	JL	EQ				0	0
4	IFLOT	ILOAN	JR	EQ			AND	0	0
5	ILOA	TPLNR	JL	EQ				0	0
6	IFLOT	TPLNR	JR	EQ			AND	0	0
7	IFLOT	MANDT	JL	EQ				0	0
8	IFLOTX	MANDT	JR	EQ			AND	0	0
9	IFLOT	TPLNR	JL	EQ				0	0
10	IFLOTX	TPLNR	JR	EQ				0	0

View Fields

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

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