USH02

Transparent Table Temporary Data
19 Fields 1 CDS Views

Change history for logon data

USH02 is an SAP database table in S/4HANA. Change history for logon data. It contains 19 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
SUIM_GET_USH02_EXT view_entity from USH02 + Action flag and Deletion records

Fields (19)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY bname XUBNAME User
KEY modda XUMODDATE Modification date
KEY modti XUMODTIME Modification time
KEY modbe XUMODIFIER Changed By
KEY tcode CHAR4 Undefined range (can be used for patch levels)
KEY repid REPID Program name
bcode XUCODE Initial PW
gltgv XUGLTGV Valid from
gltgb XUGLTGB Valid to
ustyp XUUSTYP User Type
class XUCLASS User Group
uflag XUUFLAG User Lock
accnt XUACCNT Account no.
passcode PWD_SHA1 Password Hash Val
codvn XUCODEVER2 Code Version
pwdinitial XUPWDINIT Initial Password
pwdsaltedhash PWD_HASH_STRING Hash Value
security_policy SECURITY_POLICY_NAME Security Policy

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Change history for logon data
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE USH02 (
    MANDT,            -- Client [MANDT]
    BNAME,            -- User [XUBNAME]
    MODDA,            -- Modification date [XUMODDATE]
    MODTI,            -- Modification time [XUMODTIME]
    MODBE,            -- Changed By [XUMODIFIER]
    TCODE,            -- Undefined range (can be used for patch levels) [CHAR4]
    REPID,            -- Program name [REPID]
    BCODE,            -- Initial PW [XUCODE]
    GLTGV,            -- Valid from [XUGLTGV]
    GLTGB,            -- Valid to [XUGLTGB]
    USTYP,            -- User Type [XUUSTYP]
    CLASS,            -- User Group [XUCLASS]
    UFLAG,            -- User Lock [XUUFLAG]
    ACCNT,            -- Account no. [XUACCNT]
    PASSCODE,         -- Password Hash Val [PWD_SHA1]
    CODVN,            -- Code Version [XUCODEVER2]
    PWDINITIAL,       -- Initial Password [XUPWDINIT]
    PWDSALTEDHASH,    -- Hash Value [PWD_HASH_STRING]
    SECURITY_POLICY,  -- Security Policy [SECURITY_POLICY_NAME]
    PRIMARY KEY (MANDT, BNAME, MODDA, MODTI, MODBE, TCODE, REPID)
);

Learn More