RSDWC_PermissionsForDAC

DDL: RSDWC_PERMISSIONSFORDAC SQL: RSDWCV_DCL_DAC Type: view

S/4HANA Permissions Table

RSDWC_PermissionsForDAC is a CDS View of category Fact that provides data about "S/4HANA Permissions Table" in SAP S/4HANA. It reads from 1 data source (rsdwc_dcl_dac) and exposes 9 fields with key fields CDSView, UserID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
rsdwc_dcl_dac rsdwc_dcl_dac from

Associations (1)

CardinalityTargetAliasCondition
[0..1] usr02 _User $projection.UserID = _User.bname

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName RSDWCV_DCL_DAC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
Analytics.dataCategory #FACT view
Analytics.dataExtraction.enabled true view
EndUserText.label S/4HANA Permissions Table view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY CDSView cds_view_name S/4HANA CDS View (CDS view name)
KEY UserID principal S/4HANA User ID
SQLView sql_view_name S/4HANA CDS View (ODP extractor name)
AnalyticsEmailAddress external_principal Analytics User ID
AnalyticsUUID external_user_uuid Analytics UUID
CDSViewPermissions where_clause CDS View permissions string
SerializedCDSViewPermissions serialized_where_clause Serialized CDS View permissions string
LastChangeDateTime mod_timestamp Timestamp
UserGroup _User class User Group

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view RSDWC_PermissionsForDAC.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: RSDWCV_DCL_DAC

CREATE VIEW RSDWC_PermissionsForDAC AS
SELECT
  cds_view_name AS CDSView,
  principal AS UserID,
  sql_view_name AS SQLView,
  external_principal AS AnalyticsEmailAddress,
  external_user_uuid AS AnalyticsUUID,
  where_clause AS CDSViewPermissions,
  serialized_where_clause AS SerializedCDSViewPermissions,
  mod_timestamp AS LastChangeDateTime,
  _User.class AS UserGroup
FROM rsdwc_dcl_dac
LEFT OUTER JOIN usr02 AS _User ON UserID = _User.bname  -- association [0..1]
;