I_CnsldtnGroup

DDL: I_CNSLDTNGROUP Type: view BASIC Package: FIN_CS_MD_GROUP
5 Fields 1 Data Sources 3 Associations

Consolidation Group

I_CnsldtnGroup (Basic)

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

Consolidation Group · Group Reporting

I_CnsldtnGroup is a Basic CDS View (Dimension) that provides data about "Consolidation Group" in SAP S/4HANA. It reads from 1 data source (tf180) and exposes 5 fields with key fields ConsolidationDimension, ConsolidationGroup. It has 3 associations to related views. Part of development package FIN_CS_MD_GROUP.

SAP API Hub

CategoryBasic
StateC1
Line of BusinessGroup Reporting
Application ComponentFIN-CS-MD-2CL
CapabilitiesData Source for Defining CDS Entities,Association Target for Defining CDS Entities,Data Source in SQL Select,Analytical Dimension
Extensible (Key User)No
Extensible (Developer)No
Release State (Key User)Released
Release State (Developer)Not Released
PackageGroup Reporting for SAP S/4HANA Cloud Public Edition
Description <p>This CDS view provides access to the master data of a consolidation group.</p> <p>This CDS view provides the prerequisites for answering the following business questions:</p> <ul> <li>What is the consolidation dimension for my consolidation groups or subgroups?</li> <li>What is the hierarchy level of a certain group within a hierarchy of consolidation groups?</li> </ul>

Documentation

Data Sources (1)

SourceAliasJoin Type
tf180 tf180 from

Associations (3)

CardinalityTargetAliasCondition
[0..*] I_CnsldtnGroupT _Text $projection.ConsolidationDimension = _Text.ConsolidationDimension and $projection.ConsolidationGroup = _Text.ConsolidationGroup
[0..1] I_CnsldtnDimension _Dimension $projection.ConsolidationDimension = _Dimension.ConsolidationDimension
[0..*] I_CnsldtnGrpHierNode _GrpHierNode $projection.ConsolidationDimension = _GrpHierNode.ConsolidationDimension and $projection.ConsolidationGroup = _GrpHierNode.ConsolidationGroup

Annotations (17)

NameValueLevelField
AbapCatalog.sqlViewName ICCGROUP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.buffering.status #ACTIVE view
AbapCatalog.buffering.type #FULL view
AccessControl.authorizationCheck #CHECK view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.representativeKey ConsolidationGroup view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
ObjectModel.sapObjectNodeType.name ConsolidationGroup view
Analytics.dataCategory #DIMENSION view
VDM.viewType #BASIC view
EndUserText.label Consolidation Group view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY ConsolidationDimension dimen Dimension Unit
KEY ConsolidationGroup congr Consolidation Group
_Dimension _Dimension
_Text _Text
_GrpHierNode _GrpHierNode

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_CnsldtnGroup.
-- 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_CnsldtnGroup AS
SELECT
  dimen AS ConsolidationDimension,
  congr AS ConsolidationGroup
FROM tf180
LEFT OUTER JOIN I_CnsldtnGroupT AS _Text ON ConsolidationDimension = _Text.ConsolidationDimension AND ConsolidationGroup = _Text.ConsolidationGroup  -- association [0..*]
LEFT OUTER JOIN I_CnsldtnDimension AS _Dimension ON ConsolidationDimension = _Dimension.ConsolidationDimension  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnGrpHierNode AS _GrpHierNode ON ConsolidationDimension = _GrpHierNode.ConsolidationDimension AND ConsolidationGroup = _GrpHierNode.ConsolidationGroup  -- association [0..*]
;

Learn More