I_EHSTaskInFutureOrPaused

DDL: I_EHSTASKINFUTUREORPAUSED SQL: IEHSTASKFUTPAUSE Type: view COMPOSITE Package: EHFND_BO_TASK_DEFINITION
30 Fields 1 Data Sources

EHS Task in future or paused

I_EHSTaskInFutureOrPaused is a Composite CDS View that provides data about "EHS Task in future or paused" in SAP S/4HANA. It reads from 1 data source (I_EHSTaskFutureInstance) and exposes 30 fields with key fields EHSTaskDefinitionUUID, EHSPlannedTaskUUID. Part of development package EHFND_BO_TASK_DEFINITION.

Data Sources (1)

SourceAliasJoin Type
I_EHSTaskFutureInstance EHSTaskFutureInstance from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IEHSTASKFUTPAUSE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label EHS Task in future or paused view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.viewType #COMPOSITE view

Fields (30)

KeyFieldSource TableSource FieldDescription
KEY EHSTaskDefinitionUUID I_EHSTaskFutureInstance EHSTaskDefinitionUUID Task Definition
KEY EHSPlannedTaskUUID EHSPlannedTaskUUID Planned Task
EHSTaskHostObjectInstanceUUID I_EHSTaskFutureInstance EHSTaskHostObjectInstanceUUID Host Obj. UUID
EHSTaskHostObjectInstance I_EHSTaskFutureInstance EHSTaskHostObjectInstance Instance ID
EHSTaskHostObjectAdapterClass I_EHSTaskFutureInstance EHSTaskHostObjectAdapterClass Class Name
EHSTaskDefinitionType I_EHSTaskFutureInstance EHSTaskDefinitionType Task Type
EHSTaskDefinitionStatus I_EHSTaskFutureInstance EHSTaskDefinitionStatus Status
EHSTaskTitle I_EHSTaskFutureInstance EHSTaskTitle Title
EHSTaskOwnerUser I_EHSTaskFutureInstance EHSTaskOwnerBP Owner
EHSTaskAssignedBP I_EHSTaskFutureInstance EHSTaskAssignedBP Assignee
EHSTaskApprovingBP I_EHSTaskFutureInstance EHSTaskApprovingBP Approver
EHSTaskPriority I_EHSTaskFutureInstance EHSTaskPriority Priority
EHSTaskStartDate I_EHSTaskFutureInstance EHSTaskStartDate Start Date
EHSTaskDueDate I_EHSTaskFutureInstance EHSTaskDueDate Due Date
EHSTaskRecurrenceType I_EHSTaskFutureInstance EHSTaskRecurrenceType Recurrence Type
EHSTaskDefinitionIsPaused I_EHSTaskFutureInstance EHSTaskDefinitionIsPaused Is Paused
_EHSTaskOwnerUser I_EHSTaskFutureInstance _EHSTaskOwnerUser
_EHSTaskAssignedUser I_EHSTaskFutureInstance _EHSTaskAssignedUser
EHSTaskNextExecUTCDateTime I_EHSTaskFutureInstance EHSTaskNextExecUTCDateTime Time Stamp
_EHSTaskPriority I_EHSTaskFutureInstance _EHSTaskPriority
_EHSTaskAdapterClass I_EHSTaskFutureInstance _EHSTaskAdapterClass
EHSLocationUUID I_EHSTaskFutureInstance EHSLocationUUID NodeID
EHSTaskTimeZone I_EHSTaskFutureInstance EHSTaskTimeZone Time Zone
_IncidentAuthorizationFields I_EHSTaskFutureInstance _IncidentAuthorizationFields
_EHSCtrlImplmtnAuthznFields I_EHSTaskFutureInstance _EHSCtrlImplmtnAuthznFields
_EHSRskAssessmentAuthznFields I_EHSTaskFutureInstance _EHSRskAssessmentAuthznFields
_EHSRskAssmt2RskCtrlAuthznFld I_EHSTaskFutureInstance _EHSRskAssmt2RskCtrlAuthznFld
_EHSCmplncScenAuthznFields I_EHSTaskFutureInstance _EHSCmplncScenAuthznFields
_CmplncRqmtAuthznFields I_EHSTaskFutureInstance _CmplncRqmtAuthznFields
IncidentHasAccessRestriction I_EHSTaskFutureInstance IncidentHasAccessRestriction Restricted

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_EHSTaskInFutureOrPaused.
-- 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: IEHSTASKFUTPAUSE

