USRACL

Transparent Table Application Table
11 Fields 2 CDS Views

SNC Zugangskontrollliste (ACL) für Benutzer

USRACL is an SAP database table in S/4HANA. SNC Zugangskontrollliste (ACL) für Benutzer. It contains 11 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 (11)

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
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 Zugangskontrollliste (ACL) für Benutzer
-- 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]
    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