SAP Table USR02

Logon Data (Kernel-Side Use)

The table USR02 (Logon Data (Kernel-Side Use)) is a standard table in SAP ERP. It belongs to the package SUSR.

Technical Information

Table	USR02
Short Text	Logon Data (Kernel-Side Use)
Package	SUSR
Table Type	Transparent Table

Fields for Table USR02

Field Name	Key	Description	Data Element	Type	Length	Check Table
MANDT	✔	Client	MANDT	CLNT	3	*
BNAME	✔	User Name in User Master Record	XUBNAME	CHAR	12
BCODE		Password Hash Key	XUCODE	RAW	8
GLTGV		User valid from	XUGLTGV	DATS	8
GLTGB		User valid to	XUGLTGB	DATS	8
USTYP		User Type	XUUSTYP	CHAR	1
CLASS		User group in user master maintenance	XUCLASS	CHAR	12	USGRP
LOCNT		Number of failed logon attempts	XULOCNT	INT1	3
UFLAG		User Lock Status	XUUFLAG	INT1	3
ACCNT		Account ID	XUACCNT	CHAR	12
ANAME		Creator of the User Master Record	XUANAME	CHAR	12
ERDAT		Creation Date of the User Master Record	XUERDAT	DATS	8
TRDAT		Last Logon Date	XULDATE	DATS	8
LTIME		Last Logon Time	XULTIME	TIMS	6
OCOD1		Password Hash Key	XUCODE	RAW	8
BCDA1		Date of Last Password Change	XUBCDAT	DATS	8
CODV1		Code Version of Password Hash Algorithm (Old Systems)	XUCODEVERS	CHAR	1
OCOD2		Password Hash Key	XUCODE	RAW	8
BCDA2		Date of Last Password Change	XUBCDAT	DATS	8
CODV2		Code Version of Password Hash Algorithm (Old Systems)	XUCODEVERS	CHAR	1
OCOD3		Password Hash Key	XUCODE	RAW	8
BCDA3		Date of Last Password Change	XUBCDAT	DATS	8
CODV3		Code Version of Password Hash Algorithm (Old Systems)	XUCODEVERS	CHAR	1
OCOD4		Password Hash Key	XUCODE	RAW	8
BCDA4		Date of Last Password Change	XUBCDAT	DATS	8
CODV4		Code Version of Password Hash Algorithm (Old Systems)	XUCODEVERS	CHAR	1
OCOD5		Password Hash Key	XUCODE	RAW	8
BCDA5		Date of Last Password Change	XUBCDAT	DATS	8
CODV5		Code Version of Password Hash Algorithm (Old Systems)	XUCODEVERS	CHAR	1
VERSN		User master record version	XUVERSION	CHAR	3
CODVN		Code Version of Password Hash Algorithm (New Systems)	XUCODEVER2	CHAR	1
TZONE		Time Zone	TZNZONE	CHAR	6	TTZZ
ZBVMASTER		CUA User Template: Logon Not Possible Here	XUZBVFLAG	CHAR	1
PASSCODE		Password Hash Value (SHA1, 160 Bit)	PWD_SHA1	RAW	20
PWDCHGDATE		Date of Last Password Change	XUBCDAT	DATS	8
PWDSTATE		Password Change: Required / Allowed / Not Possible	PWDCHGSTATE	INT1	3
RESERVED		CUA Control Information	XUCUACNTL	INT1	3
PWDHISTORY		Indicator: Password History Stored in Table USRPWDHISTORY	XUPWDHIST	INT1	3
PWDLGNDATE		Date of Last Password Logon	XULPDAT	DATS	8
PWDSETDATE		Date: Password Reset by Administrator	XUSPDAT	DATS	8
PWDINITIAL		Indicator: Password Is Initial (= Set by Administrator)	XUPWDINIT	INT1	3
PWDLOCKDATE		Date: Setting of Password Lock	XUPLDAT	DATS	8
PWDSALTEDHASH		Password Hash Value (Various Algorithms and Codings)	PWD_HASH_STRING	CHAR	255
SECURITY_POLICY		Security Policy Name	SECURITY_POLICY_NAME	CHAR	40	SEC_POLICY_CUST