What is C_ConsolidationMatrixRpt01Q in SAP S/4HANA?

C_ConsolidationMatrixRpt01Q is a consumption CDS view in SAP S/4HANA. Local/Group Data Analysis Query It contains 106 fields.

Which tables does C_ConsolidationMatrixRpt01Q read from?

C_ConsolidationMatrixRpt01Q reads data from: I_MatrixCnsldtnReport01C.

What VDM layer is C_ConsolidationMatrixRpt01Q?

C_ConsolidationMatrixRpt01Q is classified as a Consumption view optimized for specific business scenarios and reporting.

C_ConsolidationMatrixRpt01Q

DDL: C_CONSOLIDATIONMATRIXRPT01Q Type: view CONSUMPTION

106 Fields 1 Data Sources 1 Associations

Local/Group Data Analysis Query

C_ConsolidationMatrixRpt01Q (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_ConsolidationMatrixRpt01Q 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_MatrixCnsldtnReport01C) and exposes 106 fields. It has 1 association to related views.

SAP Help Documentation

Category	CDS Views for Transaction Data
Data Category	Analytical Query
Status	C1-Released (for Key User Apps)
Corresponding DataSource	2CCCSMATRIXRPT01Q

Purpose
This CDS view provides access to the combined data of old and new reporting logic. If you are using fiscal year periods where some of them belong to the old reporting logic and some to the new reporting logic, then you can use this CDS view. Note For more information on the combined stack of old and new reporting logic, please see SAP Note 3048807 . This CDS view provides the data to answer the following business questions: What is the organizational unit information of the consolidated data in my specified fiscal year and period? What is the document number, posting level, and document type for a certain journal entry? What are the amounts of relevant financial statement items or reporting items in the transaction currency, local currency, and group currency? What are the amounts of interunit eliminations between consolidation unit pairs in the same consolidation group? 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_ConsolidationGroup : Consolidation Group. The assigned value must not be empty. If you assign # as a value, which represents no consolidation group, you will get no results. P_FromFiscalYear : From Fiscal Year. This value corresponds to the fiscal year of the minimum value of the Fiscal Year Period field used for filtering. For example, if you have selected the two fiscal year periods 008.2020 and 005.2021 (PPP.YYYY), then the value for parameter P_FromFiscalYear is 2020 because it's the corresponding fiscal year from the minimum fiscal year period 008.2020 . Caution Any value for this parameter other than the corresponding fiscal year of the minimum value of the Fiscal Year Period field can lead to bad performance or wrong results. P_ToFiscalYearPeriod : To Fiscal Year Period. This value corresponds to the maximum value of the Fiscal Year Period field used for filtering. For example, if you have selected the two fiscal year periods 008.2020 and 005.2021 (PPP.YYYY), then the value for parameter P_ToFiscalYearPeriod is 005.2021 because this corresponds to the maximum fiscal year period 005.2021 . Caution Any value for this parameter other than the corresponding maximum value of the Fiscal Year Period field can lead to bad performance or wrong results. Note The format of this parameter may name the year before the period, such as 2021.005 (YYYY.PPP). This differs from the format of Fiscal Year Period which names the period before the year, such as 005.2021 (PPP.YYYY). To check which format is used, you can use the value help for this parameter. P_ConsolidationChartOfAccounts : Consolidation Chart of Accounts. P_FinancialStatementItemHier : Financial Statement Item Hierarchy. Use $ if you don’t want to assign a value. P_KeyDate : Key Date. This is used as a validity date of hierarchies like financial statement item hierarchies. Fields used for filtering The main filters are as follows: ConsolidationVersion : Consolidation Version, also referred to as Version. FiscalYearPeriod : Fiscal Year Period. Further important fields Important fields in this view include the following: FinancialStatementItem : Financial Statement Item. YTDAmtInCnsldtnGroupCrcy : Amount in Group Currency Using Year-To-Date (YTD) Mode. YTD refers to the length of time from the beginning of the fiscal year to the selected fiscal year period. Therefore, this field reflects the aggregate amount of all fiscal year periods prior to and including the selected fiscal year period in the given fiscal year. For example, if the selected fiscal year period is 003.2021 (PPP.YYYY), then the am

View on SAP Help Portal →

SAP API Hub

State	C1
Line of Business	Group Reporting
Application Component	FIN-CS-EA
Capabilities	Analytical Query
Package	Group Reporting for SAP S/4HANA Cloud Private Edition
Description	<p>This CDS view provides access to the combined data of old and new reporting logic. If you are using fiscal year periods where some of them belong to the old reporting logic and some to the new reporting logic, then you can use this CDS view.</p> This CDS view provides the data to answer the following business questions:<ul> <li><p>What is the organizational unit information of the consolidated data in my specified fiscal year and period?</p></li> <li><p>What is the document number, posting level, and document type for a certain journal entry?</p></li> <li><p>What are the amounts of relevant financial statement items or reporting items in the transaction currency, local currency, and group currency?</p></li> <li><p>What are the amounts of interunit eliminations between consolidation unit pairs in the same consolidation group?</p></li> </ul> <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

