What is C_CnsldtnReldAcctgJrnlEntrItm in SAP S/4HANA?

C_CnsldtnReldAcctgJrnlEntrItm is a consumption CDS view in SAP S/4HANA. Cnsldtn - Released Acct Journal Ent Item It contains 101 fields.

Which tables does C_CnsldtnReldAcctgJrnlEntrItm read from?

C_CnsldtnReldAcctgJrnlEntrItm reads data from: I_CnsldtnReldAcctgJrnlEntrItm.

What VDM layer is C_CnsldtnReldAcctgJrnlEntrItm?

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

C_CnsldtnReldAcctgJrnlEntrItm

DDL: C_CNSLDTNRELDACCTGJRNLENTRITM SQL: CRELDJRNLITM Type: view CONSUMPTION Package: FIN_CS_RELEASE_UNIVERSAL_JRNL

101 Fields 1 Data Sources

Cnsldtn - Released Acct Journal Ent Item

C_CnsldtnReldAcctgJrnlEntrItm is a Consumption CDS View that provides data about "Cnsldtn - Released Acct Journal Ent Item" in SAP S/4HANA. It reads from 1 data source (I_CnsldtnReldAcctgJrnlEntrItm) and exposes 101 fields with key field ConsolidationRecordNumber. Part of development package FIN_CS_RELEASE_UNIVERSAL_JRNL.

Data Sources (1)

Source	Alias	Join Type
I_CnsldtnReldAcctgJrnlEntrItm	I_CnsldtnReldAcctgJrnlEntrItm	from

Parameters (2)

Name	Type	Default
P_CreationDateTimeRgFr	timestamp
P_CreationDateTimeRgTo	timestamp

Annotations (12)

Name	Value	Level
AbapCatalog.sqlViewName	CRELDJRNLITM	view
AbapCatalog.compiler.compareFilter	true	view
VDM.viewType	#CONSUMPTION	view
AbapCatalog.preserveKey	true	view
AccessControl.authorizationCheck	#CHECK	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
AbapCatalog.buffering.status	#NOT_ALLOWED	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.dataClass	#MIXED	view
Metadata.ignorePropagatedAnnotations	true	view
EndUserText.label	Cnsldtn - Released Acct Journal Ent Item	view

Fields (101)

