P_BPContactToAddress

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_BPContactToAddress.
-- 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: PBPCNTCTADDRESS

CREATE VIEW P_BPContactToAddress AS
SELECT
  but052.relnr AS RelationshipNumber,
  but052.partner1 AS BusinessPartnerCompany,
  but052.partner2 AS BusinessPartnerPerson,
  but050.date_to AS ValidityEndDate,
  but052.addrnumber AS AddressID,
  'X' AS BPRelshpCatIsInFwdDirection,
  but000.persnumber AS PersonNumber,
  but052.xdfadr AS IsDefaultAddress,
  'BUR001' AS RelationshipCategory,
  _AddressDetails[1: nation = ' '].nation AS AddressRepresentationCode,
  _AddressDetails[1: nation = ' '].function AS ContactRelationshipFunction,
  _AddressDetails[1: nation = ' '].department AS ContactRelationshipDepartment,
  _AddressDetails[1: nation = ' '].floor AS Floor,
  _AddressDetails[1: nation = ' '].building AS Building,
  _AddressDetails[1: nation = ' '].roomnumber AS RoomNumber,
  _AddressDetails[1: nation = ' '].deflt_comm AS PrfrdCommMediumType,
  _AddressDetails[1: nation = ' '].id_code AS CorrespondenceShortName,
  _AddressDetails[1: nation = ' '].ih_mail AS InhouseMail,
  _BusinessPartnerPerson.AuthorizationGroup AS AuthorizationGroup,
  _BusinessPartnerPerson.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  but052.date_to AS RelValidityEndDate
FROM but052
INNER JOIN but000 ON /* join condition not captured in parsed metadata */
INNER JOIN but050 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartnerCompany ON BusinessPartnerCompany = _BusinessPartnerCompany.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartnerPerson ON BusinessPartnerPerson = _BusinessPartnerPerson.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN adcp AS _AddressDetails ON AddressID = _AddressDetails.addrnumber AND PersonNumber = _AddressDetails.persnumber  -- association [1..*]
LEFT OUTER JOIN adrp AS _PersonDetails ON PersonNumber = _PersonDetails.persnumber  -- association [1..*]
LEFT OUTER JOIN I_BusinessPartnerAddress AS _BPCompanyPostalAddress ON AddressID = _BPCompanyPostalAddress.AddressNumber AND ( BusinessPartnerPerson = _BPCompanyPostalAddress.BusinessPartner OR BusinessPartnerCompany = _BPCompanyPostalAddress.BusinessPartner )  -- association [1..*]
LEFT OUTER JOIN I_AddressPhoneNumber_2 AS _Telephone ON AddressID = _Telephone.AddressID AND PersonNumber = _Telephone.AddressPersonID AND _Telephone.PhoneNumberType = '1'  -- association [0..*]
LEFT OUTER JOIN I_AddressPhoneNumber_2 AS _MobilePhone ON AddressID = _MobilePhone.AddressID AND PersonNumber = _MobilePhone.AddressPersonID AND _MobilePhone.PhoneNumberType = '3'  -- association [0..*]
LEFT OUTER JOIN I_AddressFaxNumber_2 AS _FaxNumber ON AddressID = _FaxNumber.AddressID AND PersonNumber = _FaxNumber.AddressPersonID AND _FaxNumber.FaxNumberIsCurrentDefault = 'X'  -- association [0..*]
-- UNION ALL with additional select branch(es): but052
;