What is I_ConsolidationGroupRptEnhcdC in SAP S/4HANA?

I_ConsolidationGroupRptEnhcdC is a composite CDS view in SAP S/4HANA. Enhanced Group Reporting Data - Cube It contains 107 fields.

Which tables does I_ConsolidationGroupRptEnhcdC read from?

I_ConsolidationGroupRptEnhcdC reads data from: P_CnsldtnFndnWithRptRules.

What VDM layer is I_ConsolidationGroupRptEnhcdC?

I_ConsolidationGroupRptEnhcdC is classified as a Composite view that combines data from multiple basic views.

I_ConsolidationGroupRptEnhcdC

DDL: I_CONSOLIDATIONGROUPRPTENHCDC SQL: ICCGRPRPTENHANC Type: view COMPOSITE

107 Fields 1 Data Sources 1 Associations

Enhanced Group Reporting Data - Cube

I_ConsolidationGroupRptEnhcdC (Composite)

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

Group Reporting

I_ConsolidationGroupRptEnhcdC is a Composite CDS View (Cube) that provides data about "Enhanced Group Reporting Data - Cube" in SAP S/4HANA. It reads from 1 data source (P_CnsldtnFndnWithRptRules) and exposes 107 fields with key fields ConsolidationLedger, ConsolidationDimension, FiscalYear, ConsolidationDocumentNumber, ConsolidationPostingItem. It has 1 association to related views.

SAP API Hub

State	C1
Line of Business	Group Reporting
Application Component	FIN-CS-EA
Capabilities	Data Provider for Analytical Queries, Data Source in SQL Select, Data Source for Defining CDS Entities
Package	Group Reporting for SAP S/4HANA Cloud Private Edition
Description	<p>This CDS view provides access to all details of the data in group reporting that has the consolidation logic applied. It additionally supports the rule-based reports where your defined reporting items are displayed as reporting dimensions. You can create rule-based group reports for consolidation groups, such as cash flow statements and consolidated P&L statements, with the data provided by this CDS view. For more information, see Rule-Based Reports.</p> <p>This CDS view provides the prerequisites for answering the following business questions:</p> <ul> <li><p>What is the consolidation dimension, consolidation chart of accounts, and consolidation ledger in which the reporting logic is applied?</p></li> <li><p>What is the fiscal year, period, and organizational unit information of the consolidated data? </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> </ul>

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
P_CnsldtnFndnWithRptRules	P_CnsldtnFndnWithRptRules	from

Parameters (2)

Name	Type	Default
P_ConsolidationRptgItemHier	fincs_rihry
P_ConsolidationRptgRuleID	fincs_rptid

Associations (1)

Cardinality	Target	Alias	Condition
[0..1]	I_CnsldtnRptgItem	_RptgItm	`$projection.ConsolidationChartOfAccounts = _RptgItm.ConsolidationChartOfAccounts and $projection.ConsolidationReportingItem = _RptgItm.ConsolidationReportingItem`

Annotations (14)

Name	Value	Level
AbapCatalog.sqlViewName	ICCGRPRPTENHANC	view
AbapCatalog.compiler.compareFilter	true	view
AccessControl.authorizationCheck	#CHECK	view
Analytics.dataCategory	#CUBE	view
VDM.viewType	#COMPOSITE	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
AbapCatalog.buffering.status	#NOT_ALLOWED	view
Metadata.allowExtensions	true	view
Metadata.ignorePropagatedAnnotations	true	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.dataClass	#MIXED	view
ObjectModel.modelingPattern	#ANALYTICAL_CUBE	view
EndUserText.label	Enhanced Group Reporting Data - Cube	view

Fields (107)

