Fclm_Bm_Docu

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_Bm_Docu.
-- 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_BM_DOCU

CREATE VIEW Fclm_Bm_Docu AS
SELECT
  objectclas,
  objectid,
  changenr,
  username,
  techdesc,
  udate,
  utime,
  ChangeDate,
  ChangeTime,
  tcode,
  planchngnr,
  change_ind,
  ChangeType,
  tabname,
  tabkey,
  fname,
  FieldName,
  value_new,
  value_old,
  BankCountry,
  _Country.CountryName AS CountryName,
  BankInternalId,
  _Bank.BankName AS BankName,
  cast('' as abap.char(4) ) AS CompanyCode,
  cast('' as abap.char(25) ) AS CompanyName,
  HouseBankKey
FROM Fclm_Bm_Bank_Docu
LEFT OUTER JOIN t001 AS _company ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Bank AS _Bank ON BankCountry = _Bank.BankCountry AND BankInternalId = _Bank.BankInternalID  -- association [0..1]
LEFT OUTER JOIN I_CountryText AS _Country ON BankCountry = _Country.Country AND _Country.Language = $session.system_language  -- association [0..1]
-- UNION with additional select branch(es): Fclm_Bm_Hbank_Docu_All
;