I_EHSCombinedTaskDefAndInstce

DDL: I_EHSCOMBINEDTASKDEFANDINSTCE SQL: IEHSTASKDEFINSTN Type: view COMPOSITE
43 Fields 1 Data Sources 3 Associations

Task Instances and Future Definitions

I_EHSCombinedTaskDefAndInstce is a Composite CDS View that provides data about "Task Instances and Future Definitions" in SAP S/4HANA. It reads from 1 data source (I_EHSTaskPlannedInstance) and exposes 43 fields with key field EHSPlannedTaskUUID. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_EHSTaskPlannedInstance PlannedInstance from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_BusinessUser _EHSTaskAssignedUser PlannedInstance.EHSTaskAssignedBP = _EHSTaskAssignedUser.BusinessPartner
[0..1] I_EHSTaskPriority _EHSTaskPriority $projection.EHSTaskPriority = _EHSTaskPriority.EHSTaskPriority
[0..*] I_OTRText _OTRText _OTRText.Language = $session.system_language

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IEHSTASKDEFINSTN view
VDM.viewType #COMPOSITE view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Task Instances and Future Definitions view

Fields (43)

KeyFieldSource TableSource FieldDescription
KEY EHSPlannedTaskUUID I_EHSTaskPlannedInstance EHSPlannedTaskUUID Planned Task
EHSTaskDefinitionUUID I_EHSTaskPlannedInstance EHSTaskDefinitionUUID Task Definition
WorkflowTaskInternalID I_EHSTaskPlannedInstance WorkflowTaskInternalID Work Item ID
WorkflowTaskStatus WorkflowTask WorkflowTaskStatus
WorkflowTaskDefinition WorkflowTask WorkflowTaskDefinition
EHSTaskHostSemanticObject
EHSTaskHostObjectAdapterClass
EHSTaskHostObjectInstance
EHSTaskHostObjectInstanceUUID
EHSTaskDefinitionType
EHSTaskDefinitionStatus
EHSTaskDefinitionIsPaused
EHSTaskPriorityasEHSTaskPriority
EHSTaskRecurrenceType
EHSTaskStartDate I_EHSTaskPlannedInstance EHSTaskStartDate Start Date
EHSTaskDueDate I_EHSTaskPlannedInstance EHSTaskDueDate Due Date
WrkflwTskCompletionUTCDateTime WorkflowTask WrkflwTskCompletionUTCDateTime
EHSTaskInstceCompletionDate I_EHSTaskPlannedInstance EHSTaskInstceCompletionDate Completion Date
EHSTaskUser
EHSTaskOwnerUser
EHSTaskInstanceProcessorBP I_EHSTaskPlannedInstance EHSTaskInstanceProcessorBP Current Processor
EHSTaskAssignedBP I_EHSTaskPlannedInstance EHSTaskAssignedBP Assignee
EHSTaskAssignedUserName
EHSTaskApprovingBP I_EHSTaskPlannedInstance EHSTaskApprovingBP Approver
EHSTaskOwnerBP I_EHSTaskPlannedInstance EHSTaskOwnerBP Owner
EHSTaskAssignedLocRole I_EHSTaskPlannedInstance EHSTaskAssignedLocRole Assignee Location Role
EHSTaskApproverLocRole I_EHSTaskPlannedInstance EHSTaskApproverLocRole Approver Location Role
EHSLocationUUID
EHSTaskTimeZone I_EHSTaskPlannedInstance EHSTaskTimeZone Time Zone
_EHSTaskAdapterClass
_EHSTaskOwnerUser I_EHSTaskPlannedInstance _EHSTaskOwnerUser
_EHSTaskAssignedUser _EHSTaskAssignedUser
_EHSTaskDefinition I_EHSTaskPlannedInstance _EHSTaskDefinition
EHSLearningUUID
_IncidentAuthorizationFields
_EHSCtrlImplmtnAuthznFields
_EHSRskAssessmentAuthznFields
_EHSRskAssmt2RskCtrlAuthznFld
_EHSCmplncScenAuthznFields
_CmplncRqmtAuthznFields
_EHSTaskPriority _EHSTaskPriority
IncidentHasAccessRestriction
EHSPlannedTaskID I_EHSTaskPlannedInstance EHSPlannedTaskID ID

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_EHSCombinedTaskDefAndInstce.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: IEHSTASKDEFINSTN

