USR02

Transparent Table Application Table
44 Fields 44 CDS Views

Logon Data (Kernel-Side Use)

USR02 is an SAP database table in S/4HANA. Logon Data (Kernel-Side Use). It contains 44 fields. 44 CDS views read from this table.

CDS Views using this table (44)

ViewTypeJoinVDMDescription
/AGIL/LUR_I_User view from Relevant Users
/dmbe/i_User_Description view inner Deal User Description
CUAN_ME_ME_QR_AUTH_USER_SEARCH view_entity inner CUAN_ME_ME_QR_AUTH_USER_SEARCH
I_Acmusr02 view from BASIC View of user-table: USR02, used by ACM
I_DFS_MaintUserDetailsBasic view from BASIC User Details Basic View
I_FrcElmntOrgUserDetails view from BASIC Basic view to read the user details
I_PrepaymentAgrmtUserNameText view from BASIC Prepayment Agreement User Name Text
I_PrepaymentAgrmtUserNameVH view from BASIC Prepayment Agrmt User Name VH
I_RSAU_UGROUP view from Cross Client User Group Assignments
I_SWI_WIIinvUsers view_entity inner Work Items with Invalid Users
I_SWI_WIIinvUsers view_entity left_outer Work Items with Invalid Users
I_SystemUser view from BASIC System Benutzer
I_UserBasic view_entity from BASIC Benutzer
P_BPUsrAssignment view_entity from BASIC Business User - User Assignment
P_BPUsrDetail view_entity inner BASIC Business User - User Detail
P_BPUsrEEWASmtpSrch view_entity inner BASIC Workplace Address Smtp Srch (BUM)
P_DDMRPController view left_outer BASIC
P_USER_ADDR view from BASIC F4 Suchhilfe für Benutzer
P_USER_LOGON view from BASIC Suche nach Logondaten
P_UserAddress view from BASIC Allgemeiner CDS View für Adresse
P_USERCREATIONTIMESTAMPS view_entity inner
P_USR_BY_GLOBALUID view inner BASIC User UUID
P_USR_EXTUID view inner BASIC Externe UID
P_USR_TO_GLOBALUID view inner BASIC User UUID
P_USR02 view from BASIC F4 Suchhilfe für Benutzer
P_USR02_USR21 view from User from USR02 and USR21
s_sclt_customeruser_ddl view from Customer User
SAIS_GAF_USER_F4_X view_entity inner GAF Value Help for Users (Helper)
SAIS_USER_F4_X view_entity inner BC-SEC Value Help for Users (Helper)
SAIS_USER_VALID_STATE view_entity from SUIM | Get User Valid Status
SUIM__USR_VAL_4_FLD_X view_entity from SUIM | Get Authorization Values
SUIM_GET_CR_USR_ATTRIB view_entity from SUIM|User Attr. for Crit.-Auth.
SUIM_GET_US_AUTH_S_TABU_DIS view_entity from Get S_TABU_DIS Auth. for User
SUIM_GET_US_AUTH_S_TABU_NAM view_entity from Get S_TABU_NAM Auth. for User
SUIM_IS_AUTH_TABU_ACT_X view_entity inner User with generic table authorizations
SUIM_S_USER_GRP view_entity from SUIM|List granted User Ids for ACTVT 03
SUIM_SECPOL_ATTR view_entity from Attributs of SecPol
SUIM_SECPOL_VIEW view_entity left_outer Get Profil Parameter for Users
SUIM_START_CHECK_FOR_TCD view_entity inner Authority Check for TCODE Start
SUIM_US_DOCU view_entity from SUIM | Get User Documentation List
SUIM_USER_VALID_STATE view_entity from SUIM | Get User Valid Status
usr_attr_id_assign_w_default view_entity from Zuordnung Benutzerattribute mit Default
Usr02_Class view from User with user group
VFCLM_BAM_DDL_USERFULLNAME view from User full name view

