SAP ABAP View BBP_SUS_USER_SEA (View for Searching for Users in SUS UM)

Hierarchy

☛ SRM_SERVER (Software Component) SRM_SERVER
   ⤷ SRM-SUS (Application Component) Supplier Self Services
     ⤷ BBP_SUS_UI (Package) SUS UI-Layer (on SRM Server)

Basic Data

View Type	D	Database View
Database View	BBP_SUS_USER_SEA
Short Description	View for Searching for Users in SUS UM
Root table	USR21	User Name/Address Key Assignment

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	USR21	USR21
2	ADRP
3	ADR6

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	ADRP	CLIENT	JL	EQ				0	0
2	USR21	MANDT	JR	EQ			AND	0	0
3	ADR6	CLIENT	JL	EQ				0	0
4	USR21	MANDT	JR	EQ			AND	0	0
5	ADRP	PERSNUMBER	JL	EQ				0	0
6	USR21	PERSNUMBER	JR	EQ			AND	0	0
7	ADR6	PERSNUMBER	JL	EQ				0	0
8	USR21	PERSNUMBER	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	USR21	MANDT		☐	MANDT	☐	Client
2	BNAME	USR21	BNAME		☐	XUBNAME	☐	User Name in User Master Record
3	DATE_FROM	ADRP	DATE_FROM		☐	AD_DATE_FR	☐	Valid-from date - in current Release only 00010101 possible
4	DATE_FROM_ADR6	ADR6	DATE_FROM		☐	AD_DATE_FR	☐	Valid-from date - in current Release only 00010101 possible
5	CLIENT	ADRP	CLIENT		☐	MANDT	☐	Client
6	PERSNUMBER	ADRP	PERSNUMBER		☐	AD_PERSNUM	☐	Person number
7	NATION	ADRP	NATION		☐	AD_NATION	☐	Version ID for International Addresses
8	CLIENT_ADR6	ADR6	CLIENT		☐	MANDT	☐	Client
9	ADDRNUMBER	ADR6	ADDRNUMBER		☐	AD_ADDRNUM	☐	Address number
10	PERSNUMBER_ADR6	ADR6	PERSNUMBER		☐	AD_PERSNUM	☐	Person number
11	CONSNUMBER	ADR6	CONSNUMBER		☐	AD_CONSNUM	☐	Sequence Number
12	KOSTL	USR21	KOSTL		☐	XUKOSTL	☐	Cost center
13	DATE_TO	ADRP	DATE_TO		☐	AD_DATE_TO	☐	Valid-to date in current Release only 99991231 possible
14	NAME_FIRST	ADRP	NAME_FIRST		☐	AD_NAMEFIR	☐	First name
15	NAME_LAST	ADRP	NAME_LAST		☐	AD_NAMELAS	☐	Last name
16	NAME_TEXT	ADRP	NAME_TEXT		☐	AD_NAMTEXT	☐	Full Name of Person
17	LANGU	ADRP	LANGU		☐	SPRAS	☐	Language Key
18	MC_NAMEFIR	ADRP	MC_NAMEFIR		☐	AD_MC_NMFI	☐	First name in upper case for search help
19	MC_NAMELAS	ADRP	MC_NAMELAS		☐	AD_MC_NMLA	☐	Last name in upper-case for search help
20	SMTP_ADDR	ADR6	SMTP_ADDR		☐	AD_SMTPADR	☐	E-Mail Address
21	SMTP_SRCH	ADR6	SMTP_SRCH		☐	AD_SMTPAD2	☐	E-Mail Address Search Field
22	VALID_FROM	ADR6	VALID_FROM		☐	AD_VALFROM	☐	Communication Data: Valid From (YYYYMMDDHHMMSS)
23	VALID_TO	ADR6	VALID_TO		☐	AD_VALTO	☐	Communication Data: Valid To (YYYYMMDDHHMMSS)

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