Fclm_Bm_Used_Bp

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_Used_Bp.
-- 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_USEDBP
-- Parameters: p_spras : sylangu

CREATE VIEW Fclm_Bm_Used_Bp AS
SELECT
  BPAddress.BusinessPartnerNumber AS BpNumber,
  BPAddress.BankCountry AS BankCountry,
  BPAddress.BankInternalID AS BankInternalId,
  BusinessPartnerName AS BpName,
  _Bank.BankName AS BankName,
  _Country.CountryName AS CountryName,
  cast('' as abap.char( 255 )) AS BpRoleDescription,
  AddressCountry,
  _AddrCountry.CountryName AS AddressCountryText,
  AddressCityName AS AddressCity
FROM I_CashBankBusinessPartnerUsed AS BPAddress
LEFT OUTER JOIN I_Bank_2 AS _Bank ON BankCountry = _Bank.BankCountry AND BankInternalId = _Bank.BankInternalID  -- association [1..1]
LEFT OUTER JOIN I_CountryText AS _Country ON BankCountry = _Country.Country AND _Country.Language = $parameters.p_spras  -- association [1..1]
LEFT OUTER JOIN I_CountryText AS _AddrCountry ON AddressCountry = _AddrCountry.Country AND _AddrCountry.Language = $parameters.p_spras  -- association [1..1]
;