C_IncidentTaskDefAndInstance

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_IncidentTaskDefAndInstance.
-- 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: CINCDEFINST

CREATE VIEW C_IncidentTaskDefAndInstance AS
SELECT
  EHSTaskDefinitionUUID,
  WorkflowTaskInternalID,
  EHSPlannedTaskUUID,
  EHSTaskHostObjectInstance,
  EHSTaskHostObjectInstanceUUID,
  EHSTaskHostObjectAdapterClass,
  EHSTaskHostSemanticObject,
  EHSTaskHasWorkflow,
  EHSTaskTitle,
  EHSPlannedTaskID,
  EHSTaskDefinitionType,
  EHSTaskStatusName,
  EHSTaskStatusCriticality,
  EHSTaskDueDate,
  EHSTaskIsRecurrent,
  cast(EHSTaskInstanceProcessorName as ehfnd_current_processor_name) AS EHSTaskInstanceProcessorName,
  cast ( '' as ehfnd_task_reference_descr ) AS EHSTskRelatedObjectDescription,
  EHSTaskStartDate,
  EHSTaskInstceCompletionDate,
  EHSTaskStatusValueForSorting,
  EHSTaskDateForSorting,
  EHSTaskDefinitionIsPaused,
  WorkflowTaskStatus,
  WrkflwTskCompletionUTCDateTime,
  EHSTaskDefinitionStatus,
  EHSTaskTimeZone,
  EHSTaskDefinitionManageAction,
  EHSTaskInstanceDisplayAction,
  EHSTaskOwnerUser,
  EHSTaskOwnerBP,
  EHSTaskOwnerUserName,
  EHSTaskAssignedBP,
  EHSTaskAssignedUserName,
  EHSTaskAssignedLocRoleName,
  EHSTaskApprovingBP,
  EHSTaskApprovingUserName,
  EHSTaskApproverLocRoleName,
  EHSTaskInstanceProcessorUser,
  IsDraftEntity,
  EditingStatusText,
  DraftEntityLastChangeDateTime,
  DraftIsLastChangedByMe,
  LastChangedByUserDescription,
  DraftIsProcessedByMe,
  InProcessByUserDescription,
  InProcessByUser,
  HasActiveEntity,
  DraftUUID,
  _EHSTaskDefinitionTypeText[1:Language = $session.system_language ].EHSTaskDefinitionTypeName AS EHSTaskDefinitionTypeName,
  _IncidentAuthorizationFields.IncidentUUID AS IncidentUUID,
  IncidentHasAccessRestriction
FROM C_EHSCombinedTaskDefAndInstce AS CombinedTaskDefAndInstce
LEFT OUTER JOIN E_EHSTaskDefinition AS _Extension ON EHSTaskDefinitionUUID = _Extension.EHSTaskDefinitionUUID  -- association [1..1]
LEFT OUTER JOIN E_EHSTaskPlannedInstance AS _ExtensionInstance ON EHSPlannedTaskUUID = _ExtensionInstance.EHSPlannedTaskUUID  -- association [1..1]
;