P_UserWorkItems

DDL: P_USERWORKITEMS SQL: PUSERWORKITEMS Type: view BASIC Package: ODATA_BANK_PAYMENT_APPROVAL
6 Fields 1 Data Sources

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.

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 User Scope
WorkItem WorkItem ID
ObjectType Task
EntryIsNotRelevantToSel Not relevant
WorkItemIsNotExecutedByUser No execution
WorkItemIsForwarded Forwarded

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view P_UserWorkItems.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: PUSERWORKITEMS

CREATE VIEW P_UserWorkItems AS
SELECT
  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
FROM swwuserwi AS UserWorkItems
;

Learn More