SAP ABAP View V_SOUSRADR (SAPoffice: View for SAP user and his/her address)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-SRV-COM (Application Component) Communication Services: Mail, Fax, SMS, Telephony
     ⤷ SO (Package) SAPoffice

Basic Data

View Type	D	Database View
Database View	V_SOUSRADR
Short Description	SAPoffice: View for SAP user and his/her address
Root table	SOUC	SAPoffice: Inverse user (SAP user)

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	SOUC	SOUC
2	SOUD
3	SADRP

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	SOUD	MANDT	JL	EQ				0	0
2	SOUC	MANDT	JR	EQ			AND	0	0
3	SOUD	USRTP	JL	EQ				0	0
4	SOUC	USRTP	JR	EQ			AND	0	0
5	SOUD	USRYR	JL	EQ				0	0
6	SOUC	USRYR	JR	EQ			AND	0	0
7	SOUD	USRNO	JL	EQ				0	0
8	SOUC	USRNO	JR	EQ			AND	0	0
9	SADRP	MANDT	JL	EQ				0	0
10	SOUD	MANDT	JR	EQ			AND	0	0
11	SADRP	ADRNR	JL	EQ				0	0
12	SOUD	USRADR	JR	EQ			AND	0	0
13	SADRP	NATIO	JL	EQ				0	0
14	SOUD	NATIO	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	SOUC	MANDT		☐	MANDT	☐	Client
2	SAPNAM	SOUC	SAPNAM		☐	SO_SAP_NAM	☐	SAP name of a SAPoffice user
3	USRTP	SOUC	USRTP		☐	SO_USR_TP	☐	User type from ID
4	USRYR	SOUC	USRYR		☐	SO_USR_YR	☐	User year from the ID
5	USRNO	SOUC	USRNO		☐	SO_USR_NO	☐	User number from the ID
6	USRNAM	SOUC	USRNAM		☐	SO_USR_NAM	☐	SAPoffice user name
7	DELETED	SOUC	DELETED		☐	SO_USR_DEL	☐	SAPoffice: Office user was deleted
8	ADRNR	SADRP	ADRNR		☐	ADRNR	☐	Address
9	NATIO	SADRP	NATIO		☐	INTER	☐	International address version ID
10	ANRED	SADRP	ANRED		☐	ANRED	☐	Title
11	ABTEI	SADRP	ABTEI		☐	DEPTM	☐	Addresses: Department
12	COSTC	SADRP	COSTC		☐	COST_CT	☐	Addresses: Cost center
13	ROOMN	SADRP	ROOMN		☐	ROOM_NR	☐	Addresses: Room number
14	BUILD	SADRP	BUILD		☐	BUIL_NR	☐	Addresses: Building number
15	NAME1	SADRP	NAME1		☐	NAME1_BAS	☐	Name 1
16	NAME2	SADRP	NAME2		☐	NAME2_BAS	☐	Name 2
17	STDCOM	SADRP	STDCOM		☐	COM_ART	☐	Addresses: Communication type
18	SPRAS	SADRP	SPRAS		☐	SPRAS	☐	Language Key
19	CHNAM	SADRP	CHNAM		☐	CH_NAM	☐	Addresses: Changed by
20	CHDAT	SADRP	CHDAT		☐	CH_DAT	☐	Addresses: Change date
21	CHTIM	SADRP	CHTIM		☐	CH_TIM	☐	Addresses: Changed at
22	CRNAM	SADRP	CRNAM		☐	CR_NAM	☐	Addresses: Created by
23	CRDAT	SADRP	CRDAT		☐	CR_DAT	☐	Addresses: Creation date
24	CRTIM	SADRP	CRTIM		☐	CR_TIM	☐	Addresses: Creation time
25	KLASSE	SADRP	KLASSE		☐	SO_KLASSE	☐	Addresses: class assigned to an address
26	DBNAME	SADRP	DBNAME		☐	SYM_DST	☐	Addresses: System ID
27	CMPYADR	SADRP	CMPYADR		☐	CADNR	☐	Addresses: Address Number
28	ANREK	SADRP	ANREK		☐	ANREK	☐	Addresses: Form of address key
29	SORT1	SADRP	SORT1		☐	SORTL_BAS	☐	Sort field
30	SORT2	SADRP	SORT2		☐	SORT20	☐	Sort field
31	FNAME	SADRP	FNAME		☐	AD_FNAME	☐	A person's first name (Addresses)
32	UCFNAME	SADRP	UCFNAME		☐	AD_UCFNAME	☐	A person's first name in upper case (Addresses)
33	LNAME	SADRP	LNAME		☐	AD_LNAME	☐	A person's last name (Addresses)
34	UCLNAME	SADRP	UCLNAME		☐	AD_UCLNAME	☐	A person's last name (Addresses)
35	UCABTEI	SADRP	UCABTEI		☐	AD_UCABTEI	☐	Department in upper case (Addresses)
36	UCNAMECMPY	SADRP	UCNAMECMPY		☐	AD_UCNAMCP	☐	Company name in upper case (addresses)
37	USRTYPE	SADRP	USRTYPE		☐	AD_USRTYPE	☐	Flag: Person is internal SAP user
38	REFNR	SADRP	REFNR		☐	ADRNR_REF	☐	Address reference for alias names

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