SAP ABAP View IFLS_ADDR (Address View for Collective Search Help IFLS)

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	IFLS_ADDR
Short Description	Address View for Collective Search Help IFLS
Root table	IFLOT	Functional Location (Table)

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	IFLOT	IFLOT
2	ILOA
3	IFLOTX
4	ADRC
5	IFLOS

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	IFLOTX	MANDT	JL	EQ				0	0
8	IFLOT	MANDT	JR	EQ			AND	0	0
9	IFLOTX	TPLNR	JL	EQ				0	0
10	IFLOT	TPLNR	JR	EQ			AND	0	0
11	ADRC	CLIENT	JL	EQ				0	0
12	IFLOT	MANDT	JR	EQ			AND	0	0
13	ADRC	ADDRNUMBER	JL	EQ				0	0
14	ILOA	ADRNR	JR	EQ			AND	0	0
15	IFLOT	MANDT	JL	EQ				0	0
16	IFLOS	MANDT	JR	EQ			AND	0	0
17	IFLOT	TPLNR	JL	EQ				0	0
18	IFLOS	TPLNR	JR	EQ			AND	0	0
19	ILOA	OWNER		EQ	'2'		AND	0	0
20	ADRC	ADDR_GROUP		EQ	'PM01'			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	TPLKZ	IFLOT	TPLKZ		☐	TPLKZ	☐	Functional location structure indicators
4	FLTYP	IFLOT	FLTYP		☐	FLTYP	☐	Functional Location Category
5	TPLMA	IFLOT	TPLMA		☐	TPLMA	☐	Superior functional location
6	IWERK	IFLOT	IWERK		☐	IWERK	☐	Maintenance Planning Plant
7	INGRP	IFLOT	INGRP		☐	INGRP	☐	Planner Group for Customer Service and Plant Maintenance
8	ISTYP	IFLOT	ISTYP		☐	ILOM_ISTYP	☐	Object category for Industry Solutions (IS)
9	PREMS	IFLOT	PREMS		☐	ILOM_PREMS	☐	Premise
10	EQART	IFLOT	EQART		☐	EQART	☐	Type of Technical Object
11	ALKEY	IFLOS	ALKEY		☐	ILOM_ALKEY	☐	Labeling system for functional locations
12	ACTVS	IFLOS	ACTVS		☐	ILOM_ACTVS	☐	Active version
13	STRNO	IFLOS	STRNO		☐	ILOM_STRNO	☐	Functional location label
14	PRKEY	IFLOS	PRKEY		☐	ILOM_PRKEY	☐	Primary labeling system
15	ABCKZ	ILOA	ABCKZ		☐	ABCKZ	☐	ABC Indicator for Technical Object
16	EQFNR	ILOA	EQFNR		☐	EQFNR	☐	Sort Field
17	SWERK	ILOA	SWERK		☐	SWERK	☐	Maintenance Plant
18	STORT	ILOA	STORT		☐	PMLOC	☐	Location of maintenance object
19	MSGRP	ILOA	MSGRP		☐	RAUMNR	☐	Room
20	BEBER	ILOA	BEBER		☐	BEBER	☐	Organizational Area
21	KOKRS	ILOA	KOKRS		☐	KOKRS	☐	Controlling Area
22	KOSTL	ILOA	KOSTL		☐	KOSTL	☐	Cost Center
23	BUKRS	ILOA	BUKRS		☐	BUKRS	☐	Company Code
24	ANLNR	ILOA	ANLNR		☐	ANLN1	☐	Main Asset Number
25	ANLUN	ILOA	ANLUN		☐	ANLN2	☐	Asset Subnumber
26	VKORG	ILOA	VKORG		☐	VKORG	☐	Sales Organization
27	VTWEG	ILOA	VTWEG		☐	VTWEG	☐	Distribution Channel
28	SPART	ILOA	SPART		☐	SPART	☐	Division
29	VKBUR	ILOA	VKBUR		☐	VKBUR	☐	Sales office
30	VKGRP	ILOA	VKGRP		☐	VKGRP	☐	Sales group
31	OWNER	ILOA	OWNER		☐	ILOM_OWNER	☐	Object reference indicator
32	SPRAS	IFLOTX	SPRAS		☐	SPRAS	☐	Language Key
33	KZMLA	IFLOTX	KZMLA		☐	KZMLA	☐	Primary language indicator for text segment
34	PLTXT	IFLOTX	PLTXT		☐	PLTXT	☐	Description of functional location
35	PLTXU	IFLOTX	PLTXU		☐	ILOM_PLTXU	☐	Description of functional location in capital letters
36	ADRNR	ILOA	ADRNR		☐	AD_ADDRNUM	☐	Address number
37	ADRNRI	ILOA	ADRNRI		☐	INH_ADRNRI	☐	Data origin for address field
38	NAME_TEXT	ADRC	NAME_TEXT		☐	AD_NAMETXT	☐	Converted name field (with form of address)
39	ADDR_GROUP	ADRC	ADDR_GROUP		☐	AD_GROUP	☐	Address Group (Key) (Business Address Services)
40	SORT1	ADRC	SORT1		☐	AD_SORT1	☐	Search Term 1
41	SORT2	ADRC	SORT2		☐	AD_SORT2	☐	Search Term 2
42	MC_NAME1	ADRC	MC_NAME1		☐	AD_MC_NAME	☐	Name (field NAME1) in upper case for matchcode
43	MC_CITY1	ADRC	MC_CITY1		☐	AD_MC_CITY	☐	City name in upper case for search help
44	MC_STREET	ADRC	MC_STREET		☐	AD_MC_STRT	☐	Street name in upper case for search help
45	NAME1	ADRC	NAME1		☐	AD_NAME1	☐	Name 1
46	NAME2	ADRC	NAME2		☐	AD_NAME2	☐	Name 2
47	POST_CODE1	ADRC	POST_CODE1		☐	AD_PSTCD1	☐	City postal code
48	CITY1	ADRC	CITY1		☐	AD_CITY1	☐	City
49	STREET	ADRC	STREET		☐	AD_STREET	☐	Street
50	HOUSE_NUM1	ADRC	HOUSE_NUM1		☐	AD_HSNM1	☐	House 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	20140121
SAP Release Created in