SAP ABAP View V_EHAUADR (Test)

Hierarchy

☛ IS-UT (Software Component) SAP Utilities/Telecommunication
   ⤷ IS-U (Application Component) SAP Utilities
     ⤷ EE00 (Package) IS-U: General (Domains and General Objects)

Basic Data

View Type	D	Database View
Database View	V_EHAUADR
Short Description	Test
Root table	EHAUISU	Connect. Obj.

Table

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

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	ADRC	CLIENT	JL	EQ				0	0
2	ILOA	MANDT	JR	EQ			AND	0	0
3	ADRC	ADDRNUMBER	JL	EQ				0	0
4	ILOA	ADRNR	JR	EQ			AND	0	0
5	IFLOT	MANDT	JL	EQ				0	0
6	EHAUISU	MANDT	JR	EQ			AND	0	0
7	IFLOT	TPLNR	JL	EQ				0	0
8	EHAUISU	HAUS	JR	EQ			AND	0	0
9	IFLOT	MANDT	JL	EQ				0	0
10	ILOA	MANDT	JR	EQ			AND	0	0
11	IFLOT	TPLNR	JL	EQ				0	0
12	ILOA	TPLNR	JR	EQ			AND	0	0
13	IFLOT	ILOAN	JL	EQ				0	0
14	ILOA	ILOAN	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	CLIENT	ADRC	CLIENT		☐	MANDT	☐	Client
2	ADDRNUMBER	ADRC	ADDRNUMBER		☐	AD_ADDRNUM	☐	Address number
3	DATE_FROM	ADRC	DATE_FROM		☐	AD_DATE_FR	☐	Valid-from date - in current Release only 00010101 possible
4	NATION	ADRC	NATION		☐	AD_NATION	☐	Version ID for International Addresses
5	HAUS	EHAUISU	HAUS		☐	TPLNR	☐	Functional Location
6	ILOAN	ILOA	ILOAN		☐	ILOAN	☐	Location and account assignment for technical object
7	NAME1	ADRC	NAME1		☐	AD_NAME1	☐	Name 1
8	NAME2	ADRC	NAME2		☐	AD_NAME2	☐	Name 2
9	NAME3	ADRC	NAME3		☐	AD_NAME3	☐	Name 3
10	NAME4	ADRC	NAME4		☐	AD_NAME4	☐	Name 4
11	NAME_CO	ADRC	NAME_CO		☐	AD_NAME_CO	☐	c/o name
12	CITY1	ADRC	CITY1		☐	AD_CITY1	☐	City
13	CITY2	ADRC	CITY2		☐	AD_CITY2	☐	District
14	CITY_CODE	ADRC	CITY_CODE		☐	AD_CITYNUM	☐	City code for city/street file
15	POST_CODE1	ADRC	POST_CODE1		☐	AD_PSTCD1	☐	City postal code
16	POST_CODE2	ADRC	POST_CODE2		☐	AD_PSTCD2	☐	PO Box postal code
17	POST_CODE3	ADRC	POST_CODE3		☐	AD_PSTCD3	☐	Company postal code (for large customers)
18	TITLE	ADRC	TITLE		☐	AD_TITLE	☐	Form-of-Address Key
19	DATE_TO	ADRC	DATE_TO		☐	AD_DATE_TO	☐	Valid-to date in current Release only 99991231 possible
20	MLANG	IFLOT	MLANG		☐	MLANG	☐	Primary language for object texts
21	TPLKZ	IFLOT	TPLKZ		☐	TPLKZ	☐	Functional location structure indicators
22	FLTYP	IFLOT	FLTYP		☐	FLTYP	☐	Functional Location Category
23	TPLMA	IFLOT	TPLMA		☐	TPLMA	☐	Superior functional location
24	ERDAT	IFLOT	ERDAT		☐	ICRDT	☐	Date on Which Object Was Created
25	ERNAM	IFLOT	ERNAM		☐	ICRNA	☐	Name of User Who Created the Object
26	AEDAT	IFLOT	AEDAT		☐	IUPDT	☐	Date on which the object was last changed
27	AENAM	IFLOT	AENAM		☐	IUPNA	☐	Name of the User Who Last Changed the Object
28	DATAB	IFLOT	DATAB		☐	ILOM_DATAB	☐	Start-up Date of the Technical Object
29	PSTAE	IFLOT	PSTAE		☐	RESERVE_CHAR_004	☐	SAP Development reserve: Format CHAR, length 4
30	LVORM	IFLOT	LVORM		☐	RESERVE_CHAR_001	☐	SAP Development Reserve: Format CHAR, Length 1
31	SWERK	ILOA	SWERK		☐	SWERK	☐	Maintenance Plant
32	MSGRP	ILOA	MSGRP		☐	RAUMNR	☐	Room
33	STORT	ILOA	STORT		☐	PMLOC	☐	Location of maintenance object
34	BEBER	ILOA	BEBER		☐	BEBER	☐	Organizational Area
35	GSBER	ILOA	GSBER		☐	GSBER	☐	Business Area
36	PO_BOX	ADRC	PO_BOX		☐	AD_POBX	☐	PO Box
37	PO_BOX_LOC	ADRC	PO_BOX_LOC		☐	AD_POBXLOC	☐	PO Box city
38	POSTALAREA	ADRC	POSTALAREA		☐	AD_PSTLAR	☐	(Not Supported) Post Delivery District
39	TRANSPZONE	ADRC	TRANSPZONE		☐	LZONE	☐	Transportation zone to or from which the goods are delivered
40	STREET	ADRC	STREET		☐	AD_STREET	☐	Street
41	STREETCODE	ADRC	STREETCODE		☐	AD_STRNUM	☐	Street Number for City/Street File
42	STREETABBR	ADRC	STREETABBR		☐	AD_STRABBR	☐	(Not Supported) Abbreviation of Street Name
43	HOUSE_NUM1	ADRC	HOUSE_NUM1		☐	AD_HSNM1	☐	House Number
44	HOUSE_NUM2	ADRC	HOUSE_NUM2		☐	AD_HSNM2	☐	House number supplement
45	HOUSE_NUM3	ADRC	HOUSE_NUM3		☐	AD_HSNM3	☐	(Not supported) House Number Range
46	LOCATION	ADRC	LOCATION		☐	AD_LCTN	☐	Street 5
47	BUILDING	ADRC	BUILDING		☐	AD_BLDNG	☐	Building (Number or Code)
48	FLOOR	ADRC	FLOOR		☐	AD_FLOOR	☐	Floor in building
49	ROOMNUMBER	ADRC	ROOMNUMBER		☐	AD_ROOMNUM	☐	Room or Appartment Number
50	COUNTRY	ADRC	COUNTRY		☐	LAND1	☐	Country Key
51	REGION	ADRC	REGION		☐	REGIO	☐	Region (State, Province, County)

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