I_EHSTaskPlannedWorkflowInstce

DDL: I_EHSTASKPLANNEDWORKFLOWINSTCE SQL: IEHSTASKPLANWF Type: view COMPOSITE Package: EHFND_CNS_TASK_MANAGEMENT

EHS Task Planned Workflow Instance

I_EHSTaskPlannedWorkflowInstce is a Composite CDS View that provides data about "EHS Task Planned Workflow Instance" in SAP S/4HANA. It reads from 2 data sources (I_EHSTaskDefinition, I_EHSTaskPlannedWorkflowHead) and exposes 36 fields with key field EHSPlannedTaskUUID. It has 9 associations to related views. Part of development package EHFND_CNS_TASK_MANAGEMENT.

2 data source(s) 36 fields

Data Sources (2)

SourceAliasJoin Type
I_EHSTaskDefinition EHSTaskDefinition inner
I_EHSTaskPlannedWorkflowHead EHSTaskPlannedWorkflow from

Associations (9)

CardinalityTargetAliasCondition
[1..1] I_BusinessUser _EHSTaskOwnerUser $projection.EHSTaskOwnerUser = _EHSTaskOwnerUser.UserID
[0..1] I_EHSTaskPriority _EHSTaskPriority $projection.EHSTaskPriority = _EHSTaskPriority.EHSTaskPriority
[1..1] I_EHSTaskAdapterClass _EHSTaskAdapterClass $projection.EHSTaskHostObjectAdapterClass = _EHSTaskAdapterClass.EHSTaskAdapterClass
[0..1] I_IncidentCombAuthFields _IncidentAuthorizationFields $projection.EHSTaskHostObjectInstanceUUID = _IncidentAuthorizationFields.EHSTaskHostObjectInstanceUUID
[0..1] I_IncidentTaskRefAccRestricted _IncidentTaskRefAccRestricted $projection.EHSTaskDefinitionUUID = _IncidentTaskRefAccRestricted.EHSTaskDefinitionUUID and $projection.EHSTaskHostObjectInstanceUUID = _IncidentTaskRefAccRestricted.IncidentUUID
[0..1] I_EHSCtrlImplmtnAuthznFields _EHSCtrlImplmtnAuthznFields $projection.EHSTaskHostObjectInstanceUUID = _EHSCtrlImplmtnAuthznFields.EHSControlInstanceUUID
[0..1] I_EHSRskAssessmentAuthznFields _EHSRskAssessmentAuthznFields $projection.EHSTaskHostObjectInstanceUUID = _EHSRskAssessmentAuthznFields.EHSRiskAssessmentUUID
[0..1] I_EHSRskAssmt2RskCtrlAuthznFld _EHSRskAssmt2RskCtrlAuthznFld $projection.EHSTaskHostObjectInstanceUUID = _EHSRskAssmt2RskCtrlAuthznFld.EHSRiskControlUUID
[0..1] I_EHSCmplncScenAuthznFields _EHSCmplncScenAuthznFields $projection.EHSTaskHostObjectInstanceUUID = _EHSCmplncScenAuthznFields.EHSCmplncScenOrignRootUUID

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IEHSTASKPLANWF view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label EHS Task Planned Workflow Instance view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view

Fields (36)

