SAP ABAP View USER_ADDR_IDAD3 (Users by Address Data (Type 3)) is using

• Data Element (111)
• Table/Structure Field (222)
• Table (4)

#	Object Type	Object Name	Object Description	Note
1	Data Element	AD_ADDRCOM	(not used)
2	Data Element	AD_ADDRNUM	Address number
3	Data Element	AD_ADDR_ID	(Not supported) Physical address ID
4	Data Element	AD_BLDNG	Building (Number or Code)
5	Data Element	AD_BLDNG_P	Building (number or code)
6	Data Element	AD_CHECKST	City file test status
7	Data Element	AD_CIT2NUM	City PO box code (City file)
8	Data Element	AD_CITY1	City
9	Data Element	AD_CITY2	District
10	Data Element	AD_CITY3	City (different from postal city)
11	Data Element	AD_CITYHNM	Different city for city/street file
12	Data Element	AD_CITYNUM	City code for city/street file
13	Data Element	AD_CITYPNM	District code for City and Street file
14	Data Element	AD_COMM	Communication Method (Key) (Business Address Services)
15	Data Element	AD_DATE_FR	Valid-from date - in current Release only 00010101 possible
16	Data Element	AD_DATE_TO	Valid-to date in current Release only 99991231 possible
17	Data Element	AD_DPRTMNT	Department
18	Data Element	AD_EXTENS1	Extension (only for data conversion) (e.g. data line)
19	Data Element	AD_EXTENS2	Extension (only for data conversion) (e.g. telebox)
20	Data Element	AD_FLOOR	Floor in building
21	Data Element	AD_FLOOR	Floor in building
22	Data Element	AD_FNCTN	Function
23	Data Element	AD_FORMAT	Name format
24	Data Element	AD_FXNMBR1	First fax no.: dialling code+number
25	Data Element	AD_FXNMBR1	First fax no.: dialling code+number
26	Data Element	AD_FXXTNS1	First fax no.: extension
27	Data Element	AD_FXXTNS1	First fax no.: extension
28	Data Element	AD_GROUP	Address Group (Key) (Business Address Services)
29	Data Element	AD_GROUP_P	Person Group (Key) (Business Address Services)
30	Data Element	AD_HSNM1	House Number
31	Data Element	AD_HSNM2	House number supplement
32	Data Element	AD_HSNM3	(Not supported) House Number Range
33	Data Element	AD_ID_CODE	Short name for correspondence
34	Data Element	AD_IH_MAIL	Int. mail postal code
35	Data Element	AD_INITS	"Middle Initial" or personal initials
36	Data Element	AD_LANGUCR	Address record creation original language
37	Data Element	AD_LANGUCR	Address record creation original language
38	Data Element	AD_LCTN	Street 5
39	Data Element	AD_NAMCONV	Status of Field 'Full Name' NAME_TEXT
40	Data Element	AD_NAMCTRY	Country for name format rule
41	Data Element	AD_NAME1	Name 1
42	Data Element	AD_NAME2	Name 2
43	Data Element	AD_NAME2_P	Name of person at birth
44	Data Element	AD_NAME3	Name 3
45	Data Element	AD_NAME4	Name 4
46	Data Element	AD_NAMEFIR	First name
47	Data Element	AD_NAMELAS	Last name
48	Data Element	AD_NAMEMID	Middle name or second forename of a person
49	Data Element	AD_NAMETXT	Converted name field (with form of address)
50	Data Element	AD_NAME_CO	c/o name
51	Data Element	AD_NAMLAS2	Second surname of a person
52	Data Element	AD_NAMTEXT	Full Name of Person
53	Data Element	AD_NATION	Version ID for International Addresses
54	Data Element	AD_NICKNAM	Nickname or name used
55	Data Element	AD_ORIGINA	(Not Supported) Address Data Source (Key)
56	Data Element	AD_ORIGINP	Personal data source (key)
57	Data Element	AD_PERSNUM	Person number
58	Data Element	AD_POBX	PO Box
59	Data Element	AD_POBXCTY	PO box country
60	Data Element	AD_POBXLOC	PO Box city
61	Data Element	AD_POBXNUM	Flag: PO Box without number
62	Data Element	AD_POBXREG	Region for PO Box (Country, State, Province, ...)
63	Data Element	AD_PREFIX	Name Prefix (Key)
64	Data Element	AD_PREFIX2	2nd name prefix (key)
65	Data Element	AD_PROFESS	Profession
66	Data Element	AD_PST1XT	(Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code
67	Data Element	AD_PST2XT	(Not Supported) PO Box Postal Code Extension
68	Data Element	AD_PST3XT	(Not Supported) Major Customer Postal Code Extension
69	Data Element	AD_PSTCD1	City postal code
70	Data Element	AD_PSTCD2	PO Box postal code
71	Data Element	AD_PSTCD3	Company postal code (for large customers)
72	Data Element	AD_PSTLAR	(Not Supported) Post Delivery District
73	Data Element	AD_ROOMNUM	Room or Appartment Number
74	Data Element	AD_ROOMNUM	Room or Appartment Number
75	Data Element	AD_SEX	Gender key
76	Data Element	AD_SORT1	Search Term 1
77	Data Element	AD_SORT1	Search Term 1
78	Data Element	AD_SORT2	Search Term 2
79	Data Element	AD_SORT2	Search Term 2
80	Data Element	AD_SORTOLD	(Not Supported) Search Term
81	Data Element	AD_SORTOLD	(Not Supported) Search Term
82	Data Element	AD_SO_KEY	SAP-Office key
83	Data Element	AD_SRTPHN	(Not Supported) Phonetic Search Sort Field
84	Data Element	AD_SRTPHN	(Not Supported) Phonetic Search Sort Field
85	Data Element	AD_SRTPHN	(Not Supported) Phonetic Search Sort Field
86	Data Element	AD_STRABBR	(Not Supported) Abbreviation of Street Name
87	Data Element	AD_STREET	Street
88	Data Element	AD_STRNUM	Street Number for City/Street File
89	Data Element	AD_STRSPP1	Street 2
90	Data Element	AD_STRSPP2	Street 3
91	Data Element	AD_STRSPP3	Street 4
92	Data Element	AD_TITLE	Form-of-Address Key
93	Data Element	AD_TITLE	Form-of-Address Key
94	Data Element	AD_TITLE1	Academic Title: Key
95	Data Element	AD_TITLE2	Second academic title (key)
96	Data Element	AD_TITLES	Name supplement, e.g. noble title (key)
97	Data Element	AD_TLNMBR1	First telephone no.: dialling code+number
98	Data Element	AD_TLNMBR1	First telephone no.: dialling code+number
99	Data Element	AD_TLXTNS1	First Telephone No.: Extension
100	Data Element	AD_TLXTNS1	First Telephone No.: Extension
101	Data Element	AD_TXJCD	Tax Jurisdiction
102	Data Element	AD_TZONE	Address time zone
103	Data Element	LAND1	Country Key
104	Data Element	LZONE	Transportation zone to or from which the goods are delivered
105	Data Element	MANDT	Client
106	Data Element	REGIO	Region (State, Province, County)
107	Data Element	REGIOGROUP	Regional structure grouping
108	Data Element	SPRAS	Language Key
109	Data Element	SPRAS	Language Key
110	Data Element	SUIDADTYPE	Address Type of the Identity
111	Data Element	XUBNAME	User Name in User Master Record