C_BPContactAddress

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 C_BPContactAddress.
-- 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: CBPCPADDR

CREATE VIEW C_BPContactAddress AS
SELECT
  CPAddress.BusinessPartner1 AS BusinessPartner1,
  CPAddress.BusinessPartner2 AS BusinessPartner2,
  CPAddress.RelationshipNumber AS RelationshipNumber,
  CPAddress.ValidityEndDate AS ValidityEndDate,
  CPAddress.AddressID AS AddressID,
  CPAddress.BusinessPartner1ForEdit AS BusinessPartner1ForEdit,
  CPAddress.BusinessPartner2ForEdit AS BusinessPartner2ForEdit,
  CPAddress.ValidityEndDateForEdit AS ValidityEndDateForEdit,
  CPAddress.AddressIDForEdit AS AddressIDForEdit,
  CPAddress.RelationshipNumberForEdit AS RelationshipNumberForEdit,
  CPAddress.IsDefaultAddress AS IsDefaultAddress,
  CPAddress.ContactRelationshipFunction AS ContactRelationshipFunction,
  CPAddress.ContactRelationshipDepartment AS ContactRelationshipDepartment,
  CPAddress.Floor AS Floor,
  CPAddress.Building AS Building,
  CPAddress.RoomNumber AS RoomNumber,
  CPAddress.PrfrdCommMediumType AS PrfrdCommMediumType,
  CPAddress.CorrespondenceShortName AS CorrespondenceShortName,
  CPAddress.InhouseMail AS InhouseMail,
  CPAddress.FormattedAddress AS FormattedAddress,
  CPAddress.FormOfAddress AS FormOfAddress,
  CPAddress.FullName AS FullName,
  CPAddress.HouseNumber AS HouseNumber,
  CPAddress.StreetName AS StreetName,
  CPAddress.CityName AS CityName,
  CPAddress.PostalCode AS PostalCode,
  CPAddress.Region AS Region,
  CPAddress.Country AS Country,
  CPAddress.AddressTimeZone AS AddressTimeZone
FROM I_BPContactAddressTP AS CPAddress
LEFT OUTER JOIN C_BusinessPartner AS _BusinessPartner ON BusinessPartner1 = _BusinessPartner.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN C_BusinessPartnerCustomer AS _BusinessPartnerCustomer ON BusinessPartner1 = _BusinessPartnerCustomer.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN C_BusinessPartnerSupplier AS _BusinessPartnerSupplier ON BusinessPartner1 = _BusinessPartnerSupplier.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN C_BusinessPartnerContact AS _BusinessPartnerContact ON BusinessPartner1 = _BusinessPartnerContact.BusinessPartner AND BusinessPartner2 = _BusinessPartnerContact.BusinessPartnerPerson AND RelationshipNumber = _BusinessPartnerContact.RelationshipNumber AND ValidityEndDate = _BusinessPartnerContact.ValidityEndDate  -- association [1..1]
LEFT OUTER JOIN C_BPContactEmlAddr 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 C_BPContactTelNmbr 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 C_BPContactMblNmbr 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 C_BPContactFaxNmbr 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 C_BPContactWbsteURL AS _BPContactWbsteURL ON BusinessPartner1 = _BPContactWbsteURL.BusinessPartner1 AND BusinessPartner2 = _BPContactWbsteURL.BusinessPartner2 AND RelationshipNumber = _BPContactWbsteURL.RelationshipNumber AND ValidityEndDate = _BPContactWbsteURL.ValidityEndDate AND AddressID = _BPContactWbsteURL.AddressID  -- association [0..*]
LEFT OUTER JOIN C_TitleTextVHTemp AS _TitleText ON FormOfAddress = _TitleText.FormOfAddress  -- association [0..*]
;