I_BusinessPartAddress_2

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_BusinessPartAddress_2.
-- 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: IBPADDR

CREATE VIEW I_BusinessPartAddress_2 AS
SELECT
  BusinessPartnerAddress.partner AS BusinessPartner,
  BusinessPartnerAddress.addrnumber AS AddressNumber,
  BusinessPartnerAddress.addr_valid_from AS ValidityStartDate,
  BusinessPartnerAddress.addr_valid_to AS ValidityEndDate,
  BusinessPartnerAddress.address_guid AS BusinessPartnerAddressUUID,
  BusinessPartnerAddress.move_addr AS BPTargetAddressID,
  BusinessPartnerAddress.addr_move_date AS BPAddressMoveDateTime,
  _Address.CareOfName AS CareOfName,
  _Address.FormOfAddress AS FormOfAddress,
  _Address.AddresseeFullName AS FullName,
  _Address.HouseNumber AS HouseNumber,
  _Address.StreetName AS StreetName,
  _Address.HouseNumberSupplementText AS HouseNumberSupplementText,
  _Address.DistrictName AS District,
  _Address.DistrictName AS DistrictName,
  _Address.PostalCode AS PostalCode,
  _Address.CityName AS CityName,
  _Address.Country AS Country,
  _Address.Region AS Region,
  _Address.AddressTimeZone AS AddressTimeZone,
  _Address.TaxJurisdiction AS TaxJurisdiction,
  _Address.TransportZone AS TransportZone,
  _Address.CompanyPostalCode AS CompanyPostalCode,
  _Address.DeliveryServiceNumber AS DeliveryServiceNumber,
  _Address.POBox AS POBox,
  _Address.POBoxIsWithoutNumber AS POBoxIsWithoutNumber,
  _Address.POBoxPostalCode AS POBoxPostalCode,
  _Address.POBoxLobbyName AS POBoxLobbyName,
  _Address.POBoxDeviatingCityName AS POBoxDeviatingCityName,
  _Address.POBoxDeviatingRegion AS POBoxDeviatingRegion,
  _Address.POBoxDeviatingCountry AS POBoxDeviatingCountry,
  _Address.CorrespondenceLanguage AS CorrespondenceLanguage,
  _Address.PrfrdCommMediumType AS PrfrdCommMediumType,
  _Address.StreetPrefixName1 AS StreetPrefixName,
  _Address.StreetPrefixName2 AS AdditionalStreetPrefixName,
  _Address.StreetSuffixName1 AS StreetSuffixName,
  _Address.StreetSuffixName2 AS AdditionalStreetSuffixName,
  _Address.VillageName AS HomeCityName,
  _Address.DeliveryServiceTypeCode AS DeliveryServiceTypeCode,
  _Address.StreetAddrNonDeliverableReason AS AddressStreetUnusable,
  _Address.POBoxAddrNonDeliverableReason AS AddressPostBoxUnusable,
  _Address.Building AS Building,
  _Address.Floor AS Floor,
  _Address.RoomNumber AS RoomNumber,
  _Address.SecondaryRegionName AS County,
  _Address.SecondaryRegionName AS BPCountyText,
  _Address.SecondaryRegion AS CountyCode,
  _Address.TertiaryRegion AS TownshipCode,
  _Address.TertiaryRegionName AS TownshipName,
  _Address.RegionalStructureCheckStatus AS CityFileTestStatus,
  _Address._CurrentDfltLandlinePhoneNmbr.PhoneAreaCodeSubscriberNumber AS PhoneNumber,
  _Address._CurrentDfltLandlinePhoneNmbr.PhoneNumberCountry AS PhoneNumberCountry,
  _Address._CurrentDfltLandlinePhoneNmbr.PhoneExtensionNumber AS PhoneNumberExtension,
  _Address._CurrentDfltFaxNumber.FaxAreaCodeSubscriberNumber AS FaxNumber,
  _Address._CurrentDfltFaxNumber.FaxNumberCountry AS FaxCountry,
  _Address._CurrentDfltFaxNumber.FaxExtensionNumber AS FaxNumberExtension,
  _Address._CurrentDfltMobilePhoneNumber.PhoneAreaCodeSubscriberNumber AS MobilePhoneNumber,
  _Address._CurrentDfltMobilePhoneNumber.PhoneNumberCountry AS MobilePhoneCountry,
  _Address._CurrentDfltEmailAddress.EmailAddress AS EmailAddress,
  cast ('00000' as abap.int2 ) AS URLFieldLength,
  _Address._MainWebsiteURL.UniformResourceIdentifier AS WebsiteURL,
  but000.persnumber AS PersonNumber,
  _BusinessPartner.DataControllerSet AS DataControllerSet,
  _BusinessPartner.DataController1 AS DataController1,
  _BusinessPartner.DataController2 AS DataController2,
  _BusinessPartner.DataController3 AS DataController3,
  _BusinessPartner.DataController4 AS DataController4,
  _BusinessPartner.DataController5 AS DataController5,
  _BusinessPartner.DataController6 AS DataController6,
  _BusinessPartner.DataController7 AS DataController7,
  _BusinessPartner.DataController8 AS DataController8,
  _BusinessPartner.DataController9 AS DataController9,
  _BusinessPartner.DataController10 AS DataController10
FROM but020 AS BusinessPartnerAddress
INNER JOIN but000 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON BusinessPartner = _BusinessPartner.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN I_Address_2 AS _Address ON AddressNumber = _Address.AddressID AND _Address.AddressRepresentationCode is initial AND PersonNumber = _Address.AddressPersonID  -- association [1..1]
LEFT OUTER JOIN I_BPProtectedAddress AS _BPProtectedAddress ON BusinessPartner = _BPProtectedAddress.BusinessPartner AND AddressNumber = _BPProtectedAddress.AddressID  -- association [0..1]
;