I_ScriptedPersonAddress

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_ScriptedPersonAddress.
-- 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: ISCRPTPRSNADDR

CREATE VIEW I_ScriptedPersonAddress AS
SELECT
  adcp.addrnumber AS AddressNumber,
  adrp.nation AS AddressRepresentationCode,
  adrp.persnumber AS Person,
  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,
  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,
  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,
  adrp.title AS FormOfAddress,
  adrp.sort1 AS SearchTerm1,
  adrp.sort2 AS SearchTerm2,
  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.title_sppl AS BusinessPartnerSupplementName,
  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 adrp
INNER JOIN adcp ON /* join condition not captured in parsed metadata */
INNER JOIN adrc ON /* join condition not captured in parsed metadata */
;