SWF_SDM_SWWWIHEAD

DDL: SWF_SDM_SWWWIHEAD SQL: SWFSDMWIHEAD Type: view
8 Fields 2 Data Sources

Workflow: join SDM state to SWWWIHEAD

SWF_SDM_SWWWIHEAD is a CDS View that provides data about "Workflow: join SDM state to SWWWIHEAD" in SAP S/4HANA. It reads from 2 data sources (swwwihead, swf_sdm_state) and exposes 8 fields with key field wi_id.

Data Sources (2)

SourceAliasJoin Type
swwwihead head from
swf_sdm_state state left_outer

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName SWFSDMWIHEAD view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Workflow: join SDM state to SWWWIHEAD view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY wi_id swwwihead wi_id WorkItem ID
crea_tmp swwwihead crea_tmp Created On
wi_cd swwwihead wi_cd Creation Date
wi_ct swwwihead wi_ct Creation Time
wi_stat swwwihead wi_stat Status
wi_type swwwihead wi_type Type
top_task swwwihead top_task Top Task
top_wi_id swwwihead 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 SWF_SDM_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: SWFSDMWIHEAD

CREATE VIEW SWF_SDM_SWWWIHEAD AS
SELECT
  head.wi_id AS wi_id,
  head.crea_tmp AS crea_tmp,
  head.wi_cd AS wi_cd,
  head.wi_ct AS wi_ct,
  head.wi_stat AS wi_stat,
  head.wi_type AS wi_type,
  head.top_task AS top_task,
  head.top_wi_id AS top_wi_id
FROM swwwihead AS head
LEFT OUTER JOIN swf_sdm_state AS state ON /* join condition not captured in parsed metadata */
;

Learn More