SAP ABAP View USER_ADDR (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_ADDR
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	ADRC
3	ADRP
4	ADCP
5	USCOMPANY

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	USR21	MANDT	JR	EQ			AND	0	0
3	ADRC	ADDRNUMBER	JL	EQ				0	0
4	USR21	ADDRNUMBER	JR	EQ			AND	0	0
5	ADRP	CLIENT	JL	EQ				0	0
6	USR21	MANDT	JR	EQ			AND	0	0
7	ADRP	PERSNUMBER	JL	EQ				0	0
8	USR21	PERSNUMBER	JR	EQ			AND	0	0
9	ADCP	CLIENT	JL	EQ				0	0
10	USR21	MANDT	JR	EQ			AND	0	0
11	ADCP	ADDRNUMBER	JL	EQ				0	0
12	USR21	ADDRNUMBER	JR	EQ			AND	0	0
13	ADCP	PERSNUMBER	JL	EQ				0	0
14	USR21	PERSNUMBER	JR	EQ			AND	0	0
15	USCOMPANY	MANDT	JL	EQ				0	0
16	USR21	MANDT	JR	EQ			AND	0	0
17	USCOMPANY	ADDRNUMBER	JL	EQ				0	0
18	USR21	ADDRNUMBER	JR	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	NAME_FIRST	ADRP	NAME_FIRST		☐	AD_NAMEFIR	☐	First name
4	NAME_LAST	ADRP	NAME_LAST		☐	AD_NAMELAS	☐	Last name
5	NAME_TEXTC	ADRP	NAME_TEXT		☐	AD_NAMTEXT	☐	Full Name of Person
6	TEL_EXTENS	ADCP	TEL_EXTENS		☐	AD_TLXTNS1	☐	First Telephone No.: Extension
7	KOSTL	USR21	KOSTL		☐	XUKOSTL	☐	Cost center
8	BUILDING	ADCP	BUILDING		☐	AD_BLDNG_P	☐	Building (number or code)
9	ROOMNUMBER	ADCP	ROOMNUMBER		☐	AD_ROOMNUM	☐	Room or Appartment Number
10	DEPARTMENT	ADCP	DEPARTMENT		☐	AD_DPRTMNT	☐	Department
11	INHOUSE_ML	ADCP	IH_MAIL		☐	AD_IH_MAIL	☐	Int. mail postal code
12	NAME1	ADRC	NAME1		☐	AD_NAME1	☐	Name 1
13	CITY1	ADRC	CITY1		☐	AD_CITY1	☐	City
14	POST_CODE1	ADRC	POST_CODE1		☐	AD_PSTCD1	☐	City postal code
15	MC_NAMEFIR	ADRP	MC_NAMEFIR		☐	AD_MC_NMFI	☐	First name in upper case for search help
16	MC_NAMELAS	ADRP	MC_NAMELAS		☐	AD_MC_NMLA	☐	Last name in upper-case for search help
17	MC_NAME1	ADRC	MC_NAME1		☐	AD_MC_NAME	☐	Name (field NAME1) in upper case for matchcode
18	MC_CITY1	ADRC	MC_CITY1		☐	AD_MC_CITY	☐	City name in upper case for search help
19	COMPANY	USCOMPANY	COMPANY		☐	USCOMP	☐	Company address, cross-system key

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