I_EHSTaskFutureInstance

DDL: I_EHSTASKFUTUREINSTANCE SQL: IEHSTASKFUTURE Type: view COMPOSITE

EHS Future Task Instance

I_EHSTaskFutureInstance is a Composite CDS View that provides data about "EHS Future Task Instance" in SAP S/4HANA. It reads from 2 data sources (I_EHSTaskDefinition, I_EHSTaskPlannedInstance) and exposes 32 fields with key field EHSPlannedTaskUUID. It has 9 associations to related views.

2 data source(s) 32 fields

Data Sources (2)

SourceAliasJoin Type
I_EHSTaskDefinition EHSTaskDefinition inner
I_EHSTaskPlannedInstance EHSTaskPlannedInstance from

Associations (9)

CardinalityTargetAliasCondition
[1..1] I_BusinessUser _EHSTaskOwnerUser $projection.EHSTaskOwnerBP = _EHSTaskOwnerUser.BusinessPartner
[1..1] I_BusinessUser _EHSTaskAssignedUser $projection.EHSTaskAssignedBP = _EHSTaskAssignedUser.BusinessPartner
[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_EHSCmplncScenAuthznFields _EHSCmplncScenAuthznFields $projection.EHSTaskHostObjectInstanceUUID = _EHSCmplncScenAuthznFields.EHSCmplncScenOrignRootUUID

Annotations (10)

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

Fields (32)

KeyFieldSource TableSource FieldDescription
KEY EHSPlannedTaskUUID I_EHSTaskPlannedInstance EHSPlannedTaskUUID
EHSTaskDefinitionUUID I_EHSTaskPlannedInstance EHSTaskDefinitionUUID
WorkflowTaskInternalID I_EHSTaskPlannedInstance WorkflowTaskInternalID
EHSTaskStartDate I_EHSTaskPlannedInstance EHSTaskStartDate
EHSTaskDueDate I_EHSTaskPlannedInstance EHSTaskDueDate
EHSTaskInstceCompletionDate I_EHSTaskPlannedInstance EHSTaskInstceCompletionDate
EHSTaskTimeZone I_EHSTaskPlannedInstance EHSTaskTimeZone
EHSTaskOwnerBP I_EHSTaskPlannedInstance EHSTaskOwnerBP
EHSTaskAssignedBP I_EHSTaskPlannedInstance EHSTaskAssignedBP
EHSTaskApprovingBP I_EHSTaskPlannedInstance 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
_EHSTaskOwnerUser _EHSTaskOwnerUser
_EHSTaskAssignedUser _EHSTaskAssignedUser
_EHSTaskPriority _EHSTaskPriority
_EHSTaskAdapterClass _EHSTaskAdapterClass
_IncidentAuthorizationFields _IncidentAuthorizationFields
_EHSCtrlImplmtnAuthznFields _EHSCtrlImplmtnAuthznFields
_EHSRskAssessmentAuthznFields _EHSRskAssessmentAuthznFields
_EHSCmplncScenAuthznFields _EHSCmplncScenAuthznFields
_CmplncRqmtAuthznFields _CmplncRqmtAuthznFields
IncidentHasAccessRestriction _IncidentTaskRefAccRestricted IncidentHasAccessRestriction 
@AbapCatalog.sqlViewName: 'IEHSTASKFUTURE'
@AbapCatalog.preserveKey:true
@AbapCatalog.compiler.compareFilter:true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #('TRANSACTIONAL_DATA')
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'EHS Future Task Instance'

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

  association [1..1] to I_BusinessUser                 as _EHSTaskOwnerUser             on  $projection.EHSTaskOwnerBP = _EHSTaskOwnerUser.BusinessPartner
  association [1..1] to I_BusinessUser                 as _EHSTaskAssignedUser          on  $projection.EHSTaskAssignedBP = _EHSTaskAssignedUser.BusinessPartner
  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_EHSCmplncScenAuthznFields    as _EHSCmplncScenAuthznFields    on  $projection.EHSTaskHostObjectInstanceUUID = _EHSCmplncScenAuthznFields.EHSCmplncScenOrignRootUUID
{
  key EHSTaskPlannedInstance.EHSPlannedTaskUUID,
      EHSTaskPlannedInstance.EHSTaskDefinitionUUID,

      EHSTaskPlannedInstance.WorkflowTaskInternalID,

      EHSTaskPlannedInstance.EHSTaskStartDate,
      EHSTaskPlannedInstance.EHSTaskDueDate,
      EHSTaskPlannedInstance.EHSTaskInstceCompletionDate,
      EHSTaskPlannedInstance.EHSTaskTimeZone,

      // USERS

      EHSTaskPlannedInstance.EHSTaskOwnerBP,
      EHSTaskPlannedInstance.EHSTaskAssignedBP,
      EHSTaskPlannedInstance.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,

      //association exposure:

      _EHSTaskOwnerUser,
      _EHSTaskAssignedUser,
      _EHSTaskPriority,

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

}
where
  WorkflowTaskInternalID is initial

Learn More