C_EHSTaskPlannedInstancesAll

DDL: C_EHSTASKPLANNEDINSTANCESALL SQL: CEHSTASKPLANAL Type: view CONSUMPTION
20 Fields 1 Data Sources 2 Associations

EHS Planned and Executed Task Instances

C_EHSTaskPlannedInstancesAll is a Consumption CDS View that provides data about "EHS Planned and Executed Task Instances" in SAP S/4HANA. It reads from 1 data source (I_EHSCombinedTaskDefAndInstce) and exposes 20 fields with key field EHSPlannedTaskUUID. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_EHSCombinedTaskDefAndInstce EHSCombinedTaskDefAndInstce from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_EHSTaskDefinitionTypeText _EHSTaskDefinitionTypeText $projection.EHSTaskDefinitionType = _EHSTaskDefinitionTypeText.EHSTaskDefinitionType and _EHSTaskDefinitionTypeText.Language = $session.system_language
[0..1] I_EHSTaskCalendarStatusText _EHSTaskCalendarStatusText $projection.WorkflowTaskStatus = _EHSTaskCalendarStatusText.EHSTaskStatus and _EHSTaskCalendarStatusText.Language = $session.system_language

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CEHSTASKPLANAL view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label EHS Planned and Executed Task Instances view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY EHSPlannedTaskUUID I_EHSCombinedTaskDefAndInstce EHSPlannedTaskUUID Planned Task
EHSPlannedTaskID I_EHSCombinedTaskDefAndInstce EHSPlannedTaskID ID
EHSTaskTitle I_EHSCombinedTaskDefAndInstce EHSTaskTitle Title
EHSTaskDefinitionTypeName _EHSTaskDefinitionTypeText EHSTaskDefinitionTypeName
EHSTaskStartDate I_EHSCombinedTaskDefAndInstce EHSTaskStartDate Start Date
EHSTaskDueDate I_EHSCombinedTaskDefAndInstce EHSTaskDueDate Due Date
EHSTaskDefinitionType I_EHSCombinedTaskDefAndInstce EHSTaskDefinitionType Task Type
WorkflowTaskStatus I_EHSCombinedTaskDefAndInstce EHSTaskStatusValueForSorting
EHSTaskStatusName _EHSTaskCalendarStatusText EHSTaskStatusName
EHSTaskOwnerUser I_EHSCombinedTaskDefAndInstce EHSTaskOwnerUser Owner
EHSTaskHostObjectInstance I_EHSCombinedTaskDefAndInstce EHSTaskHostObjectInstance Instance ID
EHSTaskHostObjectInstanceUUID I_EHSCombinedTaskDefAndInstce EHSTaskHostObjectInstanceUUID Host Obj. UUID
EHSTaskHostObjectAdapterClass I_EHSCombinedTaskDefAndInstce EHSTaskHostObjectAdapterClass Class Name
_EHSTaskAdapterClass I_EHSCombinedTaskDefAndInstce _EHSTaskAdapterClass
_IncidentAuthorizationFields I_EHSCombinedTaskDefAndInstce _IncidentAuthorizationFields
_EHSCtrlImplmtnAuthznFields I_EHSCombinedTaskDefAndInstce _EHSCtrlImplmtnAuthznFields
_EHSRskAssessmentAuthznFields I_EHSCombinedTaskDefAndInstce _EHSRskAssessmentAuthznFields
_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_EHSTaskPlannedInstancesAll.
-- 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: CEHSTASKPLANAL

CREATE VIEW C_EHSTaskPlannedInstancesAll AS
SELECT
  EHSCombinedTaskDefAndInstce.EHSPlannedTaskUUID AS EHSPlannedTaskUUID,
  EHSCombinedTaskDefAndInstce.EHSPlannedTaskID AS EHSPlannedTaskID,
  EHSCombinedTaskDefAndInstce.EHSTaskTitle AS EHSTaskTitle,
  _EHSTaskDefinitionTypeText.EHSTaskDefinitionTypeName AS EHSTaskDefinitionTypeName,
  EHSCombinedTaskDefAndInstce.EHSTaskStartDate AS EHSTaskStartDate,
  EHSCombinedTaskDefAndInstce.EHSTaskDueDate AS EHSTaskDueDate,
  EHSCombinedTaskDefAndInstce.EHSTaskDefinitionType AS EHSTaskDefinitionType,
  EHSCombinedTaskDefAndInstce.EHSTaskStatusValueForSorting AS WorkflowTaskStatus,
  _EHSTaskCalendarStatusText.EHSTaskStatusName AS EHSTaskStatusName,
  EHSCombinedTaskDefAndInstce.EHSTaskOwnerUser AS EHSTaskOwnerUser,
  EHSCombinedTaskDefAndInstce.EHSTaskHostObjectInstance AS EHSTaskHostObjectInstance,
  EHSCombinedTaskDefAndInstce.EHSTaskHostObjectInstanceUUID AS EHSTaskHostObjectInstanceUUID,
  EHSCombinedTaskDefAndInstce.EHSTaskHostObjectAdapterClass AS EHSTaskHostObjectAdapterClass,
  EHSCombinedTaskDefAndInstce._EHSTaskAdapterClass AS _EHSTaskAdapterClass,
  EHSCombinedTaskDefAndInstce._IncidentAuthorizationFields AS _IncidentAuthorizationFields,
  EHSCombinedTaskDefAndInstce._EHSCtrlImplmtnAuthznFields AS _EHSCtrlImplmtnAuthznFields,
  EHSCombinedTaskDefAndInstce._EHSRskAssessmentAuthznFields AS _EHSRskAssessmentAuthznFields,
  EHSCombinedTaskDefAndInstce._EHSCmplncScenAuthznFields AS _EHSCmplncScenAuthznFields,
  EHSCombinedTaskDefAndInstce._CmplncRqmtAuthznFields AS _CmplncRqmtAuthznFields,
  EHSCombinedTaskDefAndInstce.IncidentHasAccessRestriction AS IncidentHasAccessRestriction
FROM I_EHSCombinedTaskDefAndInstce AS EHSCombinedTaskDefAndInstce
LEFT OUTER JOIN I_EHSTaskDefinitionTypeText AS _EHSTaskDefinitionTypeText ON EHSTaskDefinitionType = _EHSTaskDefinitionTypeText.EHSTaskDefinitionType AND _EHSTaskDefinitionTypeText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_EHSTaskCalendarStatusText AS _EHSTaskCalendarStatusText ON WorkflowTaskStatus = _EHSTaskCalendarStatusText.EHSTaskStatus AND _EHSTaskCalendarStatusText.Language = $session.system_language  -- association [0..1]
;

Learn More