Which tables does ESH_N_USER_USER use?

ESH_N_USER_USER reads from 1 data source(s): usr21.

How many fields does ESH_N_USER_USER have?

ESH_N_USER_USER has 6 fields. Key fields: bname.

ESH_N_USER_USER

DDL: ESH_N_USER_USER SQL: ESH_L_USER_USER Type: view

SAP User

ESH_N_USER_USER is a CDS View that provides data about "SAP User" in SAP S/4HANA. It reads from 1 data source (usr21) and exposes 6 fields with key field bname. It has 3 associations to related views.

Data Sources (1)

Source	Alias	Join Type
usr21	usr21	from

Associations (3)

Cardinality	Target	Alias	Condition
[1..1]	ESH_N_USER_USER_NAME	_TO_USER_NAME	`$projection.persnumber = _TO_USER_NAME.persnumber`
[1..1]	adcp	_TO_USER_DETAILS	`$projection.persnumber = _TO_USER_DETAILS.persnumber and $projection.addrnumber = _TO_USER_DETAILS.addrnumber`
[0..*]	ESH_N_COMPANY_ADDRESS_ADDRESS	_USER2COMPANY_ADDRESS	`$projection.addrnumber = _USER2COMPANY_ADDRESS.ADDRNUMBER`

Annotations (7)

Name	Value	Level
AbapCatalog.sqlViewName	ESH_L_USER_USER	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	SAP User	view

Fields (6)

Key	Field	Source Field
KEY	bname	bname
	persnumber	persnumber
	addrnumber	addrnumber
	_TO_USER_NAME	_TO_USER_NAME
	_TO_USER_DETAILS	_TO_USER_DETAILS
	_USER2COMPANY_ADDRESS	_USER2COMPANY_ADDRESS

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

  association [1..1] to ESH_N_USER_USER_NAME          as _TO_USER_NAME         on $projection.persnumber = _TO_USER_NAME.persnumber
  association [1..1] to adcp                          as _TO_USER_DETAILS      on $projection.persnumber = _TO_USER_DETAILS.persnumber      and
                                                                                  $projection.addrnumber = _TO_USER_DETAILS.addrnumber
  association [0..*] to ESH_N_COMPANY_ADDRESS_ADDRESS as _USER2COMPANY_ADDRESS on $projection.addrnumber = _USER2COMPANY_ADDRESS.ADDRNUMBER

{
  key bname,
  persnumber,
  addrnumber,
  _TO_USER_NAME,
  _TO_USER_DETAILS,
  _USER2COMPANY_ADDRESS
}

Depth:

ESH_N_USER_USER view

usr21