I_WorkflowRecipients

DDL: I_WORKFLOWRECIPIENTS SQL: IWRKFLWRCPNTS Type: view COMPOSITE

Workflow Task Recipient

I_WorkflowRecipients is a Composite CDS View that provides data about "Workflow Task Recipient" in SAP S/4HANA. It reads from 1 data source (swwwihead) and exposes 7 fields with key fields WorkflowTaskInternalID, WorkflowTaskRecipient. It has 2 associations to related views.

1 data source(s) 7 fields

Data Sources (1)

SourceAliasJoin Type
swwwihead TaskHeader inner

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_BusinessUser _WorkflowTaskRecipient $projection.WorkflowTaskRecipient = _WorkflowTaskRecipient.UserID
[0..1] I_BusinessUserBasic _WorkflowTaskRecipient_2 $projection.WorkflowTaskRecipient = _WorkflowTaskRecipient_2.UserID

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IWRKFLWRCPNTS 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 #L view
ObjectModel.usageType.dataClass #MASTER view
EndUserText.label Workflow Task Recipient view
VDM.lifecycle.status #DEPRECATED view
VDM.lifecycle.successor I_WorkflowRecipients_V2 view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY WorkflowTaskInternalID TaskRecipient WorkflowTaskInternalID
KEY WorkflowTaskRecipient TaskRecipient WorkflowTaskRecipient
WorkflowInternalID swwwihead top_wi_id
_WorkflowTaskRecipient _WorkflowTaskRecipient
_WorkflowTaskRecipient_2 _WorkflowTaskRecipient_2
WorkflowTaskIsForwarded TaskRecipient WorkflowTaskIsForwarded
WorkflowTaskIsVisibleInInbox TaskRecipient WorkflowTaskIsVisibleInInbox 
@AbapCatalog.sqlViewName: 'IWRKFLWRCPNTS'
@AbapCatalog.compiler.compareFilter: true
@VDM.viewType: #COMPOSITE
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #MASTER
@EndUserText.label: 'Workflow Task Recipient'
@ObjectModel.supportedCapabilities: [ #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE, #CDS_MODELING_ASSOCIATION_TARGET]
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: 'I_WorkflowRecipients_V2'
/*+[hideWarning] { "IDS" : [ "CARDINALITY_CHECK" ]  } */
define view I_WorkflowRecipients
  as select distinct from I_WorkflowTaskRecipient as TaskRecipient
    inner join   swwwihead               as TaskHeader on TaskHeader.wi_id = TaskRecipient.WorkflowTaskInternalID
  association [0..1] to I_BusinessUser      as _WorkflowTaskRecipient   on $projection.WorkflowTaskRecipient = _WorkflowTaskRecipient.UserID
  association [0..1] to I_BusinessUserBasic as _WorkflowTaskRecipient_2 on $projection.WorkflowTaskRecipient = _WorkflowTaskRecipient_2.UserID
{
  key TaskRecipient.WorkflowTaskInternalID       as WorkflowTaskInternalID,
  key TaskRecipient.WorkflowTaskRecipient        as WorkflowTaskRecipient,
      TaskHeader.top_wi_id                       as WorkflowInternalID,
      @API.element.releaseState: #DEPRECATED
      @API.element.successor: '_WorkflowTaskRecipient_2'
      _WorkflowTaskRecipient,
      _WorkflowTaskRecipient_2,
      TaskRecipient.WorkflowTaskIsForwarded      as WorkflowTaskIsForwarded,
      TaskRecipient.WorkflowTaskIsVisibleInInbox as WorkflowTaskIsVisibleInInbox
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_WORKFLOWTASKRECIPIENT",
"SWWWIHEAD"
],
"ASSOCIATED":
[
"I_BUSINESSUSER",
"I_BUSINESSUSERBASIC"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More