C_EHSControlImplementationTask

DDL: C_EHSCONTROLIMPLEMENTATIONTASK Type: view CONSUMPTION Package: EHHSS_CNS_RISK_ASSESSMENT
53 Fields 1 Data Sources 2 Associations

Control Implementation Task

C_EHSControlImplementationTask is a Consumption CDS View that provides data about "Control Implementation Task" in SAP S/4HANA. It reads from 1 data source (C_EHSCombinedTaskDefAndInstce) and exposes 53 fields with key fields EHSTaskDefinitionUUID, WorkflowTaskInternalID, EHSPlannedTaskUUID. It has 2 associations to related views. Part of development package EHHSS_CNS_RISK_ASSESSMENT.

Data Sources (1)

SourceAliasJoin Type
C_EHSCombinedTaskDefAndInstce CombinedTaskDefAndInstce from

Associations (2)

CardinalityTargetAliasCondition
[1..1] E_EHSTaskDefinition _Extension $projection.EHSTaskDefinitionUUID = _Extension.EHSTaskDefinitionUUID
[1..1] E_EHSTaskPlannedInstance _ExtensionInstance $projection.EHSPlannedTaskUUID = _ExtensionInstance.EHSPlannedTaskUUID

Annotations (12)

NameValueLevelField
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName CEHSCTRLTSK view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
Consumption.semanticObject EHSTask view
EndUserText.label Control Implementation Task view
Metadata.allowExtensions true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view

Fields (53)

KeyFieldSource TableSource FieldDescription
KEY EHSTaskDefinitionUUID EHSTaskDefinitionUUID Task Definition
KEY WorkflowTaskInternalID WorkflowTaskInternalID Work Item ID
KEY EHSPlannedTaskUUID EHSPlannedTaskUUID Planned Task
EHSTaskHostObjectInstanceUUID EHSTaskHostObjectInstanceUUID Host Obj. UUID
EHSTaskHostObjectInstance EHSTaskHostObjectInstance Instance ID
EHSTaskHostObjectAdapterClass EHSTaskHostObjectAdapterClass Class Name
EHSTaskHostSemanticObject EHSTaskHostSemanticObject
EHSTaskHasWorkflow EHSTaskHasWorkflow
EHSTaskDefinitionType EHSTaskDefinitionType Task Type
EHSTaskTitle EHSTaskTitle Title
EHSPlannedTaskID EHSPlannedTaskID ID
EHSTaskOwnerUser EHSTaskOwnerUser Owner
EHSTaskInstanceProcessorUser EHSTaskInstanceProcessorUser User Name
EHSTaskInstanceProcessorName EHSTaskInstanceProcessorName
EHSTaskOwnerBP EHSTaskOwnerBP Owner
EHSTaskOwnerUserName EHSTaskOwnerUserName
EHSTaskAssignedBP EHSTaskAssignedBP Assignee
EHSTaskAssignedUserName EHSTaskAssignedUserName
EHSTaskApprovingBP EHSTaskApprovingBP Approver
EHSTaskApprovingUserName EHSTaskApprovingUserName
WorkflowTaskStatus WorkflowTaskStatus
EHSTaskDefinitionStatus EHSTaskDefinitionStatus Status
EHSTaskStatusName EHSTaskStatusName
EHSTaskStatusCriticality EHSTaskStatusCriticality
EHSTaskStatusValueForSorting EHSTaskStatusValueForSorting
EHSTaskStartDate EHSTaskStartDate Start Date
EHSTaskDueDate EHSTaskDueDate Due Date
EHSTaskInstceCompletionDate EHSTaskInstceCompletionDate Completion Date
WrkflwTskCompletionUTCDateTime WrkflwTskCompletionUTCDateTime
EHSTaskDateForSorting EHSTaskDateForSorting
EHSTaskTimeZone EHSTaskTimeZone Time Zone
EHSTaskIsRecurrent EHSTaskIsRecurrent
EHSTaskDefinitionIsPaused EHSTaskDefinitionIsPaused Is Paused
EHSTaskDefinitionManageAction EHSTaskDefinitionManageAction Action TaskDef
EHSTaskInstanceDisplayAction EHSTaskInstanceDisplayAction Action TaskInst
IsDraftEntity IsDraftEntity
DraftEntityLastChangeDateTime DraftEntityLastChangeDateTime Draft Last Changed On
DraftIsLastChangedByMe DraftIsLastChangedByMe
LastChangedByUserDescription LastChangedByUserDescription Description
DraftIsProcessedByMe DraftIsProcessedByMe
InProcessByUserDescription InProcessByUserDescription
InProcessByUser InProcessByUser
HasActiveEntity HasActiveEntity TRUE
DraftUUID DraftUUID UUID
_EHSTaskDefinitionTypeText _EHSTaskDefinitionTypeText
_TernaryLogicalStateText _TernaryLogicalStateText
_EHSTaskAdapterClass _EHSTaskAdapterClass
_IncidentAuthorizationFields _IncidentAuthorizationFields
_EHSCtrlImplmtnAuthznFields _EHSCtrlImplmtnAuthznFields
_EHSRskAssessmentAuthznFields _EHSRskAssessmentAuthznFields
_EHSCmplncScenAuthznFields _EHSCmplncScenAuthznFields
_CmplncRqmtAuthznFields _CmplncRqmtAuthznFields
IncidentHasAccessRestriction

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_EHSControlImplementationTask.
-- 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.

CREATE VIEW C_EHSControlImplementationTask AS
SELECT
  EHSTaskDefinitionUUID,
  WorkflowTaskInternalID,
  EHSPlannedTaskUUID,
  EHSTaskHostObjectInstanceUUID,
  EHSTaskHostObjectInstance,
  EHSTaskHostObjectAdapterClass,
  EHSTaskHostSemanticObject,
  EHSTaskHasWorkflow,
  EHSTaskDefinitionType,
  EHSTaskTitle,
  EHSPlannedTaskID,
  EHSTaskOwnerUser,
  EHSTaskInstanceProcessorUser,
  EHSTaskInstanceProcessorName,
  EHSTaskOwnerBP,
  EHSTaskOwnerUserName,
  EHSTaskAssignedBP,
  EHSTaskAssignedUserName,
  EHSTaskApprovingBP,
  EHSTaskApprovingUserName,
  WorkflowTaskStatus,
  EHSTaskDefinitionStatus,
  EHSTaskStatusName,
  EHSTaskStatusCriticality,
  EHSTaskStatusValueForSorting,
  EHSTaskStartDate,
  EHSTaskDueDate,
  EHSTaskInstceCompletionDate,
  WrkflwTskCompletionUTCDateTime,
  EHSTaskDateForSorting,
  EHSTaskTimeZone,
  EHSTaskIsRecurrent,
  EHSTaskDefinitionIsPaused,
  EHSTaskDefinitionManageAction,
  EHSTaskInstanceDisplayAction,
  IsDraftEntity,
  DraftEntityLastChangeDateTime,
  DraftIsLastChangedByMe,
  LastChangedByUserDescription,
  DraftIsProcessedByMe,
  InProcessByUserDescription,
  InProcessByUser,
  HasActiveEntity,
  DraftUUID,
  ' ' AS 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]
;

Learn More