I_CN_CADEJournalEntryWithBal

DDL: I_CN_CADEJOURNALENTRYWITHBAL SQL: ICNJRNLENTRWBAL Type: view COMPOSITE
42 Fields 2 Data Sources

CADE - Journal Entry Item with Balance

I_CN_CADEJournalEntryWithBal is a Composite CDS View that provides data about "CADE - Journal Entry Item with Balance" in SAP S/4HANA. It reads from 2 data sources (I_CN_CADEJrnlEntryWthAddlInfo, P_FsclYearPerdWithSpclPerd) and exposes 42 fields with key fields CompanyCode, Ledger, FiscalYear, CN_CADENatlStdRelVersion, AccountingDocument.

Data Sources (2)

SourceAliasJoin Type
I_CN_CADEJrnlEntryWthAddlInfo JournalEntryItem left_outer
P_FsclYearPerdWithSpclPerd P_FsclYearPerdWithSpclPerd from

Parameters (4)

NameTypeDefault
P_FiscalYear fis_gjahr
P_FromFiscalPeriod fins_fiscalperiod
P_ToFiscalPeriod fins_fiscalperiod
P_IsSpecialPeriod xfeld

Annotations (13)

NameValueLevelField
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
AbapCatalog.preserveKey true view
AbapCatalog.sqlViewName ICNJRNLENTRWBAL view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.personalData.blocking #BLOCKED_DATA_INCLUDED view
EndUserText.label CADE - Journal Entry Item with Balance view

Fields (42)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode FiscalYearPeriod CompanyCode Receiver Company Code
KEY Ledger FiscalYearPeriod Ledger Ledger
KEY FiscalYear FiscalYearPeriod FiscalYear G/L Fiscal Year
KEY CN_CADENatlStdRelVersion I_CN_CADEJrnlEntryWthAddlInfo CN_CADENatlStdRelVersion
KEY AccountingDocument I_CN_CADEJrnlEntryWthAddlInfo AccountingDocument Journal Entry
KEY PostingDate I_CN_CADEJrnlEntryWthAddlInfo PostingDate Posting Date for GR
KEY LedgerGLLineItem I_CN_CADEJrnlEntryWthAddlInfo LedgerGLLineItem Journal Entry Item
KEY FiscalPeriod FiscalYearPeriod FiscalPeriod Tax period
KEY FiscalYearPostingPeriod I_CN_CADEJrnlEntryWthAddlInfo FiscalPeriod Tax period
GLAccount I_CN_CADEJrnlEntryWthAddlInfo GLAccount General Ledger
FunctionalAreaIsUsed I_CN_CADEJrnlEntryWthAddlInfo FunctionalArea Sendr Fctl Area
ChartOfAccounts I_CN_CADEJrnlEntryWthAddlInfo ChartOfAccounts Node Class
FiscalYearPeriod FiscalYearPeriod FiscalYearPeriod Period/Year
Supplier I_CN_CADEJrnlEntryWthAddlInfo Supplier Supplier
Customer I_CN_CADEJrnlEntryWthAddlInfo Customer Sold-to Party
CostCenter I_CN_CADEJrnlEntryWthAddlInfo CostCenter Cost Center
InternalOrder I_CN_CADEJrnlEntryWthAddlInfo InternalOrder Order
BillToParty I_CN_CADEJrnlEntryWthAddlInfo BillToParty Inv. Recipient
BusinessArea I_CN_CADEJrnlEntryWthAddlInfo BusinessArea Business Area
BusinessProcess I_CN_CADEJrnlEntryWthAddlInfo BusinessProcess Business Process
ControllingArea I_CN_CADEJrnlEntryWthAddlInfo ControllingArea Controlling Area
CustomerGroup I_CN_CADEJrnlEntryWthAddlInfo CustomerGroup Customer Group
DistributionChannel I_CN_CADEJrnlEntryWthAddlInfo DistributionChannel RefDistCh-Cust/Mat.
FunctionalArea I_CN_CADEJrnlEntryWthAddlInfo FunctionalArea Sendr Fctl Area
Fund I_CN_CADEJrnlEntryWthAddlInfo Fund Sender Fund
FundsCenter I_CN_CADEJrnlEntryWthAddlInfo FundsCenter Funds Center
HouseBank I_CN_CADEJrnlEntryWthAddlInfo HouseBank House Bank
HouseBankAccount I_CN_CADEJrnlEntryWthAddlInfo HouseBankAccount House Bank Account
Material I_CN_CADEJrnlEntryWthAddlInfo Material Vehicle Model
MaterialGroup I_CN_CADEJrnlEntryWthAddlInfo MaterialGroup Product Group
Plant I_CN_CADEJrnlEntryWthAddlInfo Plant Valuation Area
ProfitCenter I_CN_CADEJrnlEntryWthAddlInfo ProfitCenter Profit Center
Project I_CN_CADEJrnlEntryWthAddlInfo Project WBS Element
ProjectNetwork I_CN_CADEJrnlEntryWthAddlInfo ProjectNetwork Order
SalesDistrict I_CN_CADEJrnlEntryWthAddlInfo SalesDistrict Sales District
SalesOrganization I_CN_CADEJrnlEntryWthAddlInfo SalesOrganization Sales Organization
Segment I_CN_CADEJrnlEntryWthAddlInfo Segment Segment number
ShipToParty I_CN_CADEJrnlEntryWthAddlInfo ShipToParty Ship-To Party (obsolete)
SoldMaterial I_CN_CADEJrnlEntryWthAddlInfo SoldMaterial Product Sold
WBSElement I_CN_CADEJrnlEntryWthAddlInfo WBSElement WBS Internal ID
CompanyCodeCurrency I_CN_CADEJrnlEntryWthAddlInfo CompanyCodeCurrency Local Currency
TransactionCurrency I_CN_CADEJrnlEntryWthAddlInfo TransactionCurrency Transaction Currency

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_CADEJournalEntryWithBal.
-- 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: ICNJRNLENTRWBAL
-- Parameters: P_FiscalYear : fis_gjahr, P_FromFiscalPeriod : fins_fiscalperiod, P_ToFiscalPeriod : fins_fiscalperiod, P_IsSpecialPeriod : xfeld

