ESH_N_COMPANY_ADDRESS_ADDRESS

-- Enterprise Search help view
-- This CDS view represents node COMPANY_ADDRESS of search model COMPANY_ADDRESS_H of search software component SAPAPPLH.
-- This CDS view represents: Company Address.
-- CSS component (relevant to Customer Incidents): BC-EIM-ESH
-- Package: SESH_SAP_BASIS_USER
-- Software Component: SAP_BASIS
@AbapCatalog.sqlViewName: 'ESH_L_COMPA_RESS'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.serviceQuality: #P
@ClientHandling.algorithm: #SESSION_VARIABLE
@ClientHandling.type: #INHERITED
@AbapCatalog.compiler.compareFilter: true
@EndUserText.label: 'Company Address'
define view ESH_N_COMPANY_ADDRESS_ADDRESS
as select from adrc

  association [0..1] to ESH_N_COMPANY_ADDRESS_ION_TEXT as _TO_REGION_TEXT           on $projection.country               = _TO_REGION_TEXT.land1                and
                                                                                       $projection.region                = _TO_REGION_TEXT.bland
  association [0..1] to adr6                           as _TO_COMPANY_STD_EMAIL     on $projection.addrnumber            = _TO_COMPANY_STD_EMAIL.addrnumber     and
                                                                                       _TO_COMPANY_STD_EMAIL.persnumber  = '          '                         and
                                                                                       _TO_COMPANY_STD_EMAIL.flgdefault  = 'X'
  association [0..1] to adr3                           as _TO_COMPANY_STD_FAX       on $projection.addrnumber            = _TO_COMPANY_STD_FAX.addrnumber       and
                                                                                       _TO_COMPANY_STD_FAX.persnumber    = '          '                         and
                                                                                       _TO_COMPANY_STD_FAX.flgdefault    = 'X'
  association [0..1] to adr2                           as _TO_COMPANY_STD_MOBILE    on $projection.addrnumber            = _TO_COMPANY_STD_MOBILE.addrnumber    and
                                                                                       _TO_COMPANY_STD_MOBILE.persnumber = '          '                         and
                                                                                       _TO_COMPANY_STD_MOBILE.r3_user    = '3'
  association [0..1] to adr2                           as _TO_COMPANY_STD_PHONE     on $projection.addrnumber            = _TO_COMPANY_STD_PHONE.addrnumber     and
                                                                                       _TO_COMPANY_STD_PHONE.persnumber  = '          '                         and
                                                                                       _TO_COMPANY_STD_PHONE.r3_user     = '1'
  association [0..*] to t005t                          as _TO_T005T                 on $projection.country               = _TO_T005T.land1
  association [0..*] to ESH_N_AD_TITLE_AD_TITLE        as _COMPANY_ADDRESS2AD_TITLE on $projection.title                 = _COMPANY_ADDRESS2AD_TITLE.DOMVALUE_L
  association [0..*] to ESH_N_LAND1_LAND1              as _COMPANY_ADDRESS2LAND1    on $projection.country               = _COMPANY_ADDRESS2LAND1.DOMVALUE_L

{
  key addrnumber,
  key date_from,
  key nation,
  date_to,
  title,
  name1,
  name2,
  city1,
  post_code1,
  po_box,
  street,
  house_num1,
  country,
  region,
  _TO_REGION_TEXT,
  _TO_COMPANY_STD_EMAIL,
  _TO_COMPANY_STD_FAX,
  _TO_COMPANY_STD_MOBILE,
  _TO_COMPANY_STD_PHONE,
  _TO_T005T,
  _COMPANY_ADDRESS2AD_TITLE,
  _COMPANY_ADDRESS2LAND1
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"ADRC"
],
"ASSOCIATED":
[
"ESH_N_AD_TITLE_AD_TITLE",
"ESH_N_COMPANY_ADDRESS_ION_TEXT",
"ESH_N_LAND1_LAND1",
"ADR2",
"ADR3",
"ADR6",
"T005T"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/