P_OrganizationAddressConsum

@AbapCatalog.sqlViewName: 'PORGADDRCONS'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #CONSUMPTION
@VDM.private: true

define view P_OrganizationAddressConsum as select from adrc {
  adrc.client, 
  adrc.addrnumber, 
  adrc.date_from, 
  adrc.nation, 
  adrc.date_to, 
  adrc.title, 
  adrc.name1, 
  adrc.name2, 
  adrc.name3, 
  adrc.name4, 
  adrc.name_text, 
  adrc.name_co, 
  adrc.city1, 
  adrc.city2, 
  adrc.city_code, 
  adrc.cityp_code, 
  adrc.home_city, 
  adrc.cityh_code, 
  adrc.chckstatus, 
  adrc.regiogroup, 
  adrc.post_code1, 
  adrc.post_code2, 
  adrc.post_code3, 
  adrc.pcode1_ext, 
  adrc.pcode2_ext, 
  adrc.pcode3_ext, 
  adrc.po_box, 
  adrc.dont_use_p, 
  adrc.po_box_num, 
  adrc.po_box_loc, 
  adrc.city_code2, 
  adrc.po_box_reg, 
  adrc.po_box_cty, 
  adrc.postalarea, 
  adrc.transpzone, 
  adrc.street, 
  adrc.dont_use_s, 
  adrc.streetcode, 
  adrc.streetabbr, 
  adrc.house_num1, 
  adrc.house_num2, 
  adrc.house_num3, 
  adrc.str_suppl1, 
  adrc.str_suppl2, 
  adrc.str_suppl3, 
  adrc.location, 
  adrc.building, 
  adrc.floor, 
  adrc.roomnumber, 
  adrc.country, 
  adrc.langu, 
  adrc.region, 
  adrc.addr_group, 
  adrc.flaggroups, 
  adrc.pers_addr, 
  adrc.sort1, 
  adrc.sort2, 
  adrc.sort_phn, 
  adrc.deflt_comm, 
  adrc.tel_number, 
  adrc.tel_extens, 
  adrc.fax_number, 
  adrc.fax_extens, 
  adrc.flagcomm2, 
  adrc.flagcomm3, 
  adrc.flagcomm4, 
  adrc.flagcomm5, 
  adrc.flagcomm6, 
  adrc.flagcomm7, 
  adrc.flagcomm8, 
  adrc.flagcomm9, 
  adrc.flagcomm10, 
  adrc.flagcomm11, 
  adrc.flagcomm12, 
  adrc.flagcomm13, 
  adrc.addrorigin, 
  adrc.mc_name1, 
  adrc.mc_city1, 
  adrc.mc_street, 
  adrc.extension1, 
  adrc.extension2, 
  adrc.time_zone, 
  adrc.taxjurcode, 
  adrc.address_id, 
  adrc.langu_crea, 
  adrc.adrc_uuid, 
  adrc.uuid_belated, 
  adrc.id_category, 
  adrc.adrc_err_status, 
  adrc.po_box_lobby, 
  adrc.deli_serv_type, 
  adrc.deli_serv_number, 
  adrc.county_code, 
  adrc.county, 
  adrc.township_code, 
  adrc.township, 
  adrc.mc_county, 
  adrc.mc_township, 
  adrc.xpcpt, 
  adrc._dataaging, 
  adrc.duns, 
  adrc.dunsp4,
  
  
  rtrim(
    ltrim(
      concat_with_space(
          concat_with_space(  
              concat_with_space(adrc.name1, adrc.name2, 1),   
          adrc.name3, 1), 
      adrc.name4, 1), 
    ' '), 
  ' ') as OrganizationName
  
}