A_BPContactWorkPlaceEmailAddr

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_BPContactWorkPlaceEmailAddr.
-- 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: ABPCONTACTEMAIL

CREATE VIEW A_BPContactWorkPlaceEmailAddr AS
SELECT
  ContactPerson.BusinessPartnerCompany AS BusinessPartnerCompany,
  ContactPerson.BusinessPartnerPerson AS BusinessPartnerPerson,
  ContactPerson.RelationshipNumber AS RelationshipNumber,
  ContactPerson.AddressID AS AddressID,
  ContactPerson.ValidityEndDate AS ValidityEndDate,
  EmailAddress.OrdinalNumber AS OrdinalNumber,
  EmailAddress.IsDefaultEmailAddress AS IsDefaultEmailAddress,
  EmailAddress.EmailAddress AS EmailAddress,
  EmailAddress.SearchEmailAddress AS SearchEmailAddress,
  EmailAddress._AddressCommunicationRemark.AddressCommunicationRemarkText AS AddressCommunicationRemarkText
FROM I_BpContactToAddress AS ContactPerson
INNER JOIN I_AddressEmailAddress AS EmailAddress 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]
;