P_EHSTASKINSTANCETODEFINITION

CDS View

Connects Task Instances to Definitions

P_EHSTASKINSTANCETODEFINITION is a CDS View in S/4HANA. Connects Task Instances to Definitions. It contains 6 fields. 3 CDS views read from this table.

Used by 3 CDS view(s) 6 fields

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_EHSTask view inner COMPOSITE EHS Task
P_EHSWorkflowStep view inner COMPOSITE EHS Workflow Step
P_TaskDefAndInstForCount view union COMPOSITE EHS Task Definitions and Instances for counting

Fields (6)

KeyField CDS FieldsUsed in Views
KEY WorkflowTaskInternalID WorkflowTaskInternalID 1
_EHSTaskDefinition _EHSTaskDefinition 1
EHSTaskDefinitionUUID EHSTaskDefinitionUUID 1
EHSTaskHostObjectAdapterClass EHSTaskHostObjectAdapterClass 1
EHSTaskHostObjectInstance EHSTaskHostObjectInstance 2
EHSTaskHostObjectInstanceUUID EHSTaskHostObjectInstanceUUID 1 
@AbapCatalog.sqlViewName: 'PEHSTDEF2WF'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling: {
  algorithm: #SESSION_VARIABLE
}
@VDM.private: true
@VDM.viewType: #COMPOSITE
//@EndUserText.label: 'Connects Task Instances to Definitions'


/*+[hideWarning] { "IDS" : [ "KEY_CHECK" ] }*/
define view P_EHSTaskInstanceToDefinition
  as select from I_EHSTaskPlannedInstance
  association [0..1] to I_WorkflowTask as _WorkflowTask     on $projection.WorkflowTaskInternalID = _WorkflowTask.WorkflowTaskInternalID
  association [0..1] to I_BusinessUser as _EHSTaskOwnerUser on $projection.ehstaskowneruser = _EHSTaskOwnerUser.BusinessPartner
{
      @ObjectModel.foreignKey.association: '_EHSTaskDefinition'
  key EHSTaskDefinitionUUID,
      @ObjectModel.foreignKey.association: '_WorkflowTask'
  key WorkflowTaskInternalID,
      _EHSTaskDefinition.EHSTaskOwnerUser,
      _EHSTaskDefinition.EHSTaskAssignedUser as EHSTaskAssignedBP,
      _EHSTaskDefinition.EHSTaskHostObjectInstance,
      _EHSTaskDefinition.EHSTaskHostObjectInstanceUUID,
      _EHSTaskDefinition.EHSTaskDefinitionStatus,
      _EHSTaskDefinition.EHSLocationUUID,
      _EHSTaskDefinition.EHSTaskHostObjectAdapterClass,

      _EHSTaskDefinition,
      _WorkflowTask,
      _EHSTaskOwnerUser
}

Learn More