Analytics with CDS Views — Build Analytics for S/4HANA Cloud Private Edition ABAP CDS views replicated to SAP Cloud Platform
CDS Views on SAP Business Accelerator Hub — Explore SAP S/4HANA Cloud Private Edition Private Edition CDS Views on SAP Business Accelerator Hub
Create CDS View as API — Create CDS views in SAP S/4HANA Cloud Private Edition and consume them as APIs
Custom CDS Views — Access data using a Custom Core Data Service view (Custom CDS view)
Key User Extensibility Tools — The Key User Extensibility Tools of S/4HANA
SAP Extensibility Explorer for SAP S/4HANA Cloud Private Edition — Explore SAP S/4HANA Cloud Private Edition Extensibility options by leveraging the sample scenarios from SAP
SAP S/4HANA Extensibility — SAP S/4HANA Extensibility Tutorial
VDM View Types — The Virtual Data Model in SAP S/4HANA Cloud Private Edition
View Browser — Search, browse and tag CDS Views

Data Sources (1)

Source	Alias	Join Type
I_MatrixCnsldtnReport01C	I_MatrixCnsldtnReport01C	from

Parameters (12)

Name	Type	Default
P_FiscalYear	ryear
P_FiscalPeriod	poper
P_FiscalYearVariant	fincs_periv
P_ConsolidationDimension	fc_dimen
P_ConsolidationGroup	fc_congr
distinctValues	true
P_FromFiscalYear	fincs_from_fiscal_year
P_FromFiscalYearPeriod	fis_jahrper_conv
P_ToFiscalYearPeriod	fis_jahrper_conv
P_ConsolidationChartOfAccounts	fincs_itclg
P_FinancialStatementItemHier	fincs_ithry
P_KeyDate	vdm_v_key_date

Associations (1)

Cardinality	Target	Alias	Condition
[1..1]	I_FinStmntItmHierDir	_FinStmntItmHierDir	`$projection.ConsolidationChartOfAccounts = _FinStmntItmHierDir.ConsolidationChartOfAccounts and _FinStmntItmHierDir.FinancialStatementItemHier = $parameters.P_FinancialStatementItemHier`

Annotations (13)

Name	Value	Level
AbapCatalog.sqlViewName	CCSMATRIXRPT01Q	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 (106)

