What is I_CN_CADEJrnlEntryWthAddlInfo in SAP S/4HANA?

I_CN_CADEJrnlEntryWthAddlInfo is a composite CDS view in SAP S/4HANA. CADE journal entry with subsidiary item It contains 62 fields.

Which tables does I_CN_CADEJrnlEntryWthAddlInfo read from?

I_CN_CADEJrnlEntryWthAddlInfo reads data from: I_GLAccountLineItem.

What VDM layer is I_CN_CADEJrnlEntryWthAddlInfo?

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

I_CN_CADEJrnlEntryWthAddlInfo

DDL: I_CN_CADEJRNLENTRYWTHADDLINFO SQL: ICADESUBACCTGJE Type: view COMPOSITE

62 Fields 1 Data Sources

CADE journal entry with subsidiary item

I_CN_CADEJrnlEntryWthAddlInfo is a Composite CDS View that provides data about "CADE journal entry with subsidiary item" in SAP S/4HANA. It reads from 1 data source (I_GLAccountLineItem) and exposes 62 fields with key fields SourceLedger, CompanyCode, Ledger, CN_CADENatlStdRelVersion, FiscalYear.

Data Sources (1)

Source	Alias	Join Type
I_GLAccountLineItem	I_GLAccountLineItem	from

Annotations (12)

Name	Value	Level
VDM.lifecycle.contract.type	#PUBLIC_LOCAL_API	view
AbapCatalog.preserveKey	true	view
AbapCatalog.sqlViewName	ICADESUBACCTGJE	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
ObjectModel.usageType.sizeCategory	#XXL	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
ObjectModel.usageType.serviceQuality	#D	view
VDM.viewType	#COMPOSITE	view
AbapCatalog.compiler.compareFilter	true	view
AccessControl.authorizationCheck	#CHECK	view
AccessControl.personalData.blocking	#BLOCKED_DATA_INCLUDED	view
EndUserText.label	CADE journal entry with subsidiary item	view

Fields (62)

Key	Field	Source Table	Source Field	Description
KEY	SourceLedger		SourceLedger	Source Ledger
KEY	CompanyCode	I_GLAccountLineItem	CompanyCode	Receiver Company Code
KEY	Ledger	I_GLAccountLineItem	Ledger	Ledger
KEY	CN_CADENatlStdRelVersion	GeneralInfo	CN_CADENatlStdRelVersion
KEY	FiscalYear	I_GLAccountLineItem	FiscalYear	G/L Fiscal Year
KEY	AccountingDocument		AccountingDocument	Journal Entry
KEY	LedgerGLLineItem		LedgerGLLineItem	Journal Entry Item
	FiscalYearPeriod	I_GLAccountLineItem	FiscalYearPeriod	Period/Year
	PostingDate		PostingDate	Posting Date for GR
	GLAccount	I_GLAccountLineItem	GLAccount	General Ledger
	FunctionalAreaIsUsed	I_GLAccountLineItem	FunctionalArea	Sendr Fctl Area
	ChartOfAccounts		ChartOfAccounts	Node Class
	FiscalPeriod	I_GLAccountLineItem	FiscalPeriod	Tax period
	AccountingDocumentCategory		AccountingDocumentCategory	Journal Entry Category
	BaseUnit		BaseUnit	Unit of Measure
	DebitCreditCode		DebitCreditCode	Single-Character Flag
	Quantity		Quantity	Value
	DocumentItemText		DocumentItemText	Text
	FinancialAccountType		FinancialAccountType	Fin. Account Type
	AlternativeGLAccount		AlternativeGLAccount	Group Account
	AlternativeGLAccountExternal	_GLAccountInCompanyCode	AlternativeGLAccount	Group Account
	CN_CADEJournalEntryBookKeeper	GeneralInfo	CN_CADEJournalEntryBookKeeper
	CN_CADEJournalEntryReviewer	GeneralInfo	CN_CADEJournalEntryReviewer
	IsSpecialPeriod	FiscalYearPeriod	IsSpecialPeriod
	SupplierendasSupplier
	CustomerendasCustomer
	CostCenterendasCostCenter
	BillToPartyendasBillToParty
	BusinessAreaendasBusinessArea
	BusinessProcessendasBusinessProcess
	ControllingAreaendasControllingArea
	CustomerGroupendasCustomerGroup
	FunctionalAreaendasFunctionalArea
	FundendasFund
	FundsCenterendasFundsCenter
	HouseBankendasHouseBank
	HouseBankAccountendasHouseBankAccount
	MaterialendasMaterial
	MaterialGroupendasMaterialGroup
	PlantendasPlant
	ProfitCenterendasProfitCenter
	ProjectendasProject
	ProjectNetworkendasProjectNetwork
	SalesDistrictendasSalesDistrict
	SalesOrganizationendasSalesOrganization
	SegmentendasSegment
	ShipToPartyendasShipToParty
	SoldMaterialendasSoldMaterial
	WBSElementendasWBSElement
	CompanyCodeCurrency		CompanyCodeCurrency	Local Currency
	DebitAmountInCoCodeCrcy		DebitAmountInCoCodeCrcy	Debit Amount in Company Code Currency
	CreditAmountInCoCodeCrcy		CreditAmountInCoCodeCrcy	Credit Amount in Company Code Currency
	AmountInCompanyCodeCurrency		AmountInCompanyCodeCurrency	Local Crcy Amt
	TransactionCurrency		TransactionCurrency	Transaction Currency
	DebitAmountInTransCrcy		DebitAmountInTransCrcy	Debit Amt in DC
	CreditAmountInTransCrcy		CreditAmountInTransCrcy	Credit Amt in DC
	AmountInTransactionCurrency		AmountInTransactionCurrency	Pt Crcy Amt
	FreightSupplier	I_GLAccountLineItem	Supplier	Supplier
	SiteCustomer	I_GLAccountLineItem	Customer	Sold-to Party
	_Supplier	I_GLAccountLineItem	_Supplier
	_Customer	I_GLAccountLineItem	_Customer
	_JournalEntry		_JournalEntry

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_CN_CADEJrnlEntryWthAddlInfo.
-- 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: ICADESUBACCTGJE

