I_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 I_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: IBPCNTCTADDRESS

CREATE VIEW I_BpContactToAddress AS
SELECT
  but052.relnr AS RelationshipNumber,
  but052.partner1 AS BusinessPartnerCompany,
  but052.partner2 AS BusinessPartnerPerson,
  but052.date_to AS ValidityEndDate,
  but052.addrnumber AS AddressID,
  but000.persnumber AS PersonNumber,
  but052.xdfadr AS IsDefaultAddress,
  _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,
  _Telephone_2.InternationalPhoneNumber AS InternationalPhoneNumber,
  _Telephone_2.PhoneNumberCountry AS PhoneNumberCountry,
  _Telephone_2.PhoneAreaCodeSubscriberNumber AS PhoneNumber,
  _MobilePhone_2.InternationalPhoneNumber AS InternationalMobilePhoneNumber,
  _MobilePhone_2.PhoneNumberCountry AS MobilePhoneCountry,
  _MobilePhone_2.PhoneAreaCodeSubscriberNumber AS MobilePhoneNumber,
  _MobilePhone_2.PhoneExtensionNumber AS MobilePhoneNumberExtension,
  _FaxNumber_2.InternationalFaxNumber AS InternationalFaxNumber,
  _FaxNumber_2.FaxNumberCountry AS FaxCountry,
  _BusinessPartnerPerson.AuthorizationGroup AS AuthorizationGroup,
  _BusinessPartnerPerson.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted
FROM but052
INNER JOIN but000 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 BusinessPartnerCompany = _BPCompanyPostalAddress.BusinessPartner  -- association [1]
LEFT OUTER JOIN I_BusinessPartAddress_2 AS _BPCompanyPostalAddress_2 ON AddressID = _BPCompanyPostalAddress_2.AddressNumber AND BusinessPartnerCompany = _BPCompanyPostalAddress_2.BusinessPartner  -- association [1]
LEFT OUTER JOIN I_AddressPhoneNumber AS _Telephone ON AddressID = _Telephone.AddressID AND PersonNumber = _Telephone.Person AND _Telephone.PhoneNumberType = '1'  -- association [0..1]
LEFT OUTER JOIN I_AddressPhoneNumber AS _MobilePhone ON AddressID = _MobilePhone.AddressID AND PersonNumber = _MobilePhone.Person AND _MobilePhone.PhoneNumberType = '3'  -- association [0..1]
LEFT OUTER JOIN I_AddressFaxNumber AS _FaxNumber ON AddressID = _FaxNumber.AddressID AND PersonNumber = _FaxNumber.Person AND _FaxNumber.IsDefaultFaxNumber = 'X'  -- association [0..1]
LEFT OUTER JOIN I_AddressPhoneNumber_2 AS _Telephone_2 ON AddressID = _Telephone_2.AddressID AND PersonNumber = _Telephone_2.AddressPersonID AND _Telephone_2.PhoneNumberType = '1'  -- association [0..1]
LEFT OUTER JOIN I_AddressPhoneNumber_2 AS _MobilePhone_2 ON AddressID = _MobilePhone_2.AddressID AND PersonNumber = _MobilePhone_2.AddressPersonID AND _MobilePhone_2.PhoneNumberType = '3'  -- association [0..1]
LEFT OUTER JOIN I_AddressFaxNumber_2 AS _FaxNumber_2 ON AddressID = _FaxNumber_2.AddressID AND PersonNumber = _FaxNumber_2.AddressPersonID AND _FaxNumber_2.FaxNumberIsCurrentDefault = 'X'  -- association [0..1]
LEFT OUTER JOIN I_Address_2 AS _AddressDefaultRepresentation ON AddressID = _AddressDefaultRepresentation.AddressID AND PersonNumber = _AddressDefaultRepresentation.AddressPersonID AND _AddressDefaultRepresentation.AddressRepresentationCode is initial  -- association [0..1]
LEFT OUTER JOIN I_Address_2 AS _AddressInternationalVersions ON AddressID = _AddressInternationalVersions.AddressID AND PersonNumber = _AddressInternationalVersions.AddressPersonID AND _AddressInternationalVersions.AddressRepresentationCode is not initial  -- association [0..*]
;