1. Home
  2. Resources
  3. SAP Tables
  4. USH02 - Change history for logon data

SAP Table USH02

Change history for logon data

USH02 (Change history for logon data) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link USH02 to other SAP tables.

USH02 table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
BNAME User Name in User Master Record XUBNAME CHAR 12 0
MODDA Modification date XUMODDATE DATS 8 0
MODTI Modification time XUMODTIME TIMS 6 0
MODBE Last Changed By XUMODIFIER CHAR 12 0
TCODE Not More Closely Defined Area, Possibly Used for Patchlevels CHAR4 CHAR 4 0
REPID ABAP Program Name REPID CHAR 40 0
BCODE Password Hash Key XUCODE RAW 8 0
GLTGV User valid from XUGLTGV DATS 8 0
GLTGB User valid to XUGLTGB DATS 8 0
USTYP User Type XUUSTYP CHAR 1 0
A Dialog
B System
C Communications Data
L Reference (Logon not possible)
S Service
CLASS User group in user master maintenance XUCLASS CHAR 12 0
UFLAG User Lock Status XUUFLAG INT1 3 0
0 Not Locked
32 Locked Globally By Administrator
64 Locked Locally By Administrator
128 Locked Due To Incorrect Logons (Limited Term)
ACCNT Account ID XUACCNT CHAR 12 0
PASSCODE Password Hash Value (SHA1, 160 Bit) PWD_SHA1 RAW 20 0
CODVN Code Version of Password Hash Algorithm (New Systems) XUCODEVER2 CHAR 1 0
A Code Version A (Obsolete)
B Code Version B (MD5-Based, 8 Characters, Upper-Case, ASCII)
C Code Version C (Not Implemented)
D Code Version D (MD5-Based, 8 Characters, Upper-Case, 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 = Code Vers. F + Code Vers. B (2 Hash Values)
H Code Version H (Generic Hash Procedure)
I Code Version I = Code Versions H + F + B (Three Hash Values)
X Password Deactivated
PWDINITIAL Indicator: Password Is Initial (= Set by Administrator) XUPWDINIT INT1 3 0
0 Undetermined (Initial)
1 True
2 False
PWDSALTEDHASH Password Hash Value (Various Algorithms and Codings) PWD_HASH_STRING CHAR 255 0
SECURITY_POLICY Security Policy Name SECURITY_POLICY_NAME SEC_POLICY_CUST CHAR 40 0

USH02 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
USH02 SECURITY_POLICY USH02 MANDT SEC_POLICY_CUST Configuration of Security Policies CLIENT
USH02 SECURITY_POLICY USH02 SECURITY_POLICY SEC_POLICY_CUST Configuration of Security Policies NAME