ESH_N_USER_USER_DETAILS

DDL: ESH_N_USER_USER_DETAILS SQL: ESH_L_USER_TAILS Type: view Package: SESH_SAP_BASIS_USER
12 Fields 1 Data Sources 4 Associations

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. Part of development package SESH_SAP_BASIS_USER.

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 Address Number
KEY persnumber persnumber Person Number
department department Department
function function Unit Func.
building building Building code
floor floor Floor
roomnumber roomnumber Room Number
ih_mail ih_mail Internal 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

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view ESH_N_USER_USER_DETAILS.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: ESH_L_USER_TAILS

CREATE VIEW ESH_N_USER_USER_DETAILS AS
SELECT
  addrnumber,
  persnumber,
  department,
  function,
  building,
  floor,
  roomnumber,
  ih_mail
FROM adcp
LEFT OUTER JOIN adr6 AS _TO_USER_EMAIL ON addrnumber = _TO_USER_EMAIL.addrnumber AND persnumber = _TO_USER_EMAIL.persnumber AND _TO_USER_EMAIL.flgdefault = 'X'  -- association [0..1]
LEFT OUTER JOIN adr3 AS _TO_USER_FAX ON addrnumber = _TO_USER_FAX.addrnumber AND persnumber = _TO_USER_FAX.persnumber AND _TO_USER_FAX.flgdefault = 'X'  -- association [0..1]
LEFT OUTER JOIN adr2 AS _TO_USER_MOBILE ON addrnumber = _TO_USER_MOBILE.addrnumber AND persnumber = _TO_USER_MOBILE.persnumber AND _TO_USER_MOBILE.r3_user = '3'  -- association [0..1]
LEFT OUTER JOIN adr2 AS _TO_USER_PHONE ON addrnumber = _TO_USER_PHONE.addrnumber AND persnumber = _TO_USER_PHONE.persnumber AND _TO_USER_PHONE.r3_user = '1'  -- association [0..1]
;

Learn More