I_CnsldtnUnit

DDL: I_CNSLDTNUNIT Type: view BASIC
8 Fields 2 Data Sources 4 Associations

Consolidation Unit

I_CnsldtnUnit (Basic)

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

Group Reporting

I_CnsldtnUnit is a Basic CDS View (Dimension) that provides data about "Consolidation Unit" in SAP S/4HANA. It reads from 2 data sources (tf160, tf162) and exposes 8 fields with key fields ConsolidationDimension, ConsolidationUnit. It has 4 associations to related views.

SAP API Hub

StateC1
Line of BusinessGroup Reporting
Application ComponentFIN-CS-MD
CapabilitiesData Source for Defining CDS Entities, Association Target for Defining CDS Entities, Data Source in SQL Select, Analytical Dimension
PackageGroup Reporting for SAP S/4HANA Cloud Private Edition
Description <p>This CDS view provides access to the master data of a consolidation unit and to the associated time-dependent and time-version-dependent attributes..</p> <p>A consolidation unit is the smallest entity of the corporate group structure that can be used as the basis for performing a consolidation.</p> <p>This CDS view provides the prerequisites for answering the following business questions:</p> <ul> <li><p>What is the hierarchy level of a certain unit within a hierarchy of consolidation units?</p></li> <li><p>What is the local currency at a specific fiscal year and period?</p></li> <li><p>What is the currency translation method in a specific consolidation version and at a specific fiscal year and period? Or the tax rate, the fiscal year variant, the data transfer method, and more?</p></li> </ul>

Documentation

Data Sources (2)

SourceAliasJoin Type
tf160 tf160 from
tf162 tf162 left_outer

Associations (4)

CardinalityTargetAliasCondition
[0..*] I_CnsldtnUnitT _Text $projection.ConsolidationDimension = _Text.ConsolidationDimension and $projection.ConsolidationUnit = _Text.ConsolidationUnit
[0..1] I_CnsldtnDimension _Dimension $projection.ConsolidationDimension = _Dimension.ConsolidationDimension
[0..*] I_CnsldtnUnitHierNode _UnitHierNode $projection.ConsolidationDimension = _UnitHierNode.ConsolidationDimension and $projection.ConsolidationUnit = _UnitHierNode.ConsolidationUnit
[0..1] I_CnsldtnCountry _Country $projection.Country = _Country.Country

Annotations (17)

NameValueLevelField
AbapCatalog.sqlViewName ICCUNIT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AbapCatalog.buffering.status #ACTIVE view
AbapCatalog.buffering.type #FULL view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.representativeKey ConsolidationUnit view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
Analytics.dataCategory #DIMENSION view
VDM.viewType #BASIC view
EndUserText.label Consolidation Unit view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY ConsolidationDimension tf160 dimen Dimension Unit
KEY ConsolidationUnit Consolidation Unit
DocumentEntryIsInGroupCurrency tf160 gcind Entry in group currency
Country tf162 cntry Country/Region
_Dimension _Dimension
_UnitHierNode _UnitHierNode
_Text _Text
_Country _Country

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_CnsldtnUnit.
-- 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_CnsldtnUnit AS
SELECT
  tf160.dimen AS ConsolidationDimension,
  cast( tf160.bunit as fincs_consolidationunit preserving type ) AS ConsolidationUnit,
  tf160.gcind AS DocumentEntryIsInGroupCurrency,
  tf162.cntry AS Country
FROM tf160
LEFT OUTER JOIN tf162 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CnsldtnUnitT AS _Text ON ConsolidationDimension = _Text.ConsolidationDimension AND ConsolidationUnit = _Text.ConsolidationUnit  -- association [0..*]
LEFT OUTER JOIN I_CnsldtnDimension AS _Dimension ON ConsolidationDimension = _Dimension.ConsolidationDimension  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnUnitHierNode AS _UnitHierNode ON ConsolidationDimension = _UnitHierNode.ConsolidationDimension AND ConsolidationUnit = _UnitHierNode.ConsolidationUnit  -- association [0..*]
LEFT OUTER JOIN I_CnsldtnCountry AS _Country ON Country = _Country.Country  -- association [0..1]
;

Learn More