SAP ABAP View USER_ADDRS (Users by Address Data)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-SEC-USR-ADM (Application Component) User and Authorization Management
     ⤷ SUSR (Package) ABAP User Administration

Basic Data

View Type	D	Database View
Database View	USER_ADDRS
Short Description	Users by Address Data
Root table	USR21	User Name/Address Key Assignment

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	USR21	USR21
2	ADRP
3	ADCP
4	ADRC

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	ADRP	CLIENT	JL	EQ				0	0
2	ADCP	CLIENT	JR	EQ			AND	0	0
3	ADRP	PERSNUMBER	JL	EQ				0	0
4	ADCP	PERSNUMBER	JR	EQ			AND	0	0
5	ADRP	NATION	JL	EQ				0	0
6	ADCP	NATION	JR	EQ			AND	0	0
7	ADRP	PERSNUMBER	JL	EQ				0	0
8	USR21	PERSNUMBER	JR	EQ			AND	0	0
9	ADRC	CLIENT	JL	EQ				0	0
10	ADCP	CLIENT	JR	EQ			AND	0	0
11	ADRC	ADDRNUMBER	JL	EQ				0	0
12	ADCP	ADDRNUMBER	JR	EQ			AND	0	0
13	ADRC	NATION	JL	EQ				0	0
14	ADCP	NATION	JR	EQ			AND	0	0
15	ADRC	ADDRNUMBER	JL	EQ				0	0
16	USR21	ADDRNUMBER	JR	EQ			AND	0	0
17	ADRP	CLIENT	JL	EQ				0	0
18	USR21	MANDT	JR	EQ			AND	0	0
19	ADRP	DATE_FROM		EQ	'00010101'		AND	0	0
20	ADRP	NATION		EQ	' '		AND	0	0
21	ADRC	DATE_FROM		EQ	'00010101'		AND	0	0
22	ADRC	NATION		EQ	' '		AND	0	0
23	ADCP	DATE_FROM		EQ	'00010101'		AND	0	0
24	ADCP	NATION		EQ	' '			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	USR21	MANDT		☐	MANDT	☐	Client
2	BNAME	USR21	BNAME		☐	XUBNAME	☐	User Name in User Master Record
3	DATE_FROM	ADRP	DATE_FROM		☐	AD_DATE_FR	☐	Valid-from date - in current Release only 00010101 possible
4	NATION	ADRP	NATION		☐	AD_NATION	☐	Version ID for International Addresses
5	DATE_FROMCP	ADCP	DATE_FROM		☐	AD_DATE_FR	☐	Valid-from date - in current Release only 00010101 possible
6	DATE_FROMC	ADRC	DATE_FROM		☐	AD_DATE_FR	☐	Valid-from date - in current Release only 00010101 possible
7	NAME_FIRST	ADRP	NAME_FIRST		☐	AD_NAMEFIR	☐	First name
8	NAME_LAST	ADRP	NAME_LAST		☐	AD_NAMELAS	☐	Last name
9	NAME_TEXT	ADRP	NAME_TEXT		☐	AD_NAMTEXT	☐	Full Name of Person
10	MC_NAMEFIR	ADRP	MC_NAMEFIR		☐	AD_MC_NMFI	☐	First name in upper case for search help
11	MC_NAMELAS	ADRP	MC_NAMELAS		☐	AD_MC_NMLA	☐	Last name in upper-case for search help
12	TEL_EXTENS	ADCP	TEL_EXTENS		☐	AD_TLXTNS1	☐	First Telephone No.: Extension
13	FAX_EXTENS	ADCP	FAX_EXTENS		☐	AD_FXXTNS1	☐	First fax no.: extension
14	BUILDING	ADCP	BUILDING		☐	AD_BLDNG_P	☐	Building (number or code)
15	ROOMNUMBER	ADCP	ROOMNUMBER		☐	AD_ROOMNUM	☐	Room or Appartment Number
16	DEPARTMENT	ADCP	DEPARTMENT		☐	AD_DPRTMNT	☐	Department
17	FUNCTION	ADCP	FUNCTION		☐	AD_FNCTN	☐	Function
18	INHOUSE_ML	ADCP	IH_MAIL		☐	AD_IH_MAIL	☐	Int. mail postal code
19	NAME1	ADRC	NAME1		☐	AD_NAME1	☐	Name 1
20	CITY1	ADRC	CITY1		☐	AD_CITY1	☐	City
21	MC_NAME1	ADRC	MC_NAME1		☐	AD_MC_NAME	☐	Name (field NAME1) in upper case for matchcode
22	MC_CITY1	ADRC	MC_CITY1		☐	AD_MC_CITY	☐	City name in upper case for search help

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	20141013
SAP Release Created in	640