C_DeviationTriggeringTasks

DDL: C_DEVIATIONTRIGGERINGTASKS SQL: CDEVTRIGGER Type: view CONSUMPTION Package: EHHSS_CNS_INC_DEVIATION
43 Fields 2 Data Sources 4 Associations

Deviation Triggering Tasks

C_DeviationTriggeringTasks is a Consumption CDS View that provides data about "Deviation Triggering Tasks" in SAP S/4HANA. It reads from 2 data sources (I_EHSCombinedTaskDefAndInstce, I_EHSTaskFollowUp) and exposes 43 fields with key fields EHSTaskFollowUpUUID, EHSPlannedTaskUUID, EHSTaskDefinitionUUID. It has 4 associations to related views. Part of development package EHHSS_CNS_INC_DEVIATION.

Data Sources (2)

SourceAliasJoin Type
I_EHSCombinedTaskDefAndInstce EHSCombinedTaskDefAndInstce from
I_EHSTaskFollowUp EhsTaskFollowUps inner

Associations (4)

CardinalityTargetAliasCondition
[1..1] I_EHSTaskTriggerCategoryText _EHSTaskTriggerCategoryText $projection.TaskFollowCategoryCode = _EHSTaskTriggerCategoryText.TaskFollowCategoryCode and _EHSTaskTriggerCategoryText.Language = $session.system_language
[0..*] I_EHSTaskDefinitionTypeText _EHSTaskDefinitionTypeText $projection.EHSTaskDefinitionType = _EHSTaskDefinitionTypeText.EHSTaskDefinitionType
[0..1] I_EHSTaskPriorityText _EHSTaskPriorityText $projection.EHSTaskPriority = _EHSTaskPriorityText.EHSTaskPriority and _EHSTaskPriorityText.Language = $session.system_language
[0..1] I_EHSTaskCalendarStatusText _EHSTaskCalendarStatusText EHSCombinedTaskDefAndInstce.EHSTaskStatusValueForSorting = _EHSTaskCalendarStatusText.EHSTaskStatus and _EHSTaskCalendarStatusText.Language = $session.system_language

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName CDEVTRIGGER view
VDM.viewType #CONSUMPTION view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Deviation Triggering Tasks view
Consumption.semanticObject EHSTask view
ObjectModel.semanticKey EHSTaskTitle view
ObjectModel.representativeKey EHSTaskDefinitionUUID view
Metadata.allowExtensions true view

Fields (43)