Key	Field	Source Field	Description
KEY	ConsolidationLedger	ConsolidationLedger	Ledger
KEY	ConsolidationDimension	ConsolidationDimension	Dimension
KEY	FiscalYear	FiscalYear	G/L Fiscal Year
KEY	ConsolidationDocumentNumber	ConsolidationDocumentNumber	Group Journal Entry
KEY	ConsolidationPostingItem	ConsolidationPostingItem	Group Journal Entry Item
	ConsolidationVersion	ConsolidationVersion	Consolidation Version
	TransactionCurrency	TransactionCurrency	Transaction Currency
	LocalCurrency	LocalCurrency	Currency key of the local currency
	GroupCurrency	GroupCurrency	Group Currency
	BaseUnit	BaseUnit	Base Unit of Measure
	FiscalPeriod	FiscalPeriod	Fiscal Period
	DebitCreditCode	DebitCreditCode	Debit/Credit Indicator
	Company	Company	Company
	ConsolidationUnit	ConsolidationUnit	Consolidation Unit
	ConsolidationChartOfAccounts	ConsolidationChartOfAccounts	Consolidation Chart of Accounts
	FinancialStatementItem	FinancialStatementItem	Financial Statement Item
	PartnerConsolidationUnit	PartnerConsolidationUnit	Partner Consolidation Unit
	ConsolidationGroup	ConsolidationGroup	Consolidation Group
	CompanyCode	CompanyCode	Receiver Company Code
	SubItemCategory	SubItemCategory	Subitem Category
	SubItem	SubItem	Subitem Number
	PostingLevel	PostingLevel	Posting Level
	ConsolidationApportionment	ConsolidationApportionment	Apportionment
	CurrencyConversionsDiffType	CurrencyConversionsDiffType	Currency Translation
	ConsolidationDocumentType	ConsolidationDocumentType	Document Type
	ConsolidationAcquisitionYear	ConsolidationAcquisitionYear	Year of Acquisition
	ConsolidationAcquisitionPeriod	ConsolidationAcquisitionPeriod	Period of Acquisition
	InvesteeConsolidationUnit	InvesteeConsolidationUnit	Investee Consolidation Unit
	YTDQtyInCnsldtnBaseUnit		Quantity
	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
	CostCenter	CostCenter	Cost Center
	ProfitCenter	ProfitCenter	Profit Center
	FunctionalArea	FunctionalArea	Sendr Fctl Area
	BusinessArea	BusinessArea	Business Area
	ControllingArea	ControllingArea	Controlling Area
	Segment	Segment	Segment for Segmental Reporting
	PartnerCostCenter	PartnerCostCenter	Sender cost center
	PartnerProfitCenter	PartnerProfitCenter	Partner Profit Center
	PartnerFunctionalArea	PartnerFunctionalArea	Partner Functional Area
	PartnerBusinessArea	PartnerBusinessArea	Trading partner's business area
	PartnerCompany	PartnerCompany	Company ID of Trading Partner
	PartnerSegment	PartnerSegment	Partner Segment for Segmental Reporting
	OrderID	OrderID	Order Number
	Customer	Customer	Customer Number
	Supplier	Supplier	Account Number of Supplier
	Material	Material	Material Number
	Plant	Plant	Valuation Area
	FinancialTransactionType	FinancialTransactionType	Transaction type
	WBSElement	WBSElement	Work Breakdown Structure Element (WBS Element)
	Project	Project	Project definition
	ConsolidationRecordNumber	ConsolidationRecordNumber	Record number of the line item record
	ConsolidationReportingItem		Reporting Item
	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
	_Ledger	_Ledger
	_Dimension	_Dimension
	_Version	_Version
	_CnsldtnUnit	_CnsldtnUnit
	_CnsldtnGroup	_CnsldtnGroup
	_ChartOfAccounts	_ChartOfAccounts
	_FinStmntItm	_FinStmntItm
	_PartnerUnit	_PartnerUnit
	_SubItemCategory	_SubItemCategory
	_SubItem	_SubItem
	_DocumentType	_DocumentType
	_PostingLevel	_PostingLevel
	_InvesteeUnit	_InvesteeUnit
	_TransactionCurrency	_TransactionCurrency
	_LocalCurrency	_LocalCurrency
	_GroupCurrency	_GroupCurrency
	_BaseUnit	_BaseUnit
	_RptgItm	_RptgItm

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_ConsolidationGroupRptEnhcdC.
-- 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: ICCGRPRPTENHANC
-- Parameters: P_ConsolidationRptgItemHier : fincs_rihry, P_ConsolidationRptgRuleID : fincs_rptid

CREATE VIEW I_ConsolidationGroupRptEnhcdC AS
SELECT
  ConsolidationLedger,
  ConsolidationDimension,
  FiscalYear,
  ConsolidationDocumentNumber,
  ConsolidationPostingItem,
  ConsolidationVersion,
  TransactionCurrency,
  LocalCurrency,
  GroupCurrency,
  BaseUnit,
  FiscalPeriod,
  DebitCreditCode,
  Company,
  ConsolidationUnit,
  ConsolidationChartOfAccounts,
  FinancialStatementItem,
  PartnerConsolidationUnit,
  ConsolidationGroup,
  CompanyCode,
  SubItemCategory,
  SubItem,
  PostingLevel,
  ConsolidationApportionment,
  CurrencyConversionsDiffType,
  ConsolidationDocumentType,
  ConsolidationAcquisitionYear,
  ConsolidationAcquisitionPeriod,
  InvesteeConsolidationUnit,
  cast ( QuantityInBaseUnit as quan1_12 ) AS YTDQtyInCnsldtnBaseUnit,
  DocumentItemText,
  ConsolidationPostgItemAutoFlag,
  BusinessTransactionType,
  PostingDate,
  CurrencyTranslationDate,
  RefConsolidationDocumentNumber,
  ReferenceFiscalYear,
  RefConsolidationPostingItem,
  RefConsolidationDocumentType,
  RefBusinessTransactionType,
  CreationDate,
  CreationTime,
  UserID,
  ReverseDocument,
  ReversedDocument,
  InvestmentActivityType,
  InvestmentActivity,
  ConsolidationDocReversalYear,
  ReferenceDocumentType,
  ReferenceDocumentContext,
  LogicalSystem,
  ChartOfAccounts,
  GLAccount,
  AssignmentReference,
  CostCenter,
  ProfitCenter,
  FunctionalArea,
  BusinessArea,
  ControllingArea,
  Segment,
  PartnerCostCenter,
  PartnerProfitCenter,
  PartnerFunctionalArea,
  PartnerBusinessArea,
  PartnerCompany,
  PartnerSegment,
  OrderID,
  Customer,
  Supplier,
  Material,
  Plant,
  FinancialTransactionType,
  WBSElement,
  Project,
  ConsolidationRecordNumber,
  cast ( ConsolidationReportingItem as fincs_ritem ) AS ConsolidationReportingItem,
  BillingDocumentType,
  SalesOrganization,
  DistributionChannel,
  OrganizationDivision,
  MaterialGroup,
  SoldProduct,
  SoldProductGroup,
  CustomerGroup,
  CustomerSupplierCountry,
  CustomerSupplierIndustry,
  SalesDistrict,
  BillToParty,
  ShipToParty,
  CustomerSupplierCorporateGroup
FROM P_CnsldtnFndnWithRptRules
LEFT OUTER JOIN I_CnsldtnRptgItem AS _RptgItm ON ConsolidationChartOfAccounts = _RptgItm.ConsolidationChartOfAccounts AND ConsolidationReportingItem = _RptgItm.ConsolidationReportingItem  -- association [0..1]
;

Depth:

I_ConsolidationGroupRptEnhcdC view

P_CnsldtnFndnWithRptRules view