Key	Field	Source Table	Source Field	Description
KEY	ConsolidationRecordNumber	RealTimeRptdFinData	ConsolidationRecordNumber	Record number
	ConsolidationLedger	RealTimeRptdFinData	ConsolidationLedger	Ledger
	GLRecordType	RealTimeRptdFinData	GLRecordType	Record Type
	ConsolidationVersion	RealTimeRptdFinData	ConsolidationVersion	Version
	FiscalYear	RealTimeRptdFinData	FiscalYear	G/L Fiscal Year
	TransactionCurrency	RealTimeRptdFinData	TransactionCurrency	Transaction Currency
	BaseUnit	RealTimeRptdFinData	BaseUnit	Unit of Measure
	DebitCreditCode	RealTimeRptdFinData	DebitCreditCode	Single-Character Flag
	FiscalPeriod	RealTimeRptdFinData	FiscalPeriod	Tax period
	FiscalYearPeriod	RealTimeRptdFinData	FiscalYearPeriod	Period/Year
	DocumentCategory	RealTimeRptdFinData	DocumentCategory	Document Category
	ConsolidationDocumentNumber	RealTimeRptdFinData	ConsolidationDocumentNumber	Document Number
	ConsolidationPostingItem	RealTimeRptdFinData	ConsolidationPostingItem	G/L Line Item
	Company	RealTimeRptdFinData	Company	Owner
	ConsolidationDimension	RealTimeRptdFinData	ConsolidationDimension	Dimension
	ConsolidationUnit	RealTimeRptdFinData	ConsolidationUnit	Consolidation Unit
	ConsolidationChartOfAccounts	RealTimeRptdFinData	ConsolidationChartOfAccounts	Cons. COA
	FinancialStatementItem	RealTimeRptdFinData	FinancialStatementItem	FS Item
	PartnerConsolidationUnit	RealTimeRptdFinData	PartnerConsolidationUnit	Partner Unit
	ConsolidationGroup	RealTimeRptdFinData	ConsolidationGroup	Cons. Group
	CompanyCode	RealTimeRptdFinData	CompanyCode	Receiver Company Code
	SubItemCategory	RealTimeRptdFinData	SubItemCategory	Subitem Category
	SubItem	RealTimeRptdFinData	SubItem	Subitem Number
	PostingLevel	RealTimeRptdFinData	PostingLevel	Posting Level
	ConsolidationApportionment	RealTimeRptdFinData	ConsolidationApportionment	Apportionment
	CurrencyConversionsDiffType	RealTimeRptdFinData	CurrencyConversionsDiffType	CT Indicator
	ConsolidationDocumentType	RealTimeRptdFinData	ConsolidationDocumentType	Document Type
	ConsolidationAcquisitionYear	RealTimeRptdFinData	ConsolidationAcquisitionYear	Acquis. Year
	ConsolidationAcquisitionPeriod	RealTimeRptdFinData	ConsolidationAcquisitionPeriod	Period of Acq.
	InvesteeConsolidationUnit	RealTimeRptdFinData	InvesteeConsolidationUnit	Investee Unit
	CnsldtnHighestUpdatePeriod	RealTimeRptdFinData	CnsldtnHighestUpdatePeriod	HighstUpdPer
	AmountInTransactionCurrency	RealTimeRptdFinData	AmountInTransactionCurrency	Pt Crcy Amt
	AmountInLocalCurrency	RealTimeRptdFinData	AmountInLocalCurrency	Local Crcy Amt
	AmountInGroupCurrency	RealTimeRptdFinData	AmountInGroupCurrency	Amnt in GrpCrcy
	QuantityInBaseUnit	RealTimeRptdFinData	QuantityInBaseUnit	Quantity
	DocumentItemText	RealTimeRptdFinData	DocumentItemText	Text
	ConsolidationPostgItemAutoFlag	RealTimeRptdFinData	ConsolidationPostgItemAutoFlag	Auto. ID
	BusinessTransactionType	RealTimeRptdFinData	BusinessTransactionType	Bus.transaction
	IntercompanyTransaction	RealTimeRptdFinData	IntercompanyTransaction	Intercompany Transaction
	PostingDate	RealTimeRptdFinData	PostingDate	Posting Date for GR
	CurrencyTranslationDate	RealTimeRptdFinData	CurrencyTranslationDate	Value Date
	RefConsolidationDocumentNumber	RealTimeRptdFinData	RefConsolidationDocumentNumber	Document Number
	ReferenceFiscalYear	RealTimeRptdFinData	ReferenceFiscalYear	Original FY
	RefConsolidationPostingItem	RealTimeRptdFinData	RefConsolidationPostingItem	Item
	RefConsolidationDocumentType	RealTimeRptdFinData	RefConsolidationDocumentType	Document Categ.
	RefBusinessTransactionType	RealTimeRptdFinData	RefBusinessTransactionType	Bus.transaction
	CreationDate	RealTimeRptdFinData	CreationDate	Time Stamp
	CreationTime	RealTimeRptdFinData	CreationTime	Time of Change
	UserID	RealTimeRptdFinData	UserID	User Name
	ReverseDocument	RealTimeRptdFinData	ReverseDocument	Reversed With
	ReversedDocument	RealTimeRptdFinData	ReversedDocument	Reversed doc.
	InvestmentActivityType	RealTimeRptdFinData	InvestmentActivityType	C/I Activity
	InvestmentActivity	RealTimeRptdFinData	InvestmentActivity	Activity Number
	InvestorConsolidationUnit	RealTimeRptdFinData	InvestorConsolidationUnit
	ConsolidationDocReversalYear	RealTimeRptdFinData	ConsolidationDocReversalYear	Year of reversal doc
	ReferenceDocumentType	RealTimeRptdFinData	ReferenceDocumentType	Reference Document Type
	ReferenceDocumentContext	RealTimeRptdFinData	ReferenceDocumentContext	Reference Document Context
	LogicalSystem	RealTimeRptdFinData	LogicalSystem	Logical System
	ChartOfAccounts	RealTimeRptdFinData	ChartOfAccounts	Node Class
	LocalCurrency	RealTimeRptdFinData	LocalCurrency	Local Currency
	GroupCurrency	RealTimeRptdFinData	GroupCurrency	Ledger curr.
	GLAccount	RealTimeRptdFinData	GLAccount	General Ledger
	ReferenceDocumentNumber	RealTimeRptdFinData	ReferenceDocumentNumber	Reference
	AssignmentReference	RealTimeRptdFinData	AssignmentReference	Assignment Reference
	CostCenter	RealTimeRptdFinData	CostCenter	Cost Center
	ProfitCenter	RealTimeRptdFinData	ProfitCenter	Profit Center
	FunctionalArea	RealTimeRptdFinData	FunctionalArea	Sendr Fctl Area
	BusinessArea	RealTimeRptdFinData	BusinessArea	Business Area
	ControllingArea	RealTimeRptdFinData	ControllingArea	Controlling Area
	Segment	RealTimeRptdFinData	Segment	Segment number
	PartnerCostCenter	RealTimeRptdFinData	PartnerCostCenter	Sender Cost Ctr
	PartnerProfitCenter	RealTimeRptdFinData	PartnerProfitCenter	Profit Center
	PartnerFunctionalArea	RealTimeRptdFinData	PartnerFunctionalArea	Rec. Fntcl Area
	PartnerBusinessArea	RealTimeRptdFinData	PartnerBusinessArea	Trdg Part.BA
	PartnerCompany	RealTimeRptdFinData	PartnerCompany	Trading Partner
	PartnerSegment	RealTimeRptdFinData	PartnerSegment	Partner Segment
	OrderID	RealTimeRptdFinData	OrderID	Order ID
	Customer	RealTimeRptdFinData	Customer	Sold-to Party
	Supplier	RealTimeRptdFinData	Supplier	Supplier
	Material	RealTimeRptdFinData	Material	Vehicle Model
	MaterialGroup	RealTimeRptdFinData	MaterialGroup	Product Group
	Plant	RealTimeRptdFinData	Plant	Valuation Area
	FinancialTransactionType	RealTimeRptdFinData	FinancialTransactionType	Transact. Type
	WBSElementInternalID	RealTimeRptdFinData	WBSElementInternalID	WBS Internal ID
	WBSElementExternalID	RealTimeRptdFinData	WBSElementExternalID	WBS Element External ID
	Project	RealTimeRptdFinData	Project	WBS Element
	BillingDocumentType	RealTimeRptdFinData	BillingDocumentType	Billing Type
	SalesOrganization	RealTimeRptdFinData	SalesOrganization	Sales Organization
	DistributionChannel	RealTimeRptdFinData	DistributionChannel	RefDistCh-Cust/Mat.
	OrganizationDivision	RealTimeRptdFinData	OrganizationDivision	Org. Division
	SoldProduct	RealTimeRptdFinData	SoldProduct	Product Sold
	SoldProductGroup	RealTimeRptdFinData	SoldProductGroup	Product Sold Group
	CustomerGroup	RealTimeRptdFinData	CustomerGroup	Customer Group
	CustomerSupplierCountry	RealTimeRptdFinData	CustomerSupplierCountry	Customer or Supplier Country/Region
	CustomerSupplierIndustry	RealTimeRptdFinData	CustomerSupplierIndustry	Industry
	SalesDistrict	RealTimeRptdFinData	SalesDistrict	Sales District
	BillToParty	RealTimeRptdFinData	BillToParty	Inv. Recipient
	ShipToParty	RealTimeRptdFinData	ShipToParty	Ship-To Party (obsolete)
	CustomerSupplierCorporateGroup	RealTimeRptdFinData	CustomerSupplierCorporateGroup	Group
	CreationDateTime	RealTimeRptdFinData	CreationDateTime	Timestamp
	DataAgingObject	RealTimeRptdFinData	DataAgingObject	Data Aging

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_CnsldtnReldAcctgJrnlEntrItm.
-- 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: CRELDJRNLITM
-- Parameters: P_CreationDateTimeRgFr : timestamp, P_CreationDateTimeRgTo : timestamp

