SWF_SDM_SWF_FLEX_PROC

DDL: SWF_SDM_SWF_FLEX_PROC SQL: SWFSDMFLXPROCD Type: view Package: SWF_SDM

Workflow: SWF_FLEX_PROC & SDM state

SWF_SDM_SWF_FLEX_PROC is a CDS View that provides data about "Workflow: SWF_FLEX_PROC & SDM state" in SAP S/4HANA. It reads from 3 data sources (swf_flex_scact, swf_flex_proc, swf_sdm_state) and exposes 5 fields with key field id. Part of development package SWF_SDM.

Data Sources (3)

SourceAliasJoin Type
swf_flex_scact activation inner
swf_flex_proc conditional from
swf_sdm_state state left_outer

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName SWFSDMFLXPROCD view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Workflow: SWF_FLEX_PROC & SDM state view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY id swf_flex_proc id WorklistID
creation_ts swf_flex_proc creation_ts Time Stamp
change_ts swf_flex_proc change_ts Time Stamp
scenario_id swf_flex_proc scenario_id Workflow definition
active swf_flex_scact active Usage Active

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_SWF_FLEX_PROC.
-- 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: SWFSDMFLXPROCD

CREATE VIEW SWF_SDM_SWF_FLEX_PROC AS
SELECT
  conditional.id AS id,
  conditional.creation_ts AS creation_ts,
  conditional.change_ts AS change_ts,
  conditional.scenario_id AS scenario_id,
  activation.active AS active
FROM swf_flex_proc AS conditional
INNER JOIN swf_flex_scact AS activation ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN swf_sdm_state AS state ON /* join condition not captured in parsed metadata */
;