Field	Source Field	Description
lookupEntityI_CnsldtnGlobalParameter
resultElementFiscalYearP_FiscalYearryear
resultElementFiscalYearPeriod
P_ConsolidationGroup		To Fiscal Year Period
P_FromFiscalYearPeriod
YTDAmtInCnsldtnTransactionCrcy	YTDAmtInCnsldtnTransactionCrcy	YTD Amount in Transaction Currency
YTDAmtInCnsldtnLocalCrcy	YTDAmtInCnsldtnLocalCrcy	YTD Amount in Local Currency
YTDQtyInCnsldtnBaseUnit	YTDQtyInCnsldtnBaseUnit	YTD Quantity
ConsolidationVersion	ConsolidationVersion	Consolidation Version
FiscalYear	FiscalYear	G/L Fiscal Year
FiscalPeriod	FiscalPeriod	Reporting Period
FiscalYearPeriod	FiscalYearPeriod	Fiscal Year Period
ConsolidationChartOfAccounts	ConsolidationChartOfAccounts	Consolidation Chart of Accounts
FinancialStatementItem	FinancialStatementItem	Financial Statement Item
ConsolidationGroup	ConsolidationGroup	Consolidation Group
ConsolidationUnit	ConsolidationUnit	Consolidation Unit
ProfitCenter	ProfitCenter	Profit Center
Segment	Segment	Segment for Segmental Reporting
ConsolidationLedger	ConsolidationLedger	Ledger
GroupCurrency	GroupCurrency	Group Currency
SubItemCategory	SubItemCategory	Subitem Category
SubItem	SubItem	Subitem Number
ConsolidationDocumentType	ConsolidationDocumentType	Document Type
PostingLevel	PostingLevel	Posting Level
PartnerConsolidationUnit	PartnerConsolidationUnit	Partner Consolidation Unit
PartnerProfitCenter	PartnerProfitCenter	Partner Profit Center
PartnerSegment	PartnerSegment	Partner Segment for Segmental Reporting
ControllingArea	ControllingArea	Controlling Area
CostCenter	CostCenter	Cost Center
FinancialTransactionType	FinancialTransactionType	Transaction type
FunctionalArea	FunctionalArea	Sendr Fctl Area
CurrencyConversionsDiffType	CurrencyConversionsDiffType	Currency Translation
TransactionCurrency	TransactionCurrency	Transaction Currency
LocalCurrency	LocalCurrency	Currency key of the local currency
BaseUnit	BaseUnit	Base Unit of Measure
ConsolidationDocumentNumber	ConsolidationDocumentNumber	Group Journal Entry
ConsolidationPostingItem	ConsolidationPostingItem	Group Journal Entry Item
GLRecordType	GLRecordType	Record Type
DebitCreditCode	DebitCreditCode	Debit/Credit Indicator
Company	Company	Company
CompanyCode	CompanyCode	Receiver Company Code
ConsolidationApportionment	ConsolidationApportionment	Apportionment
ConsolidationAcquisitionYear	ConsolidationAcquisitionYear	Year of Acquisition
ConsolidationAcquisitionPeriod	ConsolidationAcquisitionPeriod	Period of Acquisition
InvesteeConsolidationUnit	InvesteeConsolidationUnit	Investee Consolidation Unit
DocumentItemText	DocumentItemText	Item Text
ConsolidationPostgItemAutoFlag	ConsolidationPostgItemAutoFlag	Indicator: Automatic posting lines
BusinessTransactionType	BusinessTransactionType	Business Transaction
PostingDate	PostingDate	Posting Date in the Document
CurrencyTranslationDate	CurrencyTranslationDate	Value Date for Currency Translation
RefConsolidationDocumentNumber	RefConsolidationDocumentNumber	Document Number of an Accounting Document
ReferenceFiscalYear	ReferenceFiscalYear	Original Fiscal Year
RefConsolidationPostingItem	RefConsolidationPostingItem	Six-figure number of line item
RefConsolidationDocumentType	RefConsolidationDocumentType	Document Category
RefBusinessTransactionType	RefBusinessTransactionType	Business Transaction
CreationDate	CreationDate	Day On Which Accounting Document Was Entered
CreationTime	CreationTime	Time of Change
UserID	UserID	User Name
ReverseDocument	ReverseDocument	Reverse Document Number
ReversedDocument	ReversedDocument	Number of Reversed Document
InvestmentActivityType	InvestmentActivityType	Consolidation of Investments Activity
InvestmentActivity	InvestmentActivity	Consolidation of Investments Activity Number
ConsolidationDocReversalYear	ConsolidationDocReversalYear	Year of reversal document or reversed document
ReferenceDocumentType	ReferenceDocumentType	Reference Document Type
ReferenceDocumentContext	ReferenceDocumentContext	Reference Organizational Units
LogicalSystem	LogicalSystem	Logical System
ChartOfAccounts	ChartOfAccounts	Chart of Accounts
GLAccount	GLAccount	General Ledger
AssignmentReference	AssignmentReference	Assignment Reference
BusinessArea	BusinessArea	Business Area
PartnerCostCenter	PartnerCostCenter	Sender cost center
PartnerFunctionalArea	PartnerFunctionalArea	Partner Functional Area
PartnerBusinessArea	PartnerBusinessArea	Trading partner's business area
PartnerCompany	PartnerCompany	Company ID of Trading Partner
OrderID	OrderID	Order Number
Customer	Customer	Customer Number
Supplier	Supplier	Account Number of Supplier
Plant	Plant	Valuation Area
WBSElementInternalID	WBSElementInternalID	WBS Internal ID
WBSElementExternalID	WBSElementExternalID	Work Breakdown Structure Element (WBS Element) Edited
Project	Project	Project Number (External) Edited
BillingDocumentType	BillingDocumentType	Billing Type
SalesOrganization	SalesOrganization	Sales Organization
DistributionChannel	DistributionChannel	Distribution Channel
OrganizationDivision	OrganizationDivision	Org. Division
MaterialGroup	MaterialGroup	Material Group
SoldProduct	SoldProduct	Product Sold
SoldProductGroup	SoldProductGroup	Product Sold Group
CustomerGroup	CustomerGroup	Customer Group
CustomerSupplierCountry	CustomerSupplierCountry	Country/Region of Customer or Supplier
CustomerSupplierIndustry	CustomerSupplierIndustry	Industry Key
SalesDistrict	SalesDistrict	Sales District
BillToParty	BillToParty	Inv. Recipient
ShipToParty	ShipToParty	Ship-To Party (obsolete)
CustomerSupplierCorporateGroup	CustomerSupplierCorporateGroup	Group key
ConsolidationDimension	ConsolidationDimension	Dimension
FinancialStatementItemHier
KeyDate
_FinStmntItmHierDir	_FinStmntItmHierDir
_ControllingArea	_ControllingArea
_TransactionCurrency	_TransactionCurrency
_GroupCurrency	_GroupCurrency
_LocalCurrency	_LocalCurrency
_BaseUnit	_BaseUnit
_SubItemCategory	_SubItemCategory
_SubItem	_SubItem

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_ConsolidationMatrixRpt01Q.
-- 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_FiscalYear : ryear, P_FiscalPeriod : poper, P_FiscalYearVariant : fincs_periv, P_ConsolidationDimension : fc_dimen, P_ConsolidationGroup : fc_congr, distinctValues : true, P_FromFiscalYear : fincs_from_fiscal_year, P_FromFiscalYearPeriod : fis_jahrper_conv, P_ToFiscalYearPeriod : fis_jahrper_conv, P_ConsolidationChartOfAccounts : fincs_itclg, P_FinancialStatementItemHier : fincs_ithry, P_KeyDate : vdm_v_key_date

