ATOV_USER_ASSIGNMENT

CDS View

ATO: User Assignment

ATOV_USER_ASSIGNMENT is a CDS View in S/4HANA. ATO: User Assignment. 2 CDS views read from this table.

Used by 2 CDS view(s)

CDS Views using this table (2)

ViewTypeJoinVDMDescription
ATOV_BUSINESS_USER view left_outer ATO: Business User
ATOV_BUSINESS_USER_BASE1 view left_outer ATO: Basic View for Business User 
@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