CREATE VIEW I_EHSTaskInFutureOrPaused AS
SELECT
  EHSTaskFutureInstance.EHSTaskDefinitionUUID AS EHSTaskDefinitionUUID,
  EHSPlannedTaskUUID,
  EHSTaskFutureInstance.EHSTaskHostObjectInstanceUUID AS EHSTaskHostObjectInstanceUUID,
  EHSTaskFutureInstance.EHSTaskHostObjectInstance AS EHSTaskHostObjectInstance,
  EHSTaskFutureInstance.EHSTaskHostObjectAdapterClass AS EHSTaskHostObjectAdapterClass,
  EHSTaskFutureInstance.EHSTaskDefinitionType AS EHSTaskDefinitionType,
  EHSTaskFutureInstance.EHSTaskDefinitionStatus AS EHSTaskDefinitionStatus,
  EHSTaskFutureInstance.EHSTaskTitle AS EHSTaskTitle,
  EHSTaskFutureInstance.EHSTaskOwnerBP AS EHSTaskOwnerUser,
  EHSTaskFutureInstance.EHSTaskAssignedBP AS EHSTaskAssignedBP,
  EHSTaskFutureInstance.EHSTaskApprovingBP AS EHSTaskApprovingBP,
  EHSTaskFutureInstance.EHSTaskPriority AS EHSTaskPriority,
  EHSTaskFutureInstance.EHSTaskStartDate AS EHSTaskStartDate,
  EHSTaskFutureInstance.EHSTaskDueDate AS EHSTaskDueDate,
  EHSTaskFutureInstance.EHSTaskRecurrenceType AS EHSTaskRecurrenceType,
  EHSTaskFutureInstance.EHSTaskDefinitionIsPaused AS EHSTaskDefinitionIsPaused,
  EHSTaskFutureInstance._EHSTaskOwnerUser AS _EHSTaskOwnerUser,
  EHSTaskFutureInstance._EHSTaskAssignedUser AS _EHSTaskAssignedUser,
  EHSTaskFutureInstance.EHSTaskNextExecUTCDateTime AS EHSTaskNextExecUTCDateTime,
  EHSTaskFutureInstance._EHSTaskPriority AS _EHSTaskPriority,
  EHSTaskFutureInstance._EHSTaskAdapterClass AS _EHSTaskAdapterClass,
  EHSTaskFutureInstance.EHSLocationUUID AS EHSLocationUUID,
  EHSTaskFutureInstance.EHSTaskTimeZone AS EHSTaskTimeZone,
  EHSTaskFutureInstance._IncidentAuthorizationFields AS _IncidentAuthorizationFields,
  EHSTaskFutureInstance._EHSCtrlImplmtnAuthznFields AS _EHSCtrlImplmtnAuthznFields,
  EHSTaskFutureInstance._EHSRskAssessmentAuthznFields AS _EHSRskAssessmentAuthznFields,
  EHSTaskFutureInstance._EHSRskAssmt2RskCtrlAuthznFld AS _EHSRskAssmt2RskCtrlAuthznFld,
  EHSTaskFutureInstance._EHSCmplncScenAuthznFields AS _EHSCmplncScenAuthznFields,
  EHSTaskFutureInstance._CmplncRqmtAuthznFields AS _CmplncRqmtAuthznFields,
  EHSTaskFutureInstance.IncidentHasAccessRestriction AS IncidentHasAccessRestriction
FROM I_EHSTaskFutureInstance AS EHSTaskFutureInstance
;

Learn More