I_BusinessPartnerAddressProc

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_BusinessPartnerAddressProc.
-- 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: IBPADDRPROC

CREATE VIEW I_BusinessPartnerAddressProc AS
SELECT
  but020_prc.process_id AS MasterDataChangeProcess,
  but020_prc.process_step_no AS MDChgProcessStep,
  but020_prc.source_system AS MDChgProcessSrceSystem,
  but020_prc.source_id AS MDChgProcessSrceObject,
  but020_prc.source_addrnumber AS AddressNumber,
  partner AS BusinessPartner,
  xdfadr AS StandardUsage,
  but020_prc.address_guid AS BusinessPartnerAddressUUID,
  addr_valid_from AS ValidityStartDate,
  addr_valid_to AS ValidityEndDate,
  title AS FormOfAddress,
  name1 AS BusinessPartnerName1,
  name2 AS BusinessPartnerName2,
  name3 AS BusinessPartnerName3,
  name4 AS BusinessPartnerName4,
  name_co AS CareOfName,
  city1 AS CityName,
  city2 AS DistrictName,
  city_code AS CityNumber,
  home_city AS HomeCityName,
  chckstatus AS CityFileTestStatus,
  post_code1 AS PostalCode,
  post_code2 AS POBoxPostalCode,
  post_code3 AS CompanyPostalCode,
  po_box AS POBox,
  dont_use_p AS AddressPostBoxUnusable,
  po_box_num AS POBoxIsWithoutNumber,
  po_box_loc AS POBoxDeviatingCityName,
  po_box_reg AS POBoxDeviatingRegion,
  po_box_cty AS POBoxDeviatingCountry,
  transpzone AS TransportZone,
  street AS StreetName,
  dont_use_s AS AddressStreetUnusable,
  house_num1 AS HouseNumber,
  house_num2 AS HouseNumberSupplementText,
  str_suppl1 AS StreetPrefixName,
  str_suppl2 AS AdditionalStreetPrefixName,
  str_suppl3 AS StreetSuffixName,
  location AS AdditionalStreetSuffixName,
  Building,
  Floor,
  RoomNumber,
  Country,
  langu AS CorrespondenceLanguage,
  Region,
  sort1 AS SearchTerm1,
  sort2 AS SearchTerm2,
  deflt_comm AS PrfrdCommMediumType,
  tel_number AS PhoneNumber,
  fax_number AS AddressFaxNumber,
  mc_city1 AS CitySearch,
  mc_street AS StreetSearch,
  time_zone AS AddressTimeZone,
  taxjurcode AS TaxJurisdiction,
  po_box_lobby AS POBoxLobbyName,
  deli_serv_type AS DeliveryServiceTypeCode,
  deli_serv_number AS DeliveryServiceNumber,
  county_code AS CountyCode,
  county AS BPCountyText,
  but_adrc_prc.source_modified AS MDChgProcessSourceModified,
  but_adrc_prc.source_modification_blip AS MDChgProcessSourceModifBinary,
  but020_prc.source_modification_blip AS MDChgProcessSourceModif2Binary,
  but_adrc_prc.source_recency AS MDChgProcSrceLastChgdDateTime
FROM but020_prc
LEFT OUTER JOIN I_BusinessPartnerProcess AS _BusinessPartner ON but020_prc.process_id = _BusinessPartner.MasterDataChangeProcess AND but020_prc.process_step_no = _BusinessPartner.MDChgProcessStep AND but020_prc.source_system = _BusinessPartner.MDChgProcessSrceSystem AND but020_prc.source_id = _BusinessPartner.MDChgProcessSrceObject  -- association [1..1]
LEFT OUTER JOIN I_BusPartProtectedAddressProc AS _BPProtectedAddress ON but020_prc.process_id = _BPProtectedAddress.MasterDataChangeProcess AND but020_prc.process_step_no = _BPProtectedAddress.MDChgProcessStep AND but020_prc.source_system = _BPProtectedAddress.MDChgProcessSrceSystem AND but020_prc.source_id = _BPProtectedAddress.MDChgProcessSrceObject AND but020_prc.source_addrnumber = _BPProtectedAddress.AddressNumber  -- association [0..1]
;