I_CN_BankRecnclnStatement

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_BankRecnclnStatement.
-- 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: ICNBKRECNCLNSTMN

CREATE VIEW I_CN_BankRecnclnStatement AS
SELECT
  BankReconciliationStatement.bukrs AS CompanyCode,
  BankReconciliationStatement.hbkid AS HouseBank,
  BankReconciliationStatement.hktid AS HouseBankAccount,
  BankReconciliationStatement.reconciliation_date AS BankReconciliationDate,
  BankReconciliationStatement.rldnr AS Ledger,
  BankReconciliationStatement.waers AS HouseBankCurrency,
  BankReconciliationStatement.entrps_adjusted_end_balance AS AdjustedGLAcctBalanceAmt,
  BankReconciliationStatement.bank_adjusted_end_balance AS AdjustedBkAcctBalanceAmt,
  BankReconciliationStatement.bank_end_balance AS BankAcctBalanceAmt,
  BankReconciliationStatement.entrps_end_balance AS GLAcctBalanceAmt,
  BankReconciliationStatement.recptinbankwoje AS UnmatchedIncgBkStmntPayt,
  BankReconciliationStatement.paymntinbankwoje AS UnmatchedOutgBkStmntPayt,
  BankReconciliationStatement.recptinjewobank AS UnmatchedIncgJrnlEntrPayt,
  BankReconciliationStatement.paymntinjewobank AS UnmatchedOutgJrnlEntrPayt,
  BankReconciliationStatement.changed_user AS CreationUserName,
  BankReconciliationStatement.changed_timestamp AS LastChangeDateTime,
  BankReconciliationStatement.reconciliation_date_last AS LastBankReconciliationDate,
  BankReconciliationStatement.epic_br_rcon_status AS BankReconciliationStatus,
  HouseBankAccount.bankn AS BankAccount,
  HouseBankAccount.refzl AS BankAccountReferenceText,
  HouseBankAccount.hkont AS GLAccount
FROM epict_brs AS BankReconciliationStatement
LEFT OUTER JOIN P_HouseBankAccount AS HouseBankAccount ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CN_RecnclnBankStatementItem AS _BankStatementItem ON CompanyCode = _BankStatementItem.CompanyCode AND HouseBank = _BankStatementItem.HouseBank AND HouseBankAccount = _BankStatementItem.HouseBankAccount AND BankReconciliationDate = _BankStatementItem.BankReconciliationDate  -- association [0..*]
LEFT OUTER JOIN I_CN_RecnclnJournalEntryItem AS _JournalEntryItem ON CompanyCode = _JournalEntryItem.CompanyCode AND HouseBank = _JournalEntryItem.HouseBank AND HouseBankAccount = _JournalEntryItem.HouseBankAccount AND BankReconciliationDate = _JournalEntryItem.BankReconciliationDate  -- association [0..*]
LEFT OUTER JOIN I_Housebank AS _HouseBank ON HouseBank = _HouseBank.HouseBank AND CompanyCode = _HouseBank.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _Currency ON HouseBankCurrency = _Currency.Currency  -- association [0..1]
LEFT OUTER JOIN I_CN_BankReconciliationSts AS _ReconciliationSts ON BankReconciliationStatus = _ReconciliationSts.BankReconciliationStatus  -- association [0..1]
;