SAP ABAP View /SRMERP/V_USR (ERP E-Procurement:View for Created By Input Help)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ MM-PUR-SSP (Application Component) Self-Service Procurement
     ⤷ /SRMERP/OL_MO (Package) Master Data Objects/Access

Basic Data

View Type	D	Database View
Database View	/SRMERP/V_USR
Short Description	ERP E-Procurement:View for Created By Input Help
Root table	USR21	User Name/Address Key Assignment

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	USR21	USR21
2	ADRC
3	ADRP
4	ADCP
5	/SRMERP/D_PERSON

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	ADRC	CLIENT	JL	EQ				0	0
2	USR21	MANDT	JR	EQ			AND	0	0
3	ADRC	ADDRNUMBER	JL	EQ				0	0
4	USR21	ADDRNUMBER	JR	EQ			AND	0	0
5	ADRP	CLIENT	JL	EQ				0	0
6	USR21	MANDT	JR	EQ			AND	0	0
7	ADRP	PERSNUMBER	JL	EQ				0	0
8	USR21	PERSNUMBER	JR	EQ			AND	0	0
9	ADCP	CLIENT	JL	EQ				0	0
10	USR21	MANDT	JR	EQ			AND	0	0
11	ADCP	ADDRNUMBER	JL	EQ				0	0
12	USR21	ADDRNUMBER	JR	EQ			AND	0	0
13	ADCP	PERSNUMBER	JL	EQ				0	0
14	USR21	PERSNUMBER	JR	EQ			AND	0	0
15	/SRMERP/D_PERSON	MANDT	JL	EQ				0	0
16	USR21	MANDT	JR	EQ			AND	0	0
17	/SRMERP/D_PERSON	USERNAME	JL	EQ				0	0
18	USR21	BNAME	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	KOSTL	USR21	KOSTL		☐	XUKOSTL	☐	Cost center
4	CITY1	ADRC	CITY1		☐	AD_CITY1	☐	City
5	POST_CODE1	ADRC	POST_CODE1		☐	AD_PSTCD1	☐	City postal code
6	NAME_FIRST	ADRP	NAME_FIRST		☐	AD_NAMEFIR	☐	First name
7	NAME_LAST	ADRP	NAME_LAST		☐	AD_NAMELAS	☐	Last name
8	DEPARTMENT	ADCP	DEPARTMENT		☐	AD_DPRTMNT	☐	Department
9	BUILDING	ADCP	BUILDING		☐	AD_BLDNG_P	☐	Building (number or code)
10	FLOOR	ADCP	FLOOR		☐	AD_FLOOR	☐	Floor in building
11	ROOMNUMBER	ADCP	ROOMNUMBER		☐	AD_ROOMNUM	☐	Room or Appartment Number
12	USERNAME	/SRMERP/D_PERSON	USERNAME		☐	XUBNAME	☐	User Name in User Master Record

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