Fclm_Bam_Banksummary

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 Fclm_Bam_Banksummary.
-- 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: VFCLM_BAM_BANKSU

CREATE VIEW Fclm_Bam_Banksummary AS
SELECT
  syst AS Targetsystem,
  cast( '' as fclm_bam_syncobject ) AS SyncObject,
  rfcdoc.rfcdoc1 AS description,
  cast( '' as abap.char( 50 ) ) AS LastUpdateAt,
  cast( '' as abap.char( 4 ) ) AS CompanyCode,
  cast( '' as abap.char( 3) ) AS BankCountry,
  cast( '' as abap.char( 15 ) ) AS BankKey,
  cast( '' as abap.char( 40 ) ) AS BankAccount,
  cast( '' as abap.char( 2 ) ) AS Status,
  _recordsum.Bank_consistentnum AS Bank_consistentnum,
  _recordsum.Bank_inconsistentnum AS Bank_inconsistentnum,
  cast( 0 as abap.char(6) ) AS Bank_additionalnum,
  _recordsum.HouseBank_consistentnum AS HouseBank_consistentnum,
  _recordsum.HouseBank_inconsistentnum AS HouseBank_inconsistentnum,
  cast( 0 as abap.char(6) ) AS HouseBank_additionalnum,
  _recordsum.BankAcct_consistentnum AS BankAcct_consistentnum,
  _recordsum.BankAcct_inconsistentnum AS BankAcct_inconsistentnum,
  cast( 0 as abap.char(6) ) AS BankAcct_additionalnum,
  _recordsum.Lastupdatedate AS Lastupdatedate
LEFT OUTER JOIN Fclm_Syncrecord_Sum AS _recordsum ON Targetsystem = _recordsum.targetsystem  -- association [1..1]
;