SAP ABAP View V_EHAU_ADDRNRTXT (IS-U Connection Object: Optimized Access for Address Number)

Hierarchy

☛ IS-UT (Software Component) SAP Utilities/Telecommunication
   ⤷ IS-U-MD (Application Component) Master Data
     ⤷ EE01 (Package) IS-U Master Data

Basic Data

View Type	D	Database View
Database View	V_EHAU_ADDRNRTXT
Short Description	IS-U Connection Object: Optimized Access for Address Number
Root table	ILOA	PM Object Location and Account Assignment

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	ILOA	ILOA
2	IFLOT	IFLOT
3	EHAUISU
4	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	TPLNR	JL	EQ				0	0
4	IFLOT	TPLNR	JR	EQ			AND	0	0
5	EHAUISU	MANDT	JL	EQ				0	0
6	IFLOT	MANDT	JR	EQ			AND	0	0
7	EHAUISU	HAUS	JL	EQ				0	0
8	IFLOT	TPLNR	JR	EQ			AND	0	0
9	IFLOT	MANDT	JL	EQ				0	0
10	IFLOTX	MANDT	JR	EQ			AND	0	0
11	IFLOT	TPLNR	JL	EQ				0	0
12	IFLOTX	TPLNR	JR	EQ			AND	0	0
13	IFLOT	ISTYP		EQ	'C'			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	*	EHAUISU	*		☐		☐
2	MANDT	EHAUISU	MANDT		☐	MANDT	☐	Client
3	HAUS	EHAUISU	HAUS		☐	TPLNR	☐	Functional Location
4	COUNC	EHAUISU	COUNC		☐	COUNC	☐	County Code
5	REGIOGROUP	EHAUISU	REGIOGROUP		☐	REGIOGROUP	☐	Regional structure grouping
6	REGPOLIT	EHAUISU	REGPOLIT		☐	REGPOLIT	☐	Political regional structure element
7	REGIOGROUP_PERM	EHAUISU	REGIOGROUP_PERM		☐	REGIOGROUP_PERMIT	☐	Regional structure group for supply permit processing
8	CRM_GUID	EHAUISU	CRM_GUID		☐	EHAU_GUID	☐	CRM GUID of Connection Object
9	*	IFLOT	*		☐		☐
10	-	IFLOT	MANDT		☐	MANDT	☐	Client
11	TPLNR	IFLOT	TPLNR		☐	TPLNR	☐	Functional Location
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	-	IFLOT	PSTAE		☐	RESERVE_CHAR_004	☐	SAP Development reserve: Format CHAR, length 4
24	-	IFLOT	STNAM		☐	RESERVE_CHAR_012	☐	SAP Development Reserve: Format CHAR, Length 12
25	-	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	-	IFLOT	MAPAR		☐	MAPAR	☐	Manufacturer part number
29	-	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	-	IFLOT	LGWID		☐	LGWID	☐	Object ID of the Work Center
40	-	IFLOT	LGWIDI		☐	INH_LGWIDI	☐	Data Origin for the Field 'Work Center'
41	-	IFLOT	RBNR		☐	RBNR	☐	Report layout
42	-	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_SRTYPE	IFLOT	IFLOT_SRTYPE		☐	ILOM_SR_SRTYPE	☐	Shift Report Type for Object
68	IFLOT_SNTYPE	IFLOT	IFLOT_SNTYPE		☐	ILOM_SN_SNTYPE	☐	Notification Type for Shift Note for Object
69	ILOAN	ILOA	ILOAN		☐	ILOAN	☐	Location and account assignment for technical object
70	ADDRNUMBER	ILOA	ADRNR		☐	AD_ADDRNUM	☐	Address number
71	SWERK	ILOA	SWERK		☐	SWERK	☐	Maintenance Plant
72	SWERKI	ILOA	SWERKI		☐	INH_SWERKI	☐	Data origin for maintenance plant field
73	OWNER	ILOA	OWNER		☐	ILOM_OWNER	☐	Object reference indicator
74	SPRAS	IFLOTX	SPRAS		☐	SPRAS	☐	Language Key
75	PLTXT	IFLOTX	PLTXT		☐	PLTXT	☐	Description of 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