What is I_ConsolidationJournalEntryC in SAP S/4HANA?

I_ConsolidationJournalEntryC is a composite CDS view in SAP S/4HANA. Group Journal Entries - Cube It contains 108 fields.

Which tables does I_ConsolidationJournalEntryC read from?

I_ConsolidationJournalEntryC reads data from: I_CnsldtnFoundation.

What VDM layer is I_ConsolidationJournalEntryC?

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

I_ConsolidationJournalEntryC

DDL: I_CONSOLIDATIONJOURNALENTRYC SQL: ICCRNLENTRC Type: view COMPOSITE Package: FIN_CS_JOURNAL_ENTRY_DISPLAY

108 Fields 1 Data Sources

Group Journal Entries - Cube

I_ConsolidationJournalEntryC (Composite)

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

Group Reporting

I_ConsolidationJournalEntryC is a Composite CDS View (Cube) that provides data about "Group Journal Entries - 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. Part of development package FIN_CS_JOURNAL_ENTRY_DISPLAY.

SAP API Hub

Category	Composite
State	C1
Line of Business	Group Reporting
Application Component	FIN-CS-JE-2CL
Capabilities	Data Provider for Analytical Queries,Data Source in SQL Select,Data Source for Defining CDS Entities
Extensible (Key User)	No
Extensible (Developer)	No
Release State (Key User)	Released
Release State (Developer)	Not Released
Package	Group Reporting for SAP S/4HANA Cloud Public Edition
Description	<p>This CDS view provides access to all details of the journal entries in group reporting that has no consolidation logic applied yet. You can create local reports for consolidation units, such as balance sheets and P&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>What is the consolidation dimension, consolidation chart of accounts, and organizational unit information of my journal entries?</li> <li><p>What is the fiscal year and period when my journal entries are posted?</p></li> <li><p>What is the document number, consolidation financial statement item, posting level, and document type for a certain journal entry?</p></li> <li><p>What are the amounts in the transaction currency, local currency, and group currency on journal entry or line item level?</p></li> </ul>

Documentation

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

Data Sources (1)

Source	Alias	Join Type
I_CnsldtnFoundation	I_CnsldtnFoundation	from

Annotations (14)

Name	Value	Level
AbapCatalog.sqlViewName	ICCRNLENTRC	view
AbapCatalog.compiler.compareFilter	true	view
AccessControl.authorizationCheck	#CHECK	view
EndUserText.label	Group Journal Entries - 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.modelingPattern	#ANALYTICAL_CUBE	view

Fields (108)

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 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 Unit
	AmountInTransactionCurrency	AmountInTransactionCurrency	Amount in Transaction Currency
	AmountInLocalCurrency	AmountInLocalCurrency	Amount in Local Currency
	AmountInGroupCurrency	AmountInGroupCurrency	Amount in Group Currency
	QuantityInBaseUnit	QuantityInBaseUnit	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_ConsolidationJournalEntryC.
-- 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: ICCRNLENTRC

CREATE VIEW I_ConsolidationJournalEntryC 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,
  AmountInTransactionCurrency,
  AmountInLocalCurrency,
  AmountInGroupCurrency,
  QuantityInBaseUnit,
  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
;

Depth:

I_ConsolidationJournalEntryC view

I_CnsldtnFoundation view