R_MDORULESET

DDL: R_MDORULESET Type: view_entity Package: MDO_OWNERSHIP_MODEL
7 Fields 1 Data Sources 2 Associations

MDO: Data Ownership Model - Rule Set

R_MDORULESET is a CDS View that provides data about "MDO: Data Ownership Model - Rule Set" in SAP S/4HANA. It reads from 1 data source (mdo_ruleset) and exposes 7 fields with key field Id. It has 2 associations to related views. Part of development package MDO_OWNERSHIP_MODEL.

Data Sources (1)

SourceAliasJoin Type
mdo_ruleset mdo_ruleset from

Associations (2)

CardinalityTargetAliasCondition
[0..*] R_MDORULEASSIGNMENT _RuleAssignment
[0..*] R_MDORULE _Rule

Annotations (2)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label MDO: Data Ownership Model - Rule Set view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY Id id WorklistID
Name name Zone name
ParentId parentid UUID
LastChangedAt _Parent LastchangedAt Time Stamp
_Parent _Parent
_RuleAssignment _RuleAssignment
_Rule _Rule

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 R_MDORULESET.
-- 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.

CREATE VIEW R_MDORULESET AS
SELECT
  Id,
  Name,
  ParentId,
  _Parent.LastchangedAt AS LastChangedAt
FROM mdo_ruleset
LEFT OUTER JOIN R_MDORULEASSIGNMENT AS _RuleAssignment ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_MDORULE AS _Rule ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More