ACM_USED_ACCONDITIONS

DDL: ACM_USED_ACCONDITIONS SQL: ACM_USED_ACCOND Type: view Package: SACMTOOLS

Used ACConditions within a Role/Rule/DTCondition

ACM_USED_ACCONDITIONS is a CDS View that provides data about "Used ACConditions within a Role/Rule/DTCondition" in SAP S/4HANA. It reads from 4 data sources (acmaccondition, acmdtcondition, acmrole, acmrule) and exposes 5 fields. Part of development package SACMTOOLS.

Data Sources (4)

SourceAliasJoin Type
acmaccondition acmaccondition inner
acmdtcondition acmdtcondition inner
acmrole acmrole from
acmrule acmrule inner

Annotations (2)

NameValueLevelField
AbapCatalog.sqlViewName ACM_USED_ACCOND view
AccessControl.authorizationCheck #NOT_ALLOWED view

Fields (5)

KeyFieldSource TableSource FieldDescription
role_id acmrole id WorklistID
role_dclname acmrole dclname Acc. Ctrl. Name
role_name acmrole name Zone name
rule_id acmrule id WorklistID
rule_pos acmrule rulepos Position

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 ACM_USED_ACCONDITIONS.
-- 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: ACM_USED_ACCOND

CREATE VIEW ACM_USED_ACCONDITIONS AS
SELECT
  acmrole.id AS role_id,
  acmrole.dclname AS role_dclname,
  acmrole.name AS role_name,
  acmrule.id AS rule_id,
  acmrule.rulepos AS rule_pos
FROM acmrole
INNER JOIN acmrule ON /* join condition not captured in parsed metadata */
INNER JOIN acmdtcondition ON /* join condition not captured in parsed metadata */
INNER JOIN acmaccondition ON /* join condition not captured in parsed metadata */
;