CREATE VIEW I_CN_CADEJournalEntryWithBal AS
SELECT
  FiscalYearPeriod.CompanyCode AS CompanyCode,
  FiscalYearPeriod.Ledger AS Ledger,
  FiscalYearPeriod.FiscalYear AS FiscalYear,
  JournalEntryItem.CN_CADENatlStdRelVersion AS CN_CADENatlStdRelVersion,
  JournalEntryItem.AccountingDocument AS AccountingDocument,
  JournalEntryItem.PostingDate AS PostingDate,
  JournalEntryItem.LedgerGLLineItem AS LedgerGLLineItem,
  FiscalYearPeriod.FiscalPeriod AS FiscalPeriod,
  JournalEntryItem.FiscalPeriod AS FiscalYearPostingPeriod,
  JournalEntryItem.GLAccount AS GLAccount,
  JournalEntryItem.FunctionalArea AS FunctionalAreaIsUsed,
  JournalEntryItem.ChartOfAccounts AS ChartOfAccounts,
  FiscalYearPeriod.FiscalYearPeriod AS FiscalYearPeriod,
  JournalEntryItem.Supplier AS Supplier,
  JournalEntryItem.Customer AS Customer,
  JournalEntryItem.CostCenter AS CostCenter,
  JournalEntryItem.InternalOrder AS InternalOrder,
  JournalEntryItem.BillToParty AS BillToParty,
  JournalEntryItem.BusinessArea AS BusinessArea,
  JournalEntryItem.BusinessProcess AS BusinessProcess,
  JournalEntryItem.ControllingArea AS ControllingArea,
  JournalEntryItem.CustomerGroup AS CustomerGroup,
  JournalEntryItem.DistributionChannel AS DistributionChannel,
  JournalEntryItem.FunctionalArea AS FunctionalArea,
  JournalEntryItem.Fund AS Fund,
  JournalEntryItem.FundsCenter AS FundsCenter,
  JournalEntryItem.HouseBank AS HouseBank,
  JournalEntryItem.HouseBankAccount AS HouseBankAccount,
  JournalEntryItem.Material AS Material,
  JournalEntryItem.MaterialGroup AS MaterialGroup,
  JournalEntryItem.Plant AS Plant,
  JournalEntryItem.ProfitCenter AS ProfitCenter,
  JournalEntryItem.Project AS Project,
  JournalEntryItem.ProjectNetwork AS ProjectNetwork,
  JournalEntryItem.SalesDistrict AS SalesDistrict,
  JournalEntryItem.SalesOrganization AS SalesOrganization,
  JournalEntryItem.Segment AS Segment,
  JournalEntryItem.ShipToParty AS ShipToParty,
  JournalEntryItem.SoldMaterial AS SoldMaterial,
  JournalEntryItem.WBSElement AS WBSElement,
  JournalEntryItem.CompanyCodeCurrency AS CompanyCodeCurrency,
  JournalEntryItem.TransactionCurrency AS TransactionCurrency
FROM P_FsclYearPerdWithSpclPerd
LEFT OUTER JOIN I_CN_CADEJrnlEntryWthAddlInfo AS JournalEntryItem ON /* join condition not captured in parsed metadata */
;

Learn More