KeyFieldSource TableSource FieldDescription
KEY EHSPlannedTaskUUID I_EHSTaskPlannedWorkflowHead EHSPlannedTaskUUID
EHSTaskDefinitionUUID I_EHSTaskPlannedWorkflowHead EHSTaskDefinitionUUID
WorkflowTaskInternalID I_EHSTaskPlannedWorkflowHead WorkflowTaskInternalID
EHSTaskStartDate I_EHSTaskPlannedWorkflowHead EHSTaskStartDate
EHSTaskDueDate I_EHSTaskPlannedWorkflowHead EHSTaskDueDate
EHSTaskInstceCompletionDate I_EHSTaskPlannedWorkflowHead EHSTaskInstceCompletionDate
EHSTaskTimeZone I_EHSTaskPlannedWorkflowHead EHSTaskTimeZone
EHSTaskOwnerUser I_EHSTaskPlannedWorkflowHead WorkflowTaskCreatedByUser
EHSTaskOwnerBP I_EHSTaskPlannedWorkflowHead EHSTaskOwnerBP
EHSTaskAssignedBP I_EHSTaskPlannedWorkflowHead EHSTaskAssignedBP
EHSTaskApprovingBP I_EHSTaskPlannedWorkflowHead EHSTaskApprovingBP
EHSTaskTitle I_EHSTaskDefinition EHSTaskTitle
EHSTaskDefinitionType I_EHSTaskDefinition EHSTaskWorkflowEvent
EHSTaskPriority I_EHSTaskDefinition EHSTaskPriority
EHSTaskDefinitionStatus I_EHSTaskDefinition EHSTaskDefinitionStatus
EHSTaskDefinitionIsPaused I_EHSTaskDefinition EHSTaskDefinitionIsPaused
EHSTaskRecurrenceType I_EHSTaskDefinition EHSTaskRecurrenceType
EHSTaskNextExecUTCDateTime _EHSTaskDefinitionExecution EHSTaskNextExecUTCDateTime
EHSLocationUUID I_EHSTaskDefinition EHSLocationUUID
EHSTaskHostSemanticObject
EHSTaskHostObjectInstanceUUID I_EHSTaskDefinition EHSTaskHostObjectInstanceUUID
EHSTaskHostObjectInstance I_EHSTaskDefinition EHSTaskHostObjectInstance
EHSTaskHostObjectAdapterClass I_EHSTaskDefinition EHSTaskHostObjectAdapterClass
WorkflowTaskStatus I_EHSTaskPlannedWorkflowHead WorkflowTaskStatus
WorkflowTaskDefinition I_EHSTaskPlannedWorkflowHead WorkflowTaskDefinition
WorkflowTaskName I_EHSTaskPlannedWorkflowHead WorkflowTaskName
_EHSTaskOwnerUser _EHSTaskOwnerUser
_EHSTaskPriority _EHSTaskPriority
_EHSTaskAdapterClass _EHSTaskAdapterClass
_IncidentAuthorizationFields _IncidentAuthorizationFields
_EHSCtrlImplmtnAuthznFields _EHSCtrlImplmtnAuthznFields
_EHSRskAssessmentAuthznFields _EHSRskAssessmentAuthznFields
_EHSRskAssmt2RskCtrlAuthznFld _EHSRskAssmt2RskCtrlAuthznFld
_EHSCmplncScenAuthznFields _EHSCmplncScenAuthznFields
_CmplncRqmtAuthznFields _CmplncRqmtAuthznFields
IncidentHasAccessRestriction _IncidentTaskRefAccRestricted IncidentHasAccessRestriction 
@AbapCatalog.sqlViewName: 'IEHSTASKPLANWF'
@AbapCatalog.preserveKey:true
@AbapCatalog.compiler.compareFilter:true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #('TRANSACTIONAL_DATA')
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'EHS Task Planned Workflow Instance'

