VFCLM_BAM_DDL_BANK_WITHDESP

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 VFCLM_BAM_DDL_BANK_WITHDESP.
-- 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_BANKDP
-- Parameters: plang : abap.lang

CREATE VIEW VFCLM_BAM_DDL_BANK_WITHDESP AS
SELECT
  header.BankCountry AS BankCountry,
  header.BankKey AS BankKey,
  t005t.landx AS BankCountryDesp,
  header.CreatedAt AS CreatedAt,
  header.CreatedBy AS CreatedBy,
  header.BankName AS BankName,
  header.Region AS Region,
  header.HouseStreet AS HouseStreet,
  header.City AS City,
  header.SWIFT AS SWIFT,
  header.BankNetworkGrouping AS BankNetworkGrouping,
  header.PostbankAccount AS PostbankAccount,
  header.BankNumber AS BankNumber,
  header.PostalCheckAccount AS PostalCheckAccount,
  header.Branch AS Branch,
  header.CheckDigitMethod AS CheckDigitMethod,
  header.BankDataFormat AS BankDataFormat,
  header.AddressCountry AS AddressCountry,
  header.AddressCity AS AddressCity,
  header.AddressRegion AS AddressRegion,
  header.AddressStreet AS AddressStreet,
  header.AddressStreetPostalCode AS AddressStreetPostalCode,
  header.AddressPOBoxPostalCode AS AddressPOBoxPostalCode,
  header.AddressMailbox AS AddressMailbox
FROM VFCLM_BAM_DDL_BANK AS header
LEFT OUTER JOIN t005t ON /* join condition not captured in parsed metadata */
;