I_SAFTBankStatement

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_SAFTBankStatement.
-- 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: ISAFTBNKST

CREATE VIEW I_SAFTBankStatement AS
SELECT
  f.bukrs AS CompanyCode,
  f.kukey AS BankStatementShortID,
  iban.IBAN AS IBAN,
  f.azidt AS BankStatementInternalID,
  f.azdat AS BankStatementDate,
  f.waers AS Currency,
  f.ssvoz AS StartingBalSurplusDeficitCode,
  f.esvoz AS ClosingBalSurplusDeficitCode,
  f.hbkid AS HouseBank,
  f.ktonr AS BankAccount,
  hb.BankCountry AS BankCountry,
  hb.BankInternalID AS BankInternalID,
  hb.BankControlKey AS BankControlKey
FROM febko AS f
INNER JOIN I_Housebank AS hb ON /* join condition not captured in parsed metadata */
INNER JOIN I_Iban AS iban ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _Currency ON Currency = _Currency.Currency  -- association [1..1]
;