ESH_N_USER_USER_DETAILS

DDL: ESH_N_USER_USER_DETAILS SQL: ESH_L_USER_TAILS Type: view

ESH View for User Details

ESH_N_USER_USER_DETAILS is a CDS View that provides data about "ESH View for User Details" in SAP S/4HANA. It reads from 1 data source (adcp) and exposes 12 fields with key fields addrnumber, persnumber. It has 4 associations to related views.

1 data source(s) 12 fields

Data Sources (1)

SourceAliasJoin Type
adcp adcp from

Associations (4)

CardinalityTargetAliasCondition
[0..1] adr6 _TO_USER_EMAIL $projection.addrnumber = _TO_USER_EMAIL.addrnumber and $projection.persnumber = _TO_USER_EMAIL.persnumber and _TO_USER_EMAIL.flgdefault = 'X'
[0..1] adr3 _TO_USER_FAX $projection.addrnumber = _TO_USER_FAX.addrnumber and $projection.persnumber = _TO_USER_FAX.persnumber and _TO_USER_FAX.flgdefault = 'X'
[0..1] adr2 _TO_USER_MOBILE $projection.addrnumber = _TO_USER_MOBILE.addrnumber and $projection.persnumber = _TO_USER_MOBILE.persnumber and _TO_USER_MOBILE.r3_user = '3'
[0..1] adr2 _TO_USER_PHONE $projection.addrnumber = _TO_USER_PHONE.addrnumber and $projection.persnumber = _TO_USER_PHONE.persnumber and _TO_USER_PHONE.r3_user = '1'

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName ESH_L_USER_TAILS view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #P view
ClientHandling.algorithm #SESSION_VARIABLE view
ClientHandling.type #INHERITED view
AbapCatalog.compiler.compareFilter true view
EndUserText.label ESH View for User Details view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY addrnumber addrnumber
KEY persnumber persnumber
department department
function function
building building
floor floor
roomnumber roomnumber
ih_mail ih_mail
_TO_USER_EMAIL _TO_USER_EMAIL
_TO_USER_FAX _TO_USER_FAX
_TO_USER_MOBILE _TO_USER_MOBILE
_TO_USER_PHONE _TO_USER_PHONE 
-- Enterprise Search help view
-- This CDS view represents node USER_DETAILS of search model USER_H of search software component SAPAPPLH.
-- This CDS view represents: User Details.
-- CSS component (relevant to Customer Incidents): BC-EIM-ESH
-- Package: SESH_SAP_BASIS_USER
-- Software Component: SAP_BASIS
@AbapCatalog.sqlViewName: 'ESH_L_USER_TAILS'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.serviceQuality: #P
@ClientHandling.algorithm: #SESSION_VARIABLE
@ClientHandling.type: #INHERITED
@AbapCatalog.compiler.compareFilter: true
@EndUserText.label: 'ESH View for User Details'
define view ESH_N_USER_USER_DETAILS
as select from adcp

  association [0..1] to adr6 as _TO_USER_EMAIL  on $projection.addrnumber    = _TO_USER_EMAIL.addrnumber  and
                                                   $projection.persnumber    = _TO_USER_EMAIL.persnumber  and
                                                   _TO_USER_EMAIL.flgdefault = 'X'
  association [0..1] to adr3 as _TO_USER_FAX    on $projection.addrnumber    = _TO_USER_FAX.addrnumber    and
                                                   $projection.persnumber    = _TO_USER_FAX.persnumber    and
                                                   _TO_USER_FAX.flgdefault   = 'X'
  association [0..1] to adr2 as _TO_USER_MOBILE on $projection.addrnumber    = _TO_USER_MOBILE.addrnumber and
                                                   $projection.persnumber    = _TO_USER_MOBILE.persnumber and
                                                   _TO_USER_MOBILE.r3_user   = '3'
  association [0..1] to adr2 as _TO_USER_PHONE  on $projection.addrnumber    = _TO_USER_PHONE.addrnumber  and
                                                   $projection.persnumber    = _TO_USER_PHONE.persnumber  and
                                                   _TO_USER_PHONE.r3_user    = '1'

{
  key addrnumber,
  key persnumber,
  department,
  function,
  building,
  floor,
  roomnumber,
  ih_mail,
  _TO_USER_EMAIL,
  _TO_USER_FAX,
  _TO_USER_MOBILE,
  _TO_USER_PHONE
}

Learn More