I_EHSCOMBINEDTASKDEFANDINSTCE

CDS View
32 Fields 6 CDS Views

Task Instances and Future Definitions

I_EHSCOMBINEDTASKDEFANDINSTCE is a CDS View in S/4HANA. Task Instances and Future Definitions. It contains 32 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
C_DeviationTriggeringTasks view from CONSUMPTION Deviation Triggering Tasks
C_EHSCombinedTaskDefAndInstce view from CONSUMPTION Task Instances and Future Definitions
C_EHSTaskPlannedInstancesAll view from CONSUMPTION EHS Planned and Executed Task Instances
I_DvtnIncdntTriggeringTask view from COMPOSITE Deviation Triggering Task
I_EHSTaskCalendar view from COMPOSITE EHS Task Calendar Items
P_NmbrOfClsdEHSTskDefAndInstce view from COMPOSITE

Fields (32)

KeyField CDS FieldsUsed in Views
KEY EHSPlannedTaskUUID EHSPlannedTaskUUID 3
KEY EHSTaskDefinitionUUID EHSTaskDefinitionUUID 1
_CmplncRqmtAuthznFields _CmplncRqmtAuthznFields 2
_EHSCmplncScenAuthznFields _EHSCmplncScenAuthznFields 2
_EHSCtrlImplmtnAuthznFields _EHSCtrlImplmtnAuthznFields 2
_EHSRskAssessmentAuthznFields _EHSRskAssessmentAuthznFields 2
_EHSRskAssmt2RskCtrlAuthznFld _EHSRskAssmt2RskCtrlAuthznFld 2
_EHSTaskAdapterClass _EHSTaskAdapterClass 2
_EHSTaskPriority _EHSTaskPriority 1
_IncidentAuthorizationFields _IncidentAuthorizationFields 2
EHSLocationUUID EHSLocationUUID 1
EHSPlannedTaskID EHSPlannedTaskID 2
EHSTaskDefinitionIsPaused EHSTaskDefinitionIsPaused 1
EHSTaskDefinitionStatus EHSTaskDefinitionStatus 1
EHSTaskDefinitionType EHSTaskDefinitionType 2
EHSTaskDueDate EHSTaskDueDate 2
EHSTaskHostObjectAdapterClass EHSTaskHostObjectAdapterClass 3
EHSTaskHostObjectInstance EHSTaskHostObjectInstance 2
EHSTaskHostObjectInstanceUUID EHSTaskHostObjectInstanceUUID 2
EHSTaskHostSemanticObject EHSTaskHostSemanticObject 1
EHSTaskInstceCompletionDate EHSTaskInstceCompletionDate 1
EHSTaskOwnerBP EHSTaskOwnerBP 2
EHSTaskOwnerUser EHSTaskOwnerUser 2
EHSTaskPriority EHSTaskPriority 1
EHSTaskRecurrenceType EHSTaskRecurrenceType 1
EHSTaskStartDate EHSTaskStartDate 2
EHSTaskStatusValueForSorting EHSTaskStatusValueForSorting,WorkflowTaskStatus 2
EHSTaskTimeZone EHSTaskTimeZone 1
EHSTaskTitle EHSTaskTitle 2
IncidentHasAccessRestriction IncidentHasAccessRestriction 2
WorkflowTaskInternalID WorkflowTaskInternalID 1
WorkflowTaskStatus WorkflowTaskStatus 1

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Task Instances and Future Definitions
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_EHSCOMBINEDTASKDEFANDINSTCE (
    EHSPLANNEDTASKUUID,
    EHSTASKDEFINITIONUUID,
    _CMPLNCRQMTAUTHZNFIELDS,
    _EHSCMPLNCSCENAUTHZNFIELDS,
    _EHSCTRLIMPLMTNAUTHZNFIELDS,
    _EHSRSKASSESSMENTAUTHZNFIELDS,
    _EHSRSKASSMT2RSKCTRLAUTHZNFLD,
    _EHSTASKADAPTERCLASS,
    _EHSTASKPRIORITY,
    _INCIDENTAUTHORIZATIONFIELDS,
    EHSLOCATIONUUID,
    EHSPLANNEDTASKID,
    EHSTASKDEFINITIONISPAUSED,
    EHSTASKDEFINITIONSTATUS,
    EHSTASKDEFINITIONTYPE,
    EHSTASKDUEDATE,
    EHSTASKHOSTOBJECTADAPTERCLASS,
    EHSTASKHOSTOBJECTINSTANCE,
    EHSTASKHOSTOBJECTINSTANCEUUID,
    EHSTASKHOSTSEMANTICOBJECT,
    EHSTASKINSTCECOMPLETIONDATE,
    EHSTASKOWNERBP,
    EHSTASKOWNERUSER,
    EHSTASKPRIORITY,
    EHSTASKRECURRENCETYPE,
    EHSTASKSTARTDATE,
    EHSTASKSTATUSVALUEFORSORTING,
    EHSTASKTIMEZONE,
    EHSTASKTITLE,
    INCIDENTHASACCESSRESTRICTION,
    WORKFLOWTASKINTERNALID,
    WORKFLOWTASKSTATUS,
    PRIMARY KEY (EHSPLANNEDTASKUUID, EHSTASKDEFINITIONUUID)
);

Learn More