I_WorkflowTaskApplObject

DDL: I_WORKFLOWTASKAPPLOBJECT Type: view BASIC

Application object of work items

I_WorkflowTaskApplObject is a Basic CDS View that provides data about "Application object of work items" in SAP S/4HANA. It reads from 1 data source (sww_wi2obj) and exposes 14 fields with key field WorkflowTaskObject.

Data Sources (1)

SourceAliasJoin Type
sww_wi2obj sww_wi2obj from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IWFTASKOBJECT view
AbapCatalog.buffering.type #NONE view
EndUserText.label Application object of work items view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #META view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY WorkflowTaskObject UUID 22 char.
WorkflowObjectRole wi_reltype Type of Relation
WorkflowTaskInternalID wi_id WorkItem ID
TopLevelWorkflowTask top_wi_id Top Level Workflow
TechnicalWrkflwObjectCategory catid Vendor Category ID
TechnicalWrkflwObjectType typeid Trans Doc Ty ID
TechnicalWrkflwObject instid Instance ID
SAPObjectNodeRepresentation sont SAP Obj Node Type
SAPBusinessObjectNodeKey1 sont_key_part_1 SONT partial key 1
SAPBusinessObjectNodeKey2 sont_key_part_2 SONT partial key 2
SAPBusinessObjectNodeKey3 sont_key_part_3 SONT partial key 3
SAPBusinessObjectNodeKey4 sont_key_part_4 SONT partial key 4
SAPBusinessObjectNodeKey5 sont_key_part_5 SONT partial key 5
SAPBusinessObjectNodeKey6 sont_key_part_6 SONT partial key 6

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 I_WorkflowTaskApplObject.
-- 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.

CREATE VIEW I_WorkflowTaskApplObject AS
SELECT
  cast ( guid as sww_wi2obj_guid ) AS WorkflowTaskObject,
  wi_reltype AS WorkflowObjectRole,
  wi_id AS WorkflowTaskInternalID,
  top_wi_id AS TopLevelWorkflowTask,
  catid AS TechnicalWrkflwObjectCategory,
  typeid AS TechnicalWrkflwObjectType,
  instid AS TechnicalWrkflwObject,
  sont AS SAPObjectNodeRepresentation,
  sont_key_part_1 AS SAPBusinessObjectNodeKey1,
  sont_key_part_2 AS SAPBusinessObjectNodeKey2,
  sont_key_part_3 AS SAPBusinessObjectNodeKey3,
  sont_key_part_4 AS SAPBusinessObjectNodeKey4,
  sont_key_part_5 AS SAPBusinessObjectNodeKey5,
  sont_key_part_6 AS SAPBusinessObjectNodeKey6
FROM sww_wi2obj
;