CREATE VIEW I_CN_CADEJrnlEntryWthAddlInfo AS
SELECT
  SourceLedger,
  I_GLAccountLineItem.CompanyCode AS CompanyCode,
  I_GLAccountLineItem.Ledger AS Ledger,
  GeneralInfo.CN_CADENatlStdRelVersion AS CN_CADENatlStdRelVersion,
  I_GLAccountLineItem.FiscalYear AS FiscalYear,
  AccountingDocument,
  LedgerGLLineItem,
  I_GLAccountLineItem.FiscalYearPeriod AS FiscalYearPeriod,
  PostingDate,
  I_GLAccountLineItem.GLAccount AS GLAccount,
  I_GLAccountLineItem.FunctionalArea AS FunctionalAreaIsUsed,
  ChartOfAccounts,
  I_GLAccountLineItem.FiscalPeriod AS FiscalPeriod,
  AccountingDocumentCategory,
  BaseUnit,
  DebitCreditCode,
  Quantity,
  DocumentItemText,
  FinancialAccountType,
  AlternativeGLAccount,
  _GLAccountInCompanyCode.AlternativeGLAccount AS AlternativeGLAccountExternal,
  GeneralInfo.CN_CADEJournalEntryBookKeeper AS CN_CADEJournalEntryBookKeeper,
  GeneralInfo.CN_CADEJournalEntryReviewer AS CN_CADEJournalEntryReviewer,
  FiscalYearPeriod.IsSpecialPeriod AS IsSpecialPeriod,
  case when Subledger.Supplier = 'X' then I_GLAccountLineItem.Supplier end as Supplier AS SupplierendasSupplier,
  case when Subledger.Customer = 'X' then I_GLAccountLineItem.Customer end as Customer AS CustomerendasCustomer,
  case when Subledger.CostCenter = 'X' then I_GLAccountLineItem.CostCenter end as CostCenter AS CostCenterendasCostCenter,
  case when Subledger.BillToParty = 'X' then I_GLAccountLineItem.BillToParty end as BillToParty AS BillToPartyendasBillToParty,
  case when Subledger.BusinessArea = 'X' then I_GLAccountLineItem.BusinessArea end as BusinessArea AS BusinessAreaendasBusinessArea,
  case when Subledger.BusinessProcess = 'X' then I_GLAccountLineItem.BusinessProcess end as BusinessProcess AS BusinessProcessendasBusinessProcess,
  case when Subledger.ControllingArea = 'X' then I_GLAccountLineItem.ControllingArea end as ControllingArea AS ControllingAreaendasControllingArea,
  case when Subledger.CustomerGroup = 'X' then I_GLAccountLineItem.CustomerGroup end as CustomerGroup AS CustomerGroupendasCustomerGroup,
  case when Subledger.FunctionalArea = 'X' then I_GLAccountLineItem.FunctionalArea end as FunctionalArea AS FunctionalAreaendasFunctionalArea,
  case when Subledger.Fund = 'X' then I_GLAccountLineItem.Fund end as Fund AS FundendasFund,
  case when Subledger.FundsCenter = 'X' then I_GLAccountLineItem.FundsCenter end as FundsCenter AS FundsCenterendasFundsCenter,
  case when Subledger.HouseBank = 'X' then I_GLAccountLineItem.HouseBank end as HouseBank AS HouseBankendasHouseBank,
  case when Subledger.HouseBankAccount = 'X' then I_GLAccountLineItem.HouseBankAccount end as HouseBankAccount AS HouseBankAccountendasHouseBankAccount,
  case when Subledger.Material = 'X' then I_GLAccountLineItem.Material end as Material AS MaterialendasMaterial,
  case when Subledger.MaterialGroup = 'X' then I_GLAccountLineItem.MaterialGroup end as MaterialGroup AS MaterialGroupendasMaterialGroup,
  case when Subledger.Plant = 'X' then I_GLAccountLineItem.Plant end as Plant AS PlantendasPlant,
  case when Subledger.ProfitCenter = 'X' then I_GLAccountLineItem.ProfitCenter end as ProfitCenter AS ProfitCenterendasProfitCenter,
  case when Subledger.Project = 'X' then I_GLAccountLineItem.Project end as Project AS ProjectendasProject,
  case when Subledger.ProjectNetwork = 'X' then I_GLAccountLineItem.ProjectNetwork end as ProjectNetwork AS ProjectNetworkendasProjectNetwork,
  case when Subledger.SalesDistrict = 'X' then I_GLAccountLineItem.SalesDistrict end as SalesDistrict AS SalesDistrictendasSalesDistrict,
  case when Subledger.SalesOrganization = 'X' then I_GLAccountLineItem.SalesOrganization end as SalesOrganization AS SalesOrganizationendasSalesOrganization,
  case when Subledger.Segment = 'X' then I_GLAccountLineItem.Segment end as Segment AS SegmentendasSegment,
  case when Subledger.ShipToParty = 'X' then I_GLAccountLineItem.ShipToParty end as ShipToParty AS ShipToPartyendasShipToParty,
  case when Subledger.SoldMaterial = 'X' then I_GLAccountLineItem.SoldMaterial end as SoldMaterial AS SoldMaterialendasSoldMaterial,
  case when Subledger.WBSElement = 'X' then I_GLAccountLineItem.WBSElement end as WBSElement AS WBSElementendasWBSElement,
  CompanyCodeCurrency,
  DebitAmountInCoCodeCrcy,
  CreditAmountInCoCodeCrcy,
  AmountInCompanyCodeCurrency,
  TransactionCurrency,
  DebitAmountInTransCrcy,
  CreditAmountInTransCrcy,
  AmountInTransactionCurrency,
  I_GLAccountLineItem.Supplier AS FreightSupplier,
  I_GLAccountLineItem.Customer AS SiteCustomer,
  I_GLAccountLineItem._Supplier AS _Supplier,
  I_GLAccountLineItem._Customer AS _Customer
FROM I_GLAccountLineItem
;

Depth:

I_CN_CADEJrnlEntryWthAddlInfo view

I_GLAccountLineItem view_entity

I_CN_CADEJournalEntry view
I_CN_CADEJournalEntryWithBal view