USR02

Transparent Table Application Table
44 Fields 35 CDS Views

Anmeldedaten (kernelseitige Verwendung !!!)

USR02 is an SAP database table in S/4HANA. Anmeldedaten (kernelseitige Verwendung !!!). It contains 44 fields. 35 CDS views read from this table.

CDS Views using this table (35)

ViewTypeJoinVDMDescription
/dmbe/i_User_Description view inner Deal User Description
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
P_BPUsrAssignment view from BASIC Business User - User Assignment
P_BPUsrDetail view inner BASIC Business User - User Detail
P_BPUsrEEWASmtpSrch view inner BASIC Business User Workplace Address Smtp Srch
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 Allegmeine CDS View für Adresse
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_JOB_LIST_EXA view inner Get list of sheduled job steps with user data
SAIS_JOB_LIST_EXC_GET view inner Get latest execution timestamp per job and bname tupel
SAIS_JOB_LIST_SHD view inner Get list of sheduled job steps with user data
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_SECPOL_ATTR view_entity from Attributs of SecPol
SUIM_SECPOL_VIEW view_entity left_outer Get Profil Parameter for Users
SUIM_US_DOCU view_entity from SUIM | Get User Documentation List
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.

-- Anmeldedaten (kernelseitige Verwendung !!!)
-- 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