C_CN_CADEJournalEntry

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_CN_CADEJournalEntry.
-- 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: CCADEJOURNLENT
-- Parameters: P_CompanyCode : fis_bukrs, P_Ledger : fis_rldnr, P_FiscalYear : fis_gjahr, P_FromFiscalPeriod : fins_fiscalperiod, P_ToFiscalPeriod : fins_fiscalperiod, P_Language : sylangu, P_AlternativeGLAccount : cade_xfeld

CREATE VIEW C_CN_CADEJournalEntry AS
SELECT
  JournalEntryItem.CompanyCode AS CompanyCode,
  JournalEntryItem.AccountingDocument AS OriginAccountingDocument,
  JournalEntryItem.LedgerGLLineItem AS AccountingDocumentItem,
  JournalEntryItem.FiscalYear AS FiscalYear,
  JournalEntryItem.Ledger AS Ledger,
  CN_CADENatlStdRelVersion,
  ltrim(JournalEntryItem.FiscalPeriod,'0') AS FiscalPeriod,
  JournalEntryItem.PostingDate AS PostingDate,
  AccountingDocumentType,
  AccountingDocumentHeaderText,
  Currency,
  _Currency.CurrencyISOCode AS CurrencyISOCode,
  CompanyCodeCurrency,
  BaseUnit,
  DebitCreditCode,
  cast(Quantity as abap.quan( 20, 6 )) AS Quantity,
  cast(JournalEntryItem.DebitAmountInTransCrcy as abap.char( 30 )) AS DebitAmountInTransCrcy,
  cast(JournalEntryItem.DebitAmountInCoCodeCrcy as abap.char( 30 )) AS DebitAmountInCoCodeCrcy,
  _OperationalAcctgDocItem._JournalEntry.ExchangeRateType AS ExchangeRateType,
  _OperationalAcctgDocItem.PaymentMethod AS PaymentMethod,
  ExchangeRate,
  cast(((-1)*JournalEntryItem.CreditAmountInTransCrcy) as abap.char( 30 )) AS CreditAmountInTransCrcy,
  cast(((-1)*JournalEntryItem.CreditAmountInCoCodeCrcy) as abap.char( 30 )) AS CreditAmountInCoCodeCrcy,
  case when AccountingDocumentCategory = '' then cast ('1' as abap.char( 1 )) when AccountingDocumentCategory != '' then cast ('0' as abap.char( 1 )) end as CN_JournalEntryIsCADEPosted AS char1endasCN_JournalEntryIsCADEPosted,
  case when IsReversed = '' then cast ('0' as abap.char( 1 )) when IsReversed != '' then cast ('1' as abap.char( 1 )) end as IsCancelled AS char1endasIsCancelled,
  AlternativeReferenceDocument,
  case :P_AlternativeGLAccount when 'X' then case when AlternativeGLAccount != '' then ltrim(AlternativeGLAccount,'0') when AlternativeGLAccount = '' and AlternativeGLAccountExternal !='' then LTRIM( AlternativeGLAccountExternal,'0') when AlternativeGLAccount = '' and AlternativeGLAccountExternal ='' then ltrim(JournalEntryItem.GLAccount,'0') end when ' ' then ltrim(JournalEntryItem.GLAccount,'0') end as GLAccount AS GLAccount0endasGLAccount,
  CN_CADEOriginalPaymentDocType,
  CN_CADEOriginalPaymentDocument,
  PaymentDocumentPostingDate,
  substring(CN_CADEJournalEntryBookKeeper ,1,30) AS CN_CADEJournalEntryBookKeeper,
  substring(CN_CADEJournalEntryReviewer, 1,30) AS CN_CADEJournalEntryReviewer,
  LTRIM(NmbrOfPages,'0') AS CN_NmbrOfCADEJournalEntrAttchs,
  Supplier,
  Customer,
  CostCenter,
  InternalOrder,
  BillToParty,
  BusinessArea,
  BusinessProcess,
  ControllingArea,
  CustomerGroup,
  DistributionChannel,
  FunctionalArea,
  Fund,
  FundsCenter,
  HouseBank,
  HouseBankAccount,
  Material,
  MaterialGroup,
  Plant,
  ProfitCenter,
  Project,
  ProjectNetwork,
  SalesDistrict,
  SalesOrganization,
  Segment,
  ShipToParty,
  SoldMaterial,
  WBSElement,
  FreightSupplier,
  SiteCustomer
FROM I_CN_CADEJournalEntry
LEFT OUTER JOIN I_CN_CADEJournalEntryMapping AS _DocumentType ON AccountingDocumentType = _DocumentType.AccountingDocumentType AND CompanyCode = _DocumentType.CompanyCode AND CN_CADENatlStdRelVersion = _DocumentType.CN_CADENatlStdRelVersion  -- association [0..1]
LEFT OUTER JOIN I_CN_CADEJournalEntryDocType AS CADEJournalEntryDocType ON CompanyCode = CADEJournalEntryDocType.CompanyCode AND CADEJournalEntryDocType.CN_CADEDocumentTypeUsage = '1' AND CADEJournalEntryDocType.IsDefaultValue = 'X' AND CADEJournalEntryDocType.CN_CADENatlStdRelVersion = CN_CADENatlStdRelVersion  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _Currency ON Currency = _Currency.Currency  -- association [0..1]
;