ESH_N_USER_USER_NAME

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

  association [0..1] to adr6                      as _TO_USER_STANDARD_EMAIL  on $projection.persnumber             = _TO_USER_STANDARD_EMAIL.persnumber  and
                                                                                 _TO_USER_STANDARD_EMAIL.flgdefault = 'X'
  association [0..1] to adr3                      as _TO_USER_STANDARD_FAX    on $projection.persnumber             = _TO_USER_STANDARD_FAX.persnumber    and
                                                                                 _TO_USER_STANDARD_FAX.flgdefault   = 'X'
  association [0..1] to adr2                      as _TO_USER_STANDARD_MOBILE on $projection.persnumber             = _TO_USER_STANDARD_MOBILE.persnumber and
                                                                                 _TO_USER_STANDARD_MOBILE.r3_user   = '3'
  association [0..1] to adr2                      as _TO_USER_STANDARD_PHONE  on $projection.persnumber             = _TO_USER_STANDARD_PHONE.persnumber  and
                                                                                 _TO_USER_STANDARD_PHONE.r3_user    = '1'
  association [0..*] to ESH_N_AD_TITLE_AD_TITLE   as _USER_NAME2AD_TITLE      on $projection.title                  = _USER_NAME2AD_TITLE.DOMVALUE_L
  association [0..*] to ESH_N_AD_TITLE1_AD_TITLE1 as _USER_NAME2AD_TITLE1     on $projection.title_aca1             = _USER_NAME2AD_TITLE1.DOMVALUE_L

{
  key persnumber,
  title,
  name_first,
  name_last,
  name_text,
  title_aca1,
  profession,
  _TO_USER_STANDARD_EMAIL,
  _TO_USER_STANDARD_FAX,
  _TO_USER_STANDARD_MOBILE,
  _TO_USER_STANDARD_PHONE,
  _USER_NAME2AD_TITLE,
  _USER_NAME2AD_TITLE1
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"ADRP"
],
"ASSOCIATED":
[
"ESH_N_AD_TITLE1_AD_TITLE1",
"ESH_N_AD_TITLE_AD_TITLE",
"ADR2",
"ADR3",
"ADR6"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/