Fields (44)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY bname XUBNAME User
bcode XUCODE Initial PW
gltgv XUGLTGV Valid from
gltgb XUGLTGB Valid to
ustyp XUUSTYP User Type
class XUCLASS User Group
locnt XULOCNT Failed Logons
uflag XUUFLAG User Lock
accnt XUACCNT Account no.
aname XUANAME Creator
erdat XUERDAT Created On
trdat XULDATE Last Logon Date
ltime XULTIME Last Logon Time
ocod1 XUCODE Initial PW
bcda1 XUBCDAT Password Change
codv1 XUCODEVERS Code version
ocod2 XUCODE Initial PW
bcda2 XUBCDAT Password Change
codv2 XUCODEVERS Code version
ocod3 XUCODE Initial PW
bcda3 XUBCDAT Password Change
codv3 XUCODEVERS Code version
ocod4 XUCODE Initial PW
bcda4 XUBCDAT Password Change
codv4 XUCODEVERS Code version
ocod5 XUCODE Initial PW
bcda5 XUBCDAT Password Change
codv5 XUCODEVERS Code version
versn XUVERSION User master record version
codvn XUCODEVER2 Code Version
tzone TZNZONE Time Zone
zbvmaster XUZBVFLAG CUA User
passcode PWD_SHA1 Password Hash Val
pwdchgdate XUBCDAT Password Change
pwdstate PWDCHGSTATE Password Change
reserved XUCUACNTL CUA Control
pwdhistory XUPWDHIST External History
pwdlgndate XULPDAT Password Logon
pwdsetdate XUSPDAT Password Reset
pwdinitial XUPWDINIT Initial Password
pwdlockdate XUPLDAT Password Lock
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.

-- Logon Data (Kernel-Side Use)
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE USR02 (
    MANDT,            -- Client [MANDT]
    BNAME,            -- User [XUBNAME]
    BCODE,            -- Initial PW [XUCODE]
    GLTGV,            -- Valid from [XUGLTGV]
    GLTGB,            -- Valid to [XUGLTGB]
    USTYP,            -- User Type [XUUSTYP]
    CLASS,            -- User Group [XUCLASS]
    LOCNT,            -- Failed Logons [XULOCNT]
    UFLAG,            -- User Lock [XUUFLAG]
    ACCNT,            -- Account no. [XUACCNT]
    ANAME,            -- Creator [XUANAME]
    ERDAT,            -- Created On [XUERDAT]
    TRDAT,            -- Last Logon Date [XULDATE]
    LTIME,            -- Last Logon Time [XULTIME]
    OCOD1,            -- Initial PW [XUCODE]
    BCDA1,            -- Password Change [XUBCDAT]
    CODV1,            -- Code version [XUCODEVERS]
    OCOD2,            -- Initial PW [XUCODE]
    BCDA2,            -- Password Change [XUBCDAT]
    CODV2,            -- Code version [XUCODEVERS]
    OCOD3,            -- Initial PW [XUCODE]
    BCDA3,            -- Password Change [XUBCDAT]
    CODV3,            -- Code version [XUCODEVERS]
    OCOD4,            -- Initial PW [XUCODE]
    BCDA4,            -- Password Change [XUBCDAT]
    CODV4,            -- Code version [XUCODEVERS]
    OCOD5,            -- Initial PW [XUCODE]
    BCDA5,            -- Password Change [XUBCDAT]
    CODV5,            -- Code version [XUCODEVERS]
    VERSN,            -- User master record version [XUVERSION]
    CODVN,            -- Code Version [XUCODEVER2]
    TZONE,            -- Time Zone [TZNZONE]
    ZBVMASTER,        -- CUA User [XUZBVFLAG]
    PASSCODE,         -- Password Hash Val [PWD_SHA1]
    PWDCHGDATE,       -- Password Change [XUBCDAT]
    PWDSTATE,         -- Password Change [PWDCHGSTATE]
    RESERVED,         -- CUA Control [XUCUACNTL]
    PWDHISTORY,       -- External History [XUPWDHIST]
    PWDLGNDATE,       -- Password Logon [XULPDAT]
    PWDSETDATE,       -- Password Reset [XUSPDAT]
    PWDINITIAL,       -- Initial Password [XUPWDINIT]
    PWDLOCKDATE,      -- Password Lock [XUPLDAT]
    PWDSALTEDHASH,    -- Hash Value [PWD_HASH_STRING]
    SECURITY_POLICY,  -- Security Policy [SECURITY_POLICY_NAME]
    PRIMARY KEY (MANDT, BNAME)
);

Learn More