I_BPContactAddressTP

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_BPContactAddressTP.
-- 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: IBPCPADDTP

CREATE VIEW I_BPContactAddressTP AS
SELECT
  BusinessPartnerCompany AS BusinessPartner1,
  BusinessPartnerPerson AS BusinessPartner2,
  RelationshipNumber,
  ValidityEndDate,
  AddressID,
  BusinessPartnerCompany AS BusinessPartner1ForEdit,
  BusinessPartnerPerson AS BusinessPartner2ForEdit,
  ValidityEndDate AS ValidityEndDateForEdit,
  AddressID AS AddressIDForEdit,
  RelationshipNumber AS RelationshipNumberForEdit,
  IsDefaultAddress,
  ContactRelationshipFunction,
  ContactRelationshipDepartment,
  Floor,
  Building,
  RoomNumber,
  PrfrdCommMediumType,
  CorrespondenceShortName,
  InhouseMail,
  concat_with_space(_BPCompanyPostalAddress.HouseNumber, concat_with_space(_BPCompanyPostalAddress.StreetName, concat_with_space(_BPCompanyPostalAddress.CityName, concat_with_space(_BPCompanyPostalAddress.PostalCode,_BPCompanyPostalAddress.Country,1),1),1),1) as FormattedAddress AS Country1111asFormattedAddress,
  _BPCompanyPostalAddress.FormOfAddress AS FormOfAddress,
  _BPCompanyPostalAddress.FullName AS FullName,
  _BPCompanyPostalAddress.HouseNumber AS HouseNumber,
  _BPCompanyPostalAddress.StreetName AS StreetName,
  _BPCompanyPostalAddress.CityName AS CityName,
  _BPCompanyPostalAddress.PostalCode AS PostalCode,
  _BPCompanyPostalAddress.Region AS Region,
  _BPCompanyPostalAddress.Country AS Country,
  _BPCompanyPostalAddress.AddressTimeZone AS AddressTimeZone
FROM I_BpContactToAddress
LEFT OUTER JOIN I_BusinessPartnerTP AS _BusinessPartner ON BusinessPartner1 = _BusinessPartner.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN I_BusinessPartnerContactTP AS _BPContactAddress ON BusinessPartner1 = _BPContactAddress.BusinessPartner AND BusinessPartner2 = _BPContactAddress.BusinessPartnerPerson AND RelationshipNumber = _BPContactAddress.RelationshipNumber AND ValidityEndDate = _BPContactAddress.ValidityEndDate  -- association [1..1]
LEFT OUTER JOIN I_BPContactEmlAddrTP AS _BPContactEmlAddr ON BusinessPartner1 = _BPContactEmlAddr.BusinessPartner1 AND BusinessPartner2 = _BPContactEmlAddr.BusinessPartner2 AND RelationshipNumber = _BPContactEmlAddr.RelationshipNumber AND ValidityEndDate = _BPContactEmlAddr.ValidityEndDate AND AddressID = _BPContactEmlAddr.AddressID  -- association [0..*]
LEFT OUTER JOIN I_BPContactTelNmbrTP AS _BPContactTelNmbr ON BusinessPartner1 = _BPContactTelNmbr.BusinessPartner1 AND BusinessPartner2 = _BPContactTelNmbr.BusinessPartner2 AND RelationshipNumber = _BPContactTelNmbr.RelationshipNumber AND ValidityEndDate = _BPContactTelNmbr.ValidityEndDate AND AddressID = _BPContactTelNmbr.AddressID  -- association [0..*]
LEFT OUTER JOIN I_BPContactMblNmbrTP AS _BPContactMblNmbr ON BusinessPartner1 = _BPContactMblNmbr.BusinessPartner1 AND BusinessPartner2 = _BPContactMblNmbr.BusinessPartner2 AND RelationshipNumber = _BPContactMblNmbr.RelationshipNumber AND ValidityEndDate = _BPContactMblNmbr.ValidityEndDate AND AddressID = _BPContactMblNmbr.AddressID  -- association [0..*]
LEFT OUTER JOIN I_BPContactFaxNmbrTP AS _BPContactFaxNmbr ON BusinessPartner1 = _BPContactFaxNmbr.BusinessPartner1 AND BusinessPartner2 = _BPContactFaxNmbr.BusinessPartner2 AND RelationshipNumber = _BPContactFaxNmbr.RelationshipNumber AND ValidityEndDate = _BPContactFaxNmbr.ValidityEndDate AND AddressID = _BPContactFaxNmbr.AddressID  -- association [0..*]
LEFT OUTER JOIN I_BPContactWbsteURLTP AS _BPContactWbsteURL ON BusinessPartner1 = _BPContactWbsteURL.BusinessPartner1 AND BusinessPartner2 = _BPContactWbsteURL.BusinessPartner2 AND RelationshipNumber = _BPContactWbsteURL.RelationshipNumber AND ValidityEndDate = _BPContactWbsteURL.ValidityEndDate AND AddressID = _BPContactWbsteURL.AddressID  -- association [0..*]
;