CREATE VIEW I_EHSCombinedTaskDefAndInstce AS
SELECT
  PlannedInstance.EHSPlannedTaskUUID AS EHSPlannedTaskUUID,
  PlannedInstance.EHSTaskDefinitionUUID AS EHSTaskDefinitionUUID,
  PlannedInstance.WorkflowTaskInternalID AS WorkflowTaskInternalID,
  WorkflowTask.WorkflowTaskStatus AS WorkflowTaskStatus,
  WorkflowTask.WorkflowTaskDefinition AS WorkflowTaskDefinition,
  PlannedInstance._EHSTaskDefinition._EHSTaskAdapterClass.EHSSemanticObject AS EHSTaskHostSemanticObject,
  PlannedInstance._EHSTaskDefinition.EHSTaskHostObjectAdapterClass AS EHSTaskHostObjectAdapterClass,
  PlannedInstance._EHSTaskDefinition.EHSTaskHostObjectInstance AS EHSTaskHostObjectInstance,
  PlannedInstance._EHSTaskDefinition.EHSTaskHostObjectInstanceUUID AS EHSTaskHostObjectInstanceUUID,
  PlannedInstance._EHSTaskDefinition.EHSTaskWorkflowEvent AS EHSTaskDefinitionType,
  PlannedInstance._EHSTaskDefinition.EHSTaskDefinitionStatus AS EHSTaskDefinitionStatus,
  PlannedInstance._EHSTaskDefinition.EHSTaskDefinitionIsPaused AS EHSTaskDefinitionIsPaused,
  coalesce( cast(WorkflowTask.WorkflowTaskPriority as ehfnd_task_def_priority_code preserving type ), PlannedInstance._EHSTaskDefinition.EHSTaskPriority ) as EHSTaskPriority AS EHSTaskPriorityasEHSTaskPriority,
  PlannedInstance._EHSTaskDefinition.EHSTaskRecurrenceType AS EHSTaskRecurrenceType,
  PlannedInstance.EHSTaskStartDate AS EHSTaskStartDate,
  PlannedInstance.EHSTaskDueDate AS EHSTaskDueDate,
  WorkflowTask.WrkflwTskCompletionUTCDateTime AS WrkflwTskCompletionUTCDateTime,
  PlannedInstance.EHSTaskInstceCompletionDate AS EHSTaskInstceCompletionDate,
  cast ( '' as bu_partner ) AS EHSTaskUser,
  PlannedInstance._EHSTaskOwnerUser.UserID AS EHSTaskOwnerUser,
  PlannedInstance.EHSTaskInstanceProcessorBP AS EHSTaskInstanceProcessorBP,
  PlannedInstance.EHSTaskAssignedBP AS EHSTaskAssignedBP,
  PlannedInstance._EHSTaskAssigneeUser.PersonFullName AS EHSTaskAssignedUserName,
  PlannedInstance.EHSTaskApprovingBP AS EHSTaskApprovingBP,
  PlannedInstance.EHSTaskOwnerBP AS EHSTaskOwnerBP,
  PlannedInstance.EHSTaskAssignedLocRole AS EHSTaskAssignedLocRole,
  PlannedInstance.EHSTaskApproverLocRole AS EHSTaskApproverLocRole,
  PlannedInstance._EHSTaskDefinition.EHSLocationUUID AS EHSLocationUUID,
  PlannedInstance.EHSTaskTimeZone AS EHSTaskTimeZone,
  PlannedInstance._EHSTaskDefinition._EHSTaskAdapterClass AS _EHSTaskAdapterClass,
  PlannedInstance._EHSTaskOwnerUser AS _EHSTaskOwnerUser,
  PlannedInstance._EHSTaskDefinition AS _EHSTaskDefinition,
  PlannedInstance._EHSTaskDefinition._EHSTaskLearning.EHSLearningUUID AS EHSLearningUUID,
  PlannedInstance._EHSTaskDefinition._IncidentAuthorizationFields AS _IncidentAuthorizationFields,
  PlannedInstance._EHSTaskDefinition._EHSCtrlImplmtnAuthznFields AS _EHSCtrlImplmtnAuthznFields,
  PlannedInstance._EHSTaskDefinition._EHSRskAssessmentAuthznFields AS _EHSRskAssessmentAuthznFields,
  PlannedInstance._EHSTaskDefinition._EHSRskAssmt2RskCtrlAuthznFld AS _EHSRskAssmt2RskCtrlAuthznFld,
  PlannedInstance._EHSTaskDefinition._EHSCmplncScenAuthznFields AS _EHSCmplncScenAuthznFields,
  PlannedInstance._EHSTaskDefinition._CmplncRqmtAuthznFields AS _CmplncRqmtAuthznFields,
  PlannedInstance._EHSTaskDefinition._IncidentTaskRefAccRestricted.IncidentHasAccessRestriction AS IncidentHasAccessRestriction,
  PlannedInstance.EHSPlannedTaskID AS EHSPlannedTaskID
FROM I_EHSTaskPlannedInstance AS PlannedInstance
LEFT OUTER JOIN I_BusinessUser AS _EHSTaskAssignedUser ON PlannedInstance.EHSTaskAssignedBP = _EHSTaskAssignedUser.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_EHSTaskPriority AS _EHSTaskPriority ON EHSTaskPriority = _EHSTaskPriority.EHSTaskPriority  -- association [0..1]
LEFT OUTER JOIN I_OTRText AS _OTRText ON _OTRText.Language = $session.system_language  -- association [0..*]
;

Learn More