ATOV_BUSINESS_USER_BASE

DDL: ATOV_BUSINESS_USER_BASE SQL: ATOV_BUS_USERB Type: view

ATO: Basic View for Business User

ATOV_BUSINESS_USER_BASE is a CDS View that provides data about "ATO: Basic View for Business User" in SAP S/4HANA. It reads from 6 data sources and exposes 13 fields with key fields dev_prefix, UserID, UserID.

6 data source(s) 13 fields

Data Sources (6)

SourceAliasJoin Type
I_BusinessUserVH business_user_base from
I_BusinessUserVH own_user_base union
ato_prefix_set prefix_setting inner
ato_prefix_set prefix_setting inner
usrefus useralias inner
usrefus useralias inner

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName ATOV_BUS_USERB view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_ALLOWED view
EndUserText.label ATO: Basic View for Business User view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY dev_prefix ato_prefix_set dev_prefix
KEY UserID I_BusinessUserVH UserID
BusinessPartner I_BusinessUserVH BusinessPartner
LastName I_BusinessUserVH LastName
FirstName I_BusinessUserVH FirstName
PersonFullName I_BusinessUserVH PersonFullName
dev_prefix
KEY UserID I_BusinessUserVH UserID
BusinessPartner I_BusinessUserVH BusinessPartner
LastName I_BusinessUserVH LastName
FirstName I_BusinessUserVH FirstName
PersonFullName I_BusinessUserVH PersonFullName
useralias usrefus useralias 
@AbapCatalog.sqlViewName: 'ATOV_BUS_USERB'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_ALLOWED
@EndUserText.label: 'ATO: Basic View for Business User'
define view ATOV_BUSINESS_USER_BASE as select from I_BusinessUserVH as business_user_base

// all users

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

inner join ato_prefix_set as prefix_setting on prefix_setting.category = prefix_setting.category
  
{
  key prefix_setting.dev_prefix,
  key business_user_base.UserID,
      business_user_base.BusinessPartner,
      business_user_base.LastName,
      business_user_base.FirstName,
      business_user_base.PersonFullName,
      useralias.useralias     
}
where UserID <> $session.user

// own user

union select from I_BusinessUserVH as own_user_base

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

inner join ato_prefix_set as prefix_setting on prefix_setting.category = prefix_setting.category
  
{
  key prefix_setting.dev_prefix,
  key own_user_base.UserID,
      own_user_base.BusinessPartner,
      own_user_base.LastName,
      own_user_base.FirstName,
      own_user_base.PersonFullName,
      useralias.useralias     
}
where UserID = $session.user

// own internal Support User SAP* => TOBE SECURED by DCL

//union select from I_User as support_user

//

//inner join usrefus as useralias on support_user.UserID = useralias.bname

//

//inner join ato_prefix_set as prefix_setting on prefix_setting.category = prefix_setting.category

//

//{  

//  key prefix_setting.dev_prefix,

//  key support_user.UserID,

//  '' as BusinessPartner,

//  '' as LastName,

//  '' as FirstName,

//   support_user.UserDescription as PersonFullName,

//   useralias.useralias

//}

//

//where UserID = $session.user and

//      IsTechnicalUser = 'X' 

//

//

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

Learn More