SWF_SDM_SWF_FLEX_TDRAFT

DDL: SWF_SDM_SWF_FLEX_TDRAFT SQL: SWFSDMFLXTDRFT Type: view

Workflow: SWF_FLEX_TDRAFT & SDM state

SWF_SDM_SWF_FLEX_TDRAFT is a CDS View that provides data about "Workflow: SWF_FLEX_TDRAFT & SDM state" in SAP S/4HANA. It reads from 3 data sources (swf_flex_scact, swf_flex_tdraft, swf_sdm_state) and exposes 5 fields with key fields scenario_id, appl_obj_id.

Data Sources (3)

SourceAliasJoin Type
swf_flex_scact activation inner
swf_flex_tdraft draft from
swf_sdm_state state left_outer

Annotations (5)

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

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY scenario_id swf_flex_tdraft scenario_id Workflow definition
KEY appl_obj_id swf_flex_tdraft appl_obj_id Instance ID
creation_ts swf_flex_tdraft creation_ts Time Stamp
change_ts swf_flex_tdraft change_ts Time Stamp
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_TDRAFT.
-- 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: SWFSDMFLXTDRFT

CREATE VIEW SWF_SDM_SWF_FLEX_TDRAFT AS
SELECT
  draft.scenario_id AS scenario_id,
  draft.appl_obj_id AS appl_obj_id,
  draft.creation_ts AS creation_ts,
  draft.change_ts AS change_ts,
  activation.active AS active
FROM swf_flex_tdraft AS draft
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 */
;