A_BPContactPersonWbsteURL

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 A_BPContactPersonWbsteURL.
-- 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 A_BPContactPersonWbsteURL AS
SELECT
  ContactPerson.RelationshipNumber AS RelationshipNumber,
  ContactPerson.BusinessPartnerCompany AS BusinessPartnerCompany,
  ContactPerson.BusinessPartnerPerson AS BusinessPartnerPerson,
  ContactPerson.ValidityEndDate AS ValidityEndDate,
  ContactPerson.AddressID AS AddressID,
  URLAddress.OrdinalNumber AS OrdinalNumber,
  URLAddress.IsDefaultURLAddress AS IsDefaultURLAddress,
  URLAddress.SearchURLAddress AS SearchURLAddress,
  URLAddress.CommNumberIsNotUsed AS CommNumberIsNotUsed,
  URLAddress.URLFieldLength AS URLFieldLength,
  URLAddress.WebsiteURL AS WebsiteURL
FROM I_BpContactToAddress AS ContactPerson
INNER JOIN I_AddressHomepageURL AS URLAddress ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN A_BusinessPartner AS _BusinessPartnerCompany ON BusinessPartnerCompany = _BusinessPartnerCompany.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN A_BusinessPartner AS _BusinessPartnerPerson ON BusinessPartnerPerson = _BusinessPartnerPerson.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN A_BPContactToAddress AS _BPContactAddress ON RelationshipNumber = _BPContactAddress.RelationshipNumber AND BusinessPartnerCompany = _BPContactAddress.BusinessPartnerCompany AND BusinessPartnerPerson = _BPContactAddress.BusinessPartnerPerson AND ValidityEndDate = _BPContactAddress.ValidityEndDate AND AddressID = _BPContactAddress.AddressID  -- association [1..1]
;