SAP ABAP View V_SOUIADRP (SAPoffice: View of SOUI and Fields of SADRP (Addresses))

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_SOUIADRP
Short Description	SAPoffice: View of SOUI and Fields of SADRP (Addresses)
Root table	SOUD	SAPoffice: user definition

Table

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

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	SADRP	MANDT	JL	EQ				0	0
2	SOUD	MANDT	JR	EQ			AND	0	0
3	SADRP	ADRNR	JL	EQ				0	0
4	SOUD	USRADR	JR	EQ			AND	0	0
5	SADRP	NATIO	JL	EQ				0	0
6	SOUD	NATIO	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	SOUD	MANDT		☐	MANDT	☐	Client
2	USRTP	SOUD	USRTP		☐	SO_USR_TP	☐	User type from ID
3	USRYR	SOUD	USRYR		☐	SO_USR_YR	☐	User year from the ID
4	USRNO	SOUD	USRNO		☐	SO_USR_NO	☐	User number from the ID
5	SAPNAM	SOUD	SAPNAM		☐	SO_SAP_NAM	☐	SAP name of a SAPoffice user
6	USRNAM	SOUD	USRNAM		☐	SO_USR_NAM	☐	SAPoffice user name
7	DELETED	SOUD	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