C_BusinessPartnerAddress

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_BusinessPartnerAddress.
-- 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: CBUPAADDRESS1

CREATE VIEW C_BusinessPartnerAddress AS
SELECT
  BusinessPartnerAddress.BusinessPartner AS BusinessPartner,
  BusinessPartnerAddress.AddressNumber AS AddressNumber,
  BusinessPartnerAddress.BusinessPartnerForEdit AS BusinessPartnerForEdit,
  BusinessPartnerAddress.AddressNumberForEdit AS AddressNumberForEdit,
  BusinessPartnerAddress.Country AS Country,
  BusinessPartnerAddress.AddressValidityStartDate AS AddressValidityStartDate,
  BusinessPartnerAddress.AddressValidityEndDate AS AddressValidityEndDate,
  BusinessPartnerAddress.CareOfName AS CareOfName,
  BusinessPartnerAddress.StreetPrefixName AS StreetPrefixName,
  BusinessPartnerAddress.AdditionalStreetPrefixName AS AdditionalStreetPrefixName,
  BusinessPartnerAddress.HouseNumber AS HouseNumber,
  BusinessPartnerAddress.StreetName AS StreetName,
  BusinessPartnerAddress.CustomerSupplierStreetName AS CustomerSupplierStreetName,
  BusinessPartnerAddress.HouseNumberSupplementText AS HouseNumberSupplementText,
  BusinessPartnerAddress.StreetSuffixName AS StreetSuffixName,
  BusinessPartnerAddress.AdditionalStreetSuffixName AS AdditionalStreetSuffixName,
  BusinessPartnerAddress.HomeCityName AS HomeCityName,
  BusinessPartnerAddress.District AS District,
  BusinessPartnerAddress.PostalCode AS PostalCode,
  BusinessPartnerAddress.CityName AS CityName,
  BusinessPartnerAddress.CustomerSupplierCityName AS CustomerSupplierCityName,
  BusinessPartnerAddress.Region AS Region,
  BusinessPartnerAddress.County AS County,
  BusinessPartnerAddress.TownshipName AS TownshipName,
  BusinessPartnerAddress.AddressTimeZone AS AddressTimeZone,
  BusinessPartnerAddress.TransportZone AS TransportZone,
  BusinessPartnerAddress.TaxJurisdiction AS TaxJurisdiction,
  BusinessPartnerAddress.TaxJurisdictionByProvider AS TaxJurisdictionByProvider,
  BusinessPartnerAddress.CompanyPostalCode AS CompanyPostalCode,
  BusinessPartnerAddress.DeliveryServiceTypeCode AS DeliveryServiceTypeCode,
  BusinessPartnerAddress.DeliveryServiceNumber AS DeliveryServiceNumber,
  BusinessPartnerAddress.POBox AS POBox,
  BusinessPartnerAddress.POBoxIsWithoutNumber AS POBoxIsWithoutNumber,
  BusinessPartnerAddress.POBoxPostalCode AS POBoxPostalCode,
  BusinessPartnerAddress.POBoxLobbyName AS POBoxLobbyName,
  BusinessPartnerAddress.POBoxDeviatingCityName AS POBoxDeviatingCityName,
  BusinessPartnerAddress.POBoxDeviatingRegion AS POBoxDeviatingRegion,
  BusinessPartnerAddress.POBoxDeviatingCountry AS POBoxDeviatingCountry,
  BusinessPartnerAddress.CorrespondenceLanguage AS CorrespondenceLanguage,
  BusinessPartnerAddress.PrfrdCommMediumType AS PrfrdCommMediumType,
  BusinessPartnerAddress.PhoneNumberCountry AS PhoneNumberCountry,
  BusinessPartnerAddress.PhoneNumber AS PhoneNumber,
  BusinessPartnerAddress.PhoneNumberExtension AS PhoneNumberExtension,
  BusinessPartnerAddress.MobilePhoneCountry AS MobilePhoneCountry,
  BusinessPartnerAddress.MobilePhoneNumber AS MobilePhoneNumber,
  BusinessPartnerAddress.FaxCountry AS FaxCountry,
  BusinessPartnerAddress.FaxNumber AS FaxNumber,
  BusinessPartnerAddress.FaxNumberExtension AS FaxNumberExtension,
  BusinessPartnerAddress.EmailAddress AS EmailAddress,
  BusinessPartnerAddress.StandardUsage AS StandardUsage,
  BusinessPartnerAddress.BPTargetAddressID AS BPTargetAddressID,
  BusinessPartnerAddress.AddressMoveDate AS AddressMoveDate,
  cast( ' ' as abap.sstring( 260 ) ) AS FormattedPostalAddressText,
  BusinessPartnerAddress.BPTargetAddressText AS BPTargetAddressText,
  InternationalPhoneNumber,
  BusinessPartnerAddress.URLFieldLength AS URLFieldLength,
  BusinessPartnerAddress.WebsiteURL AS WebsiteURL
