R_BankTP

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 R_BankTP.
-- 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 R_BankTP AS
SELECT
  BankCountry,
  BankInternalID,
  Bank.BankName AS BankName,
  case when ( _BankAddressAssoc.LongBankName is null or _BankAddressAssoc.LongBankName is initial ) then Bank.BankName else _BankAddressAssoc.LongBankName end as LongBankName AS LongBankNameendasLongBankName,
  Bank.BankBranch AS BankBranch,
  case when ( _BankAddressAssoc.LongBankBranch is null or _BankAddressAssoc.LongBankBranch is initial ) then Bank.BankBranch else _BankAddressAssoc.LongBankBranch end as LongBankBranch AS LongBankBranchendasLongBankBranch,
  Bank.ShortStreetName AS ShortStreetName,
  case when ( _BankAddressAssoc.StreetName is null or _BankAddressAssoc.StreetName is initial ) then Bank.ShortStreetName else _BankAddressAssoc.StreetName end as StreetName AS StreetNameendasStreetName,
  Bank.ShortCityName AS ShortCityName,
  case when ( _BankAddressAssoc.CityName is null or _BankAddressAssoc.CityName is initial ) then Bank.ShortCityName else _BankAddressAssoc.CityName end as CityName AS CityNameendasCityName,
  Bank.Region AS Region,
  case when ( _BankAddressAssoc.Region is null or _BankAddressAssoc.Region is initial ) then Bank.Region else _BankAddressAssoc.Region end as AddressRegion AS RegionendasAddressRegion,
  SWIFTCode,
  BankNetworkGrouping,
  IsMarkedForDeletion,
  Bank AS BankNumber,
  CheckDigitCalculationMethod,
  AddressID,
  BankDataFileFormat,
  cast(Bank.BankCategory as bf_bank_category preserving type) AS BankCategory,
  _BankCategory.BankCategoryDescription AS BankCategoryDescription,
  concat_with_space(BankInternalID, concat('(', concat( case when ( _BankAddressAssoc.LongBankName is null or _BankAddressAssoc.LongBankName is initial ) then Bank.BankName else _BankAddressAssoc.LongBankName end ,')') ) , 1 ) as BankKeyForDisplay AS LongBankNameend1asBankKeyForDisplay,
  abap.char' ' AS LongBankBranchIsHidden,
  abap.char' ' AS BankNumberIsHidden,
  abap.char' ' AS SWIFTCodeIsHidden,
  abap.char' ' AS BankNetworkGroupingIsHidden,
  abap.char' ' AS BankAddressIsHidden,
  abap.char' ' AS BankScriptedAddressIsHidden,
  abap.char' ' AS BankCategoryIsHidden,
  CreationDate,
  CreatedByUser
FROM I_Bank_2 AS Bank
LEFT OUTER JOIN R_BankAddressTP AS _BankAddressAssoc ON BankCountry = _BankAddressAssoc.BankCountry AND BankInternalID = _BankAddressAssoc.BankInternalID  -- association [1..1]
LEFT OUTER JOIN C_BankCategoryVH AS _BankCategory ON BankCategory = _BankCategory.BankCategory  -- association [1..1]
LEFT OUTER JOIN E_Bank AS _Extension ON BankCountry = _Extension.BankCountry AND BankInternalID = _Extension.BankInternalID  -- association [1..1]
LEFT OUTER JOIN P_BankAddressRprstnCode AS _AddrRprstnCode ON 1 = 1  -- association [1..1]
LEFT OUTER JOIN R_BankAddressTP AS _BankAddress ON /* condition not available in parsed metadata */  -- association [1..1]
;