CREATE VIEW C_CnsldtnReldAcctgJrnlEntrItm AS
SELECT
  RealTimeRptdFinData.ConsolidationRecordNumber AS ConsolidationRecordNumber,
  RealTimeRptdFinData.ConsolidationLedger AS ConsolidationLedger,
  RealTimeRptdFinData.GLRecordType AS GLRecordType,
  RealTimeRptdFinData.ConsolidationVersion AS ConsolidationVersion,
  RealTimeRptdFinData.FiscalYear AS FiscalYear,
  RealTimeRptdFinData.TransactionCurrency AS TransactionCurrency,
  RealTimeRptdFinData.BaseUnit AS BaseUnit,
  RealTimeRptdFinData.DebitCreditCode AS DebitCreditCode,
  RealTimeRptdFinData.FiscalPeriod AS FiscalPeriod,
  RealTimeRptdFinData.FiscalYearPeriod AS FiscalYearPeriod,
  RealTimeRptdFinData.DocumentCategory AS DocumentCategory,
  RealTimeRptdFinData.ConsolidationDocumentNumber AS ConsolidationDocumentNumber,
  RealTimeRptdFinData.ConsolidationPostingItem AS ConsolidationPostingItem,
  RealTimeRptdFinData.Company AS Company,
  RealTimeRptdFinData.ConsolidationDimension AS ConsolidationDimension,
  RealTimeRptdFinData.ConsolidationUnit AS ConsolidationUnit,
  RealTimeRptdFinData.ConsolidationChartOfAccounts AS ConsolidationChartOfAccounts,
  RealTimeRptdFinData.FinancialStatementItem AS FinancialStatementItem,
  RealTimeRptdFinData.PartnerConsolidationUnit AS PartnerConsolidationUnit,
  RealTimeRptdFinData.ConsolidationGroup AS ConsolidationGroup,
  RealTimeRptdFinData.CompanyCode AS CompanyCode,
  RealTimeRptdFinData.SubItemCategory AS SubItemCategory,
  RealTimeRptdFinData.SubItem AS SubItem,
  RealTimeRptdFinData.PostingLevel AS PostingLevel,
  RealTimeRptdFinData.ConsolidationApportionment AS ConsolidationApportionment,
  RealTimeRptdFinData.CurrencyConversionsDiffType AS CurrencyConversionsDiffType,
  RealTimeRptdFinData.ConsolidationDocumentType AS ConsolidationDocumentType,
  RealTimeRptdFinData.ConsolidationAcquisitionYear AS ConsolidationAcquisitionYear,
  RealTimeRptdFinData.ConsolidationAcquisitionPeriod AS ConsolidationAcquisitionPeriod,
  RealTimeRptdFinData.InvesteeConsolidationUnit AS InvesteeConsolidationUnit,
  RealTimeRptdFinData.CnsldtnHighestUpdatePeriod AS CnsldtnHighestUpdatePeriod,
  RealTimeRptdFinData.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  RealTimeRptdFinData.AmountInLocalCurrency AS AmountInLocalCurrency,
  RealTimeRptdFinData.AmountInGroupCurrency AS AmountInGroupCurrency,
  RealTimeRptdFinData.QuantityInBaseUnit AS QuantityInBaseUnit,
  RealTimeRptdFinData.DocumentItemText AS DocumentItemText,
  RealTimeRptdFinData.ConsolidationPostgItemAutoFlag AS ConsolidationPostgItemAutoFlag,
  RealTimeRptdFinData.BusinessTransactionType AS BusinessTransactionType,
  RealTimeRptdFinData.IntercompanyTransaction AS IntercompanyTransaction,
  RealTimeRptdFinData.PostingDate AS PostingDate,
  RealTimeRptdFinData.CurrencyTranslationDate AS CurrencyTranslationDate,
  RealTimeRptdFinData.RefConsolidationDocumentNumber AS RefConsolidationDocumentNumber,
  RealTimeRptdFinData.ReferenceFiscalYear AS ReferenceFiscalYear,
  RealTimeRptdFinData.RefConsolidationPostingItem AS RefConsolidationPostingItem,
  RealTimeRptdFinData.RefConsolidationDocumentType AS RefConsolidationDocumentType,
  RealTimeRptdFinData.RefBusinessTransactionType AS RefBusinessTransactionType,
  RealTimeRptdFinData.CreationDate AS CreationDate,
  RealTimeRptdFinData.CreationTime AS CreationTime,
  RealTimeRptdFinData.UserID AS UserID,
  RealTimeRptdFinData.ReverseDocument AS ReverseDocument,
  RealTimeRptdFinData.ReversedDocument AS ReversedDocument,
  RealTimeRptdFinData.InvestmentActivityType AS InvestmentActivityType,
  RealTimeRptdFinData.InvestmentActivity AS InvestmentActivity,
  RealTimeRptdFinData.InvestorConsolidationUnit AS InvestorConsolidationUnit,
  RealTimeRptdFinData.ConsolidationDocReversalYear AS ConsolidationDocReversalYear,
  RealTimeRptdFinData.ReferenceDocumentType AS ReferenceDocumentType,
  RealTimeRptdFinData.ReferenceDocumentContext AS ReferenceDocumentContext,
  RealTimeRptdFinData.LogicalSystem AS LogicalSystem,
  RealTimeRptdFinData.ChartOfAccounts AS ChartOfAccounts,
  RealTimeRptdFinData.LocalCurrency AS LocalCurrency,
  RealTimeRptdFinData.GroupCurrency AS GroupCurrency,
  RealTimeRptdFinData.GLAccount AS GLAccount,
  RealTimeRptdFinData.ReferenceDocumentNumber AS ReferenceDocumentNumber,
  RealTimeRptdFinData.AssignmentReference AS AssignmentReference,
  RealTimeRptdFinData.CostCenter AS CostCenter,
  RealTimeRptdFinData.ProfitCenter AS ProfitCenter,
  RealTimeRptdFinData.FunctionalArea AS FunctionalArea,
  RealTimeRptdFinData.BusinessArea AS BusinessArea,
  RealTimeRptdFinData.ControllingArea AS ControllingArea,
  RealTimeRptdFinData.Segment AS Segment,
  RealTimeRptdFinData.PartnerCostCenter AS PartnerCostCenter,
  RealTimeRptdFinData.PartnerProfitCenter AS PartnerProfitCenter,
  RealTimeRptdFinData.PartnerFunctionalArea AS PartnerFunctionalArea,
  RealTimeRptdFinData.PartnerBusinessArea AS PartnerBusinessArea,
  RealTimeRptdFinData.PartnerCompany AS PartnerCompany,
  RealTimeRptdFinData.PartnerSegment AS PartnerSegment,
  RealTimeRptdFinData.OrderID AS OrderID,
  RealTimeRptdFinData.Customer AS Customer,
  RealTimeRptdFinData.Supplier AS Supplier,
  RealTimeRptdFinData.Material AS Material,
  RealTimeRptdFinData.MaterialGroup AS MaterialGroup,
  RealTimeRptdFinData.Plant AS Plant,
  RealTimeRptdFinData.FinancialTransactionType AS FinancialTransactionType,
  RealTimeRptdFinData.WBSElementInternalID AS WBSElementInternalID,
  RealTimeRptdFinData.WBSElementExternalID AS WBSElementExternalID,
  RealTimeRptdFinData.Project AS Project,
  RealTimeRptdFinData.BillingDocumentType AS BillingDocumentType,
  RealTimeRptdFinData.SalesOrganization AS SalesOrganization,
  RealTimeRptdFinData.DistributionChannel AS DistributionChannel,
  RealTimeRptdFinData.OrganizationDivision AS OrganizationDivision,
  RealTimeRptdFinData.SoldProduct AS SoldProduct,
  RealTimeRptdFinData.SoldProductGroup AS SoldProductGroup,
  RealTimeRptdFinData.CustomerGroup AS CustomerGroup,
  RealTimeRptdFinData.CustomerSupplierCountry AS CustomerSupplierCountry,
  RealTimeRptdFinData.CustomerSupplierIndustry AS CustomerSupplierIndustry,
  RealTimeRptdFinData.SalesDistrict AS SalesDistrict,
  RealTimeRptdFinData.BillToParty AS BillToParty,
  RealTimeRptdFinData.ShipToParty AS ShipToParty,
  RealTimeRptdFinData.CustomerSupplierCorporateGroup AS CustomerSupplierCorporateGroup,
  RealTimeRptdFinData.CreationDateTime AS CreationDateTime,
  RealTimeRptdFinData.DataAgingObject AS DataAgingObject
FROM I_CnsldtnReldAcctgJrnlEntrItm
;

Depth:

C_CnsldtnReldAcctgJrnlEntrItm view

I_CnsldtnReldAcctgJrnlEntrItm view