C_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 C_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: CCNBKRECNCLSTMNT

CREATE VIEW C_CN_BankRecnclnStatement AS
SELECT
  BRS.CompanyCode AS CompanyCode,
  BRS.HouseBank AS HouseBank,
  BRS.HouseBankAccount AS HouseBankAccount,
  BRS.BankReconciliationDate AS BankReconciliationDate,
  BRS.Ledger AS Ledger,
  BRS.HouseBankCurrency AS HouseBankCurrency,
  BRS.BankAccount AS BankAccount,
  BRS.BankAccountReferenceText AS BankAccountReferenceText,
  BRS._HouseBank._Bank.BankName AS BankName,
  BRS.GLAccount AS GLAccount,
  BRS.AdjustedGLAcctBalanceAmt AS AdjustedGLAcctBalanceAmt,
  BRS.AdjustedBkAcctBalanceAmt AS AdjustedBkAcctBalanceAmt,
  BRS.BankAcctBalanceAmt AS BankAcctBalanceAmt,
  BRS.GLAcctBalanceAmt AS GLAcctBalanceAmt,
  BRS.UnmatchedIncgBkStmntPayt AS UnmatchedIncgBkStmntPayt,
  BRS.UnmatchedOutgBkStmntPayt AS UnmatchedOutgBkStmntPayt,
  BRS.UnmatchedIncgJrnlEntrPayt AS UnmatchedIncgJrnlEntrPayt,
  BRS.UnmatchedOutgJrnlEntrPayt AS UnmatchedOutgJrnlEntrPayt,
  BRS.CreationUserName AS CreationUserName,
  _User.UserDescription AS UserDescription,
  concat( BRS.BankAccount, BRS.BankAccountReferenceText) AS LongTextTemplate,
  BRS.LastChangeDateTime AS LastChangeDateTime,
  _CompanyCodeVH.CompanyCodeName AS CompanyCodeName,
  _HouseBankAccount.HouseBankAccountDescription AS HouseBankAccountDescription
FROM I_CN_BankRecnclnStatement AS BRS
LEFT OUTER JOIN C_Cn_RecnclnBankStatementItem AS _BankStatementItem ON BRS.CompanyCode = _BankStatementItem.CompanyCode AND BRS.HouseBank = _BankStatementItem.HouseBank AND BRS.HouseBankAccount = _BankStatementItem.HouseBankAccount AND BRS.BankReconciliationDate = _BankStatementItem.BankReconciliationDate AND _BankStatementItem.BankReconciliationMatchType = ''  -- association [0..*]
LEFT OUTER JOIN C_CN_RecnclnJournalEntryItem AS _JournalEntryItem ON BRS.CompanyCode = _JournalEntryItem.CompanyCode AND BRS.HouseBank = _JournalEntryItem.HouseBank AND BRS.HouseBankAccount = _JournalEntryItem.HouseBankAccount AND BRS.BankReconciliationDate = _JournalEntryItem.BankReconciliationDate AND _JournalEntryItem.BankReconciliationMatchType = ''  -- association [0..*]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1]
LEFT OUTER JOIN I_Currency AS _Currency ON HouseBankCurrency = _Currency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Housebank AS _HouseBank ON BRS.CompanyCode = _HouseBank.CompanyCode AND BRS.HouseBank = _HouseBank.HouseBank  -- association [1]
LEFT OUTER JOIN I_HouseBankAccountVH AS _HouseBankAccount ON BRS.CompanyCode = _HouseBankAccount.CompanyCode AND BRS.HouseBank = _HouseBankAccount.HouseBank AND BRS.HouseBankAccount = _HouseBankAccount.HouseBankAccount  -- association [1]
LEFT OUTER JOIN I_Ledger AS _Ledger ON Ledger = _Ledger.Ledger  -- association [1]
LEFT OUTER JOIN I_BankAccount AS _BankAccount ON BRS.CompanyCode = _BankAccount.CompanyCode AND BRS.BankAccount = _BankAccount.BankAccountNumber  -- association [0..*]
LEFT OUTER JOIN I_GLAccountInCompanyCode AS _GLAccount ON BRS.CompanyCode = _GLAccount.CompanyCode AND BRS.GLAccount = _GLAccount.GLAccount  -- association [1]
LEFT OUTER JOIN I_User AS _User ON CreationUserName = _User.UserID  -- association [1]
LEFT OUTER JOIN I_CompanyCodeVH AS _CompanyCodeVH ON BRS.CompanyCode = _CompanyCodeVH.CompanyCode  -- association [1]
;