SWW_SWWWIHEAD

DDL: SWW_SWWWIHEAD SQL: SWWVWIHEAD Type: view
11 Fields 1 Data Sources

Workflow: Private CDS for Workflow Header

SWW_SWWWIHEAD is a CDS View that provides data about "Workflow: Private CDS for Workflow Header" in SAP S/4HANA. It reads from 1 data source (swwwihead) and exposes 11 fields with key field wi_id.

Data Sources (1)

SourceAliasJoin Type
swwwihead swwwihead from

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName SWWVWIHEAD view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Workflow: Private CDS for Workflow Header view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY wi_id swwwihead wi_id WorkItem ID
wi_type wi_type Type
wi_stat wi_stat Status
wi_rh_task wi_rh_task Task
wi_aagent wi_aagent Agent
WorkflowTaskDefinitionObjType
WorkflowTaskDefinitionObject
step_id step_id WF Step ID
wi_chckwi wi_chckwi Workflow
crea_tmp crea_tmp Created On
top_wi_id top_wi_id Top Level Workflow

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 SWW_SWWWIHEAD.
-- 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: SWWVWIHEAD

CREATE VIEW SWW_SWWWIHEAD AS
SELECT
  swwwihead.wi_id AS wi_id,
  wi_type,
  wi_stat,
  wi_rh_task,
  wi_aagent,
  cast( substring(wi_rh_task, 1, 2) as hr_sotype ) AS WorkflowTaskDefinitionObjType,
  cast( substring(wi_rh_task, 3, 8) as hr_sobjid ) AS WorkflowTaskDefinitionObject,
  step_id,
  wi_chckwi,
  crea_tmp,
  top_wi_id
FROM swwwihead
;

Learn More