I_WorkflowStepResult

DDL: I_WORKFLOWSTEPRESULT SQL: IWRKFLWRSLT Type: view COMPOSITE

Workflow Step Result

I_WorkflowStepResult is a Composite CDS View (Dimension) that provides data about "Workflow Step Result" in SAP S/4HANA. It reads from 1 data source (I_WorkflowStepTypeNode) and exposes 6 fields with key fields WorkflowScenarioDefinition, WorkflowScenarioDefinitionVers, WorkflowStepType, WorkflowStepResult. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_WorkflowStepTypeNode WorkflowStepTypeNode from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_WorkflowStepResultText _Text $projection.WorkflowScenarioDefinition = _Text.WorkflowScenarioDefinition and $projection.WorkflowScenarioDefinitionVers = _Text.WorkflowScenarioDefinitionVers and $projection.WorkflowStepType = _Text.WorkflowStepType and $projection.WorkflowStepResult = _Text.WorkflowStepResult

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IWRKFLWRSLT view
EndUserText.label Workflow Step Result 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
ObjectModel.representativeKey WorkflowStepResult view
Analytics.dataCategory #DIMENSION view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY WorkflowScenarioDefinition I_WorkflowStepTypeNode WorkflowScenarioDefinition
KEY WorkflowScenarioDefinitionVers I_WorkflowStepTypeNode WorkflowScenarioDefinitionVers
KEY WorkflowStepType I_WorkflowStepTypeNode WorkflowStepType
KEY WorkflowStepResult I_WorkflowStepTypeNode WorkflowStepResult
WorkflowStepResultNature I_WorkflowStepTypeNode WorkflowStepResultNature
_Text _Text
@AbapCatalog.sqlViewName: 'IWRKFLWRSLT'
@EndUserText.label: 'Workflow Step Result'
@VDM.viewType: #COMPOSITE
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType : {
  dataClass: #META,
  serviceQuality: #C,
  sizeCategory: #M
}
@ObjectModel.representativeKey: 'WorkflowStepResult'
@Analytics: { dataCategory: #DIMENSION }
@ObjectModel.supportedCapabilities: [ #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE, #CDS_MODELING_ASSOCIATION_TARGET]
define view I_WorkflowStepResult
  as select from I_WorkflowStepTypeNode as WorkflowStepTypeNode

  association [0..*] to I_WorkflowStepResultText as _Text on  $projection.WorkflowScenarioDefinition     = _Text.WorkflowScenarioDefinition
                                                          and $projection.WorkflowScenarioDefinitionVers = _Text.WorkflowScenarioDefinitionVers
                                                          and $projection.WorkflowStepType               = _Text.WorkflowStepType
                                                          and $projection.WorkflowStepResult             = _Text.WorkflowStepResult
{
  key WorkflowStepTypeNode.WorkflowScenarioDefinition     as WorkflowScenarioDefinition,
  key WorkflowStepTypeNode.WorkflowScenarioDefinitionVers as WorkflowScenarioDefinitionVers,
  key WorkflowStepTypeNode.WorkflowStepType               as WorkflowStepType,
      @ObjectModel.text.association: '_Text'
  key WorkflowStepTypeNode.WorkflowStepResult             as WorkflowStepResult,
      WorkflowStepTypeNode.WorkflowStepResultNature       as WorkflowStepResultNature,
      _Text
}
where
  WorkflowStepResult <> ''