SAP ABAP Table USR02 (Logon Data (Kernel-Side Use))

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-SEC-LGN (Application Component) Authentication and SSO
     ⤷ SUSR_KRN (Package) User Administration Tables Used Kernel-Side

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	USR02	Table Relationship Diagram
Short Description	Logon Data (Kernel-Side Use)

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	BNAME	☑	XUBNAME	XUBNAME	CHAR	12	0	User Name in User Master Record
3	BCODE	☐	XUCODE	XUCODE	RAW	8	0	Password Hash Key
4	GLTGV	☐	XUGLTGV	DATUM	DATS	8	0	User valid from
5	GLTGB	☐	XUGLTGB	DATUM	DATS	8	0	User valid to
6	USTYP	☐	XUUSTYP	XUUSTYP	CHAR	1	0	User Type
7	CLASS	☐	XUCLASS	XUCLASS	CHAR	12	0	User group in user master maintenance	USGRP
8	LOCNT	☐	XULOCNT	XULOCNT	INT1	3	0	Number of failed logon attempts
9	UFLAG	☐	XUUFLAG	XUUFLAG	INT1	3	0	User Lock Status
10	ACCNT	☐	XUACCNT	XUACCNT	CHAR	12	0	Account ID
11	ANAME	☐	XUANAME	BNAME	CHAR	12	0	Creator of the User Master Record
12	ERDAT	☐	XUERDAT	DATUM	DATS	8	0	Creation Date of the User Master Record
13	TRDAT	☐	XULDATE	DATUM	DATS	8	0	Last Logon Date
14	LTIME	☐	XULTIME	UZEIT	TIMS	6	0	Last Logon Time
15	OCOD1	☐	XUCODE	XUCODE	RAW	8	0	Password Hash Key
16	BCDA1	☐	XUBCDAT	DATUM	DATS	8	0	Date of Last Password Change
17	CODV1	☐	XUCODEVERS	XUCODEVERS	CHAR	1	0	Code Version of Password Hash Algorithm (Old Systems)
18	OCOD2	☐	XUCODE	XUCODE	RAW	8	0	Password Hash Key
19	BCDA2	☐	XUBCDAT	DATUM	DATS	8	0	Date of Last Password Change
20	CODV2	☐	XUCODEVERS	XUCODEVERS	CHAR	1	0	Code Version of Password Hash Algorithm (Old Systems)
21	OCOD3	☐	XUCODE	XUCODE	RAW	8	0	Password Hash Key
22	BCDA3	☐	XUBCDAT	DATUM	DATS	8	0	Date of Last Password Change
23	CODV3	☐	XUCODEVERS	XUCODEVERS	CHAR	1	0	Code Version of Password Hash Algorithm (Old Systems)
24	OCOD4	☐	XUCODE	XUCODE	RAW	8	0	Password Hash Key
25	BCDA4	☐	XUBCDAT	DATUM	DATS	8	0	Date of Last Password Change
26	CODV4	☐	XUCODEVERS	XUCODEVERS	CHAR	1	0	Code Version of Password Hash Algorithm (Old Systems)
27	OCOD5	☐	XUCODE	XUCODE	RAW	8	0	Password Hash Key
28	BCDA5	☐	XUBCDAT	DATUM	DATS	8	0	Date of Last Password Change
29	CODV5	☐	XUCODEVERS	XUCODEVERS	CHAR	1	0	Code Version of Password Hash Algorithm (Old Systems)
30	VERSN	☐	XUVERSION	XUVERSION	CHAR	3	0	User master record version
31	CODVN	☐	XUCODEVER2	XUCODEVER2	CHAR	1	0	Code Version of Password Hash Algorithm (New Systems)
32	TZONE	☐	TZNZONE	TZNZONE	CHAR	6	0	Time Zone	TTZZ
33	ZBVMASTER	☐	XUZBVFLAG	SAP_BOOL	CHAR	1	0	CUA User Template: Logon Not Possible Here
34	PASSCODE	☐	PWD_SHA1	SHA1_HASH	RAW	20	0	Password Hash Value (SHA1, 160 Bit)
35	PWDCHGDATE	☐	XUBCDAT	DATUM	DATS	8	0	Date of Last Password Change
36	PWDSTATE	☐	PWDCHGSTATE	PWDCHGSTATE	INT1	3	0	Password Change: Required / Allowed / Not Possible
37	RESERVED	☐	XUCUACNTL	XUCUACNTL	INT1	3	0	CUA Control Information
38	PWDHISTORY	☐	XUPWDHIST	IBOOLEAN	INT1	3	0	Indicator: Password History Stored in Table USRPWDHISTORY
39	PWDLGNDATE	☐	XULPDAT	DATUM	DATS	8	0	Date of Last Password Logon
40	PWDSETDATE	☐	XUSPDAT	DATUM	DATS	8	0	Date: Password Reset by Administrator
41	PWDINITIAL	☐	XUPWDINIT	IBOOLEAN3	INT1	3	0	Indicator: Password Is Initial (= Set by Administrator)
42	PWDLOCKDATE	☐	XUPLDAT	DATUM	DATS	8	0	Date: Setting of Password Lock
43	PWDSALTEDHASH	☐	PWD_HASH_STRING	PWD_HASH_STRING	CHAR	255	0	Password Hash Value (Various Algorithms and Codings)
44	SECURITY_POLICY	☐	SECURITY_POLICY_NAME	SECURITY_POLICY_NAME	CHAR	40	0	Security Policy Name	SEC_POLICY_CUST

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	USR02	CLASS	USGRP	USERGROUP
2	USR02	SECURITY_POLICY	SEC_POLICY_CUST	NAME
3	USR02	TZONE	TTZZ	TZONE

History

Last changed by/on	SAP	20110908
SAP Release Created in