I_BPContactFaxNmbrTP

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 I_BPContactFaxNmbrTP.
-- 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: IBPCPFAXNMBRTP

CREATE VIEW I_BPContactFaxNmbrTP AS
SELECT
  ContactPerson.BusinessPartnerCompany AS BusinessPartner1,
  ContactPerson.BusinessPartnerPerson AS BusinessPartner2,
  ContactPerson.RelationshipNumber AS RelationshipNumber,
  ContactPerson.ValidityEndDate AS ValidityEndDate,
  ContactPerson.AddressID AS AddressID,
  FaxNumber.CommMediumSequenceNumber AS OrdinalNumber,
  ContactPerson.BusinessPartnerCompany AS BusinessPartner1ForEdit,
  ContactPerson.BusinessPartnerPerson AS BusinessPartner2ForEdit,
  ContactPerson.ValidityEndDate AS ValidityEndDateForEdit,
  ContactPerson.AddressID AS AddressIDForEdit,
  FaxNumber.CommMediumSequenceNumber AS OrdinalNumberForEdit,
  ContactPerson.RelationshipNumber AS RelationshipNumberForEdit,
  FaxNumber.FaxNumberCountry AS FaxCountry,
  _CountryPrefix.TelephoneCountryPrefix AS CountryDialingCode,
  FaxNumber.FaxNumberIsCurrentDefault AS IsDefaultFaxNumber,
  FaxNumber.CommLineNotForUnsolicitedCntct AS CommNumberIsNotUsed,
  FaxNumber.FaxAreaCodeSubscriberNumber AS FaxNumber,
  FaxNumber.FaxExtensionNumber AS FaxNumberExtension,
  FaxNumber._AddressCommunicationRemark.CommunicationRemarkText AS AddressCommunicationRemarkText
FROM I_BpContactToAddress AS ContactPerson
INNER JOIN I_AddressFaxNumber_2 AS FaxNumber ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_BusinessPartnerTP AS _BusinessPartner ON BusinessPartner1 = _BusinessPartner.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN I_BPContactAddressTP AS _BPContactAddress ON BusinessPartner1 = _BPContactAddress.BusinessPartner1 AND BusinessPartner2 = _BPContactAddress.BusinessPartner2 AND RelationshipNumber = _BPContactAddress.RelationshipNumber AND ValidityEndDate = _BPContactAddress.ValidityEndDate AND AddressID = _BPContactAddress.AddressID  -- association [1..1]
LEFT OUTER JOIN I_BusPartTelCountryPrefix AS _CountryPrefix ON FaxCountry = _CountryPrefix.Country  -- association [0..1]
;