SAP ABAP View VUSER001 (User data view)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-SEC-USR-ADM (Application Component) User and Authorization Management
     ⤷ SUSR (Package) ABAP User Administration

Basic Data

View Type	D	Database View
Database View	VUSER001
Short Description	User data view
Root table	USR01	User master record (runtime data)

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	USR01	USR01
2	USR02	QCM1PEST01
3	USR03	QCM1PEST01
4	UST04	QCM1PEST01

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	USR01	BNAME	JL	EQ				0	0
2	USR02	BNAME	JR	EQ			AND	0	0
3	USR02	BNAME	JL	EQ				0	0
4	USR03	BNAME	JR	EQ			AND	0	0
5	USR03	BNAME	JL	EQ				0	0
6	UST04	BNAME	JR	EQ			AND	0	0
7	USR01	MANDT	JL	EQ				0	0
8	USR02	MANDT	JR	EQ			AND	0	0
9	USR02	MANDT	JL	EQ				0	0
10	USR03	MANDT	JR	EQ			AND	0	0
11	USR03	MANDT	JL	EQ				0	0
12	UST04	MANDT	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	USR01	MANDT		☐	MANDT	☐	Client
2	BNAME	USR01	BNAME		☐	XUBNAME	☐	User Name in User Master Record
3	STCOD	USR01	STCOD		☐	XUSTCOD	☐	Start menu (old, replaced by XUSTART)
4	SPLD	USR01	SPLD		☐	RSPOPNAME	☐	Spool: Output device
5	SPLG	USR01	SPLG		☐	XUSPLG	☐	Print parameter 1
6	SPDB	USR01	SPDB		☐	XUSPDB	☐	Print parameter 2
7	SPDA	USR01	SPDA		☐	XUSPDA	☐	Print parameter 3
8	DATFM	USR01	DATFM		☐	XUDATFM	☐	Date format
9	DCPFM	USR01	DCPFM		☐	XUDCPFM	☐	Decimal Format
10	HDEST	USR01	HDEST		☐	XUHDEST	☐	Host destination
11	HMAND	USR01	HMAND		☐	XUHMAND	☐	Default host client
12	HNAME	USR01	HNAME		☐	XUHNAME	☐	Default host user name
13	MENON	USR01	MENON		☐	XUMENON	☐	Automatic Start
14	MENUE	USR01	MENUE		☐	XUMENUE	☐	Menu name
15	STRTT	USR01	STRTT		☐	XUSTCOD	☐	Start menu (old, replaced by XUSTART)
16	LANGU	USR01	LANGU		☐	XULANGU	☐	Logon Language
17	CATTKENNZ	USR01	CATTKENNZ		☐	XUCATT	☐	CATT: Test Status
18	BCODE	USR02	BCODE		☐	XUCODE	☐	Password Hash Key
19	GLTGV	USR02	GLTGV		☐	XUGLTGV	☐	User valid from
20	GLTGB	USR02	GLTGB		☐	XUGLTGB	☐	User valid to
21	USTYP	USR02	USTYP		☐	XUUSTYP	☐	User Type
22	CLASS	USR02	CLASS		☐	XUCLASS	☐	User group in user master maintenance
23	LOCNT	USR02	LOCNT		☐	XULOCNT	☐	Number of failed logon attempts
24	UFLAG	USR02	UFLAG		☐	XUUFLAG	☐	User Lock Status
25	ACCNT	USR02	ACCNT		☐	XUACCNT	☐	Account ID
26	ANAME	USR02	ANAME		☐	XUANAME	☐	Creator of the User Master Record
27	ERDAT	USR02	ERDAT		☐	XUERDAT	☐	Creation Date of the User Master Record
28	TRDAT	USR02	TRDAT		☐	XULDATE	☐	Last Logon Date
29	LTIME	USR02	LTIME		☐	XULTIME	☐	Last Logon Time
30	OCOD1	USR02	OCOD1		☐	XUCODE	☐	Password Hash Key
31	BCDA1	USR02	BCDA1		☐	XUBCDAT	☐	Date of Last Password Change
32	CODV1	USR02	CODV1		☐	XUCODEVERS	☐	Code Version of Password Hash Algorithm (Old Systems)
33	OCOD2	USR02	OCOD2		☐	XUCODE	☐	Password Hash Key
34	BCDA2	USR02	BCDA2		☐	XUBCDAT	☐	Date of Last Password Change
35	CODV2	USR02	CODV2		☐	XUCODEVERS	☐	Code Version of Password Hash Algorithm (Old Systems)
36	OCOD3	USR02	OCOD3		☐	XUCODE	☐	Password Hash Key
37	BCDA3	USR02	BCDA3		☐	XUBCDAT	☐	Date of Last Password Change
38	CODV3	USR02	CODV3		☐	XUCODEVERS	☐	Code Version of Password Hash Algorithm (Old Systems)
39	OCOD4	USR02	OCOD4		☐	XUCODE	☐	Password Hash Key
40	BCDA4	USR02	BCDA4		☐	XUBCDAT	☐	Date of Last Password Change
41	CODV4	USR02	CODV4		☐	XUCODEVERS	☐	Code Version of Password Hash Algorithm (Old Systems)
42	OCOD5	USR02	OCOD5		☐	XUCODE	☐	Password Hash Key
43	BCDA5	USR02	BCDA5		☐	XUBCDAT	☐	Date of Last Password Change
44	CODV5	USR02	CODV5		☐	XUCODEVERS	☐	Code Version of Password Hash Algorithm (Old Systems)
45	VERSN	USR02	VERSN		☐	XUVERSION	☐	User master record version
46	CODVN	USR02	CODVN		☐	XUCODEVER2	☐	Code Version of Password Hash Algorithm (New Systems)
47	NAME1	USR03	NAME1		☐	XUNAME1	☐	Name of user within the company
48	NAME2	USR03	NAME2		☐	XUNAME1	☐	Name of user within the company
49	NAME3	USR03	NAME3		☐	XUNAME1	☐	Name of user within the company
50	NAME4	USR03	NAME4		☐	XUNAME1	☐	Name of user within the company
51	SALUT	USR03	SALUT		☐	XUSALUT	☐	Form of address for letters
52	ABTLG	USR03	ABTLG		☐	XUABTEI	☐	Department
53	KOSTL	USR03	KOSTL		☐	XUKOSTL	☐	Cost center
54	BUINR	USR03	BUINR		☐	XUBUINR	☐	Building number
55	ROONR	USR03	ROONR		☐	XUROONR	☐	Room number
56	STRAS	USR03	STRAS		☐	XUSTRAS	☐	Street and House Number
57	PFACH	USR03	PFACH		☐	XUPFACH	☐	PO box
58	PSTLZ	USR03	PSTLZ		☐	XUPSTLZ	☐	Postal code
59	ORT01	USR03	ORT01		☐	XUORT01	☐	Location
60	REGIO	USR03	REGIO		☐	REGIO	☐	Region (State, Province, County)
61	LAND1	USR03	LAND1		☐	LAND1	☐	Country Key
62	SPRAS	USR03	SPRAS		☐	XUSPRAS	☐	Language Key
63	TELPR	USR03	TELPR		☐	XUTELPR	☐	Telephone number (private)
64	TELNR	USR03	TELNR		☐	XUTELNR	☐	Telephone number (work)
65	TEL01	USR03	TEL01		☐	XUTEL01	☐	Telephone number
66	TEL02	USR03	TEL02		☐	XUTEL01	☐	Telephone number
67	TELX1	USR03	TELX1		☐	XUTELX1	☐	Telex number
68	TELFX	USR03	TELFX		☐	XUTELFX	☐	Fax Number
69	TELTX	USR03	TELTX		☐	XUTELTX	☐	Teletex number
70	ORT02	USR03	ORT02		☐	XUORT02	☐	Location
71	PSTL2	USR03	PSTL2		☐	XUPSTL2	☐	District Postal Code
72	TZONE	USR03	TZONE		☐	TZNZONE	☐	Time Zone
73	PROFILE	UST04	PROFILE		☐	XUPROFILE	☐	Profile name

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