P_UserWorkItems

DDL: P_USERWORKITEMS SQL: PUSERWORKITEMS Type: view BASIC Package: ODATA_BANK_PAYMENT_APPROVAL

Current Work Items Assigned to a User

P_UserWorkItems is a Basic CDS View that provides data about "Current Work Items Assigned to a User" in SAP S/4HANA. It reads from 1 data source (swwuserwi) and exposes 6 fields. Part of development package ODATA_BANK_PAYMENT_APPROVAL.

1 data source(s) 6 fields

Data Sources (1)

SourceAliasJoin Type
swwuserwi UserWorkItems from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PUSERWORKITEMS view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
VDM.viewType #BASIC view
VDM.private true view

Fields (6)

KeyFieldSource TableSource FieldDescription
UserID
WorkItem
ObjectType
EntryIsNotRelevantToSel
WorkItemIsNotExecutedByUser
WorkItemIsForwarded 
@AbapCatalog.sqlViewName: 'PUSERWORKITEMS'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED

@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL

@VDM.viewType: #BASIC
@VDM.private: true

define view P_UserWorkItems as select from swwuserwi as UserWorkItems{
    cast(user_id    as xubname)    as UserID,
    cast(wi_id      as sww_wiid)   as WorkItem,  
    cast(task_obj   as otjid)      as ObjectType,  
    cast(no_sel     as hr_no_sel)  as EntryIsNotRelevantToSel, 
    cast(no_execute as wi_no_exec) as WorkItemIsNotExecutedByUser,  
    cast(forward    as hr_forward) as WorkItemIsForwarded 
    
}

Learn More