I_CN_RecnclnBankStatementItem

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_RecnclnBankStatementItem.
-- 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: ICNRECBKSTMNTITM

CREATE VIEW I_CN_RecnclnBankStatementItem AS
SELECT
  bsi.bukrs AS CompanyCode,
  bsi.hbkid AS HouseBank,
  bsi.hktid AS HouseBankAccount,
  bsi.reconciliation_date AS BankReconciliationDate,
  bsi.kukey AS BankStatement,
  bsi.esnum AS BankStatementItem,
  bsi.remark AS Note,
  bsi.matched_indicator AS BankReconciliationMatchType,
  bsi.matched_id AS BankRecnclnMchnLrngMatchedItem
FROM epict_brs_bsi AS bsi
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]
;