KeyFieldSource TableSource FieldDescription
KEY EHSTaskFollowUpUUID I_EHSTaskFollowUp EHSTaskFollowUpUUID Follow Up
KEY EHSPlannedTaskUUID I_EHSCombinedTaskDefAndInstce EHSPlannedTaskUUID Planned Task
KEY EHSTaskDefinitionUUID I_EHSCombinedTaskDefAndInstce EHSTaskDefinitionUUID Task Definition
WorkflowTaskInternalID I_EHSCombinedTaskDefAndInstce WorkflowTaskInternalID Work Item ID
WorkflowTaskStatus I_EHSCombinedTaskDefAndInstce WorkflowTaskStatus
EHSTaskStatusName _EHSTaskCalendarStatusText EHSTaskStatusName
EHSTaskStartDate I_EHSCombinedTaskDefAndInstce EHSTaskStartDate Start Date
EHSTaskDueDate I_EHSCombinedTaskDefAndInstce EHSTaskDueDate Due Date
EHSTaskInstceCompletionDate I_EHSCombinedTaskDefAndInstce EHSTaskInstceCompletionDate Completion Date
EHSTaskTimeZone I_EHSCombinedTaskDefAndInstce EHSTaskTimeZone Time Zone
EHSPlannedTaskID I_EHSCombinedTaskDefAndInstce EHSPlannedTaskID ID
EHSTaskOwnerBP I_EHSCombinedTaskDefAndInstce EHSTaskOwnerBP Owner
EHSTaskOwnerUserName
PersonFullName
EHSTaskAssignedUserName
EHSTaskTitle I_EHSCombinedTaskDefAndInstce EHSTaskTitle Title
EHSTaskDefinitionType I_EHSCombinedTaskDefAndInstce EHSTaskDefinitionType Task Type
EHSTaskPriority I_EHSCombinedTaskDefAndInstce EHSTaskPriority Priority
EHSTaskPriorityName _EHSTaskPriorityText EHSTaskPriorityName
EHSTaskDefinitionStatus I_EHSCombinedTaskDefAndInstce EHSTaskDefinitionStatus Status
EHSTaskDefinitionIsPaused I_EHSCombinedTaskDefAndInstce EHSTaskDefinitionIsPaused Is Paused
EHSTaskRecurrenceType I_EHSCombinedTaskDefAndInstce EHSTaskRecurrenceType Recurrence Type
EHSLocationUUID I_EHSCombinedTaskDefAndInstce EHSLocationUUID NodeID
EHSLocationName
EHSTaskHostSemanticObject I_EHSCombinedTaskDefAndInstce EHSTaskHostSemanticObject
EHSTaskHostObjectInstance I_EHSCombinedTaskDefAndInstce EHSTaskHostObjectInstance Instance ID
EHSTaskHostObjectInstanceUUID I_EHSCombinedTaskDefAndInstce EHSTaskHostObjectInstanceUUID Host Obj. UUID
EHSTaskHostObjectAdapterClass I_EHSCombinedTaskDefAndInstce EHSTaskHostObjectAdapterClass Class Name
TaskFollowCategoryCode I_EHSTaskFollowUp TaskFollowCategoryCode Foll. Up Category
EHSTriggerCategoryDesc _EHSTaskTriggerCategoryText EHSTriggerCategoryDesc
TaskFollowRefObjUUID I_EHSTaskFollowUp TaskFollowRefObjUUID Follow-Up UUID
_EHSTaskOwnerUser _EHSTaskOwnerUser
_EHSTaskDefinitionTypeText _EHSTaskDefinitionTypeText
_EHSTaskPriority I_EHSCombinedTaskDefAndInstce _EHSTaskPriority
EHSTaskOwnerUser I_EHSCombinedTaskDefAndInstce EHSTaskOwnerUser Owner
_EHSTaskAdapterClass I_EHSCombinedTaskDefAndInstce _EHSTaskAdapterClass
_IncidentAuthorizationFields I_EHSCombinedTaskDefAndInstce _IncidentAuthorizationFields
_EHSCtrlImplmtnAuthznFields I_EHSCombinedTaskDefAndInstce _EHSCtrlImplmtnAuthznFields
_EHSRskAssessmentAuthznFields I_EHSCombinedTaskDefAndInstce _EHSRskAssessmentAuthznFields
_EHSRskAssmt2RskCtrlAuthznFld I_EHSCombinedTaskDefAndInstce _EHSRskAssmt2RskCtrlAuthznFld
_EHSCmplncScenAuthznFields I_EHSCombinedTaskDefAndInstce _EHSCmplncScenAuthznFields
_CmplncRqmtAuthznFields I_EHSCombinedTaskDefAndInstce _CmplncRqmtAuthznFields
IncidentHasAccessRestriction I_EHSCombinedTaskDefAndInstce 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 C_DeviationTriggeringTasks.
-- 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: CDEVTRIGGER

