SAP table USH02 (Change history for logon data)

SAP table USH02 has 4 primary key fields being MANDT,BNAME,MODDA,MODTI.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 * MANDT
BNAME User Name in User Master Record CHAR 12 0 * XUBNAME
MODDA Modification date DATS 8 0 XUMODDATE
MODTI Modification time TIMS 6 0 XUMODTIME
MODBE Last Changed By CHAR 12 0 XUMODIFIER
TCODE Undefined range (can be used for patch levels) CHAR 4 0 CHAR4
REPID ABAP Program Name CHAR 40 0 REPID
BCODE Password Hash Key RAW 8 0 XUCODE
GLTGV User valid from DATS 8 0 XUGLTGV
GLTGB User valid to DATS 8 0 XUGLTGB
USTYP User Type CHAR 1 0 XUUSTYP
A Dialog
B System
C Communications Data
L Reference (Logon not possible)
S Service
CLASS User group in user master maintenance CHAR 12 0 * XUCLASS
UFLAG User Lock Status INT1 3 0 XUUFLAG
0 Not Locked
128 Locked Due To Incorrect Logons (Limited Term)
32 Locked Globally By Administrator
64 Locked Locally By Administrator
ACCNT Account ID CHAR 12 0 XUACCNT
PASSCODE Password Hash Value (SHA1, 160 Bit) RAW 20 0 PWD_SHA1
CODVN Code Version of Password Hash Algorithm (New Systems) CHAR 1 0 XUCODEVER2
A Code version A (obsolete)
B Code version B (MD5-based, 8 characters, uppercase, ASCII)
C Code Version C (Not Implemented)
D Code version D (MD5-based, 8 characters, uppercase, UTF-8)
E Code version E (= corrected code version D)
F Code version F (SHA1, 40 characters, case-sensitive, UTF-8)
G Code version G = version F + version B (two hash values)
H Code version H (generic hash method)
I Code version I = code versions H + F + B (three hash values)
X Password Deactivated
PWDINITIAL Indicator: Password Is Initial (= Set by Administrator) INT1 3 0 XUPWDINIT
PWDSALTEDHASH Password Hash Value (Various Algorithms and Codings) CHAR 255 0 PWD_HASH_STRING
SECURITY_POLICY Security Policy Name CHAR 40 0 SEC_POLICY_CUST SECURITY_POLICY_NAME

USH02 foreign key relationships

Table Field Check Table Check Field
0 USH02 SECURITY_POLICY SEC_POLICY_CUST Configuration of Security Policies CLIENT
0 USH02 SECURITY_POLICY SEC_POLICY_CUST Configuration of Security Policies NAME