What is C_CnsldtnGrpJEItm in SAP S/4HANA?

C_CnsldtnGrpJEItm is a consumption CDS view in SAP S/4HANA. Journal Entry Consumption It contains 208 fields.

Which tables does C_CnsldtnGrpJEItm read from?

C_CnsldtnGrpJEItm reads data from: I_CnsldtnGroupJrnlEntryItem.

What VDM layer is C_CnsldtnGrpJEItm?

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

C_CnsldtnGrpJEItm

DDL: C_CNSLDTNGRPJEITM Type: view_entity CONSUMPTION Package: FIN_CS_JOURNAL_ENTRY_DISPLAY

208 Fields 1 Data Sources 4 Associations 1 OData Services

Journal Entry Consumption

C_CnsldtnGrpJEItm is a Consumption CDS View that provides data about "Journal Entry Consumption" in SAP S/4HANA. It reads from 1 data source (I_CnsldtnGroupJrnlEntryItem) and exposes 208 fields with key fields FiscalYear, ConsolidationDocumentNumber, ConsolidationPostingItem. It has 4 associations to related views. It is exposed through 1 OData service (ASQL_F2573). Part of development package FIN_CS_JOURNAL_ENTRY_DISPLAY.

Data Sources (1)

Source	Alias	Join Type
I_CnsldtnGroupJrnlEntryItem	CnsldtnGroupJrnlEntryItem	from

Associations (4)

Cardinality	Target	Alias	Condition
[1]	I_CnsldtnGlobalSetting	_GlobalSetting	`_GlobalSetting.SequenceNumber = '1'`
[1..1]	E_CnsldtnGroupJrnlEntryItem_3	_Extension	`$projection.FiscalYear = _Extension.FiscalYear and $projection.ConsolidationDocumentNumber = _Extension.CnsldtnGroupJrnlEntry and $projection.ConsolidationPostingItem = _Extension.CnsldtnGroupJrnlEntryItem`
[0..*]	C_CnsldtnGrpJEItmDetail	_Item	`$projection.FiscalYear = _Item.FiscalYear and $projection.ConsolidationDocumentNumber = _Item.ConsolidationDocumentNumber and $projection.ConsolidationVersion = _Item.ConsolidationVersion`
[0..1]	C_CnsldtnInvmtEquityActyVH	_InvestmentActivityTypeText	`$projection.InvestmentActivityType = _InvestmentActivityTypeText.InvestmentActivityType`

Annotations (11)

Name	Value	Level
AccessControl.authorizationCheck	#MANDATORY	view
AccessControl.personalData.blocking	#NOT_REQUIRED	view
ObjectModel.compositionRoot	true	view
ObjectModel.usageType.sizeCategory	#XXL	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.dataClass	#MIXED	view
Metadata.allowExtensions	true	view
Search.searchable	true	view
Consumption.semanticObject	ConsolidationJournalList	view
VDM.viewType	#CONSUMPTION	view
EndUserText.label	Journal Entry Consumption	view

OData Services (1)

Service	Binding	Version	Contract	Release
ASQL_F2573	ASQL_F2573		C2	NOT_RELEASED

Fields (208)