CREATE VIEW C_DeviationTriggeringTasks AS
SELECT
  EhsTaskFollowUps.EHSTaskFollowUpUUID AS EHSTaskFollowUpUUID,
  EHSCombinedTaskDefAndInstce.EHSPlannedTaskUUID AS EHSPlannedTaskUUID,
  EHSCombinedTaskDefAndInstce.EHSTaskDefinitionUUID AS EHSTaskDefinitionUUID,
  EHSCombinedTaskDefAndInstce.WorkflowTaskInternalID AS WorkflowTaskInternalID,
  EHSCombinedTaskDefAndInstce.WorkflowTaskStatus AS WorkflowTaskStatus,
  _EHSTaskCalendarStatusText.EHSTaskStatusName AS EHSTaskStatusName,
  EHSCombinedTaskDefAndInstce.EHSTaskStartDate AS EHSTaskStartDate,
  EHSCombinedTaskDefAndInstce.EHSTaskDueDate AS EHSTaskDueDate,
  EHSCombinedTaskDefAndInstce.EHSTaskInstceCompletionDate AS EHSTaskInstceCompletionDate,
  EHSCombinedTaskDefAndInstce.EHSTaskTimeZone AS EHSTaskTimeZone,
  EHSCombinedTaskDefAndInstce.EHSPlannedTaskID AS EHSPlannedTaskID,
  EHSCombinedTaskDefAndInstce.EHSTaskOwnerBP AS EHSTaskOwnerBP,
  EHSCombinedTaskDefAndInstce._EHSTaskOwnerUser.PersonFullName AS EHSTaskOwnerUserName,
  EHSCombinedTaskDefAndInstce._EHSTaskOwnerUser.PersonFullName AS PersonFullName,
  EHSCombinedTaskDefAndInstce._EHSTaskAssignedUser.PersonFullName AS EHSTaskAssignedUserName,
  EHSCombinedTaskDefAndInstce.EHSTaskTitle AS EHSTaskTitle,
  EHSCombinedTaskDefAndInstce.EHSTaskDefinitionType AS EHSTaskDefinitionType,
  EHSCombinedTaskDefAndInstce.EHSTaskPriority AS EHSTaskPriority,
  _EHSTaskPriorityText.EHSTaskPriorityName AS EHSTaskPriorityName,
  EHSCombinedTaskDefAndInstce.EHSTaskDefinitionStatus AS EHSTaskDefinitionStatus,
  EHSCombinedTaskDefAndInstce.EHSTaskDefinitionIsPaused AS EHSTaskDefinitionIsPaused,
  EHSCombinedTaskDefAndInstce.EHSTaskRecurrenceType AS EHSTaskRecurrenceType,
  EHSCombinedTaskDefAndInstce.EHSLocationUUID AS EHSLocationUUID,
  cast('' as ehfnd_loc_name) AS EHSLocationName,
  EHSCombinedTaskDefAndInstce.EHSTaskHostSemanticObject AS EHSTaskHostSemanticObject,
  EHSCombinedTaskDefAndInstce.EHSTaskHostObjectInstance AS EHSTaskHostObjectInstance,
  EHSCombinedTaskDefAndInstce.EHSTaskHostObjectInstanceUUID AS EHSTaskHostObjectInstanceUUID,
  EHSCombinedTaskDefAndInstce.EHSTaskHostObjectAdapterClass AS EHSTaskHostObjectAdapterClass,
  EhsTaskFollowUps.TaskFollowCategoryCode AS TaskFollowCategoryCode,
  _EHSTaskTriggerCategoryText.EHSTriggerCategoryDesc AS EHSTriggerCategoryDesc,
  EhsTaskFollowUps.TaskFollowRefObjUUID AS TaskFollowRefObjUUID,
  EHSCombinedTaskDefAndInstce._EHSTaskPriority AS _EHSTaskPriority,
  EHSCombinedTaskDefAndInstce.EHSTaskOwnerUser AS EHSTaskOwnerUser,
  EHSCombinedTaskDefAndInstce._EHSTaskAdapterClass AS _EHSTaskAdapterClass,
  EHSCombinedTaskDefAndInstce._IncidentAuthorizationFields AS _IncidentAuthorizationFields,
  EHSCombinedTaskDefAndInstce._EHSCtrlImplmtnAuthznFields AS _EHSCtrlImplmtnAuthznFields,
  EHSCombinedTaskDefAndInstce._EHSRskAssessmentAuthznFields AS _EHSRskAssessmentAuthznFields,
  EHSCombinedTaskDefAndInstce._EHSRskAssmt2RskCtrlAuthznFld AS _EHSRskAssmt2RskCtrlAuthznFld,
  EHSCombinedTaskDefAndInstce._EHSCmplncScenAuthznFields AS _EHSCmplncScenAuthznFields,
  EHSCombinedTaskDefAndInstce._CmplncRqmtAuthznFields AS _CmplncRqmtAuthznFields,
  EHSCombinedTaskDefAndInstce.IncidentHasAccessRestriction AS IncidentHasAccessRestriction
FROM I_EHSCombinedTaskDefAndInstce AS EHSCombinedTaskDefAndInstce
INNER JOIN I_EHSTaskFollowUp AS EhsTaskFollowUps ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_EHSTaskTriggerCategoryText AS _EHSTaskTriggerCategoryText ON TaskFollowCategoryCode = _EHSTaskTriggerCategoryText.TaskFollowCategoryCode AND _EHSTaskTriggerCategoryText.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_EHSTaskDefinitionTypeText AS _EHSTaskDefinitionTypeText ON EHSTaskDefinitionType = _EHSTaskDefinitionTypeText.EHSTaskDefinitionType  -- association [0..*]
LEFT OUTER JOIN I_EHSTaskPriorityText AS _EHSTaskPriorityText ON EHSTaskPriority = _EHSTaskPriorityText.EHSTaskPriority AND _EHSTaskPriorityText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_EHSTaskCalendarStatusText AS _EHSTaskCalendarStatusText ON EHSCombinedTaskDefAndInstce.EHSTaskStatusValueForSorting = _EHSTaskCalendarStatusText.EHSTaskStatus AND _EHSTaskCalendarStatusText.Language = $session.system_language  -- association [0..1]
;

Learn More