C_ConsolidationGroupRpt10Q

DDL: C_CONSOLIDATIONGROUPRPT10Q SQL: CCSBSRPT10Q Type: view CONSUMPTION
18 Fields 1 Data Sources 1 Associations

Consolidated Balance Sheet

C_ConsolidationGroupRpt10Q (Consumption)

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

Group Reporting

C_ConsolidationGroupRpt10Q is a Consumption CDS View that provides data about "Consolidated Balance Sheet" in SAP S/4HANA. It reads from 1 data source (I_ConsolidationGroupReportC) and exposes 18 fields. It has 1 association to related views.

SAP Help Documentation

CategoryCDS Views for Transaction Data
Data CategoryQuery
Corresponding DataSourceCCSBSRPT10Q
Purpose
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 .

Structure
Parameters The parameters of the CDS view are as follows: P_ConsolidationVersion (Consolidation Version) P_ConsolidationGroup (Consolidation Group) P_FiscalYear (Fiscal Year) P_PreviousFiscalYear (Previous Fiscal Year) P_FiscalPeriod (Fiscal Period) P_ConsolidationLedger (Consolidation Ledger) P_GroupCurrency (Group Currency) P_ConsolidationChartOfAccounts (Consolidation Chart of Accounts) P_FinancialStatementItemHier (P_Financial Statement Item Hierarchy) Fields Used for Filtering The main filters are as follows: Most fields are mandatory. The relevant note is included after the field for non-mandatory fields. FiscalPeriod (Fiscal Period) ConsolidationGroup (Consolidation Group) FiscalYear (Fiscal Year) FiscalPeriod (Fiscal Period) ConsolidationDimension (Consolidation Dimension) ConsolidationLedger (Consolidation Ledger) GroupCurrency (GroupCurrency, not mandatory) SubItemCategory (Sub Item Category) FinancialStatementItem (Financial Statement Item, not mandatory) SubItem (Sub Item, not mandatory) Further Important Fields Important fields in this view include the following: Field Name Description Measure or Attribute GroupCurrency Group Currency Measure YearToDateAmountInGrpCrcy Year-to-Date Amount Measure YTDAmtInGrpCrcyInPrevYr Prior Year Year-to-Date Amount Measure

View on SAP Help Portal →

SAP API Hub

StateC1
Line of BusinessGroup Reporting
Application ComponentFIN-CS-EA
CapabilitiesAnalytical Query
PackageGroup Reporting for SAP S/4HANA Cloud Private Edition
Description <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

Data Sources (1)

SourceAliasJoin Type
I_ConsolidationGroupReportC I_ConsolidationGroupReportC from

Parameters (9)

NameTypeDefault
P_ConsolidationVersion fincs_rvers
P_ConsolidationGroup fincs_congr
P_FiscalYear gjahr
P_PreviousFiscalYear gjahr
P_FiscalPeriod poper
P_ConsolidationLedger fincs_rldnr
P_GroupCurrency waers
P_ConsolidationChartOfAccounts fincs_itclg
P_FinancialStatementItemHier fincs_ithry

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_FinStmntItmHierDir _FinStmntItmHierDir _FinStmntItmHierDir.ConsolidationChartOfAccounts = :P_ConsolidationChartOfAccounts and _FinStmntItmHierDir.FinancialStatementItemHier = :P_FinancialStatementItemHier

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName CCSBSRPT10Q view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Consolidated Balance Sheet view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.buffering.status #NOT_ALLOWED view
Analytics.query true view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.modelingPattern #ANALYTICAL_QUERY view
OData.publish true view

Fields (18)

KeyFieldSource TableSource FieldDescription
resultElementPreviousFiscalYear
ConsolidationGroup ConsolidationGroup Consolidation Group
FiscalYear FiscalYear Fiscal Year
FiscalPeriod FiscalPeriod Fiscal Period
ConsolidationDimension ConsolidationDimension Dimension
ConsolidationLedger ConsolidationLedger Ledger
GroupCurrency GroupCurrency Group Currency
SubItemCategory SubItemCategory Subitem Category
FinancialStatementItem FinancialStatementItem Financial Statement Item
SubItem SubItem Movement
ConsolidationUnit ConsolidationUnit Consolidation Unit
PartnerConsolidationUnit PartnerConsolidationUnit Partner Consolidation Unit
PostingLevel PostingLevel Posting Level
Segment Segment Segment for Segmental Reporting
PreviousFiscalYear
ConsolidationChartOfAccounts
FinancialStatementItemHier
_FinStmntItmHierDir _FinStmntItmHierDir

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 C_ConsolidationGroupRpt10Q.
-- 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.
-- SQL view name: CCSBSRPT10Q
-- Parameters: P_ConsolidationVersion : fincs_rvers, P_ConsolidationGroup : fincs_congr, P_FiscalYear : gjahr, P_PreviousFiscalYear : gjahr, P_FiscalPeriod : poper, P_ConsolidationLedger : fincs_rldnr, P_GroupCurrency : waers, P_ConsolidationChartOfAccounts : fincs_itclg, P_FinancialStatementItemHier : fincs_ithry

CREATE VIEW C_ConsolidationGroupRpt10Q AS
SELECT
  resultElement: 'PreviousFiscalYear' AS resultElementPreviousFiscalYear,
  ConsolidationGroup,
  FiscalYear,
  FiscalPeriod,
  ConsolidationDimension,
  ConsolidationLedger,
  GroupCurrency,
  SubItemCategory,
  FinancialStatementItem,
  SubItem,
  ConsolidationUnit,
  PartnerConsolidationUnit,
  PostingLevel,
  Segment,
  :P_PreviousFiscalYear AS PreviousFiscalYear,
  :P_ConsolidationChartOfAccounts AS ConsolidationChartOfAccounts,
  :P_FinancialStatementItemHier AS FinancialStatementItemHier
FROM I_ConsolidationGroupReportC
LEFT OUTER JOIN I_FinStmntItmHierDir AS _FinStmntItmHierDir ON _FinStmntItmHierDir.ConsolidationChartOfAccounts = :P_ConsolidationChartOfAccounts AND _FinStmntItmHierDir.FinancialStatementItemHier = :P_FinancialStatementItemHier  -- association [1..1]
;

Learn More