ATOV_BUSINESS_USER_BASE1

DDL: ATOV_BUSINESS_USER_BASE1 SQL: ATOV_BUS_USERB1 Type: view Package: S_ATO_NAMESPACE_HANDLING

ATO: Basic View for Business User

ATOV_BUSINESS_USER_BASE1 is a CDS View that provides data about "ATO: Basic View for Business User" in SAP S/4HANA. It reads from 2 data sources (ATOV_USER_ASSIGNMENT, ATOV_BUSINESS_USER_BASE) and exposes 7 fields with key fields namespace, user_id. Part of development package S_ATO_NAMESPACE_HANDLING.

2 data source(s) 7 fields

Data Sources (2)

SourceAliasJoin Type
ATOV_USER_ASSIGNMENT assigned_user left_outer
ATOV_BUSINESS_USER_BASE user_base from

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName ATOV_BUS_USERB1 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 (7)

KeyFieldSource TableSource FieldDescription
KEY namespace ATOV_BUSINESS_USER_BASE dev_prefix
KEY user_id ATOV_BUSINESS_USER_BASE UserID
person_id ATOV_BUSINESS_USER_BASE BusinessPartner
last_name ATOV_BUSINESS_USER_BASE LastName
first_name ATOV_BUSINESS_USER_BASE FirstName
full_name ATOV_BUSINESS_USER_BASE PersonFullName
user_alias ATOV_BUSINESS_USER_BASE useralias 
@AbapCatalog.sqlViewName: 'ATOV_BUS_USERB1'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_ALLOWED
@EndUserText.label: 'ATO: Basic View for Business User'
define view ATOV_BUSINESS_USER_BASE1 as select from ATOV_BUSINESS_USER_BASE as user_base

left outer join ATOV_USER_ASSIGNMENT as assigned_user on
   assigned_user.namespace = user_base.dev_prefix and
   assigned_user.user_id = user_base.UserID 
   
   
{
  key user_base.dev_prefix              as namespace,
  key user_base.UserID                  as user_id,
      user_base.BusinessPartner         as person_id,
      user_base.LastName                as last_name,
      user_base.FirstName               as first_name,
      user_base.PersonFullName          as full_name,
      user_base.useralias               as user_alias,               
      
 case coalesce( assigned_user.user_id, '' ) when ''
     then ''
     else 'X'
 end as user_already_assigned         
}

Learn More