Key	Field	Source Table	Source Field	Description
KEY	FiscalYear		FiscalYear	G/L Fiscal Year
KEY	ConsolidationDocumentNumber		CnsldtnGroupJrnlEntry
KEY	ConsolidationPostingItem		CnsldtnGroupJrnlEntryItem
	ConsolidationLedger		ConsolidationLedger	Ledger
	ConsolidationVersion		ConsolidationVersion	Version
	ReferenceFiscalYear		ReferenceFiscalYear	Original FY
	CompanyCode		CompanyCode	Receiver Company Code
	CompanyCodeName
	ConsolidationVersionText
	GLRecordType		GLRecordType	Record Type
	TransactionCurrency		TransactionCurrency	Transaction Currency
	LocalCurrency		LocalCurrency	Local Currency
	GroupCurrency		GroupCurrency	Ledger curr.
	BaseUnit		BaseUnit	Unit of Measure
	FiscalPeriod		FiscalPeriod	Tax period
	ConsolidationDocumentType		ConsolidationDocumentType	Document Type
	ConsolidationDocumentTypeText
	Company		Company	Owner
	ConsolidationUnit			Consolidation Unit
	ConsolidationUnitMdmText
	ConsolidationChartOfAccounts		ConsolidationChartOfAccounts	Cons. COA
	ConsolidationChartOfAcctsText
	FinancialStatementItem		FinancialStatementItem	FS Item
	FinancialStatementItemMdmText
	PartnerConsolidationUnit			Partner Unit
	PartnerCnsldtnUnitMediumText
	ConsolidationGroup		ConsolidationGroup	Cons. Group
	ConsolidationGroupMediumText
	SubItemCategory		SubItemCategory	Subitem Category
	SubItem		SubItem	Subitem Number
	PostingLevel		PostingLevel	Posting Level
	PostingLevelText
	ConsolidationApportionment		ConsolidationApportionment	Apportionment
	CurrencyConversionsDiffType		CurrencyConversionsDiffType	CT Indicator
	ConsolidationAcquisitionYear		ConsolidationAcquisitionYear	Acquis. Year
	ConsolidationAcquisitionPeriod		ConsolidationAcquisitionPeriod	Period of Acq.
	InvesteeConsolidationUnit			Investee Unit
	InvesteeConsolidationUnitText
	InvestorConsolidationUnit		InvestorConsolidationUnit
	InvestorConsolidationUnitText
	InvestmentActivityType		InvestmentActivityType	C/I Activity
	InvestmentActivityTypeText	_InvestmentActivityTypeText	InvestmentActivityTypeText
	DocumentItemText		DocumentItemText	Text
	ConsolidationPostgItemAutoFlag		ConsolidationPostgItemAutoFlag	Auto. ID
	BusinessTransactionType		BusinessTransactionType	Bus.transaction
	PostingDate		PostingDate	Posting Date for GR
	CurrencyTranslationDate		CurrencyTranslationDate	Value Date
	CreationDateTime		CreationDateTime	Timestamp
	CreationDate		CreationDate	Time Stamp
	CreationTime		CreationTime	Time of Change
	UserID		UserID	User Name
	ReverseDocument		ReverseDocument	Reversed With
	ReversedDocument		ReversedDocument	Reversed doc.
	InvestmentActivity		InvestmentActivity	Activity Number
	ConsolidationDocReversalYear		ConsolidationDocReversalYear	Year of reversal doc
	ReferenceDocumentType		ReferenceDocumentType	Reference Document Type
	ReferenceDocumentContext		ReferenceDocumentContext	Reference Document Context
	LogicalSystem		LogicalSystem	Logical System
	ChartOfAccounts		ChartOfAccounts	Node Class
	ChartOfAccountsName
	GLAccount		GLAccount	General Ledger
	GLAccountName
	AssignmentReference		AssignmentReference	Assignment Reference
	CostCenter		CostCenter	Cost Center
	CostCenterName
	ProfitCenter		ProfitCenter	Profit Center
	ProfitCenterName
	FunctionalArea		FunctionalArea	Sendr Fctl Area
	BusinessArea		BusinessArea	Business Area
	BusinessAreaName
	ControllingArea		ControllingArea	Controlling Area
	ControllingAreaName
	Segment		Segment	Segment number
	SegmentName
	PartnerCostCenter		PartnerCostCenter	Sender Cost Ctr
	PartnerCostCenterName
	PartnerProfitCenter		PartnerProfitCenter	Profit Center
	PartnerProfitCenterName
	PartnerFunctionalArea		PartnerFunctionalArea	Rec. Fntcl Area
	PartnerBusinessArea		PartnerBusinessArea	Trdg Part.BA
	PartnerBusinessAreaName
	PartnerCompany		PartnerCompany	Trading Partner
	PartnerSegment		PartnerSegment	Partner Segment
	PartnerSegmentName
	OrderID		OrderID	Order ID
	Customer		Customer	Sold-to Party
	CustomerName
	Supplier		Supplier	Supplier
	SupplierName
	Material		Material	Vehicle Model
	Plant		Plant	Valuation Area
	FinancialTransactionType		FinancialTransactionType	Transact. Type
	Project			WBS Element
	BillingDocumentType		BillingDocumentType	Billing Type
	SalesOrganization		SalesOrganization	Sales Organization
	DistributionChannel		DistributionChannel	RefDistCh-Cust/Mat.
	OrganizationDivision		OrganizationDivision	Org. Division
	SoldMaterial		SoldMaterial	Product Sold
	MaterialGroup		MaterialGroup	Product Group
	CustomerGroup		CustomerGroup	Customer Group
	CustomerSupplierCountry		CustomerSupplierCountry	Customer or Supplier Country/Region
	CustomerSupplierIndustry		CustomerSupplierIndustry	Industry
	SalesDistrict		SalesDistrict	Sales District
	BillToParty		BillToParty	Inv. Recipient
	ShipToParty		ShipToParty	Ship-To Party (obsolete)
	CustomerSupplierCorporateGroup		CustomerSupplierCorporateGroup	Group
	MatchingReasonCode		MatchingReasonCode
	OriginReference		OriginReference
	OriginType		OriginType
	CnsldtnAdhocItem		CnsldtnAdhocItem
	CnsldtnAdhocSet		CnsldtnAdhocSet
	CnsldtnAdhocSetItem		CnsldtnAdhocSetItem
	CnsldtnGroupJrnlEntryBundle		CnsldtnGroupJrnlEntryBundle	Document Bundle No.
	CnsldtnAdhocItemText
	CnsldtnAdhocSetText
	FinancialServicesProductGroup		FinancialServicesProductGroup	Product Group (FS)
	FinServicesProductGroupName
	FinancialServicesBranch		FinancialServicesBranch	Branch (FS)
	FinancialServicesBranchName
	FinancialDataSource		FinancialDataSource	Data Source
	FinancialDataSourceName
	FinancialManagementArea		FinancialManagementArea	FM Area
	FinancialManagementAreaName
	Fund		Fund	Sender Fund
	FundName
	GrantID		GrantID	Sender Grant
	GrantName
	CnsldtnCashLedgerChartOfAccts		CnsldtnCashLedgerChartOfAccts
	CnsldtnCashLdgrChtOfAcctsText
	CashLedgerAccount		CashLedgerAccount	Cash Origin Account
	CashLedgerAccountName
	PartnerFund		PartnerFund	Receiver Fund
	PartnerFundText
	GHGScope		GHGScope
	GHGScopeName
	GHGCategory		GHGCategory
	GHGCategoryName
	GHGScope2CalculationMethod		GHGScope2CalculationMethod
	GHGScope2CalculationMethodName
	GHGScope2ContractualInstrument		GHGScope2ContractualInstrument
	GHGScp2CntrctlInstrName
	SustainabilityModeOfTransport		SustainabilityModeOfTransport
	SustModeOfTransportName
	GHGDataQualityCharacteristic		GHGDataQualityCharacteristic
	GHGDtaQltyCharacteristicName
	GHGEnergyClassification		GHGEnergyClassification
	GHGEnergyClassificationName
	GHGEnergyMix		GHGEnergyMix
	GHGEnergyMixName
	GHGEnergySourcingType		GHGEnergySourcingType
	GHGEnergySourcingTypeName
	ConsolidationDimension		ConsolidationDimension	Dimension
	_TransactionCurrency		_TransactionCurrency
	_LocalCurrency		_LocalCurrency
	_GroupCurrency		_GroupCurrency
	_BaseUnit		_BaseUnit
	_FinancialTransactionType		_FinancialTransactionType
	_CompanyCode		_CompanyCode
	_SubItemCategory		_SubItemCategory
	_SubItem		_SubItem
	_Company		_Company
	_Apportionment		_Apportionment
	_CrcyCnvrsnDiffType		_CrcyCnvrsnDiffType
	_Version		_Version
	_DocumentType		_DocumentType
	_CnsldtnUnit		_CnsldtnUnit
	_ChartOfAccounts		_ChartOfAccounts
	_FinStmntItm		_FinStmntItm
	_PartnerUnit		_PartnerUnit
	_CnsldtnGroup		_CnsldtnGroup
	_PostingLevel		_PostingLevel
	_InvesteeUnit		_InvesteeUnit
	_InvestorUnit		_InvestorUnit
	_InvestmentActivityTypeText		_InvestmentActivityTypeText
	_GLChartOfAccounts		_GLChartOfAccounts
	_GLAccountInChartOfAccounts		_GLAccountInChartOfAccounts
	_CostCenter		_CostCenter
	_ProfitCenter		_ProfitCenter
	_BusinessArea		_BusinessArea
	_ControllingArea		_ControllingArea
	_Segment		_Segment
	_PartnerCostCenter		_PartnerCostCenter
	_PartnerProfitCenter		_PartnerProfitCenter
	_PartnerBusinessArea		_PartnerBusinessArea
	_PartnerSegment		_PartnerSegment
	_Supplier		_Supplier
	_Customer		_Customer
	_FinancialServicesProductGroup		_FinancialServicesProductGroup
	_FinancialServicesBranch		_FinancialServicesBranch
	_FinancialDataSource		_FinancialDataSource
	_FinancialManagementArea		_FinancialManagementArea
	_Fund		_Fund
	_Grant		_Grant
	_CashLedgerChartOfAccounts		_CashLedgerChartOfAccounts
	_CashLedgerAccount		_CashLedgerAccount
	_PartnerFund		_PartnerFund
	_GHGScope		_GHGScope
	_GHGCategory		_GHGCategory
	_GHGScope2CalculationMethod		_GHGScope2CalculationMethod
	_GHGScp2ContractualInstrument		_GHGScp2ContractualInstrument
	_SustainabilityModeOfTransport		_SustainabilityModeOfTransport
	_GHGDataQualityCharacteristic		_GHGDataQualityCharacteristic
	_GHGEnergyClassification		_GHGEnergyClassification
	_GHGEnergyMix		_GHGEnergyMix
	_GHGEnergySourcingType		_GHGEnergySourcingType
	_AdhocItem		_AdhocItem
	_AdhocSet		_AdhocSet
	_Item		_Item

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_CnsldtnGrpJEItm.
-- 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.

