I_WorkflowScenarioResult

DDL: I_WORKFLOWSCENARIORESULT SQL: IWRKFLWSCENRES Type: view BASIC
5 Fields 1 Data Sources 1 Associations

Workflow Scenario Result

I_WorkflowScenarioResult (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Cross Applications

I_WorkflowScenarioResult is a Basic CDS View that provides data about "Workflow Scenario Result" in SAP S/4HANA. It reads from 1 data source (swd_flxout) and exposes 5 fields with key fields WorkflowScenarioDefinition, WorkflowScenarioDefinitionVers, WorkflowScenarioResult. It has 1 association to related views.

SAP Help Documentation

CategoryCDS Views for Flexible Workflow
Purpose
This CDS view exposes the possible result of a workflow instance. This CDS view provides the data to answer the following business questions: What is the result of a workflow instance? To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .

Prerequisites
Authorizations Users who want to use this CDS view don't need any special authorization.

Structure
Important Fields Important fields in this view include the following: Field Name Description WorkflowScenarioDefinition Identifier of a workflow scenario WorkflowScenarioDefinitionVers Version of a workflow scenario WorkflowScenarioResult Identifier for the possible result of a workflow instance WorkflowScenarioResultNature Nature for the possible result of a workflow instance. Values are <empty>, POSITIVE, NEGATIVE and NEUTRAL. WorkflowScenarioResultText Display text for the possible result of a workflow instance (part of related text view, translated)

View on SAP Help Portal →

SAP API Hub

StateC1
Line of BusinessCross Applications
Application ComponentBC-BMT-WFM
CapabilitiesData Source for Defining CDS Entities, Data Source in SQL Select, Association Target for Defining CDS Entities
PackageCross Applications for SAP S/4HANA Cloud Private Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
swd_flxout WorkflowResult from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_WorkflowScenarioResultText _Text $projection.WorkflowScenarioDefinition = _Text.WorkflowScenarioDefinition and $projection.WorkflowScenarioDefinitionVers = _Text.WorkflowScenarioDefinitionVers and $projection.WorkflowScenarioResult = _Text.WorkflowScenarioResult

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IWRKFLWSCENRES view
EndUserText.label Workflow Scenario Result view
VDM.viewType #BASIC 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
ObjectModel.representativeKey WorkflowScenarioResult view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY WorkflowScenarioDefinition swd_flxout wfd_id Number of workflow definition
KEY WorkflowScenarioDefinitionVers swd_flxout version XML Vers.
KEY WorkflowScenarioResult swd_flxout normiert Outcome
WorkflowScenarioResultNature swd_flxout nature Workflow: Property: Positive, Negative....
_Text _Text

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_WorkflowScenarioResult.
-- 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: IWRKFLWSCENRES

CREATE VIEW I_WorkflowScenarioResult AS
SELECT
  WorkflowResult.wfd_id AS WorkflowScenarioDefinition,
  WorkflowResult.version AS WorkflowScenarioDefinitionVers,
  WorkflowResult.normiert AS WorkflowScenarioResult,
  WorkflowResult.nature AS WorkflowScenarioResultNature
FROM swd_flxout AS WorkflowResult
LEFT OUTER JOIN I_WorkflowScenarioResultText AS _Text ON WorkflowScenarioDefinition = _Text.WorkflowScenarioDefinition AND WorkflowScenarioDefinitionVers = _Text.WorkflowScenarioDefinitionVers AND WorkflowScenarioResult = _Text.WorkflowScenarioResult  -- association [0..*]
;

Learn More