SAP ABAP View V_SOUBADRP (SAPoffice: Connection between SOUB and SADRP)

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_SOUBADRP
Short Description	SAPoffice: Connection between SOUB and SADRP
Root table	SOUB	SAPoffice: Inverse user (SAPoffice user)

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	SOUB	SOUB
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	SOUB	MANDT	JR	EQ			AND	0	0
3	SOUD	USRTP	JL	EQ				0	0
4	SOUB	USRTP	JR	EQ			AND	0	0
5	SOUD	USRYR	JL	EQ				0	0
6	SOUB	USRYR	JR	EQ			AND	0	0
7	SOUD	USRNO	JL	EQ				0	0
8	SOUB	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	SOUB	MANDT		☐	MANDT	☐	Client
2	USRNAM	SOUB	USRNAM		☐	SO_USR_NAM	☐	SAPoffice user name
3	USRTP	SOUB	USRTP		☐	SO_USR_TP	☐	User type from ID
4	USRYR	SOUB	USRYR		☐	SO_USR_YR	☐	User year from the ID
5	USRNO	SOUB	USRNO		☐	SO_USR_NO	☐	User number from the ID
6	SAPNAM	SOUB	SAPNAM		☐	SO_SAP_NAM	☐	SAP name of a SAPoffice user
7	DELETED	SOUB	DELETED		☐	SO_USR_DEL	☐	SAPoffice: Office user was deleted
8	ADRNAME	SADRP	NAME1		☐	NAME1_BAS	☐	Name 1

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