I_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 I_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: ICADEJOURNLENTRY
-- Parameters: P_CompanyCode : fis_bukrs, P_Ledger : fis_rldnr, P_FiscalYear : fis_gjahr, P_FromFiscalPeriod : fins_fiscalperiod, P_ToFiscalPeriod : fins_fiscalperiod, P_Language : sylangu

CREATE VIEW I_CN_CADEJournalEntry AS
SELECT
  GLAccountLineItem.CompanyCode AS CompanyCode,
  GLAccountLineItem.AccountingDocument AS AccountingDocument,
  GLAccountLineItem.LedgerGLLineItem AS AccountingDocumentItem,
  GLAccountLineItem.FiscalYear AS FiscalYear,
  GLAccountLineItem.Ledger AS Ledger,
  GLAccountLineItem.CN_CADENatlStdRelVersion AS CN_CADENatlStdRelVersion,
  GLAccountLineItem.FiscalPeriod AS FiscalPeriod,
  cast(RIGHT(GLAccountLineItem.LedgerGLLineItem,3) as farp_buzei) AS LedgerGLLineItem,
  GLAccountLineItem.PostingDate AS PostingDate,
  _JournalEntry.AccountingDocumentType AS AccountingDocumentType,
  _JournalEntry.AccountingDocumentHeaderText AS AccountingDocumentHeaderText,
  GLAccountLineItem.GLAccount AS GLAccount,
  _JournalEntry.TransactionCurrency AS Currency,
  _JournalEntry.CompanyCodeCurrency AS CompanyCodeCurrency,
  GLAccountLineItem.BaseUnit AS BaseUnit,
  GLAccountLineItem.DebitCreditCode AS DebitCreditCode,
  Quantity,
  GLAccountLineItem.DebitAmountInTransCrcy AS DebitAmountInTransCrcy,
  GLAccountLineItem.DebitAmountInCoCodeCrcy AS DebitAmountInCoCodeCrcy,
  Quantity AS CN_CADECreditQuantity,
  GLAccountLineItem.CreditAmountInTransCrcy AS CreditAmountInTransCrcy,
  GLAccountLineItem.CreditAmountInCoCodeCrcy AS CreditAmountInCoCodeCrcy,
  GLAccountLineItem.DocumentItemText AS DocumentItemText,
  _JournalEntry.AccountingDocCreatedByUser AS AccountingDocCreatedByUser,
  _JournalEntry.AccountingDocumentCategory AS AccountingDocumentCategory,
  _JournalEntry.IsReversed AS IsReversed,
  cast(_JournalEntry.AlternativeReferenceDocument as fis_xblnr_alt_wo_exit preserving type) AS AlternativeReferenceDocument,
  GLAccountLineItem.FinancialAccountType AS FinancialAccountType,
  GLAccountLineItem.CN_CADEJournalEntryBookKeeper AS CN_CADEJournalEntryBookKeeper,
  GLAccountLineItem.CN_CADEJournalEntryReviewer AS CN_CADEJournalEntryReviewer,
  AlternativeGLAccount,
  AlternativeGLAccountExternal,
  _JournalEntry.NmbrOfPages AS NmbrOfPages,
  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,
  _checkDomain.Language AS Language,
  AmountInTransactionCurrency,
  FreightSupplier,
  SiteCustomer
FROM I_CN_CADEJrnlEntryWthAddlInfo AS GLAccountLineItem
LEFT OUTER JOIN P_CN_CADEBillofExchangeInfo AS BillofExchange ON GLAccountLineItem.FiscalYear = BillofExchange.gjahr AND GLAccountLineItem.AccountingDocument = BillofExchange.belnr AND GLAccountLineItem.CompanyCode = BillofExchange.bukrs AND GLAccountLineItem.LedgerGLLineItem = BillofExchange.buzei  -- association [0..1]
LEFT OUTER JOIN I_CN_CADEStatutoryReportTypeT AS _checkDomain ON _checkDomain.SAPDataDictionaryDomain = 'IDPOS' AND _checkDomain.Language = :P_Language AND _checkDomain.DomainValue = '2'  -- association [0..1]
LEFT OUTER JOIN I_CN_CADEStatutoryReportTypeT AS _BOEDomain ON _BOEDomain.SAPDataDictionaryDomain = 'IDPOS' AND _BOEDomain.Language = :P_Language AND _BOEDomain.DomainValue = '1'  -- association [0..1]
LEFT OUTER JOIN I_OperationalAcctgDocItem AS _OperationalAcctgDocItem ON CompanyCode = _OperationalAcctgDocItem.CompanyCode AND FiscalYear = _OperationalAcctgDocItem.FiscalYear AND AccountingDocument = _OperationalAcctgDocItem.AccountingDocument AND LedgerGLLineItem = _OperationalAcctgDocItem.AccountingDocumentItem  -- association [0..1]
LEFT OUTER JOIN P_CN_CADEINCOMINGCHECK AS _IncgChk ON AccountingDocument = _IncgChk.BankLedgerDocument AND FiscalYear = _IncgChk.FiscalYear AND CompanyCode = _IncgChk.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_OutgoingCheck AS _OutgoingCheck ON CompanyCode = _OutgoingCheck.PaymentCompanyCode AND FiscalYear = _OutgoingCheck.FiscalYear AND AccountingDocument = _OutgoingCheck.PaymentDocument AND _OutgoingCheck.ChequeIsCashed = 'X'  -- association [0..1]
;