FROM I_BusinessPartnerAddressTP AS BusinessPartnerAddress
LEFT OUTER JOIN C_BusinessPartner AS _BusinessPartner ON BusinessPartner = _BusinessPartner.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN C_BusinessPartnerSupplier AS _BusinessPartnerSupplier ON BusinessPartner = _BusinessPartnerSupplier.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN C_BusinessPartnerCustomer AS _BusinessPartnerCustomer ON BusinessPartner = _BusinessPartnerCustomer.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN C_Businesspartneraddrusage AS _BusinessPartnerAddrUsage ON BusinessPartner = _BusinessPartnerAddrUsage.BusinessPartner AND AddressNumber = _BusinessPartnerAddrUsage.AddressNumber  -- association [1..*]
LEFT OUTER JOIN C_BPTelephoneNumber AS _BPTelephoneNumber ON BusinessPartner = _BPTelephoneNumber.BusinessPartner AND AddressNumber = _BPTelephoneNumber.AddressID  -- association [0..*]
LEFT OUTER JOIN C_BPTelephoneNumber AS _BPStdTelephoneNumber ON BusinessPartner = _BPStdTelephoneNumber.BusinessPartner AND AddressNumber = _BPStdTelephoneNumber.AddressID AND _BPStdTelephoneNumber.IsDefaultPhoneNumber = 'X'  -- association [0..1]
LEFT OUTER JOIN C_BPMobilePhoneNumber AS _BPMobilePhoneNumber ON BusinessPartner = _BPMobilePhoneNumber.BusinessPartner AND AddressNumber = _BPMobilePhoneNumber.AddressID  -- association [0..*]
LEFT OUTER JOIN C_BPMobilePhoneNumber AS _BPStdMobilePhoneNumber ON BusinessPartner = _BPStdMobilePhoneNumber.BusinessPartner AND AddressNumber = _BPStdMobilePhoneNumber.AddressID AND _BPStdMobilePhoneNumber.IsDefaultPhoneNumber = 'X'  -- association [0..1]
LEFT OUTER JOIN C_BPFaxNumber AS _BPFaxNumber ON BusinessPartner = _BPFaxNumber.BusinessPartner AND AddressNumber = _BPFaxNumber.AddressID  -- association [0..*]
LEFT OUTER JOIN C_BPFaxNumber AS _BPStdFaxNumber ON BusinessPartner = _BPStdFaxNumber.BusinessPartner AND AddressNumber = _BPStdFaxNumber.AddressID AND _BPStdFaxNumber.IsDefaultFaxNumber = 'X'  -- association [0..1]
LEFT OUTER JOIN C_BPWebsiteURL AS _BPWebsiteURL ON BusinessPartner = _BPWebsiteURL.BusinessPartner AND AddressNumber = _BPWebsiteURL.AddressID  -- association [0..*]
LEFT OUTER JOIN C_BPWebsiteURL AS _BPStdWebsiteURL ON BusinessPartner = _BPStdWebsiteURL.BusinessPartner AND AddressNumber = _BPStdWebsiteURL.AddressID AND _BPStdWebsiteURL.IsDefaultURLAddress = 'X'  -- association [0..1]
LEFT OUTER JOIN C_BPEmailAddress AS _BPEmailAddress ON BusinessPartner = _BPEmailAddress.BusinessPartner AND AddressNumber = _BPEmailAddress.AddressID  -- association [0..*]
LEFT OUTER JOIN C_BPEmailAddress AS _BPStdEmailAddress ON BusinessPartner = _BPStdEmailAddress.BusinessPartner AND AddressNumber = _BPStdEmailAddress.AddressID AND _BPStdEmailAddress.IsDefaultEmailAddress = 'X'  -- association [0..1]
LEFT OUTER JOIN C_Countrytextvhtemp AS _CountryText ON Country = _CountryText.Country  -- association [0..*]
LEFT OUTER JOIN C_RegionTextVHTemp AS _RegionText ON Country = _RegionText.Country AND Region = _RegionText.Region  -- association [1..*]
LEFT OUTER JOIN I_Country AS _Country ON Country = _Country.Country  -- association [0..1]
LEFT OUTER JOIN C_BPLanguageTextValueHelp AS _LanguageText ON CorrespondenceLanguage = _LanguageText.LanguageCode  -- association [0..*]
LEFT OUTER JOIN C_CommMethTextVhTemp AS _CommMethText ON PrfrdCommMediumType = _CommMethText.CommunicationMediumType  -- association [0..*]
LEFT OUTER JOIN C_TelCountryTextVHTemp AS _TelCountryText ON PhoneNumberCountry = _TelCountryText.Country  -- association [1..*]
LEFT OUTER JOIN C_TelCountryTextVHTemp AS _MblCountryText ON MobilePhoneCountry = _MblCountryText.Country  -- association [1..*]
LEFT OUTER JOIN C_TelCountryTextVHTemp AS _FaxCountryText ON FaxCountry = _FaxCountryText.Country  -- association [1..*]
LEFT OUTER JOIN I_TimeZoneText AS _TimeZoneText ON AddressTimeZone = _TimeZoneText.TimeZoneID  -- association [0..*]
LEFT OUTER JOIN I_Transportation_Zone_Text AS _TransportZoneText ON TransportZone = _TransportZoneText.TransportZone AND Country = _TransportZoneText.CountryCode  -- association [0..*]
;