CREATE VIEW C_ConsolidationMatrixRpt01Q AS
SELECT
  lookupEntity: 'I_CnsldtnGlobalParameter' AS lookupEntityI_CnsldtnGlobalParameter,
  resultElement: 'FiscalYear' AS resultElementFiscalYearP_FiscalYearryear,
  resultElement: 'FiscalYearPeriod' AS resultElementFiscalYearPeriod,
  binding: [ { targetParameter: 'P_FiscalYear', type : #PARAMETER, value: 'P_FromFiscalYear' AS P_ConsolidationGroup,
  P_FromFiscalYearPeriod: $parameters.P_FromFiscalYearPeriod AS P_FromFiscalYearPeriod,
  YTDAmtInCnsldtnTransactionCrcy,
  YTDAmtInCnsldtnLocalCrcy,
  YTDQtyInCnsldtnBaseUnit,
  ConsolidationVersion,
  FiscalYear,
  FiscalPeriod,
  FiscalYearPeriod,
  ConsolidationChartOfAccounts,
  FinancialStatementItem,
  ConsolidationGroup,
  ConsolidationUnit,
  ProfitCenter,
  Segment,
  ConsolidationLedger,
  GroupCurrency,
  SubItemCategory,
  SubItem,
  ConsolidationDocumentType,
  PostingLevel,
  PartnerConsolidationUnit,
  PartnerProfitCenter,
  PartnerSegment,
  ControllingArea,
  CostCenter,
  FinancialTransactionType,
  FunctionalArea,
  CurrencyConversionsDiffType,
  TransactionCurrency,
  LocalCurrency,
  BaseUnit,
  ConsolidationDocumentNumber,
  ConsolidationPostingItem,
  GLRecordType,
  DebitCreditCode,
  Company,
  CompanyCode,
  ConsolidationApportionment,
  ConsolidationAcquisitionYear,
  ConsolidationAcquisitionPeriod,
  InvesteeConsolidationUnit,
  DocumentItemText,
  ConsolidationPostgItemAutoFlag,
  BusinessTransactionType,
  PostingDate,
  CurrencyTranslationDate,
  RefConsolidationDocumentNumber,
  ReferenceFiscalYear,
  RefConsolidationPostingItem,
  RefConsolidationDocumentType,
  RefBusinessTransactionType,
  CreationDate,
  CreationTime,
  UserID,
  ReverseDocument,
  ReversedDocument,
  InvestmentActivityType,
  InvestmentActivity,
  ConsolidationDocReversalYear,
  ReferenceDocumentType,
  ReferenceDocumentContext,
  LogicalSystem,
  ChartOfAccounts,
  GLAccount,
  AssignmentReference,
  BusinessArea,
  PartnerCostCenter,
  PartnerFunctionalArea,
  PartnerBusinessArea,
  PartnerCompany,
  OrderID,
  Customer,
  Supplier,
  Plant,
  WBSElementInternalID,
  WBSElementExternalID,
  Project,
  BillingDocumentType,
  SalesOrganization,
  DistributionChannel,
  OrganizationDivision,
  MaterialGroup,
  SoldProduct,
  SoldProductGroup,
  CustomerGroup,
  CustomerSupplierCountry,
  CustomerSupplierIndustry,
  SalesDistrict,
  BillToParty,
  ShipToParty,
  CustomerSupplierCorporateGroup,
  ConsolidationDimension,
  :P_FinancialStatementItemHier AS FinancialStatementItemHier,
  :P_KeyDate AS KeyDate
FROM I_MatrixCnsldtnReport01C
LEFT OUTER JOIN I_FinStmntItmHierDir AS _FinStmntItmHierDir ON ConsolidationChartOfAccounts = _FinStmntItmHierDir.ConsolidationChartOfAccounts AND _FinStmntItmHierDir.FinancialStatementItemHier = $parameters.P_FinancialStatementItemHier  -- association [1..1]
;

Depth:

C_ConsolidationMatrixRpt01Q view

I_MatrixCnsldtnReport01C view