A_BusinessPartnerContact

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_BusinessPartnerContact.
-- 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: ABUPACONTACT

CREATE VIEW A_BusinessPartnerContact AS
SELECT
  RelationshipNumber,
  BusinessPartnerCompany,
  BusinessPartnerPerson,
  ValidityEndDate,
  ValidityStartDate,
  IsStandardRelationship,
  RelationshipCategory
FROM I_BPContact
LEFT OUTER JOIN A_BusinessPartner AS _BusinessPartnerCompany ON _BusinessPartnerCompany.BusinessPartner = BusinessPartnerCompany  -- association [1..1]
LEFT OUTER JOIN A_BusinessPartner AS _BusinessPartnerPerson ON _BusinessPartnerPerson.BusinessPartner = BusinessPartnerPerson  -- association [1..1]
LEFT OUTER JOIN A_BPContactToAddress AS _ContactAddress ON RelationshipNumber = _ContactAddress.RelationshipNumber AND BusinessPartnerCompany = _ContactAddress.BusinessPartnerCompany AND BusinessPartnerPerson = _ContactAddress.BusinessPartnerPerson  -- association [1..*]
LEFT OUTER JOIN A_BPContactToFuncAndDept AS _ContactRelationship ON RelationshipNumber = _ContactRelationship.RelationshipNumber AND BusinessPartnerCompany = _ContactRelationship.BusinessPartnerCompany AND BusinessPartnerPerson = _ContactRelationship.BusinessPartnerPerson AND ValidityEndDate = _ContactRelationship.ValidityEndDate  -- association [0..1]
;