A_BPContactWorkPlaceFaxNumber

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_BPContactWorkPlaceFaxNumber.
-- 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: ABPCONTACTFAX

CREATE VIEW A_BPContactWorkPlaceFaxNumber AS
SELECT
  ContactPerson.BusinessPartnerCompany AS BusinessPartnerCompany,
  ContactPerson.BusinessPartnerPerson AS BusinessPartnerPerson,
  ContactPerson.RelationshipNumber AS RelationshipNumber,
  ContactPerson.AddressID AS AddressID,
  ContactPerson.ValidityEndDate AS ValidityEndDate,
  FaxNumber.OrdinalNumber AS OrdinalNumber,
  FaxNumber.IsDefaultFaxNumber AS IsDefaultFaxNumber,
  FaxNumber.FaxCountry AS FaxCountry,
  FaxNumber.FaxNumberExtension AS FaxNumberExtension,
  FaxNumber.InternationalFaxNumber AS InternationalFaxNumber,
  FaxNumber._AddressCommunicationRemark.AddressCommunicationRemarkText AS AddressCommunicationRemarkText
FROM I_BpContactToAddress AS ContactPerson
INNER JOIN I_AddressFaxNumber AS FaxNumber 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]
;