ATOV_USER_ASSIGNMENT

DDL: ATOV_USER_ASSIGNMENT SQL: ATOV_USER_ASGN Type: view

ATO: User Assignment

ATOV_USER_ASSIGNMENT is a CDS View that provides data about "ATO: User Assignment" in SAP S/4HANA. It reads from 2 data sources (usr05, usrefus) and exposes 6 fields with key field user_id. It has 2 associations to related views.

2 data source(s) 6 fields

Data Sources (2)

SourceAliasJoin Type
usr05 parameters from
usrefus useralias inner

Associations (2)

CardinalityTargetAliasCondition
[0..1] ATOV_USER _user _user.name = parameters.bname
[0..1] I_BusinessUserVH _business_user _business_user.UserID = parameters.bname

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName ATOV_USER_ASGN view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_ALLOWED view
EndUserText.label ATO: User Assignment view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY user_id usr05 bname
user_alias usrefus useralias
namespace parva
person_id _business_user BusinessPartner
first_name _business_user FirstName
last_name _business_user LastName 
@AbapCatalog.sqlViewName: 'ATOV_USER_ASGN'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_ALLOWED
@EndUserText.label: 'ATO: User Assignment'
define view ATOV_USER_ASSIGNMENT
  as select from usr05   as parameters

    inner join   usrefus as useralias on parameters.bname = useralias.bname

  association [0..1] to ATOV_USER        as _user          on _user.name = parameters.bname
  association [0..1] to I_BusinessUserVH as _business_user on _business_user.UserID = parameters.bname
{
  key parameters.bname                                as user_id,
      useralias.useralias                           as user_alias,
      parva                                         as namespace,
      coalesce( _user.description, parameters.bname ) as user_description,
      _business_user.BusinessPartner                as person_id,
      _business_user.FirstName                      as first_name,
      _business_user.LastName                       as last_name

}
where
  parameters.parid = 'ATO_DEV_PREFIX'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"ATOV_USER",
"I_BUSINESSUSERVH",
"USR05",
"USREFUS"
],
"ASSOCIATED":
[
"ATOV_USER",
"I_BUSINESSUSERVH"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More