I_BusPartScriptedPersAddrProc

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_BusPartScriptedPersAddrProc.
-- 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.

CREATE VIEW I_BusPartScriptedPersAddrProc 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,
  but_adrp_prc.nation AS AddressRepresentationCode,
  but_adrp_prc.persnumber AS Person,
  but020_prc.partner AS BusinessPartner,
  but020_prc.xdfadr AS StandardUsage,
  but020_prc.address_guid AS BusinessPartnerAddressUUID,
  but020_prc.addr_valid_from AS ValidityStartDate,
  but020_prc.addr_valid_to AS ValidityEndDate,
  but_adrp_prc.title AS FormOfAddress,
  but_adrp_prc.sort1 AS SearchTerm1,
  but_adrp_prc.sort2 AS SearchTerm2,
  but_adrp_prc.name_first AS FirstName,
  but_adrp_prc.name_last AS LastName,
  but_adrp_prc.name2 AS BusinessPartnerBirthName,
  but_adrp_prc.namemiddle AS MiddleName,
  but_adrp_prc.name_last2 AS AdditionalLastName,
  but_adrp_prc.name_text AS PersonFullName,
  but_adrp_prc.title_aca1 AS AcademicTitle,
  but_adrp_prc.title_aca2 AS AcademicTitle2,
  but_adrp_prc.prefix1 AS LastNamePrefix,
  but_adrp_prc.prefix2 AS LastNameSecondPrefix,
  but_adrp_prc.title_sppl AS BusinessPartnerSupplementName,
  but_adrp_prc.nickname AS BusinessPartnerNicknameLabel,
  but_adrp_prc.initials AS Initials,
  but_adrp_prc.nameformat AS NameFormat,
  but_adrp_prc.namcountry AS NameCountry,
  but_adrp_prc.mc_namefir AS BPFirstNameSearchHelp,
  but_adrp_prc.mc_namelas AS BPLastNameSearchHelp,
  cast(concat_with_space( but_adrp_prc.name_first, but_adrp_prc.name_last,1) as bu_name1tx ) as FullName AS name_last1asbu_name1txasFullName,
  but_adrc_prc.city1 AS CityName,
  but_adrc_prc.city2 AS DistrictName,
  but_adrc_prc.city_code AS CityNumber,
  but_adrc_prc.home_city AS HomeCityName,
  but_adrc_prc.chckstatus AS CityFileTestStatus,
  but_adrc_prc.post_code1 AS PostalCode,
  but_adrc_prc.post_code2 AS POBoxPostalCode,
  but_adrc_prc.post_code3 AS CompanyPostalCode,
  but_adrc_prc.po_box AS POBox,
  but_adrc_prc.dont_use_p AS AddressPostBoxUnusable,
  but_adrc_prc.po_box_num AS POBoxIsWithoutNumber,
  but_adrc_prc.po_box_loc AS POBoxDeviatingCityName,
  but_adrc_prc.po_box_reg AS POBoxDeviatingRegion,
  but_adrc_prc.po_box_cty AS POBoxDeviatingCountry,
  but_adrc_prc.transpzone AS TransportZone,
  but_adrc_prc.street AS StreetName,
  but_adrc_prc.dont_use_s AS AddressStreetUnusable,
  but_adrc_prc.house_num1 AS HouseNumber,
  but_adrc_prc.house_num2 AS HouseNumberSupplementText,
  but_adrc_prc.str_suppl1 AS StreetPrefixName,
  but_adrc_prc.str_suppl2 AS AdditionalStreetPrefixName,
  but_adrc_prc.str_suppl3 AS StreetSuffixName,
  but_adrc_prc.location AS AdditionalStreetSuffixName,
  but_adrc_prc.building AS Building,
  but_adrc_prc.floor AS Floor,
  but_adrc_prc.roomnumber AS RoomNumber,
  but_adrc_prc.country AS Country,
  but_adrc_prc.langu AS CorrespondenceLanguage,
  but_adrc_prc.region AS Region,
  but_adrc_prc.deflt_comm AS PrfrdCommMediumType,
  but_adrc_prc.tel_number AS PhoneNumber,
  but_adrc_prc.fax_number AS AddressFaxNumber,
  but_adrc_prc.mc_city1 AS CitySearch,
  but_adrc_prc.mc_street AS StreetSearch,
  but_adrc_prc.time_zone AS AddressTimeZone,
  but_adrc_prc.taxjurcode AS TaxJurisdiction,
  but_adrc_prc.po_box_lobby AS POBoxLobbyName,
  but_adrc_prc.deli_serv_type AS DeliveryServiceTypeCode,
  but_adrc_prc.deli_serv_number AS DeliveryServiceNumber,
  but_adrc_prc.county_code AS CountyCode,
  but_adrc_prc.county AS BPCountyText,
  but_adrc_prc.name_co AS CareOfName,
  but_adrc_prc.dont_use_s AS AddressNonDeliverableReason,
  but_adrc_prc.dont_use_p AS PostBoxNonDeliverableReason,
  but_adrc_prc.source_modified AS MDChgProcessSourceModified,
  but_adrc_prc.source_modification_blip AS MDChgProcessSourceModifBinary,
  but020_prc.source_modification_blip AS MDChgProcessSourceModif2Binary,
  but_adrp_prc.source_modification_blip AS MDChgProcessSourceModif3Binary,
  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]
;