C_Bank

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 C_Bank.
-- 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.

CREATE VIEW C_Bank AS
SELECT
  Bank.BankCountry AS BankCountry,
  Bank.BankInternalID AS Bank,
  Bank.BankName AS BankName,
  Bank._BankAdditionalFields.InternalBankCategory AS InternalBankCategory,
  Bank._BankAdditionalFields._BankCategory[1:Language = $session.system_language ].InternalBankCategoryDesc AS InternalBankCategoryDesc,
  Bank.ShortCityName AS ShortCityName,
  _CountryText.CountryName AS CountryName,
  Bank.Region AS Region,
  _RegionText.RegionName AS RegionName,
  Bank.ShortStreetName AS ShortStreetName,
  Bank.BankBranch AS BankBranch,
  Bank.SWIFTCode AS SWIFTCode,
  Bank.IsPostBankAccount AS IsPostBankAccount,
  Bank.Bank AS BankNumber,
  Bank.PostOfficeBankAccount AS PostOfficeBankAccount,
  Bank.BankNetworkGrouping AS BankNetworkGrouping
FROM I_Bank_2 AS Bank
;