I_CnsldtnActvRptgRuleCondition

DDL: I_CNSLDTNACTVRPTGRULECONDITION Type: view_entity BASIC Package: FIN_CS_ANALYTICS_RULES
15 Fields 1 Data Sources

Consolidation Reporting Rule Condition

I_CnsldtnActvRptgRuleCondition (Basic)

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

CnsldtnActiveRptgRuleCondition · Group Reporting

I_CnsldtnActvRptgRuleCondition is a Basic CDS View that provides data about "Consolidation Reporting Rule Condition" in SAP S/4HANA. It reads from 1 data source (fincs_rr_rt_cond) and exposes 15 fields with key fields ConsolidationChartOfAccounts, ConsolidationReportingItemHier, ConsolidationReportingRuleID, CnsldtnRptgRuleActivationMode, CnsldtnRptgRuleStaticModeDate. Part of development package FIN_CS_ANALYTICS_RULES.

SAP API Hub

CategoryBasic
StateC1
Line of BusinessGroup Reporting
Application ComponentFIN-CS-EA-2CL
CapabilitiesData Source for Data Extraction,Association Target for Defining CDS Entities,Data Source for Defining CDS Entities,Data Source in SQL Select
Extensible (Key User)No
Extensible (Developer)No
Release State (Key User)Released
Release State (Developer)Released
PackageGroup Reporting for SAP S/4HANA Cloud Public Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
fincs_rr_rt_cond _Source from

Annotations (13)

NameValueLevelField
Analytics.dataExtraction.enabled true view
Analytics.technicalName ICSACTVRPTGRULECONDITION view
AccessControl.authorizationCheck #MANDATORY view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.modelingPattern #NONE view
ObjectModel.sapObjectNodeType.name CnsldtnActiveRptgRuleCondition view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
EndUserText.label Consolidation Reporting Rule Condition view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY ConsolidationChartOfAccounts fincs_rr_rt_cond itclg Consolidation Chart of Accounts
KEY ConsolidationReportingItemHier fincs_rr_rt_cond rihry Reporting Item Hierarchy
KEY ConsolidationReportingRuleID fincs_rr_rt_cond rptid Reporting Rule Variant
KEY CnsldtnRptgRuleActivationMode fincs_rr_rt_cond rule_activation_mode Reporting Rule Activation Mode
KEY CnsldtnRptgRuleStaticModeDate fincs_rr_rt_cond rule_static_mode_date Reporting Rule Static Mode Date
KEY ConsolidationReportingItem fincs_rr_rt_cond repitem Reporting Item
KEY FinancialSelection fincs_rr_rt_cond usel_id Selection ID
KEY ConsolidationCharacteristic fincs_rr_rt_cond characteristic Characteristic
KEY CnsldtnActiveRptgRuleSequence fincs_rr_rt_cond posnr Active Reporting Rule Sequence
CnsldtnFSItemAttributeVersion fincs_rr_rt_cond iatvs FS Item Attributes Version
CnsldtnUnitAttributeVersion fincs_rr_rt_cond cuavs Consolidation Unit Attributes
FiscalYearVariant fincs_rr_rt_cond periv Fiscal Year Variant
CnsldtnCharacteristicValue fincs_rr_rt_cond characteristic_value Characteristic Value
SignIsInverted fincs_rr_rt_cond revsign Sign is Inverted
CnsldtnCharcGlobalFieldName fincs_rr_rt_cond charc_global_field_name Characteristic Global Field 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_CnsldtnActvRptgRuleCondition.
-- 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_CnsldtnActvRptgRuleCondition AS
SELECT
  _Source.itclg AS ConsolidationChartOfAccounts,
  _Source.rihry AS ConsolidationReportingItemHier,
  _Source.rptid AS ConsolidationReportingRuleID,
  _Source.rule_activation_mode AS CnsldtnRptgRuleActivationMode,
  _Source.rule_static_mode_date AS CnsldtnRptgRuleStaticModeDate,
  _Source.repitem AS ConsolidationReportingItem,
  _Source.usel_id AS FinancialSelection,
  _Source.characteristic AS ConsolidationCharacteristic,
  _Source.posnr AS CnsldtnActiveRptgRuleSequence,
  _Source.iatvs AS CnsldtnFSItemAttributeVersion,
  _Source.cuavs AS CnsldtnUnitAttributeVersion,
  _Source.periv AS FiscalYearVariant,
  _Source.characteristic_value AS CnsldtnCharacteristicValue,
  _Source.revsign AS SignIsInverted,
  _Source.charc_global_field_name AS CnsldtnCharcGlobalFieldName
FROM fincs_rr_rt_cond AS _Source
;

Learn More