RSDWC_DCL_DAC

Transparent Table Application Table
10 Fields 1 CDS Views

DWC user and CDS view authorization information

RSDWC_DCL_DAC is an SAP database table in S/4HANA. DWC user and CDS view authorization information. It contains 10 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
RSDWC_PermissionsForDAC view from S/4HANA Permissions Table

Fields (10)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY cds_view_name DDSTRUCOBJNAME DD: Name of a structured object (e.g. entity, context)
KEY principal XUBNAME User
sql_view_name DDLNAME DDL Source Name
external_principal AD_SMTPADR E-Mail Address
external_user_uuid SUID_EXTUID External UID
where_clause abap.strg
serialized_where_clause abap.strg
mod_timestamp TIMESTAMP Time Stamp
expiry_date TIMESTAMP Time Stamp

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.

-- DWC user and CDS view authorization information
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE RSDWC_DCL_DAC (
    CLIENT,                   -- Client [MANDT]
    CDS_VIEW_NAME,            -- DD: Name of a structured object (e.g. entity, context) [DDSTRUCOBJNAME]
    PRINCIPAL,                -- User [XUBNAME]
    SQL_VIEW_NAME,            -- DDL Source Name [DDLNAME]
    EXTERNAL_PRINCIPAL,       -- E-Mail Address [AD_SMTPADR]
    EXTERNAL_USER_UUID,       -- External UID [SUID_EXTUID]
    WHERE_CLAUSE,             -- abap.strg
    SERIALIZED_WHERE_CLAUSE,  -- abap.strg
    MOD_TIMESTAMP,            -- Time Stamp [TIMESTAMP]
    EXPIRY_DATE,              -- Time Stamp [TIMESTAMP]
    PRIMARY KEY (CLIENT, CDS_VIEW_NAME, PRINCIPAL)
);

Learn More