SAP ABAP View /VIRSA/USER_ADDR (User According to Address Data)

Hierarchy

☛ GRCPINW (Software Component) SAP GRC NetWeaver Plug-In
   ⤷ GRC-ACP (Application Component) GRC Access Control Plug-In
     ⤷ /VIRSA/ZVIR (Package) Virsa Tools

Basic Data

View Type	D	Database View
Database View	/VIRSA/USER_ADDR
Short Description	User According to 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

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	ADRP	PERS_GROUP		EQ	'BC01'			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_NUMBER	ADCP	TEL_NUMBER		☐	AD_TLNMBR1	☐	First telephone no.: dialling code+number
7	TEL_EXTENS	ADCP	TEL_EXTENS		☐	AD_TLXTNS1	☐	First Telephone No.: Extension
8	KOSTL	USR21	KOSTL		☐	XUKOSTL	☐	Cost center
9	BUILDING	ADCP	BUILDING		☐	AD_BLDNG_P	☐	Building (number or code)
10	ROOMNUMBER	ADCP	ROOMNUMBER		☐	AD_ROOMNUM	☐	Room or Appartment Number
11	DEPARTMENT	ADCP	DEPARTMENT		☐	AD_DPRTMNT	☐	Department
12	INHOUSE_ML	ADCP	IH_MAIL		☐	AD_IH_MAIL	☐	Int. mail postal code
13	NAME1	ADRC	NAME1		☐	AD_NAME1	☐	Name 1
14	CITY1	ADRC	CITY1		☐	AD_CITY1	☐	City
15	POST_CODE1	ADRC	POST_CODE1		☐	AD_PSTCD1	☐	City postal code
16	MC_NAMEFIR	ADRP	MC_NAMEFIR		☐	AD_MC_NMFI	☐	First name in upper case for search help
17	MC_NAMELAS	ADRP	MC_NAMELAS		☐	AD_MC_NMLA	☐	Last name in upper-case for search help
18	MC_NAME1	ADRC	MC_NAME1		☐	AD_MC_NAME	☐	Name (field NAME1) in upper case for matchcode
19	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	20141106
SAP Release Created in