I_EHSTaskDueDate

DDL: I_EHSTASKDUEDATE SQL: IEHSTASKDUEDATE Type: view COMPOSITE

EHS Task Due Date

I_EHSTaskDueDate is a Composite CDS View that provides data about "EHS Task Due Date" in SAP S/4HANA. It reads from 2 data sources (I_EHSTaskInstance, I_WorkflowTask) and exposes 1 field with key field WorkflowTaskInternalID.

2 data source(s) 1 fields

Data Sources (2)

SourceAliasJoin Type
I_EHSTaskInstance _TaskInstance from
I_WorkflowTask _WorkflowTask inner

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IEHSTASKDUEDATE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label EHS Task Due Date view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #COMPOSITE view

Fields (1)

KeyFieldSource TableSource FieldDescription
KEY WorkflowTaskInternalID I_WorkflowTask WorkflowTaskInternalID 
@AbapCatalog.sqlViewName: 'IEHSTASKDUEDATE'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AccessControl.personalData.blocking: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'EHS Task Due Date'
@ObjectModel.usageType:{ serviceQuality: #D,
                         sizeCategory:  #L,
                         dataClass: #TRANSACTIONAL }
@VDM: {
  viewType: #COMPOSITE
}
// Don't use for determining Due Date of a Task Instance, it is already present in view I_EHSTaskInstance

define view I_EHSTaskDueDate as select from I_EHSTaskInstance as _TaskInstance
inner join I_WorkflowTask as _WorkflowTask on _WorkflowTask.TopLevelWorkflowTask = _TaskInstance.WorkflowTaskInternalID
{
  key _WorkflowTask.WorkflowTaskInternalID,
  cast( tstmp_to_dats(
          _WorkflowTask._TaskDueDate.WorkflowTaskDueUTCDateTime,
          _TaskInstance.EHSTaskTimeZone,
          $session.client,
          'NULL'
        ) as ehfnd_task_def_due_date preserving type ) as EHSTaskDueDate
}
where _WorkflowTask.WorkflowTaskType != 'F'

Learn More