I_WorkflowScenarioDefText

DDL: I_WORKFLOWSCENARIODEFTEXT SQL: IWRKFLWSCDEFTXT Type: view COMPOSITE Package: SWF_FLEX_IFS_DEV_PUBLISHED

Workflow Scenario Definition Text

I_WorkflowScenarioDefText is a Composite CDS View that provides data about "Workflow Scenario Definition Text" in SAP S/4HANA. It reads from 3 data sources (I_WorkflowTaskDefinitionText, I_WorkflowScenarioDefinition, I_WorkflowTaskDefinition) and exposes 4 fields with key fields WorkflowScenarioDefinition, Language. It has 1 association to related views. Part of development package SWF_FLEX_IFS_DEV_PUBLISHED.

3 data source(s) 4 fields

Data Sources (3)

SourceAliasJoin Type
I_WorkflowTaskDefinitionText WorkflowDefinitionText left_outer
I_WorkflowScenarioDefinition WorkflowScenarioDefinition from
I_WorkflowTaskDefinition WorkflowTaskDefinition inner

Associations (1)

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

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IWRKFLWSCDEFTXT view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.dataCategory #TEXT view
ObjectModel.representativeKey WorkflowScenarioDefinition view
EndUserText.label Workflow Scenario Definition Text view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY WorkflowScenarioDefinition I_WorkflowScenarioDefinition WorkflowScenarioDefinition
KEY Language I_WorkflowTaskDefinitionText Language
_Language _Language
WorkflowScenarioDefinitionName I_WorkflowTaskDefinitionText WorkflowTaskDefinitionName 
@AbapCatalog.sqlViewName: 'IWRKFLWSCDEFTXT'
@AbapCatalog.compiler.compareFilter: true
@VDM.viewType: #COMPOSITE
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #S
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.dataCategory: #TEXT
@ObjectModel.representativeKey: 'WorkflowScenarioDefinition'
@EndUserText.label: 'Workflow Scenario Definition Text'
@ObjectModel.supportedCapabilities: [ #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE, #CDS_MODELING_ASSOCIATION_TARGET]
define view I_WorkflowScenarioDefText
  as select from    I_WorkflowScenarioDefinition as WorkflowScenarioDefinition
    inner join      I_WorkflowTaskDefinition     as WorkflowTaskDefinition on WorkflowScenarioDefinition.WorkflowScenarioDefinition = WorkflowTaskDefinition.WorkflowTaskDefinition
    left outer join I_WorkflowTaskDefinitionText as WorkflowDefinitionText on  WorkflowTaskDefinition.WorkflowTaskDefinitionObjType = WorkflowDefinitionText.WorkflowTaskDefinitionObjType
                                                                           and WorkflowTaskDefinition.WorkflowTaskDefinitionObject  = WorkflowDefinitionText.WorkflowTaskDefinitionObject
  association [0..1] to I_Language as _Language on $projection.Language = _Language.Language
{
  key WorkflowScenarioDefinition.WorkflowScenarioDefinition as WorkflowScenarioDefinition,
      @Semantics:   { language: true }
      @ObjectModel: { foreignKey.association: '_Language' }
  key WorkflowDefinitionText.Language,
      @Semantics:   { text: true }
      _Language,
      WorkflowDefinitionText.WorkflowTaskDefinitionName     as WorkflowScenarioDefinitionName
}

Learn More