I_TaskOwners

DDL: I_TASKOWNERS Type: view_entity

Task Owners

I_TaskOwners is a CDS View that provides data about "Task Owners" in SAP S/4HANA. It reads from 2 data sources (SUSR_USERS_FOR_OBJECT_ACTVT, I_User) and exposes 2 fields with key field TransportRequestTaskOwner.

2 data source(s) 2 fields

Data Sources (2)

SourceAliasJoin Type
SUSR_USERS_FOR_OBJECT_ACTVT SUSR_USERS_FOR_OBJECT_ACTVT inner
I_User User inner

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Task Owners view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY TransportRequestTaskOwner I_User UserID
UserDescriptionendasUserDescription 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Task Owners'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #S,
  dataClass: #MIXED
}
define view entity I_TaskOwners
  as select distinct from SUSR_USERS_FOR_OBJECT_FIELD(p_auth_object: 'S_TRANSPRT',
                                                      p_auth_field : 'TTYPE',
                                                      p_auth_value : 'TASK') as Task

    inner join            SUSR_USERS_FOR_OBJECT_ACTVT(p_auth_object: 'S_TRANSPRT',
                                                      p_activity   : '02')   as Activity on Task.bname = Activity.bname

    inner join            I_User                                             as User     on Task.bname = User.UserID
{
  key User.UserID                                                          as TransportRequestTaskOwner,
      case when User.UserDescription is null then User.UserID
      when User.UserDescription = ''         then User.UserID
                                             else User.UserDescription end as UserDescription

}

Learn More