USR02 SAP Table - Logon Data (Kernel-Side Use)
USR02 is a standard SAP table available within R/3 SAP systems depending on your version and release level. Below is the standard documentation available for this table and a few details of the fields which make up this table. You can view this information and more if you enter the table name USR02 into the relevant SAP transaction such as SE11 or SE80. You can also view the data contained in this database table via these transactions or alternatively use transaction SE16
Within the comments section below there is also an opportunity for anyone to be able add useful hints and information specific to this SAP object. This means that you and other users will be able to find these details quickly by simply searching on the object name USR02 .
Dictionary fields for SAP Table USR02
|
Field
|
Data Element
|
Data Type
|
length
|
Checktable
|
|
MANDT
|
MANDT
|
CLNT
|
000003
|
*
|
|
BNAME
|
XUBNAME
|
CHAR
|
000012
|
|
|
BCODE
|
XUCODE
|
RAW
|
000008
|
|
|
GLTGV
|
XUGLTGV
|
DATS
|
000008
|
|
|
GLTGB
|
XUGLTGB
|
DATS
|
000008
|
|
|
USTYP
|
XUUSTYP
|
CHAR
|
000001
|
|
|
CLASS
|
XUCLASS
|
CHAR
|
000012
|
USGRP
|
|
LOCNT
|
XULOCNT
|
INT1
|
000003
|
|
|
UFLAG
|
XUUFLAG
|
INT1
|
000003
|
|
|
ACCNT
|
XUACCNT
|
CHAR
|
000012
|
|
|
ANAME
|
XUANAME
|
CHAR
|
000012
|
|
|
ERDAT
|
XUERDAT
|
DATS
|
000008
|
|
|
TRDAT
|
XULDATE
|
DATS
|
000008
|
|
|
LTIME
|
XULTIME
|
TIMS
|
000006
|
|
|
OCOD1
|
XUCODE
|
RAW
|
000008
|
|
|
BCDA1
|
XUBCDAT
|
DATS
|
000008
|
|
|
CODV1
|
XUCODEVERS
|
CHAR
|
000001
|
|
|
OCOD2
|
XUCODE
|
RAW
|
000008
|
|
|
BCDA2
|
XUBCDAT
|
DATS
|
000008
|
|
|
CODV2
|
XUCODEVERS
|
CHAR
|
000001
|
|
|
OCOD3
|
XUCODE
|
RAW
|
000008
|
|
|
BCDA3
|
XUBCDAT
|
DATS
|
000008
|
|
|
CODV3
|
XUCODEVERS
|
CHAR
|
000001
|
|
|
OCOD4
|
XUCODE
|
RAW
|
000008
|
|
|
BCDA4
|
XUBCDAT
|
DATS
|
000008
|
|
|
CODV4
|
XUCODEVERS
|
CHAR
|
000001
|
|
|
OCOD5
|
XUCODE
|
RAW
|
000008
|
|
|
BCDA5
|
XUBCDAT
|
DATS
|
000008
|
|
|
CODV5
|
XUCODEVERS
|
CHAR
|
000001
|
|
|
VERSN
|
XUVERSION
|
CHAR
|
000003
|
|
|
CODVN
|
XUCODEVER2
|
CHAR
|
000001
|
|
|
TZONE
|
TZNZONE
|
CHAR
|
000006
|
TTZZ
|
|
ZBVMASTER
|
|
CHAR
|
000001
|
|
|
PASSCODE
|
PWD_SHA1
|
RAW
|
000020
|
|
|
PWDCHGDATE
|
XUBCDAT
|
DATS
|
000008
|
|
|
PWDSTATE
|
|
INT1
|
000003
|
|
|
RESERVED
|
|
INT1
|
000003
|
|
|
PWDHISTORY
|
XUPWDHIST
|
INT1
|
000003
|
|
|
PWDLGNDATE
|
XULPDAT
|
DATS
|
000008
|
|
|
PWDSETDATE
|
XUSPDAT
|
DATS
|
000008
|
|
|
PWDINITIAL
|
XUPWDINIT
|
INT1
|
000003
|
|
|
PWDLOCKDATE
|
XUPLDAT
|
DATS
|
000008
|
|
|