CREATE VIEW C_CnsldtnGrpJEItm AS
SELECT
  FiscalYear,
  CnsldtnGroupJrnlEntry AS ConsolidationDocumentNumber,
  CnsldtnGroupJrnlEntryItem AS ConsolidationPostingItem,
  ConsolidationLedger,
  ConsolidationVersion,
  ReferenceFiscalYear,
  CompanyCode,
  _CompanyCode[1: Language = $session.system_language].CompanyCodeName AS CompanyCodeName,
  _Version._Text[1: Language =$session.system_language].ConsolidationVersionText AS ConsolidationVersionText,
  GLRecordType,
  TransactionCurrency,
  LocalCurrency,
  GroupCurrency,
  BaseUnit,
  FiscalPeriod,
  ConsolidationDocumentType,
  _DocumentType._Text[1: Language = $session.system_language].ConsolidationDocumentTypeText AS ConsolidationDocumentTypeText,
  Company,
  cast ( ConsolidationUnit as fincs_consolidationunit preserving type ) AS ConsolidationUnit,
  _CnsldtnUnit._Text[1: Language = $session.system_language].ConsolidationUnitText AS ConsolidationUnitMdmText,
  ConsolidationChartOfAccounts,
  _ChartOfAccounts._Text[1: Language = $session.system_language].ConsolidationChartOfAcctsText AS ConsolidationChartOfAcctsText,
  FinancialStatementItem,
  _FinStmntItm._Text[1:Language = $session.system_language].FinancialStatementItemMdmText AS FinancialStatementItemMdmText,
  cast ( PartnerConsolidationUnit as fincs_partnerconsolidationunit preserving type ) AS PartnerConsolidationUnit,
  _PartnerUnit._Text[1:Language = $session.system_language].ConsolidationUnitText AS PartnerCnsldtnUnitMediumText,
  ConsolidationGroup,
  _CnsldtnGroup._Text[1:Language = $session.system_language].ConsolidationGroupMediumText AS ConsolidationGroupMediumText,
  SubItemCategory,
  SubItem,
  PostingLevel,
  _PostingLevel._Text[1:Language = $session.system_language].PostingLevelText AS PostingLevelText,
  ConsolidationApportionment,
  CurrencyConversionsDiffType,
  ConsolidationAcquisitionYear,
  ConsolidationAcquisitionPeriod,
  cast ( InvesteeConsolidationUnit as fincs_investeeconsunit preserving type ) AS InvesteeConsolidationUnit,
  _InvesteeUnit._Text[1:Language = $session.system_language].ConsolidationUnitText AS InvesteeConsolidationUnitText,
  InvestorConsolidationUnit,
  _InvestorUnit._Text[1:Language = $session.system_language].ConsolidationUnitText AS InvestorConsolidationUnitText,
  InvestmentActivityType,
  _InvestmentActivityTypeText.InvestmentActivityTypeText AS InvestmentActivityTypeText,
  DocumentItemText,
  ConsolidationPostgItemAutoFlag,
  BusinessTransactionType,
  PostingDate,
  CurrencyTranslationDate,
  CreationDateTime,
  CreationDate,
  CreationTime,
  UserID,
  ReverseDocument,
  ReversedDocument,
  InvestmentActivity,
  ConsolidationDocReversalYear,
  ReferenceDocumentType,
  ReferenceDocumentContext,
  LogicalSystem,
  ChartOfAccounts,
  _GLChartOfAccounts._Text[1:Language = $session.system_language].ChartOfAccountsName AS ChartOfAccountsName,
  GLAccount,
  _GLAccountInChartOfAccounts._Text[1:Language = $session.system_language].GLAccountName AS GLAccountName,
  AssignmentReference,
  CostCenter,
  _CostCenter._Text[1:Language = $session.system_language].CostCenterName AS CostCenterName,
  ProfitCenter,
  _ProfitCenter._Text[1:Language = $session.system_language].ProfitCenterName AS ProfitCenterName,
  FunctionalArea,
  BusinessArea,
  _BusinessArea._Text[1: Language = $session.system_language].BusinessAreaName AS BusinessAreaName,
  ControllingArea,
  _ControllingArea._Text[1: Language = $session.system_language].ControllingAreaName AS ControllingAreaName,
  Segment,
  _Segment._Text[1:Language = $session.system_language].SegmentName AS SegmentName,
  PartnerCostCenter,
  _PartnerCostCenter._Text[1: Language = $session.system_language].AdditionalMasterDataText AS PartnerCostCenterName,
  PartnerProfitCenter,
  _PartnerProfitCenter._Text[1: Language = $session.system_language].AdditionalMasterDataText AS PartnerProfitCenterName,
  PartnerFunctionalArea,
  PartnerBusinessArea,
  _PartnerBusinessArea._Text[1:Language = $session.system_language].AdditionalMasterDataText AS PartnerBusinessAreaName,
  PartnerCompany,
  PartnerSegment,
  _PartnerSegment._Text[1:Language = $session.system_language].AdditionalMasterDataText AS PartnerSegmentName,
  OrderID,
  Customer,
  _Customer._Text[1:Language = $session.system_language].AdditionalMasterDataText AS CustomerName,
  Supplier,
  _Supplier._Text[1:Language = $session.system_language].SupplierName AS SupplierName,
  Material,
  Plant,
  FinancialTransactionType,
  cast( Project as ps_pspid_edit ) AS Project,
  BillingDocumentType,
  SalesOrganization,
  DistributionChannel,
  OrganizationDivision,
  SoldMaterial,
  MaterialGroup,
  CustomerGroup,
  CustomerSupplierCountry,
  CustomerSupplierIndustry,
  SalesDistrict,
  BillToParty,
  ShipToParty,
  CustomerSupplierCorporateGroup,
  MatchingReasonCode,
  OriginReference,
  OriginType,
  CnsldtnAdhocItem,
  CnsldtnAdhocSet,
  CnsldtnAdhocSetItem,
  CnsldtnGroupJrnlEntryBundle,
  _AdhocItem._Text[1:Language = $session.system_language].CnsldtnAdhocItemText AS CnsldtnAdhocItemText,
  _AdhocSet._Text[1:Language = $session.system_language].CnsldtnAdhocSetText AS CnsldtnAdhocSetText,
  FinancialServicesProductGroup,
  _FinancialServicesProductGroup._Text[1:Language = $session.system_language].FinServicesProductGroupName AS FinServicesProductGroupName,
  FinancialServicesBranch,
  _FinancialServicesBranch._Text[1:Language = $session.system_language].FinancialServicesBranchName AS FinancialServicesBranchName,
  FinancialDataSource,
  _FinancialDataSource._Text[1:Language = $session.system_language].FinancialDataSourceName AS FinancialDataSourceName,
  FinancialManagementArea,
  _FinancialManagementArea._Text[1:Language = $session.system_language].FinancialManagementAreaName AS FinancialManagementAreaName,
  Fund,
  _Fund._Text[1:Language = $session.system_language].FundName AS FundName,
  GrantID,
  _Grant._Text[1:Language = $session.system_language].GrantName AS GrantName,
  CnsldtnCashLedgerChartOfAccts,
  _CashLedgerChartOfAccounts._Text[1:Language = $session.system_language].ChartOfAccountsName AS CnsldtnCashLdgrChtOfAcctsText,
  CashLedgerAccount,
  _CashLedgerAccount._Text[1:Language = $session.system_language].GLAccountName AS CashLedgerAccountName,
  PartnerFund,
  _PartnerFund._Text[1:Language = $session.system_language].FundName AS PartnerFundText,
  GHGScope,
  _GHGScope._Text[1:Language = $session.system_language].GHGScopeName AS GHGScopeName,
  GHGCategory,
  _GHGCategory._Text[1:Language = $session.system_language].GHGCategoryName AS GHGCategoryName,
  GHGScope2CalculationMethod,
  _GHGScope2CalculationMethod._Text[1:Language = $session.system_language].GHGScope2CalculationMethodName AS GHGScope2CalculationMethodName,
  GHGScope2ContractualInstrument,
  _GHGScp2ContractualInstrument._Text[1:Language = $session.system_language].GHGScp2CntrctlInstrName AS GHGScp2CntrctlInstrName,
  SustainabilityModeOfTransport,
  _SustainabilityModeOfTransport._Text[1:Language = $session.system_language].SustModeOfTransportName AS SustModeOfTransportName,
  GHGDataQualityCharacteristic,
  _GHGDataQualityCharacteristic._Text[1:Language = $session.system_language].GHGDtaQltyCharacteristicName AS GHGDtaQltyCharacteristicName,
  GHGEnergyClassification,
  _GHGEnergyClassification._Text[1:Language = $session.system_language].GHGEnergyClassificationName AS GHGEnergyClassificationName,
  GHGEnergyMix,
  _GHGEnergyMix._Text[1:Language = $session.system_language].GHGEnergyMixName AS GHGEnergyMixName,
  GHGEnergySourcingType,
  _GHGEnergySourcingType._Text[1:Language = $session.system_language].GHGEnergySourcingTypeName AS GHGEnergySourcingTypeName,
  ConsolidationDimension
