SAP ABAP View V_SOUCADRP (SAPoffice: Connection between SOUC 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_SOUCADRP
Short Description	SAPoffice: Connection between SOUC and SADRP
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	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