A_BPContactPersonMblNmbr

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_BPContactPersonMblNmbr.
-- 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_BPContactPersonMblNmbr AS
SELECT
  ContactPerson.RelationshipNumber AS RelationshipNumber,
  ContactPerson.BusinessPartnerCompany AS BusinessPartnerCompany,
  ContactPerson.BusinessPartnerPerson AS BusinessPartnerPerson,
  ContactPerson.ValidityEndDate AS ValidityEndDate,
  ContactPerson.AddressID AS AddressID,
  MobilePhoneNumber.OrdinalNumber AS OrdinalNumber,
  MobilePhoneNumber.IsDefaultPhoneNumber AS IsDefaultPhoneNumber,
  MobilePhoneNumber.DestinationLocationCountry AS DestinationLocationCountry,
  MobilePhoneNumber.PhoneNumber AS MobilePhoneNumber,
  MobilePhoneNumber.PhoneNumberExtension AS PhoneNumberExtension,
  MobilePhoneNumber.InternationalPhoneNumber AS InternationalPhoneNumber,
  MobilePhoneNumber.PhoneNumberType AS PhoneNumberType
FROM I_BpContactToAddress AS ContactPerson
INNER JOIN I_AddressPhoneNumber AS MobilePhoneNumber 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]
;