Sacm_Public_Dcl_For_Entity

DDL: SACM_PUBLIC_DCL_FOR_ENTITY SQL: ACMDCLENTITY Type: view
2 Fields 2 Data Sources

Show DCLs protecting DDLs

Sacm_Public_Dcl_For_Entity is a CDS View that provides data about "Show DCLs protecting DDLs" in SAP S/4HANA. It reads from 2 data sources (acmdclmetadata, acmdclmetadataen) and exposes 2 fields.

Data Sources (2)

SourceAliasJoin Type
acmdclmetadata dcl inner
acmdclmetadataen role from

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName ACMDCLENTITY view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_ALLOWED view
EndUserText.label Show DCLs protecting DDLs view
ClientDependent false view

Fields (2)

KeyFieldSource TableSource FieldDescription
entity acmdclmetadataen entity_id Tax Entity
dclname acmdclmetadata dclname Acc. Ctrl. Name

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 Sacm_Public_Dcl_For_Entity.
-- 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: ACMDCLENTITY

CREATE VIEW Sacm_Public_Dcl_For_Entity AS
SELECT
  role.entity_id AS entity,
  dcl.dclname AS dclname
FROM acmdclmetadataen AS role
INNER JOIN acmdclmetadata AS dcl ON /* join condition not captured in parsed metadata */
;

Learn More