I_ScriptedAddress

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_ScriptedAddress.
-- 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: ISCRPTEDADDR

CREATE VIEW I_ScriptedAddress AS
SELECT
  adrc.addrnumber AS AddressNumber,
  adrc.nation AS AddressRepresentationCode,
  name_co AS CareOfName,
  location AS AdditionalStreetSuffixName,
  adrc.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 AddressNonDeliverableReason,
  adrc.dont_use_p AS PostBoxNonDeliverableReason,
  cast(substring(replace(concat(name1, concat(' &', adrc.name2)), '&', ''),1,80) as adfullname ) as FullName AS name2180asadfullnameasFullName,
  city1 AS CityName,
  city2 AS District,
  city_code AS CityCode,
  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,
  county_code AS CountyCode,
  name1 AS BusinessPartnerName1,
  adrc.name2 AS BusinessPartnerName2,
  name3 AS BusinessPartnerName3,
  name4 AS BusinessPartnerName4,
  adrc.tel_number AS PhoneNumber,
  adrc.fax_number AS FaxNumber,
  mc_street AS StreetSearch,
  mc_city1 AS CitySearch,
  taxjurcode AS TaxJurisdiction,
  transpzone AS TransportZone,
  city_code2 AS AddressCityPostBoxCode,
  adcp.persnumber AS Person,
  case when adcp.persnumber is null then adrc.title else adrp.title end as FormOfAddress AS titleendasFormOfAddress,
  case when adcp.persnumber is null then adrc.sort1 else adrp.sort1 end as SearchTerm1 AS sort1endasSearchTerm1,
  case when adcp.persnumber is null then adrc.sort2 else adrp.sort2 end as SearchTerm2 AS sort2endasSearchTerm2,
  adrp.name_first AS FirstName,
  adrp.name_last AS LastName,
  adrp.name2 AS BusinessPartnerBirthName,
  adrp.namemiddle AS MiddleName,
  adrp.name_last2 AS AdditionalLastName,
  adrp.name_text AS PersonFullName,
  adrp.title_aca1 AS AcademicTitle,
  adrp.title_aca2 AS AcademicTitle2,
  adrp.prefix1 AS LastNamePrefix,
  adrp.prefix2 AS LastNameSecondPrefix,
  adrp.nickname AS BusinessPartnerNicknameLabel,
  adrp.initials AS Initials,
  adrp.nameformat AS NameFormat,
  adrp.namcountry AS NameCountry,
  adrp.mc_namefir AS BPFirstNameSearchHelp,
  adrp.mc_namelas AS BPLastNameSearchHelp
FROM adrc
LEFT OUTER JOIN adcp ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN adrp ON /* join condition not captured in parsed metadata */
;