SAP ABAP View V_SOUCADCP (SAPoffice: SAP Name -> User Data)

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_SOUCADCP
Short Description	SAPoffice: SAP Name -> User Data
Root table	SOUC	SAPoffice: Inverse user (SAP user)

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	SOUC	SOUC
2	SOUD
3	ADCP
4	ADRP

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	SOUC	MANDT	JL	EQ				0	0
2	SOUD	MANDT	JR	EQ			AND	0	0
3	SOUC	SAPNAM	JL	EQ				0	0
4	SOUD	SAPNAM	JR	EQ			AND	0	0
5	SOUC	USRTP	JL	EQ				0	0
6	SOUD	USRTP	JR	EQ			AND	0	0
7	SOUC	USRYR	JL	EQ				0	0
8	SOUD	USRYR	JR	EQ			AND	0	0
9	SOUC	USRNO	JL	EQ				0	0
10	SOUD	USRNO	JR	EQ			AND	0	0
11	SOUD	MANDT	JL	EQ				0	0
12	ADCP	CLIENT	JR	EQ			AND	0	0
13	SOUD	USRADR	JL	EQ				0	0
14	ADCP	SO_KEY	JR	EQ			AND	0	0
15	ADCP	CLIENT	JL	EQ				0	0
16	ADRP	CLIENT	JR	EQ			AND	0	0
17	ADCP	PERSNUMBER	JL	EQ				0	0
18	ADRP	PERSNUMBER	JR	EQ			AND	0	0
19	ADCP	DATE_FROM	JL	EQ				0	0
20	ADRP	DATE_FROM	JR	EQ			AND	0	0
21	ADCP	NATION	JL	EQ				0	0
22	ADRP	NATION	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	SOUD	USRTP		☐	SO_USR_TP	☐	User type from ID
4	USRYR	SOUD	USRYR		☐	SO_USR_YR	☐	User year from the ID
5	USRNO	SOUD	USRNO		☐	SO_USR_NO	☐	User number from the ID
6	ADDRNUMBER	ADCP	ADDRNUMBER		☐	AD_ADDRNUM	☐	Address number
7	PERSNUMBER	ADCP	PERSNUMBER		☐	AD_PERSNUM	☐	Person number
8	DATE_FROM	ADCP	DATE_FROM		☐	AD_DATE_FR	☐	Valid-from date - in current Release only 00010101 possible
9	NATION	ADCP	NATION		☐	AD_NATION	☐	Version ID for International Addresses
10	USRNAM	SOUC	USRNAM		☐	SO_USR_NAM	☐	SAPoffice user name
11	DELETED	SOUC	DELETED		☐	SO_USR_DEL	☐	SAPoffice: Office user was deleted
12	NAME_TEXT	ADRP	NAME_TEXT		☐	AD_NAMTEXT	☐	Full Name of Person

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