I_BusinessPartnerAddress_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_BusinessPartnerAddress_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: IBPADDRESS2

CREATE VIEW I_BusinessPartnerAddress_2 AS
SELECT
  but020.client AS mandt,
  but020.partner AS BusinessPartner,
  but020.addrnumber AS AddressNumber,
  but020.addr_valid_from AS ValidityStartDate,
  but020.addr_valid_to AS ValidityEndDate,
  but020.address_guid AS BusinessPartnerAddressUUID,
  name_co AS CareOfName,
  location AS AdditionalStreetSuffixName,
  langu AS CorrespondenceLanguage,
  adrc.deflt_comm AS PrfrdCommMediumType,
  po_box AS POBox,
  po_box_num AS POBoxIsWithoutNumber,
  post_code2 AS POBoxPostalCode,
  po_box_lobby AS POBoxLobbyName,
  po_box_loc AS POBoxDeviatingCityName,
  po_box_reg AS POBoxDeviatingRegion,
  po_box_cty AS POBoxDeviatingCountry,
  deli_serv_type AS DeliveryServiceTypeCode,
  deli_serv_number AS DeliveryServiceNumber,
  time_zone AS AddressTimeZone,
  adrc.chckstatus AS CityFileTestStatus,
  adrc.dont_use_s AS AddressStreetUnusable,
  adrc.dont_use_p AS AddressPostBoxUnusable,
  cast(substring(replace(concat(name1, concat(' &', name2)), '&', ''),1,80) as adfullname ) AS FullName,
  city1 AS CityName,
  city2 AS DistrictName,
  city_code AS CityNumber,
  home_city AS HomeCityName,
  post_code1 AS PostalCode,
  post_code3 AS CompanyPostalCode,
  street AS StreetName,
  str_suppl1 AS StreetPrefixName,
  str_suppl2 AS AdditionalStreetPrefixName,
  str_suppl3 AS StreetSuffixName,
  house_num1 AS HouseNumber,
  house_num2 AS HouseNumberSupplementText,
  adrc.building AS Building,
  adrc.floor AS Floor,
  adrc.roomnumber AS RoomNumber,
  Country,
  Region,
  county AS BPCountyText,
  county_code AS CountyCode,
  township_code AS TownshipCode,
  township AS TownshipName,
  title AS FormOfAddress,
  name1 AS BusinessPartnerName1,
  name2 AS BusinessPartnerName2,
  adrc.nation AS Nation,
  adrc.tel_number AS PhoneNumber,
  adrc.fax_number AS AddressFaxNumber,
  adrc.sort1 AS SearchTerm1,
  adrc.sort2 AS SearchTerm2,
  mc_street AS StreetSearch,
  mc_city1 AS CitySearch,
  name3 AS BusinessPartnerName3,
  name4 AS BusinessPartnerName4,
  taxjurcode AS TaxJurisdiction,
  transpzone AS TransportZone,
  city_code2 AS AddressCityPostBoxCode,
  adcp.persnumber AS Person
FROM but020
;