USRACL

Transparent Table Application Table
17 Fields 2 CDS Views

SNC Access Control List (ACL): User

USRACL is an SAP database table in S/4HANA. SNC Access Control List (ACL): User. It contains 17 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_SWI_WIIinvUsers view_entity left_outer Work Items with Invalid Users
P_UserSNC view_entity left_outer User SNC Data

Fields (17)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY bname XUBNAME User
KEY snc_sid SNC_SID Ext. security system
guiflag SNC_GUIFLG Password Logon
pname SNC_PNAME SNC name
hname SNC_HNAME Hash value
cname XUBNAME User
cdate XUMODDATE Modification date
ctime XUMODTIME Modification time
mname XUMODIFIER Changed By
mdate XUMODDATE Modification date
mtime XUMODTIME Modification time
chkversion abap.int1
chkval abap.raw
reserve abap.char
knamelen LONG_LEN LCHR or LRAW length
kname SNC_KNAME Canonical SNC name

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.

-- SNC Access Control List (ACL): User
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE USRACL (
    MANDT,       -- Client [MANDT]
    BNAME,       -- User [XUBNAME]
    SNC_SID,     -- Ext. security system [SNC_SID]
    GUIFLAG,     -- Password Logon [SNC_GUIFLG]
    PNAME,       -- SNC name [SNC_PNAME]
    HNAME,       -- Hash value [SNC_HNAME]
    CNAME,       -- User [XUBNAME]
    CDATE,       -- Modification date [XUMODDATE]
    CTIME,       -- Modification time [XUMODTIME]
    MNAME,       -- Changed By [XUMODIFIER]
    MDATE,       -- Modification date [XUMODDATE]
    MTIME,       -- Modification time [XUMODTIME]
    CHKVERSION,  -- abap.int1
    CHKVAL,      -- abap.raw
    RESERVE,     -- abap.char
    KNAMELEN,    -- LCHR or LRAW length [LONG_LEN]
    KNAME,       -- Canonical SNC name [SNC_KNAME]
    PRIMARY KEY (MANDT, BNAME, SNC_SID)
);

Learn More