P_BusinessPartnerContacts

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 P_BusinessPartnerContacts.
-- 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: PBPCONTACTS

CREATE VIEW P_BusinessPartnerContacts AS
SELECT
  but050.relnr AS RelationshipNumber,
  but050.partner1 AS BusinessPartner1,
  but050.partner2 AS BusinessPartner2,
  but050.date_to AS ValidityEndDate,
  but050.date_from AS ValidityStartDate,
  _Bpcontacts_Data.FormOfAddress AS FormOfAddress,
  _Bpcontacts_Data.FirstName AS FirstName,
  _Bpcontacts_Data.LastName AS LastName,
  _Bpcontacts_Data.BirthDate AS BirthDate,
  _Bpcontacts_Func_Dept.ContactPersonDepartment AS ContactPersonDepartment,
  _Bpcontacts_Func_Dept.ContactPersonFunction AS ContactPersonFunction,
  _Bpcontacts_Address.Building AS Building,
  _Bpcontacts_Address.Floor AS Floor,
  _Bpcontacts_Address.RoomNumber AS RoomNumber,
  _Bpcontacts_Address.InternationalPhoneNumber AS InternationalPhoneNumber,
  _Bpcontacts_Address.PhoneCountry AS PhoneCountry,
  _Bpcontacts_Address.InternationalMobilePhoneNumber AS InternationalMobilePhoneNumber,
  _Bpcontacts_Address.MobilePhoneCountry AS MobilePhoneCountry,
  _Bpcontacts_Address.MobilePhoneNumber AS MobilePhoneNumber,
  _Bpcontacts_Address.MobilePhoneExtension AS MobilePhoneExtension,
  _Bpcontacts_Address.InternationalFaxNumber AS InternationalFaxNumber,
  _Bpcontacts_Address.FaxCountry AS FaxCountry,
  _Bpcontacts_Address.IsDefaultAddress AS IsDefaultAddress,
  _Bpcontacts_Func_Dept.PhoneNumber AS PhoneNumber,
  _Bpcontacts_Func_Dept.PhoneNumberExtension AS PhoneNumberExtension,
  _Bpcontacts_Func_Dept.FaxNumber AS FaxNumber,
  _Bpcontacts_Func_Dept.FaxNumberExtension AS FaxNumberExtension,
  _Bpcontacts_Func_Dept.EmailAddress AS EmailAddress,
  _Bpcontacts_Data.AuthorizationGroup AS AuthorizationGroup,
  _Bpcontacts_Data.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  but050.reltyp AS reltyp,
  but050.xdfrel AS IsStandardRelationship
FROM but050
LEFT OUTER JOIN P_Bpcontacts_Address AS _Bpcontacts_Address ON BusinessPartner2 = _Bpcontacts_Address.BusinessPartner AND RelationshipNumber = _Bpcontacts_Address.Relationship  -- association [1..*]
LEFT OUTER JOIN P_Bpcontacts_Func_Dept AS _Bpcontacts_Func_Dept ON RelationshipNumber = _Bpcontacts_Func_Dept.relnr AND BusinessPartner1 = _Bpcontacts_Func_Dept.BusinessPartner1 AND BusinessPartner2 = _Bpcontacts_Func_Dept.BusinessPartner2  -- association [1..*]
LEFT OUTER JOIN P_Bpcontacts_Data AS _Bpcontacts_Data ON BusinessPartner2 = _Bpcontacts_Data.BusinessPartner  -- association [1..*]
;