I_WorkflowStepTypeNode

DDL: I_WORKFLOWSTEPTYPENODES SQL: IWRKFLWSTPTND Type: view COMPOSITE Package: SWF_FLEX_IFS
9 Fields 2 Data Sources

Exposes reusable step type nodes

I_WorkflowStepTypeNode is a Composite CDS View that provides data about "Exposes reusable step type nodes" in SAP S/4HANA. It reads from 2 data sources (I_WorkflowReuseStep, I_WorkflowStepNode) and exposes 9 fields with key fields WorkflowScenarioDefinition, WorkflowScenarioDefinitionVers, WorkflowStepType, WorkflowStepResult. Part of development package SWF_FLEX_IFS.

Data Sources (2)

SourceAliasJoin Type
I_WorkflowReuseStep WorkflowReuseStep from
I_WorkflowStepNode WorkflowStepNode inner

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName IWRKFLWSTPTND view
EndUserText.label Exposes reusable step type nodes view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #META view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #B view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY WorkflowScenarioDefinition I_WorkflowStepNode WorkflowScenarioDefinition Workflow definition
KEY WorkflowScenarioDefinitionVers I_WorkflowStepNode WorkflowScenarioDefinitionVers XML Vers.
KEY WorkflowStepType I_WorkflowReuseStep WorkflowStepType Unique Name
KEY WorkflowStepResult I_WorkflowStepNode WorkflowStepResult Outcome
WorkflowStepNode I_WorkflowStepNode WorkflowStepNode Workflow Step
WorkflowStepRefNode I_WorkflowStepNode WorkflowStepRefNode Reference-Step
WorkflowStepNodeType I_WorkflowStepNode WorkflowStepNodeType Object Type
WorkflowStepRefNodeType I_WorkflowStepNode WorkflowStepRefNodeType Node type
WorkflowStepResultNature I_WorkflowStepNode WorkflowStepResultNature Character

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_WorkflowStepTypeNode.
-- 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: IWRKFLWSTPTND

CREATE VIEW I_WorkflowStepTypeNode AS
SELECT
  WorkflowStepNode.WorkflowScenarioDefinition AS WorkflowScenarioDefinition,
  WorkflowStepNode.WorkflowScenarioDefinitionVers AS WorkflowScenarioDefinitionVers,
  WorkflowReuseStep.WorkflowStepType AS WorkflowStepType,
  WorkflowStepNode.WorkflowStepResult AS WorkflowStepResult,
  WorkflowStepNode.WorkflowStepNode AS WorkflowStepNode,
  WorkflowStepNode.WorkflowStepRefNode AS WorkflowStepRefNode,
  WorkflowStepNode.WorkflowStepNodeType AS WorkflowStepNodeType,
  WorkflowStepNode.WorkflowStepRefNodeType AS WorkflowStepRefNodeType,
  WorkflowStepNode.WorkflowStepResultNature AS WorkflowStepResultNature
FROM I_WorkflowReuseStep AS WorkflowReuseStep
INNER JOIN I_WorkflowStepNode AS WorkflowStepNode ON /* join condition not captured in parsed metadata */
;

Learn More