SAP table USH02_ARC_TMP (Change History for Logon Data: Last Entries from Archive)

SAP table USH02_ARC_TMP 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