I_BankCashBalancePreview

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_BankCashBalancePreview.
-- 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: ICASHBALPREVIEW

CREATE VIEW I_BankCashBalancePreview AS
SELECT
  balance.rowindex AS RowIndex,
  balance.create_user AS CashBalanceCreatedByUser,
  balance.file_name AS MnlImportedBkAcctBalFileName,
  balance.bank_account_id AS BankAccountInternalID,
  balance.value_date AS CashBalanceDate,
  balance.iban AS IBAN,
  balance.create_timestamp AS CashBalanceCreatedAtDateTime,
  balance.balance_amount AS CashBalanceAmount,
  balance.balance_currency AS CashBalanceCurrency,
  account.acc_num AS BankAccountNumber,
  account.banks AS BankCountry,
  account.bankl AS BankKey,
  account.waers AS BankAccountCurrency,
  desc.description AS BankAccountDescription,
  account.bukrs AS CompanyCode
FROM fclm_bal_preview AS balance
;