What is I_CnsldtnRptgRule in SAP S/4HANA?

I_CnsldtnRptgRule is a basic CDS view in SAP S/4HANA. Consolidation Reporting Rule It contains 15 fields.

Which tables does I_CnsldtnRptgRule read from?

I_CnsldtnRptgRule reads data from: fincs_ri_rt.

What VDM layer is I_CnsldtnRptgRule?

I_CnsldtnRptgRule is classified as a Basic (interface) view providing a 1:1 representation of a database table.

I_CnsldtnRptgRule

DDL: I_CNSLDTNRPTGRULE Type: view_entity BASIC

15 Fields 1 Data Sources

Consolidation Reporting Rule

I_CnsldtnRptgRule (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

ConsolidationReportingRule · Group Reporting

I_CnsldtnRptgRule is a Basic CDS View that provides data about "Consolidation Reporting Rule" in SAP S/4HANA. It reads from 1 data source (fincs_ri_rt) and exposes 15 fields with key fields CnsldtnRptgRuleUUID, SequenceNumber.

SAP Help Documentation

Category	CDS Views for Transaction Data

Purpose
This CDS view extracts reporting rule data based on table FINCS_RI_RT to SAP BW/4HANA and SAP Datasphere . Reporting rules can be created using the Define Reporting Rules app. To help you decide which CDS view to use for your purpose, SAP has introduced the annotation ObjectModel.supportedCapabilities , which indicates the most appropriate use cases for each CDS view. To find out which use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views . To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .

Prerequisites
Authorizations Users who want to use this CDS view must have the following authorization objects assigned: <technical name of authorization objects> (<human-readable name>)

Structure
Further Important Fields Important fields in this view include the following: Field Name Description Measure or Attribute Comment CnsldtnRptgRuleUUID Unique ID Key SequenceNumber Reporting Rule Sequence Number Key ConsolidationChartOfAccounts Consolidation Chart of Accounts ConsolidationReportingItemHier Reporting Item Hierarchy ConsolidationReportingItem Reporting Item FinancialStatementItem Financial Statement Item SubItemCategory Subitem Category SubItem Subitem ConsolidationDocumentType Document Type ConsolidationUnit Consolidation Unit ConsolidationReverseSign Reverse Sign Indicator (X) ConsolidationVersion Version FromFiscalYearPeriod Period/Year ToFiscalYearPeriod Period/Year

SAP BW/4HANA Extraction
Data Extraction Type Full (physical deletions are possible in source tables) Delta (change data capture) Note This CDS view defines the header annotation Analytics.dataExtraction.delta.changeDataCapture.mapping for delta extractions with change data capture (CDC). For more information, see Analytics Annotations . Note The corresponding DataSource (Extractor) and this CDS view may have different functionalities. For details about the DataSource, see the related documentation on the SAP Help Portal at https://help.sap.com/viewer/p/BI_CONTENT_757 under Use SAP Library BI Content . For more information about data extraction, see Extracting Data Through CDS Views to SAP BW/4HANA .

View on SAP Help Portal →

SAP API Hub

State	C1
Line of Business	Group Reporting
Application Component	FIN-CS-EA
Capabilities	Data Source in SQL Select, Data Source for Data Extraction
Package	Group Reporting for SAP S/4HANA Cloud Private Edition
Description	<p>This CDS view extracts reporting rule data based on table FINCS_RI_RT to SAP BW/4HANA and SAP Datasphere.</p> <p>Reporting rules can be created using the Define Reporting Rules app.</p> <p>To help you decide which CDS view to use for your purpose, SAP has introduced the annotation ObjectModel.supportedCapabilities, which indicates the most appropriate use cases for each CDS view. To find out which use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views.</p> <p>To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views.</p>

Documentation

Analytics with CDS Views — Build Analytics for S/4HANA Cloud Private Edition ABAP CDS views replicated to SAP Cloud Platform
CDS Views on SAP Business Accelerator Hub — Explore SAP S/4HANA Cloud Private Edition Private Edition CDS Views on SAP Business Accelerator Hub
Create CDS View as API — Create CDS views in SAP S/4HANA Cloud Private Edition and consume them as APIs
Custom CDS Views — Access data using a Custom Core Data Service view (Custom CDS view)
Key User Extensibility Tools — The Key User Extensibility Tools of S/4HANA
SAP Extensibility Explorer for SAP S/4HANA Cloud Private Edition — Explore SAP S/4HANA Cloud Private Edition Extensibility options by leveraging the sample scenarios from SAP
SAP S/4HANA Extensibility — SAP S/4HANA Extensibility Tutorial
VDM View Types — The Virtual Data Model in SAP S/4HANA Cloud Private Edition
View Browser — Search, browse and tag CDS Views

Data Sources (1)

Source	Alias	Join Type
fincs_ri_rt	fincs_ri_rt	from

Annotations (12)

Name	Value	Level
Analytics.technicalName	ICCRRULE	view
Analytics.dataExtraction.enabled	true	view
Analytics.dataExtraction.delta.changeDataCapture.automatic	false	view
AccessControl.authorizationCheck	#PRIVILEGED_ONLY	view
Metadata.ignorePropagatedAnnotations	true	view
ObjectModel.usageType.dataClass	#CUSTOMIZING	view
ObjectModel.usageType.serviceQuality	#A	view
ObjectModel.usageType.sizeCategory	#M	view
ObjectModel.modelingPattern	#ANALYTICAL_FACT	view
ObjectModel.sapObjectNodeType.name	ConsolidationReportingRule	view
VDM.viewType	#BASIC	view
EndUserText.label	Consolidation Reporting Rule	view

Fields (15)

Key	Field	Source Field	Description
KEY	CnsldtnRptgRuleUUID	uuid	Financial Consolidation UUID
KEY	SequenceNumber	posnr	Reporting Rule Position Number
	ConsolidationReportingRuleID	rptid	Reporting Rule Variant
	ConsolidationChartOfAccounts	itclg	Consolidation Chart of Accounts
	ConsolidationReportingItemHier	rihry	Reporting Item Hierarchy
	ConsolidationReportingItem	ritem	Reporting Item
	FinancialStatementItem	item	Financial Statement Item
	SubItemCategory	sityp	Trip Schedule Type
	SubItem	sitem	Subitem
	ConsolidationDocumentType	docty	Document Type
	ConsolidationUnit	bunit	Consolidation Unit
	ConsolidationReverseSign	revsign	Reverse Sign Indicator
	ConsolidationVersion	rvers	Consolidation Version
	FromFiscalYearPeriod		Fiscal Year Period
	ToFiscalYearPeriod		To Fiscal Year Period

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_CnsldtnRptgRule.
-- 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_CnsldtnRptgRule AS
SELECT
  uuid AS CnsldtnRptgRuleUUID,
  posnr AS SequenceNumber,
  rptid AS ConsolidationReportingRuleID,
  itclg AS ConsolidationChartOfAccounts,
  rihry AS ConsolidationReportingItemHier,
  ritem AS ConsolidationReportingItem,
  item AS FinancialStatementItem,
  sityp AS SubItemCategory,
  sitem AS SubItem,
  docty AS ConsolidationDocumentType,
  bunit AS ConsolidationUnit,
  revsign AS ConsolidationReverseSign,
  rvers AS ConsolidationVersion,
  cast(fromyearper as fis_jahrper_conv preserving type ) AS FromFiscalYearPeriod,
  cast(toyearper as fis_jahrper_conv preserving type ) AS ToFiscalYearPeriod
FROM fincs_ri_rt
;

Depth:

I_CnsldtnRptgRule view_entity

fincs_ri_rt