I_ConsolidationGroupReportC

DDL: I_CONSOLIDATIONGROUPREPORTC SQL: ICCGRPRPTC Type: view COMPOSITE
108 Fields 1 Data Sources

Group Reporting Data - Cube

I_ConsolidationGroupReportC (Composite)

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

CnsldtnGroupJournalEntryItem · Group Reporting

I_ConsolidationGroupReportC is a Composite CDS View (Cube) that provides data about "Group Reporting Data - Cube" in SAP S/4HANA. It reads from 1 data source (I_CnsldtnFoundation) and exposes 108 fields with key fields ConsolidationLedger, ConsolidationDimension, FiscalYear, ConsolidationDocumentNumber, ConsolidationPostingItem.

SAP API Hub

StateC1
Line of BusinessGroup Reporting
Application ComponentFIN-CS-EA
CapabilitiesData Provider for Analytical Queries, Data Source in SQL Select, Data Source for Defining CDS Entities, Data Source for Data Extraction
PackageGroup 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. You can create group reports for consolidation groups, such as consolidated balance sheets and consolidated P&amp;L statements, with the data provided by this CDS view.</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 in the transaction currency, local currency, and group currency?</p></li> </ul>

Documentation

Data Sources (1)

SourceAliasJoin Type
I_CnsldtnFoundation I_CnsldtnFoundation from

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName ICCGRPRPTC view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Group Reporting Data - 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
Analytics.dataCategory #CUBE view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.sapObjectNodeType.name CnsldtnGroupJournalEntryItem view
ObjectModel.modelingPattern #ANALYTICAL_CUBE view
Analytics.dataExtraction.enabled true view

Fields (108)

KeyFieldSource TableSource FieldDescription
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
YTDAmtInCnsldtnTransactionCrcy Cumulative Value in Transaction Currency
YTDAmtInCnsldtnLocalCrcy Cumulative Value in Local Currency
YTDAmtInCnsldtnGroupCrcy Cumulative Value in Group Currency
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
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

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_ConsolidationGroupReportC.
-- 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: ICCGRPRPTC

CREATE VIEW I_ConsolidationGroupReportC 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( AmountInTransactionCurrency as fincs_tsl_ytd preserving type ) AS YTDAmtInCnsldtnTransactionCrcy,
  cast( AmountInLocalCurrency as fincs_hsl_ytd preserving type ) AS YTDAmtInCnsldtnLocalCrcy,
  cast( AmountInGroupCurrency as fincs_ksl_ytd preserving type ) AS YTDAmtInCnsldtnGroupCrcy,
  cast ( QuantityInBaseUnit as fincs_quan preserving type ) 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,
  BillingDocumentType,
  SalesOrganization,
  DistributionChannel,
  OrganizationDivision,
  MaterialGroup,
  SoldProduct,
  SoldProductGroup,
  CustomerGroup,
  CustomerSupplierCountry,
  CustomerSupplierIndustry,
  SalesDistrict,
  BillToParty,
  ShipToParty,
  CustomerSupplierCorporateGroup
FROM I_CnsldtnFoundation
;

Learn More