SE11 ABAP Dictionary SE11 USR02

Popular:

VBAK VBAP MARA MAKT BKPF BSEG BVOR EKKO EKPO KNA1 LFA1 LIKP VBRK

USR02

Logon Data (Kernel-Side Use)

SAP SAP Transparent Table 42 Fields

Primary Key:

MANDT BNAME

#	Field Name	Key	Field Label	Type	Length	Dec	Check Table	Short Description
1	MANDT	KEY	Client	CLNT	3	-	T000	Client
2	BNAME	KEY	User	CHAR	12	-	-	User Name in User Master Record
3	BCODE	-	/	RAW	8	-	-	Password Hash Key
4	GLTGV	-	Valid from	DATS	8	-	-	User valid from
5	GLTGB	-	Valid to	DATS	8	-	-	User valid to
6	USTYP	-	Type	CHAR	1	-	-	User Type
7	CLASS	-	Group	CHAR	12	-	-	User group in user master maintenance
8	LOCNT	-	Inc.Logons	INT1	3	-	-	Users with Incorrect Logon Attempts
9	UFLAG	-	Lock	INT1	3	-	-	User Lock Status
10	ACCNT	-	Account no	CHAR	12	-	-	Account ID
11	ANAME	-	Creator	CHAR	12	-	-	Creator of the User Master Record
12	ERDAT	-	Creat.Date	DATS	8	-	-	Creation Date of the User Master Record
13	TRDAT	-	Logon	DATS	8	-	-	Last Logon Date
14	LTIME	-	Logon	TIMS	6	-	-	Last Logon Time
15	OCOD1	-	/	RAW	8	-	-	Password Hash Key
16	BCDA1	-	Password	DATS	8	-	-	Date of Last Password Change
17	CODV1	-	Code vers.	CHAR	1	-	-	Code Version of Password Hash Algorithm (Old Systems)
18	OCOD2	-	/	RAW	8	-	-	Password Hash Key
19	BCDA2	-	Password	DATS	8	-	-	Date of Last Password Change
20	CODV2	-	Code vers.	CHAR	1	-	-	Code Version of Password Hash Algorithm (Old Systems)
21	OCOD3	-	/	RAW	8	-	-	Password Hash Key
22	BCDA3	-	Password	DATS	8	-	-	Date of Last Password Change
23	CODV3	-	Code vers.	CHAR	1	-	-	Code Version of Password Hash Algorithm (Old Systems)
24	OCOD4	-	/	RAW	8	-	-	Password Hash Key
25	BCDA4	-	Password	DATS	8	-	-	Date of Last Password Change
26	CODV4	-	Code vers.	CHAR	1	-	-	Code Version of Password Hash Algorithm (Old Systems)
27	OCOD5	-	/	RAW	8	-	-	Password Hash Key
28	BCDA5	-	Password	DATS	8	-	-	Date of Last Password Change
29	CODV5	-	Code vers.	CHAR	1	-	-	Code Version of Password Hash Algorithm (Old Systems)
30	VERSN	-	User master record version	CHAR	3	-	-	User master record version
31	CODVN	-	Code Vers.	CHAR	1	-	-	Code Version of Password Hash Algorithm (New Systems)
32	TZONE	-	Time Zone	CHAR	6	-	-	Time Zone
33	ZBVMASTER	-	CUA User Template: Logon not Possible Here	CHAR	1	-	-	CUA User Template: Logon not Possible Here
34	PASSCODE	-	Password	RAW	20	-	-	Password Hash Value (SHA1, 160 Bit)
35	PWDCHGDATE	-	Password	DATS	8	-	-	Date of Last Password Change
36	PWDSTATE	-	Password Change Mandatory / Optional (See Domain XUPWDSTATE)	INT1	3	-	-	Password Change Mandatory / Optional (See Domain XUPWDSTATE)
37	RESERVED	-	Reserved for Future Extensions	INT1	3	-	-	Reserved for Future Extensions
38	PWDHISTORY	-	Ext. Hist.	INT1	3	-	-	Indicator: Password History Stored in Table USRPWDHISTORY
39	PWDLGNDATE	-	PW Logon	DATS	8	-	-	Date of Last Password Logon
40	PWDSETDATE	-	PW Reset	DATS	8	-	-	Date: Password Reset by Administrator
41	PWDINITIAL	-	Initial PW	INT1	3	-	-	Indicator: Password Is Initial (= Set by Administrator)
42	PWDLOCKDATE	-	PW Lock	DATS	8	-	-	Date: Setting of Password Lock

Related References & SQL

Diagram ERD, T-Code standar, tabel terkait, dan contoh query untuk USR02.

Interactive ERD Diagrams

Belum terpasang pada pin diagram ERD.

Standard T-Codes

SE11 SE16

Related Tables

Tidak ada relasi langsung terdeteksi.

ANSI SQL Query

SELECT a.BNAME,
       a.BCODE,
       a.GLTGV,
       a.GLTGB,
       a.USTYP,
       a.CLASS
FROM USR02 AS a
WHERE a.BNAME = '0001';

ABAP OpenSQL (7.40+)

SELECT a~bname,
       a~bcode,
       a~gltgv,
       a~gltgb,
       a~ustyp,
       a~class
  FROM usr02 AS a
  WHERE a~bname = '0001'
  INTO TABLE @DATA(lt_usr02)
  UP TO 100 ROWS.

SE11 ABAP Dictionary SE11 USR02

USR02

Dictionary Fields Fields

Related References & SQL