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.string
serialized_where_clause abap.string
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.string
    SERIALIZED_WHERE_CLAUSE,  -- abap.string
    MOD_TIMESTAMP,            -- Time Stamp [timestamp]
    EXPIRY_DATE,              -- Time Stamp [timestamp]
    PRIMARY KEY (CLIENT, CDS_VIEW_NAME, PRINCIPAL)
);

Learn More