I_CN_RecnclnJournalEntryItem

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_RecnclnJournalEntryItem.
-- 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: ICNREJRNLENTRITM

CREATE VIEW I_CN_RecnclnJournalEntryItem AS
SELECT
  ujei.bukrs AS CompanyCode,
  ujei.hbkid AS HouseBank,
  ujei.hktid AS HouseBankAccount,
  ujei.reconciliation_date AS BankReconciliationDate,
  ujei.gjahr AS FiscalYear,
  ujei.belnr AS AccountingDocument,
  ujei.buzei AS AccountingDocumentItem,
  ujei.remark AS Note,
  ujei.matched_indicator AS BankReconciliationMatchType,
  ujei.matched_id AS BankRecnclnMchnLrngMatchedItem
FROM epict_brs_ujei AS ujei
LEFT OUTER JOIN I_CN_BankRecnclnStatement AS _BankReconciliationStatement ON CompanyCode = _BankReconciliationStatement.CompanyCode AND HouseBank = _BankReconciliationStatement.HouseBank AND HouseBankAccount = _BankReconciliationStatement.HouseBankAccount AND BankReconciliationDate = _BankReconciliationStatement.BankReconciliationDate  -- association [1]
LEFT OUTER JOIN I_CN_BankRecnclnMatchType AS _BankRecnclnMatchType ON BankReconciliationMatchType = _BankRecnclnMatchType.BankReconciliationMatchType  -- association [0..1]
;