FROM I_CnsldtnGroupJrnlEntryItem AS CnsldtnGroupJrnlEntryItem
LEFT OUTER JOIN I_CnsldtnGlobalSetting AS _GlobalSetting ON _GlobalSetting.SequenceNumber = '1'  -- association [1]
LEFT OUTER JOIN E_CnsldtnGroupJrnlEntryItem_3 AS _Extension ON FiscalYear = _Extension.FiscalYear AND ConsolidationDocumentNumber = _Extension.CnsldtnGroupJrnlEntry AND ConsolidationPostingItem = _Extension.CnsldtnGroupJrnlEntryItem  -- association [1..1]
LEFT OUTER JOIN C_CnsldtnGrpJEItmDetail AS _Item ON FiscalYear = _Item.FiscalYear AND ConsolidationDocumentNumber = _Item.ConsolidationDocumentNumber AND ConsolidationVersion = _Item.ConsolidationVersion  -- association [0..*]
LEFT OUTER JOIN C_CnsldtnInvmtEquityActyVH AS _InvestmentActivityTypeText ON InvestmentActivityType = _InvestmentActivityTypeText.InvestmentActivityType  -- association [0..1]
;

Depth:

C_CnsldtnGrpJEItm view_entity

I_CnsldtnGroupJrnlEntryItem view