I_BPContactTelNmbrTP

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_BPContactTelNmbrTP.
-- 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: IBPCPTELNOTP

CREATE VIEW I_BPContactTelNmbrTP AS
SELECT
  ContactPerson.BusinessPartnerCompany AS BusinessPartner1,
  ContactPerson.BusinessPartnerPerson AS BusinessPartner2,
  ContactPerson.RelationshipNumber AS RelationshipNumber,
  ContactPerson.ValidityEndDate AS ValidityEndDate,
  ContactPerson.AddressID AS AddressID,
  TelephoneNumber.CommMediumSequenceNumber AS OrdinalNumber,
  ContactPerson.BusinessPartnerCompany AS BusinessPartner1ForEdit,
  ContactPerson.BusinessPartnerPerson AS BusinessPartner2ForEdit,
  ContactPerson.ValidityEndDate AS ValidityEndDateForEdit,
  ContactPerson.AddressID AS AddressIDForEdit,
  TelephoneNumber.CommMediumSequenceNumber AS OrdinalNumberForEdit,
  ContactPerson.RelationshipNumber AS RelationshipNumberForEdit,
  TelephoneNumber.PhoneNumberCountry AS DestinationLocationCountry,
  _CountryPrefix.TelephoneCountryPrefix AS CountryDialingCode,
  TelephoneNumber.CommLineNotForUnsolicitedCntct AS CommNumberIsNotUsed,
  TelephoneNumber.PhoneAreaCodeSubscriberNumber AS PhoneNumber,
  TelephoneNumber.PhoneExtensionNumber AS PhoneNumberExtension,
  TelephoneNumber.PhoneIsSMSEnabled AS PhoneIsSMSEnabled,
  TelephoneNumber.PhoneNumberType AS PhoneNumberType,
  TelephoneNumber._AddressCommunicationRemark.CommunicationRemarkText AS AddressCommunicationRemarkText
FROM I_BpContactToAddress AS ContactPerson
INNER JOIN I_AddressPhoneNumber_2 AS TelephoneNumber 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 DestinationLocationCountry = _CountryPrefix.Country  -- association [0..1]
;