I_WorkflowAgentRule

DDL: I_WORKFLOWAGENTRULE SQL: IWRKFLWAGNT Type: view BASIC

Workflow Definition Agent Rule

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

1 data source(s) 4 fields

Data Sources (1)

SourceAliasJoin Type
swd_flxruse swd_flxruse from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_WorkflowAgentRuleText _WorkflowAgentRuleText $projection.WorkflowScenarioDefinition = _WorkflowAgentRuleText.WorkflowScenarioDefinition and $projection.WorkflowScenarioDefinitionVers = _WorkflowAgentRuleText.WorkflowScenarioDefinitionVers and $projection.WorkflowAgentRule = _WorkflowAgentRuleText.WorkflowAgentRule

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IWRKFLWAGNT view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
EndUserText.label Workflow Definition Agent Rule view
ObjectModel.representativeKey WorkflowAgentRule view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY WorkflowScenarioDefinition wfd_id
KEY WorkflowScenarioDefinitionVers version
KEY WorkflowAgentRule ruse_label
_WorkflowAgentRuleText _WorkflowAgentRuleText 
@AbapCatalog.sqlViewName: 'IWRKFLWAGNT'
@AbapCatalog.compiler.compareFilter: true
@VDM.viewType: #BASIC
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.dataClass: #MASTER
@EndUserText.label: 'Workflow Definition Agent Rule'
@ObjectModel.representativeKey: 'WorkflowAgentRule'
@ObjectModel.supportedCapabilities: [ #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE, #CDS_MODELING_ASSOCIATION_TARGET]
/*+[hideWarning] { "IDS" : [ "KEY_CHECK" ]  } */
define view I_WorkflowAgentRule
  as select from swd_flxruse

  association [0..*] to I_WorkflowAgentRuleText as _WorkflowAgentRuleText on  $projection.WorkflowScenarioDefinition     = _WorkflowAgentRuleText.WorkflowScenarioDefinition
                                                                          and $projection.WorkflowScenarioDefinitionVers = _WorkflowAgentRuleText.WorkflowScenarioDefinitionVers
                                                                          and $projection.WorkflowAgentRule              = _WorkflowAgentRuleText.WorkflowAgentRule

{
  key wfd_id     as WorkflowScenarioDefinition,
  key version    as WorkflowScenarioDefinitionVers,
      @ObjectModel.text.association: '_WorkflowAgentRuleText'
  key ruse_label as WorkflowAgentRule,

      _WorkflowAgentRuleText
}
where
      ruse_type  = 'AGNT'
  and ruse_stype = 'WF'
  and nodeid     = '0000000002'
  and exetyp     = 'E'
  and version    < '9999'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"SWD_FLXRUSE"
],
"ASSOCIATED":
[
"I_WORKFLOWAGENTRULETEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More