C_ConsolidationMatrixRpt10Q

DDL: C_CONSOLIDATIONMATRIXRPT10Q Type: view CONSUMPTION

Local/Group Data Analysis Query

C_ConsolidationMatrixRpt10Q (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_ConsolidationMatrixRpt10Q is a Consumption CDS View that provides data about "Local/Group Data Analysis Query" in SAP S/4HANA. It reads from 1 data source (I_MatrixConsolidationReportC) and exposes 23 fields. It has 1 association to related views.

SAP Help Documentation

CategoryCDS Views for Transaction Data
Data CategoryQuery
Purpose
The primary purpose of this CDS view is to provide a structured and flexible framework for analyzing consolidated financial data. It aggregates and presents financial information from different organizational units, profit centers, segments, and other financial dimensions, enabling users to gain insights into the financial health and performance of a group or organization. This CDS view provides the data to answer the following business questions: Financial performance analysis: How is the financial performance of different consolidation units, profit centers, and segments within the organization? Period comparison: How do financial results compare across different fiscal years and periods? Currency impact: What is the impact of currency fluctuations on financial results when viewed in transaction, local, and group currencies? Hierarchy-based analysis: How do financial results vary across different levels of financial statement item hierarchies? Intercompany transactions: What are the details of intercompany transactions and eliminations within the consolidation process? Adhoc reporting: How can specific financial items or sets be analyzed on an ad-hoc basis for deeper insights? Document and transaction tracking: What are the details of specific consolidation documents, posting items, and related transactions? Investment and acquisition analysis: How do investments and acquisitions impact the consolidated financial statements over different periods? 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 need to access it via another CDS view (privileged mode).

Structure
Parameters The parameters of the CDS view are as follows: P_ConsolidationUnitHierarchy (Consolidation Unit Hierarchy) P_ConsolidationChartOfAccounts (Consolidation COA) P_ConsolidationDimension (Dimension) P_FinancialStatementItemHier (FS Item Hierarchy) P_ConsolidationPrftCtrHier (Profit Center Hierarchy) P_ConsolidationSegmentHier (Segment Hierarchy) P_KeyDate (Key Date) Fields Used for Filtering ConsolidationVersion FiscalYear FiscalPeriod ConsolidationChartOfAccounts ConsolidationGroup Important Fields Important fields in this view include the following: Field Name Description Measure or Attribute CNSLDTNSIGNADJDQTYINBASEUNIT Sign-Adjusted Quantity Measure CNSLDTNSIGNADJDAMTINGROUPCRCY Sign-Adjusted Amount in Group Crcy Measure CNSLDTNSIGNADJDAMTINLOCALCRCY Sign-Adjusted Amount in Local Crcy Measure CNSLDTNSIGNADJDAMTINTRANSCRCY Sign-Adjusted Amount in Trans. Crcy Measure CNSLDTNQUANTITYINBASEUNIT Quantity Measure AMOUNTINGROUPCURRENCY Amount in Group Currency Measure QUANTITYINBASEUNIT Quantity Measure AMOUNTINLOCALCURRENCY Amount in Local Currency Measure AMOUNTINTRANSACTIONCURRENCY Amount in Transaction Currency Measure PARTNERCOSTCENTER Sender Cost Center Attribute USERID User Name Attribute CONSOLIDATIONUNIT Consolidation Unit Attribute PARTNERCOMPANY Trading Partner No. Attribute CONSOLIDATIONDIMENSION Dimension Attribute BILLINGDOCUMENTTYPE Billing Type Attribute SEGMENT Segment Attribute BILLTOPARTY Bill-to Party Attribute ORDERID Order Attribute CUSTOMERGROUP Customer Group Attribute SHIPTOPARTY Ship-to Party Attribute FUNCTIONALAREA Functional Area Attribute COSTCENTER Cost Center Attribute GLACCOUNT Account Number Attribute CHARTOFACCOUNTS Chart of Accounts Attribute SALESDISTRICT Sales District Attribute ORGANIZATIONDIVISION Division Attribute BUSINESSAREA Business Area Attribute PROFITCENTER Profit Center Attribute CUSTOMER Customer Attribute TRANSACTIONCURRENCY Transaction Currency Attri

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>The primary purpose of this CDS view is to provide a structured and flexible framework for analyzing consolidated financial data. It aggregates and presents financial information from different organizational units, profit centers, segments, and other financial dimensions, enabling users to gain insights into the financial health and performance of a group or organization.</p> <p>This CDS view provides the data to answer the following business questions:</p> <li><p>Financial performance analysis: How is the financial performance of different consolidation units, profit centers, and segments within the organization?</p></li> <li><p>Period comparison: How do financial results compare across different fiscal years and periods?</p></li> <li><p>Currency impact: What is the impact of currency fluctuations on financial results when viewed in transaction, local, and group currencies?</p></li> <li><p>Hierarchy-based analysis: How do financial results vary across different levels of financial statement item hierarchies?</p></li> <li><p>Intercompany transactions: What are the details of intercompany transactions and eliminations within the consolidation process?</p></li> <li><p>Adhoc reporting: How can specific financial items or sets be analyzed on an ad-hoc basis for deeper insights?</p></li> <li><p>Document and transaction tracking: What are the details of specific consolidation documents, posting items, and related transactions?</p></li> <li><p>Investment and acquisition analysis: How do investments and acquisitions impact the consolidated financial statements over different periods?</p></li> <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_MatrixConsolidationReportC I_MatrixConsolidationReportC from

Parameters (12)

NameTypeDefault
P_ConsolidationUnitHierarchy fincs_hryid_consunit
P_ConsolidationSegmentHier fincs_hryid_segment
P_ConsolidationPrftCtrHier fincs_hryid_profitcenter
P_KeyDate vdm_v_key_date
P_ConsolidationVersion fincs_rvers
P_FiscalYearVariant fis_periv
P_FiscalYear gjahr
P_FiscalPeriod fincs_poper
P_FinancialStatementItemHier fincs_ithry
P_ConsolidationChartOfAccounts fincs_itclg
P_ConsolidationLedger fincs_rldnr
P_ConsolidationDimension fc_dimen

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_FinStmntItmHierDir _FinStmntItmHierDir $projection.ConsolidationChartOfAccounts = _FinStmntItmHierDir.ConsolidationChartOfAccounts and _FinStmntItmHierDir.FinancialStatementItemHier = $parameters.P_FinancialStatementItemHier

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName CCSMATRIXRPT10Q view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.buffering.status #NOT_ALLOWED view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ClientHandling.algorithm #SESSION_VARIABLE 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
Analytics.query true view
VDM.viewType #CONSUMPTION view
EndUserText.label Local/Group Data Analysis Query view

Fields (23)

KeyFieldSource TableSource FieldDescription
P_FinancialStatementItemHier
multipleSelectionstrue
multipleSelectionstrue
mandatorytrueFiscalYear
multipleSelectionstrue
multipleSelectionstrue
mandatoryfalsePeriodMode
multipleSelectionstrue
selectionTypeHIERARCHY_NODE
multipleSelectionstrue
axisROWS
displayKEY_TEXT
displayHierarchyFILTER
multipleSelectionstrue
mandatorytrueConsolidationGroup
multipleSelectionstrue
axisFREE
multipleSelectionstrue
axisFREE
multipleSelectionstrue
axisFREE
multipleSelectionstrue
multipleSelectionsfalse

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_ConsolidationMatrixRpt10Q.
-- 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.
-- Parameters: P_ConsolidationUnitHierarchy : fincs_hryid_consunit, P_ConsolidationSegmentHier : fincs_hryid_segment, P_ConsolidationPrftCtrHier : fincs_hryid_profitcenter, P_KeyDate : vdm_v_key_date, P_ConsolidationVersion : fincs_rvers, P_FiscalYearVariant : fis_periv, P_FiscalYear : gjahr, P_FiscalPeriod : fincs_poper, P_FinancialStatementItemHier : fincs_ithry, P_ConsolidationChartOfAccounts : fincs_itclg, P_ConsolidationLedger : fincs_rldnr, P_ConsolidationDimension : fc_dimen

CREATE VIEW C_ConsolidationMatrixRpt10Q AS
SELECT
  entity: { name: 'I_CnsldtnUnitHierDirVH', element: 'ConsolidationUnitHierarchy' AS P_FinancialStatementItemHier,
  multipleSelections: true AS multipleSelectionstrue,
  mandatory: true AS mandatorytrueFiscalYear,
  mandatory: false AS mandatoryfalsePeriodMode,
  selectionType: #HIERARCHY_NODE AS selectionTypeHIERARCHY_NODE,
  axis: #ROWS AS axisROWS,
  display: #KEY_TEXT AS displayKEY_TEXT,
  displayHierarchy: #FILTER AS displayHierarchyFILTER,
  mandatory: true AS mandatorytrueConsolidationGroup,
  axis: #FREE AS axisFREE,
  multipleSelections: false AS multipleSelectionsfalse
FROM I_MatrixConsolidationReportC
LEFT OUTER JOIN I_FinStmntItmHierDir AS _FinStmntItmHierDir ON ConsolidationChartOfAccounts = _FinStmntItmHierDir.ConsolidationChartOfAccounts AND _FinStmntItmHierDir.FinancialStatementItemHier = $parameters.P_FinancialStatementItemHier  -- association [1..1]
;