ATOV_BUSINESS_USER

DDL: ATOV_BUSINESS_USER SQL: ATOV_BUS_USER Type: view

ATO: Business User

ATOV_BUSINESS_USER is a CDS View that provides data about "ATO: Business User" in SAP S/4HANA. It reads from 3 data sources (ATOV_USER_ASSIGNMENT, I_BusinessUserVH, usrefus) and exposes 6 fields with key field user_id.

3 data source(s) 6 fields

Data Sources (3)

SourceAliasJoin Type
ATOV_USER_ASSIGNMENT assigned_namespace left_outer
I_BusinessUserVH business_user from
usrefus useralias inner

Annotations (5)

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

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY user_id UserID
person_id BusinessPartner
last_name LastName
first_name FirstName
full_name PersonFullName
user_alias usrefus useralias 
@AbapCatalog.sqlViewName: 'ATOV_BUS_USER'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_ALLOWED
@EndUserText.label: 'ATO: Business User'
define view ATOV_BUSINESS_USER
  as select from    I_BusinessUserVH     as business_user

    inner join      usrefus              as useralias          on business_user.UserID = useralias.bname

    left outer join ATOV_USER_ASSIGNMENT as assigned_namespace on assigned_namespace.user_id = business_user.UserID

{
  key UserID                                       as user_id,
      BusinessPartner                              as person_id,
      LastName                                     as last_name,
      FirstName                                    as first_name,
      PersonFullName                               as full_name,
      useralias.useralias                          as user_alias,
      coalesce( assigned_namespace.namespace, '' ) as assigned_namespace

}

//  as select from ATOV_BUSINESS_USER_BASE1

//

//  association [0..1] to ATOV_USER_ASSIGNMENT as _assigned_namespace on _assigned_namespace.user_id = $projection.user_id

//

//{

//  key namespace,

//  key user_id,

//  person_id,

//  last_name,

//  first_name,

//  full_name,

//  user_alias,

//  coalesce( _assigned_namespace.namespace, '' ) as assigned_namespace

//}

//where ATOV_BUSINESS_USER_BASE1.user_already_assigned <> 'X'

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"ATOV_USER_ASSIGNMENT",
"I_BUSINESSUSERVH",
"USREFUS"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More