SAP ABAP View IFLM_ADDR (Address View for Collective Search Help IFLM)

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

Table

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

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	ILOA	OWNER		EQ	'2'		AND	0	0
16	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	ABCKZ	ILOA	ABCKZ		☐	ABCKZ	☐	ABC Indicator for Technical Object
12	EQFNR	ILOA	EQFNR		☐	EQFNR	☐	Sort Field
13	SWERK	ILOA	SWERK		☐	SWERK	☐	Maintenance Plant
14	STORT	ILOA	STORT		☐	PMLOC	☐	Location of maintenance object
15	MSGRP	ILOA	MSGRP		☐	RAUMNR	☐	Room
16	BEBER	ILOA	BEBER		☐	BEBER	☐	Organizational Area
17	KOKRS	ILOA	KOKRS		☐	KOKRS	☐	Controlling Area
18	KOSTL	ILOA	KOSTL		☐	KOSTL	☐	Cost Center
19	BUKRS	ILOA	BUKRS		☐	BUKRS	☐	Company Code
20	ANLNR	ILOA	ANLNR		☐	ANLN1	☐	Main Asset Number
21	ANLUN	ILOA	ANLUN		☐	ANLN2	☐	Asset Subnumber
22	VKORG	ILOA	VKORG		☐	VKORG	☐	Sales Organization
23	VTWEG	ILOA	VTWEG		☐	VTWEG	☐	Distribution Channel
24	SPART	ILOA	SPART		☐	SPART	☐	Division
25	VKBUR	ILOA	VKBUR		☐	VKBUR	☐	Sales office
26	VKGRP	ILOA	VKGRP		☐	VKGRP	☐	Sales group
27	OWNER	ILOA	OWNER		☐	ILOM_OWNER	☐	Object reference indicator
28	SPRAS	IFLOTX	SPRAS		☐	SPRAS	☐	Language Key
29	KZMLA	IFLOTX	KZMLA		☐	KZMLA	☐	Primary language indicator for text segment
30	PLTXT	IFLOTX	PLTXT		☐	PLTXT	☐	Description of functional location
31	PLTXU	IFLOTX	PLTXU		☐	ILOM_PLTXU	☐	Description of functional location in capital letters
32	ADRNR	ILOA	ADRNR		☐	AD_ADDRNUM	☐	Address number
33	ADRNRI	ILOA	ADRNRI		☐	INH_ADRNRI	☐	Data origin for address field
34	NAME_TEXT	ADRC	NAME_TEXT		☐	AD_NAMETXT	☐	Converted name field (with form of address)
35	ADDR_GROUP	ADRC	ADDR_GROUP		☐	AD_GROUP	☐	Address Group (Key) (Business Address Services)
36	SORT1	ADRC	SORT1		☐	AD_SORT1	☐	Search Term 1
37	SORT2	ADRC	SORT2		☐	AD_SORT2	☐	Search Term 2
38	MC_NAME1	ADRC	MC_NAME1		☐	AD_MC_NAME	☐	Name (field NAME1) in upper case for matchcode
39	MC_CITY1	ADRC	MC_CITY1		☐	AD_MC_CITY	☐	City name in upper case for search help
40	MC_STREET	ADRC	MC_STREET		☐	AD_MC_STRT	☐	Street name in upper case for search help
41	NAME1	ADRC	NAME1		☐	AD_NAME1	☐	Name 1
42	NAME2	ADRC	NAME2		☐	AD_NAME2	☐	Name 2
43	POST_CODE1	ADRC	POST_CODE1		☐	AD_PSTCD1	☐	City postal code
44	CITY1	ADRC	CITY1		☐	AD_CITY1	☐	City
45	STREET	ADRC	STREET		☐	AD_STREET	☐	Street
46	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