I_ScriptedOrganizationAddress

@AbapCatalog.sqlViewName: 'ISCRPTORGADDR'
@AbapCatalog.preserveKey:true
@AbapCatalog.compiler.compareFilter:true
//@Analytics : {dataCategory: #DIMENSION}

@AccessControl.authorizationCheck:#PRIVILEGED_ONLY
@VDM.viewType: #BASIC
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.representativeKey: 'AddressNumber'
@Metadata.allowExtensions:true
@EndUserText.label: 'Interational Address Version'
define view I_ScriptedOrganizationAddress
  as select from    adrc
// filteer needed to have only ADRC entries that are not included in ADCP

{
  key adrc.addrnumber   as AddressNumber,
  key adrc.nation       as AddressRepresentationCode,

      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 AddressNonDeliverableReason,
      adrc.dont_use_p   as PostBoxNonDeliverableReason,

      cast(substring(replace(concat(name1, concat(' &@', adrc.name2)), '&@', ''),1,80)
        as adfullname ) as FullName,

      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           as Country,
      region            as Region,
      county            as County,
      county_code       as CountyCode,

      title             as FormOfAddress,
      name1             as BusinessPartnerName1,
      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,
      adrc.sort1        as SearchTerm1,
      adrc.sort2        as SearchTerm2,

      taxjurcode        as TaxJurisdiction,
      transpzone        as TransportZone,
      city_code2        as AddressCityPostBoxCode
}
where
      adrc.date_from = '00010101'
  and adrc.nation != ' '

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"ADRC"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/