@ObjectModel.usageType:{ serviceQuality: #C,
                         sizeCategory:  #XL,
                         dataClass: #MIXED }
@VDM.viewType: #COMPOSITE
define view I_EHSTaskPlannedWorkflowInstce
  as select from I_EHSTaskPlannedWorkflowHead as EHSTaskPlannedWorkflow
    inner join   I_EHSTaskDefinition          as EHSTaskDefinition on EHSTaskPlannedWorkflow.EHSTaskDefinitionUUID = EHSTaskDefinition.EHSTaskDefinitionUUID

  association [1..1] to I_BusinessUser                 as _EHSTaskOwnerUser             on  $projection.EHSTaskOwnerUser = _EHSTaskOwnerUser.UserID
  association [0..1] to I_EHSTaskPriority              as _EHSTaskPriority              on  $projection.EHSTaskPriority = _EHSTaskPriority.EHSTaskPriority

  association [1..1] to I_EHSTaskAdapterClass          as _EHSTaskAdapterClass          on  $projection.EHSTaskHostObjectAdapterClass = _EHSTaskAdapterClass.EHSTaskAdapterClass
  association [0..1] to I_IncidentCombAuthFields       as _IncidentAuthorizationFields  on  $projection.EHSTaskHostObjectInstanceUUID = _IncidentAuthorizationFields.EHSTaskHostObjectInstanceUUID
  association [0..1] to I_IncidentTaskRefAccRestricted as _IncidentTaskRefAccRestricted on  $projection.EHSTaskDefinitionUUID         = _IncidentTaskRefAccRestricted.EHSTaskDefinitionUUID
                                                                                        and $projection.EHSTaskHostObjectInstanceUUID = _IncidentTaskRefAccRestricted.IncidentUUID
  association [0..1] to I_EHSCtrlImplmtnAuthznFields   as _EHSCtrlImplmtnAuthznFields   on  $projection.EHSTaskHostObjectInstanceUUID = _EHSCtrlImplmtnAuthznFields.EHSControlInstanceUUID
  association [0..1] to I_EHSRskAssessmentAuthznFields as _EHSRskAssessmentAuthznFields on  $projection.EHSTaskHostObjectInstanceUUID = _EHSRskAssessmentAuthznFields.EHSRiskAssessmentUUID
  association [0..1] to I_EHSRskAssmt2RskCtrlAuthznFld as _EHSRskAssmt2RskCtrlAuthznFld on  $projection.EHSTaskHostObjectInstanceUUID = _EHSRskAssmt2RskCtrlAuthznFld.EHSRiskControlUUID
  association [0..1] to I_EHSCmplncScenAuthznFields    as _EHSCmplncScenAuthznFields    on  $projection.EHSTaskHostObjectInstanceUUID = _EHSCmplncScenAuthznFields.EHSCmplncScenOrignRootUUID
{
  key EHSTaskPlannedWorkflow.EHSPlannedTaskUUID,
      EHSTaskPlannedWorkflow.EHSTaskDefinitionUUID,

      EHSTaskPlannedWorkflow.WorkflowTaskInternalID,

      EHSTaskPlannedWorkflow.EHSTaskStartDate,
      EHSTaskPlannedWorkflow.EHSTaskDueDate,
      EHSTaskPlannedWorkflow.EHSTaskInstceCompletionDate,
      EHSTaskPlannedWorkflow.EHSTaskTimeZone,

      // USERS

      EHSTaskPlannedWorkflow.WorkflowTaskCreatedByUser         as EHSTaskOwnerUser,
      EHSTaskPlannedWorkflow.EHSTaskOwnerBP,
      EHSTaskPlannedWorkflow.EHSTaskAssignedBP,
      EHSTaskPlannedWorkflow.EHSTaskApprovingBP,

      // TASK DEFINITION

      EHSTaskDefinition.EHSTaskTitle,
      EHSTaskDefinition.EHSTaskWorkflowEvent                   as EHSTaskDefinitionType,
      EHSTaskDefinition.EHSTaskPriority,
      EHSTaskDefinition.EHSTaskDefinitionStatus,
      EHSTaskDefinition.EHSTaskDefinitionIsPaused,
      EHSTaskDefinition.EHSTaskRecurrenceType,
      _EHSTaskDefinitionExecution.EHSTaskNextExecUTCDateTime,
      EHSTaskDefinition.EHSLocationUUID,

      // HOST OBJECT

      EHSTaskDefinition._EHSTaskAdapterClass.EHSSemanticObject as EHSTaskHostSemanticObject,
      EHSTaskDefinition.EHSTaskHostObjectInstanceUUID,
      EHSTaskDefinition.EHSTaskHostObjectInstance,
      EHSTaskDefinition.EHSTaskHostObjectAdapterClass,

      EHSTaskPlannedWorkflow.WorkflowTaskStatus,
      EHSTaskPlannedWorkflow.WorkflowTaskDefinition,
      EHSTaskPlannedWorkflow.WorkflowTaskName,

      //association exposure:

      _EHSTaskOwnerUser,
      _EHSTaskPriority,

      _EHSTaskAdapterClass,
      _IncidentAuthorizationFields,
      _EHSCtrlImplmtnAuthznFields,
      _EHSRskAssessmentAuthznFields,
      _EHSRskAssmt2RskCtrlAuthznFld,
      _EHSCmplncScenAuthznFields,
      _CmplncRqmtAuthznFields,
      _IncidentTaskRefAccRestricted.IncidentHasAccessRestriction

}
where
  WorkflowTaskInternalID is not initial

Learn More