A_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 A_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: ABUPARTADDRESS

CREATE VIEW A_BusinessPartnerAddress AS
SELECT
  I_BusPartAddress.BusinessPartner AS BusinessPartner,
  I_BusPartAddress.AddressID AS AddressID,
  I_BusPartAddress.ValidityStartDate AS ValidityStartDate,
  I_BusPartAddress.ValidityEndDate AS ValidityEndDate,
  I_BusPartAddress.AuthorizationGroup AS AuthorizationGroup,
  I_BusPartAddress.AddressUUID AS AddressUUID,
  I_BusPartAddress._BPProtectedAddress.BPAddressIsProtected AS BPAddressIsProtected,
  _Address.AdditionalStreetPrefixName AS AdditionalStreetPrefixName,
  _Address.AdditionalStreetSuffixName AS AdditionalStreetSuffixName,
  _Address.AddressTimeZone AS AddressTimeZone,
  _Address.CareOfName AS CareOfName,
  _Address.CityCode AS CityCode,
  _Address.CityName AS CityName,
  _Address.CompanyPostalCode AS CompanyPostalCode,
  _Address.Country AS Country,
  _Address.County AS County,
  _Address.DeliveryServiceNumber AS DeliveryServiceNumber,
  _Address.DeliveryServiceTypeCode AS DeliveryServiceTypeCode,
  _Address.District AS District,
  _Address.FormOfAddress AS FormOfAddress,
  _Address.FullName AS FullName,
  _Address.HomeCityName AS HomeCityName,
  _Address.HouseNumber AS HouseNumber,
  _Address.HouseNumberSupplementText AS HouseNumberSupplementText,
  _Address.CorrespondenceLanguage AS Language,
  _Address.POBox AS POBox,
  _Address.POBoxDeviatingCityName AS POBoxDeviatingCityName,
  _Address.POBoxDeviatingCountry AS POBoxDeviatingCountry,
  _Address.POBoxDeviatingRegion AS POBoxDeviatingRegion,
  _Address.POBoxIsWithoutNumber AS POBoxIsWithoutNumber,
  _Address.POBoxLobbyName AS POBoxLobbyName,
  _Address.POBoxPostalCode AS POBoxPostalCode,
  _Address.Person AS Person,
  _Address.PostalCode AS PostalCode,
  _Address.PrfrdCommMediumType AS PrfrdCommMediumType,
  _Address.Region AS Region,
  _Address.StreetName AS StreetName,
  _Address.StreetPrefixName AS StreetPrefixName,
  _Address.StreetSuffixName AS StreetSuffixName,
  _Address.TaxJurisdiction AS TaxJurisdiction,
  _Address.TransportZone AS TransportZone,
  I_BusPartAddress.AddressIDByExternalSystem AS AddressIDByExternalSystem,
  _Address.CountyCode AS CountyCode,
  _Address.TownshipCode AS TownshipCode,
  _Address.TownshipName AS TownshipName
FROM I_BusPartAddress
INNER JOIN I_Address AS _Address ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN A_BusinessPartner AS _BusinessPartner ON BusinessPartner = _BusinessPartner.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN A_AddressPhoneNumber AS _PhoneNumber ON _PhoneNumber.AddressID = AddressID AND ( _PhoneNumber.Person = Person OR _PhoneNumber.Person = ' ' ) AND ( _PhoneNumber.PhoneNumberType = '1' OR _PhoneNumber.PhoneNumberType = ' ' )  -- association [0..*]
LEFT OUTER JOIN A_AddressPhoneNumber AS _MobilePhoneNumber ON _MobilePhoneNumber.AddressID = AddressID AND ( _MobilePhoneNumber.Person = Person OR _MobilePhoneNumber.Person = ' ' ) AND ( _MobilePhoneNumber.PhoneNumberType = '2' OR _MobilePhoneNumber.PhoneNumberType = '3' )  -- association [0..*]
LEFT OUTER JOIN A_AddressFaxNumber AS _FaxNumber ON _FaxNumber.AddressID = AddressID AND ( _FaxNumber.Person = Person OR _FaxNumber.Person = ' ' )  -- association [0..*]
LEFT OUTER JOIN A_AddressEmailAddress AS _EmailAddress ON _EmailAddress.AddressID = AddressID AND ( _EmailAddress.Person = Person OR _EmailAddress.Person = ' ' )  -- association [0..*]
LEFT OUTER JOIN A_AddressHomePageURL AS _URLAddress ON _URLAddress.AddressID = AddressID AND ( _URLAddress.Person = Person OR _URLAddress.Person = ' ' )  -- association [0..*]
LEFT OUTER JOIN A_BuPaAddressUsage AS _AddressUsage ON _AddressUsage.BusinessPartner = BusinessPartner AND _AddressUsage.AddressID = AddressID  -- association [0..*]
LEFT OUTER JOIN A_BPAddrDepdntIntlLocNumber AS _BPAddrDepdntIntlLocNumber ON _BPAddrDepdntIntlLocNumber.BusinessPartner = BusinessPartner AND _BPAddrDepdntIntlLocNumber.AddressID = AddressID  -- association [0..1]
LEFT OUTER JOIN A_BPIntlAddressVersion AS _BPIntlAddressVersion ON _BPIntlAddressVersion.BusinessPartner = BusinessPartner AND _BPIntlAddressVersion.AddressID = AddressID  -- association [0..*]
;