I_WorkflowStepResultText

DDL: I_WORKFLOWSTEPRESULTTEXT SQL: IWRKFLWRSLTTXT Type: view COMPOSITE Package: SWF_FLEX_IFS_DEV_PUBLISHED

Workflow Step Result Text

I_WorkflowStepResultText is a Composite CDS View (Dimension) that provides data about "Workflow Step Result Text" in SAP S/4HANA. It reads from 2 data sources (I_WorkflowStepText, I_WorkflowStepTypeNode) and exposes 7 fields with key fields WorkflowScenarioDefinition, WorkflowScenarioDefinitionVers, WorkflowStepType, WorkflowStepResult, Language. It has 1 association to related views. Part of development package SWF_FLEX_IFS_DEV_PUBLISHED.

2 data source(s) 7 fields

Data Sources (2)

SourceAliasJoin Type
I_WorkflowStepText WorfklowStepText from
I_WorkflowStepTypeNode WorkflowStepTypeNode inner

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_Language _Language $projection.Language = _Language.Language

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IWRKFLWRSLTTXT view
EndUserText.label Workflow Step Result Text view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.dataClass #META view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
Analytics.dataCategory #DIMENSION view
ObjectModel.dataCategory #TEXT view
ObjectModel.representativeKey WorkflowStepResult view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY WorkflowScenarioDefinition I_WorkflowStepTypeNode WorkflowScenarioDefinition
KEY WorkflowScenarioDefinitionVers I_WorkflowStepTypeNode WorkflowScenarioDefinitionVers
KEY WorkflowStepType I_WorkflowStepTypeNode WorkflowStepType
KEY WorkflowStepResult I_WorkflowStepTypeNode WorkflowStepResult
KEY Language I_WorkflowStepText Language
_Language _Language
WorkflowStepResultText I_WorkflowStepText WorkflowStepText 
@AbapCatalog.sqlViewName: 'IWRKFLWRSLTTXT'
@EndUserText.label: 'Workflow Step Result Text'
@VDM.viewType: #COMPOSITE
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType : {
  dataClass: #META,
  serviceQuality: #C,
  sizeCategory: #M
}
@Analytics: { dataCategory: #DIMENSION }
@ObjectModel.dataCategory: #TEXT
@ObjectModel.representativeKey: 'WorkflowStepResult'
@ObjectModel.supportedCapabilities: [ #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE, #CDS_MODELING_ASSOCIATION_TARGET]
define view I_WorkflowStepResultText
  as select from I_WorkflowStepText     as WorfklowStepText
    inner join   I_WorkflowStepTypeNode as WorkflowStepTypeNode on  WorfklowStepText.WorkflowScenarioDefinition     = WorkflowStepTypeNode.WorkflowScenarioDefinition
                                                                and WorfklowStepText.WorkflowScenarioDefinitionVers = WorkflowStepTypeNode.WorkflowScenarioDefinitionVers
                                                                and WorfklowStepText.WorkflowStepNode               = WorkflowStepTypeNode.WorkflowStepRefNode
  association [0..1] to I_Language as _Language on $projection.Language = _Language.Language
{
  key WorkflowStepTypeNode.WorkflowScenarioDefinition,
  key WorkflowStepTypeNode.WorkflowScenarioDefinitionVers,
  key WorkflowStepTypeNode.WorkflowStepType                 as WorkflowStepType,
  key WorkflowStepTypeNode.WorkflowStepResult               as WorkflowStepResult,
      @Semantics:   { language: true }
      @ObjectModel: { foreignKey.association: '_Language' }
  key WorfklowStepText.Language,
      @Semantics:   { text: true }
      _Language,
      WorfklowStepText.WorkflowStepText                     as WorkflowStepResultText
}
where
  WorkflowStepTypeNode.WorkflowStepResult <> ''

Learn More