I_WorkflowAgentRuleText

DDL: I_WORKFLOWAGENTRULETEXT SQL: IWRKFLWAGNTTXT Type: view BASIC

Workflow Definition Agent Rule Text

I_WorkflowAgentRuleText is a Basic CDS View (Dimension) that provides data about "Workflow Definition Agent Rule Text" in SAP S/4HANA. It reads from 2 data sources (swd_flxruse, swd_flxrutx) and exposes 6 fields with key fields WorkflowScenarioDefinition, WorkflowScenarioDefinitionVers, WorkflowAgentRule, Language. It has 1 association to related views.

2 data source(s) 6 fields

Data Sources (2)

SourceAliasJoin Type
swd_flxruse _reuse inner
swd_flxrutx _text from

Associations (1)

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

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IWRKFLWAGNTTXT view
EndUserText.label Workflow Definition Agent Rule Text view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE 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 WorkflowAgentRule view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY WorkflowScenarioDefinition swd_flxruse wfd_id
KEY WorkflowScenarioDefinitionVers swd_flxruse version
KEY WorkflowAgentRule swd_flxruse ruse_label
KEY Language swd_flxrutx language
_Language _Language
WorkflowAgentRuleText swd_flxrutx text 
@AbapCatalog.sqlViewName: 'IWRKFLWAGNTTXT'
@EndUserText.label: 'Workflow Definition Agent Rule Text'
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType : {
  dataClass: #META,
  serviceQuality: #C,
  sizeCategory: #M
}
@Analytics: { dataCategory: #DIMENSION }
@ObjectModel.dataCategory: #TEXT
@ObjectModel.representativeKey: 'WorkflowAgentRule'
@ObjectModel.supportedCapabilities: [ #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE, #CDS_MODELING_ASSOCIATION_TARGET]
define view I_WorkflowAgentRuleText
  as select from swd_flxrutx as _text
    inner join   swd_flxruse as _reuse on  _reuse.wfd_id     = _text.wfd_id
                                       and _reuse.version    = _text.version
                                       and _reuse.item_order = _text.item_order
                                       and _reuse.ruse_type  = _text.ruse_type

  association [0..1] to I_Language as _Language on $projection.Language = _Language.Language
{
  key _reuse.wfd_id     as WorkflowScenarioDefinition,
  key _reuse.version    as WorkflowScenarioDefinitionVers,
  key _reuse.ruse_label as WorkflowAgentRule,
      @Semantics:   { language: true }
      @ObjectModel: { foreignKey.association: '_Language' }
  key _text.language    as Language,
      @Semantics:   { text: true }
      _Language,
      _text.text        as WorkflowAgentRuleText
}
where
      _reuse.ruse_type  = 'AGNT'
  and _reuse.ruse_stype = 'WF'
  and _reuse.nodeid     = '0000000002'
  and _reuse.exetyp     = 'E'
  and _text.text_type   = 'FS'
  and _reuse.version    < '9999'

Learn More