I_CnsldtnPstRlGroupRelation

DDL: I_CNSLDTNPSTRLGROUPRELATION Type: view_entity BASIC Package: FIN_CS_RT_CONF
13 Fields 1 Data Sources

Rule Group Relation

I_CnsldtnPstRlGroupRelation is a Basic CDS View that provides data about "Rule Group Relation" in SAP S/4HANA. It reads from 1 data source (fincs_rulgrp_nde) and exposes 13 fields with key fields ConsolidationPostingRuleGroup, CnsldtnPostingRuleGroupElement. Part of development package FIN_CS_RT_CONF.

Data Sources (1)

SourceAliasJoin Type
fincs_rulgrp_nde fincs_rulgrp_nde from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Rule Group Relation view
VDM.viewType #BASIC view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY ConsolidationPostingRuleGroup rule_group_id
KEY CnsldtnPostingRuleGroupElement node_id Workflow Step
CnsldtnPstRlGroupNodeType node_type Type
CnsldtnPstRlGroupNodeName node_name Object Name
CnsldtnPstRlGroupParent parent_node_id Node Id
CnsldtnPstRlGroupSequence sequence Visit Sequence
CnsldtnPstRlGrpReferenceGroup ref_rule_group_id
CnsldtnPstRlGrpRefNode ref_node_id SLC Object ID
CnsldtnPstRlGrpReferenceRule ref_rule_id
CnsldtnPstRlIsDepdntOnPrevRule depends_on_prev_rules
CreatedByUser local_created_by Created By
ChangedDateTime local_last_changed_at Time Stamp
ChangedBy local_last_changed_by User 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 I_CnsldtnPstRlGroupRelation.
-- 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 I_CnsldtnPstRlGroupRelation AS
SELECT
  rule_group_id AS ConsolidationPostingRuleGroup,
  node_id AS CnsldtnPostingRuleGroupElement,
  node_type AS CnsldtnPstRlGroupNodeType,
  node_name AS CnsldtnPstRlGroupNodeName,
  parent_node_id AS CnsldtnPstRlGroupParent,
  sequence AS CnsldtnPstRlGroupSequence,
  ref_rule_group_id AS CnsldtnPstRlGrpReferenceGroup,
  ref_node_id AS CnsldtnPstRlGrpRefNode,
  ref_rule_id AS CnsldtnPstRlGrpReferenceRule,
  depends_on_prev_rules AS CnsldtnPstRlIsDepdntOnPrevRule,
  local_created_by AS CreatedByUser,
  local_last_changed_at AS ChangedDateTime,
  local_last_changed_by AS ChangedBy
FROM fincs_rulgrp_nde
;

Learn More