I_WorkflowStepTypeNode

DDL: I_WORKFLOWSTEPTYPENODES SQL: IWRKFLWSTPTND Type: view COMPOSITE

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.

2 data source(s) 9 fields

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
KEY WorkflowScenarioDefinitionVers I_WorkflowStepNode WorkflowScenarioDefinitionVers
KEY WorkflowStepType I_WorkflowReuseStep WorkflowStepType
KEY WorkflowStepResult I_WorkflowStepNode WorkflowStepResult
WorkflowStepNode I_WorkflowStepNode WorkflowStepNode
WorkflowStepRefNode I_WorkflowStepNode WorkflowStepRefNode
WorkflowStepNodeType I_WorkflowStepNode WorkflowStepNodeType
WorkflowStepRefNodeType I_WorkflowStepNode WorkflowStepRefNodeType
WorkflowStepResultNature I_WorkflowStepNode WorkflowStepResultNature 
@AbapCatalog.sqlViewName: 'IWRKFLWSTPTND'
@EndUserText.label: 'Exposes reusable step type nodes'
@VDM.viewType: #COMPOSITE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType : {
  dataClass: #META,
  sizeCategory: #M,
  serviceQuality: #B
}
define view I_WorkflowStepTypeNode
  as select from I_WorkflowReuseStep as WorkflowReuseStep
    inner join   I_WorkflowStepNode  as WorkflowStepNode on  WorkflowReuseStep.WrkflwScen         = WorkflowStepNode.WorkflowScenarioDefinition
                                                         and WorkflowReuseStep.WrkflwScenVers     = WorkflowStepNode.WorkflowScenarioDefinitionVers
                                                         and WorkflowReuseStep.WorkflowStepNodeId = WorkflowStepNode.WorkflowStepParentNode

{
  key WorkflowStepNode.WorkflowScenarioDefinition,
  key WorkflowStepNode.WorkflowScenarioDefinitionVers,
  key WorkflowReuseStep.WorkflowStepType,
  key WorkflowStepNode.WorkflowStepResult,
      WorkflowStepNode.WorkflowStepNode,
      WorkflowStepNode.WorkflowStepRefNode,
      WorkflowStepNode.WorkflowStepNodeType,
      WorkflowStepNode.WorkflowStepRefNodeType,
      WorkflowStepNode.WorkflowStepResultNature
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_WORKFLOWREUSESTEP",
"I_WORKFLOWSTEPNODE"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More