Fclm_Bm_Contacts

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_Contacts.
-- 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_CONTACT
-- Parameters: p_spras : sylangu

CREATE VIEW Fclm_Bm_Contacts AS
SELECT
  _RiskPartner.BusinessPartnerNumber AS BusinessPartnerNo,
  but000.partner AS ContactPersonNo,
  RELNR,
  _RiskPartner.BankCountry AS BankCountry,
  _RiskPartner.BankInternalID AS BankInternalId,
  _Bank.BankName AS BankName,
  _Country.CountryName AS CountryName,
  but020.addrnumber AS AddressId,
  tsad3.title AS Title,
  but000.name_first AS FirstName,
  but000.name_last AS LastName,
  but000.birthdt AS BIRTHDT,
  but051.pafkt AS Function,
  but051.abtnr AS Department,
  but100.rltyp AS Role,
  adcp.persnumber AS persnumber,
  _PhoneNumber.PhoneAreaCodeSubscriberNumber AS TelephoneNumber,
  _MobilePhoneNumber.PhoneAreaCodeSubscriberNumber AS MobileNumber,
  _FaxNumber.FaxAreaCodeSubscriberNumber AS FaxNumber,
  _EmailAddress.EmailAddress AS EmailAddress,
  _address.Country AS AddressCountry,
  _address.Region AS State,
  _address.StreetName AS Street,
  _address.HouseNumber AS HouseNumber,
  _address.CityName AS AddressCity,
  _address.PostalCode AS PostalCode,
  _address.Building AS Building,
  _address.Floor AS Floor,
  _address.RoomNumber AS RoomNumber,
  _Function.bez30 AS FunctionName,
  _Department.bez20 AS DepartmentName,
  _BusinessPartner.BusinessPartnerFullName AS BusinessPartnerFullName,
  _ContactBusinessPartner.BusinessPartnerFullName AS ContactBusinessNoFullname,
  _ContactBusinessPartner.IsBusinessPurposeCompleted AS IsCntctPurposeCompleted,
  _RiskPartner._BusinessPartner.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted
FROM I_RiskBusinessPartner AS _RiskPartner
INNER JOIN but051 ON /* join condition not captured in parsed metadata */
INNER JOIN but000 ON /* join condition not captured in parsed metadata */
INNER JOIN but100 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN but020 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN tsad3 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN adrc ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN adcp ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Address_2 AS _address ON _address.AddressID = AddressId  -- association [0..1]
LEFT OUTER JOIN I_AddressPhoneNumber_2 AS _PhoneNumber ON _PhoneNumber.AddressID = AddressId AND _PhoneNumber.AddressPersonID = persnumber AND _PhoneNumber.PhoneNumberType = '1'  -- association [0..1]
LEFT OUTER JOIN I_AddressPhoneNumber_2 AS _MobilePhoneNumber ON _MobilePhoneNumber.AddressID = AddressId AND _MobilePhoneNumber.AddressPersonID = persnumber AND _MobilePhoneNumber.PhoneNumberType = '3'  -- association [0..1]
LEFT OUTER JOIN I_AddressFaxNumber_2 AS _FaxNumber ON _FaxNumber.AddressID = AddressId AND _FaxNumber.AddressPersonID = persnumber AND _FaxNumber.FaxNumberIsCurrentDefault = 'X'  -- association [0..1]
LEFT OUTER JOIN I_AddressEmailAddress_2 AS _EmailAddress ON _EmailAddress.AddressID = AddressId AND _EmailAddress.AddressPersonID = persnumber AND _EmailAddress.EmailAddressIsCurrentDefault = 'X'  -- association [0..1]
LEFT OUTER JOIN tb913 AS _Function ON _Function.pafkt = but051.pafkt AND _Function.spras = $parameters.p_spras  -- association [0..1]
LEFT OUTER JOIN tb911 AS _Department ON _Department.abtnr = but051.abtnr AND _Department.spras = $parameters.p_spras  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON BusinessPartnerNo = _BusinessPartner.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _ContactBusinessPartner ON ContactPersonNo = _ContactBusinessPartner.BusinessPartner  -- association [0..1]
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 = $parameters.p_spras  -- association [0..1]
;