I_EHSTASKDEFINITION

CDS View
67 Fields 8 CDS Views

EHSTask Definition

I_EHSTASKDEFINITION is a CDS View in S/4HANA. EHSTask Definition. It contains 67 fields. 8 CDS views read from this table.

CDS Views using this table (8)

ViewTypeJoinVDMDescription
I_EHSTaskDefinitionTP view from TRANSACTIONAL EHSTask Definition TP
I_EHSTaskDefWithDraftUnion view from COMPOSITE EHSTask Definition Union
I_EHSTaskFutureInstance view inner COMPOSITE EHS Future Task Instance
I_EHSTaskInstanceCube view inner COMPOSITE EHS Task Instance - Cube
I_EHSTaskPlannedInstancesAll view inner BASIC EHS Planned and Executed Task Instances
I_EHSTaskPlannedWorkflowInstce view inner COMPOSITE EHS Task Planned Workflow Instance
P_EHSTaskDefinitionHex view from COMPOSITE
P_TaskDefAndInstForCount view from COMPOSITE

Fields (67)

KeyField CDS FieldsUsed in Views
KEY EHSTaskDefinitionUUID EHSTaskDefinitionUUID 2
KEY EHSTaskHostObjectInstance EHSTaskHostObjectInstance 6
_CmplncRqmtAuthznFields _CmplncRqmtAuthznFields 2
_EHSCmplncScenAuthznFields _EHSCmplncScenAuthznFields 2
_EHSCtrlImplmtnAuthznFields _EHSCtrlImplmtnAuthznFields 2
_EHSRskAssessmentAuthznFields _EHSRskAssessmentAuthznFields 2
_EHSRskAssmt2RskCtrlAuthznFld _EHSRskAssmt2RskCtrlAuthznFld 2
_EHSTaskAdapterClass _EHSTaskAdapterClass 1
_EHSTaskApprovingUser _EHSTaskApprovingUser 1
_EHSTaskAssignedUser _EHSTaskAssignedUser 2
_EHSTaskDefinitionExecution _EHSTaskDefinitionExecution 1
_EHSTaskDefinitionMaintenance _EHSTaskDefinitionMaintenance 1
_EHSTaskDefinitionMoC _EHSTaskDefinitionMoC 1
_EHSTaskDefinitionReference _EHSTaskDefinitionReference 1
_EHSTaskDefinitionType _EHSTaskDefinitionType 1
_EHSTaskDueInUnit _EHSTaskDueInUnit 1
_EHSTaskOwnerUser _EHSTaskOwnerUser 1
_EHSTaskPlannedInstance _EHSTaskPlannedInstance 1
_EHSTaskPriority _EHSTaskPriority 1
_EHSTaskRecurrenceMonth _EHSTaskRecurrenceMonth 1
_EHSTaskRecurrenceOffset _EHSTaskRecurrenceOffset 1
_EHSTaskRecurrenceType _EHSTaskRecurrenceType 1
_EHSTaskRecurrenceWeekDay _EHSTaskRecurrenceWeekDay 1
_EHSTaskStartBeforeUnit _EHSTaskStartBeforeUnit 1
_IncidentAuthorizationFields _IncidentAuthorizationFields 2
_IncidentTaskRefAccRestricted _IncidentTaskRefAccRestricted 1
EHSLocationUUID EHSLocationUUID 5
EHSTaskApproverLocRole EHSTaskApproverLocRole 1
EHSTaskApprovingUser EHSTaskApprovingBP,EHSTaskApprovingUser 1
EHSTaskAssignedLocRole EHSTaskAssignedLocRole 1
EHSTaskAssignedType EHSTaskAssignedType 1
EHSTaskAssignedUser EHSTaskAssignedBP,EHSTaskAssignedUser 2
EHSTaskDefinitionIsPaused EHSTaskDefinitionIsPaused 4
EHSTaskDefinitionStatus EHSTaskDefinitionStatus 4
EHSTaskDescription EHSTaskDescription 1
EHSTaskDueDate EHSTaskDueDate 1
EHSTaskDueInUnit EHSTaskDueInUnit 1
EHSTaskDueInValue EHSTaskDueInValue 1
EHSTaskHostObjectAdapterClass EHSTaskHostObjectAdapterClass 4
EHSTaskHostObjectInstanceUUID EHSTaskHostObjectInstanceUUID 5
EHSTaskID EHSTaskID 1
EHSTaskIsDueOnSameDay EHSTaskIsDueOnSameDay 1
EHSTaskIsRecurringOnFriday EHSTaskIsRecurringOnFriday 1
EHSTaskIsRecurringOnMonday EHSTaskIsRecurringOnMonday 1
EHSTaskIsRecurringOnSaturday EHSTaskIsRecurringOnSaturday 1
EHSTaskIsRecurringOnSunday EHSTaskIsRecurringOnSunday 1
EHSTaskIsRecurringOnThursday EHSTaskIsRecurringOnThursday 1
EHSTaskIsRecurringOnTuesday EHSTaskIsRecurringOnTuesday 1
EHSTaskIsRecurringOnWednesday EHSTaskIsRecurringOnWednesday 1
EHSTaskMigrationSource EHSTaskMigrationSource 1
EHSTaskOwnerUser EHSTaskOwnerBP,EHSTaskOwnerUser 1
EHSTaskPriority EHSTaskPriority 5
EHSTaskRecurrenceDay EHSTaskRecurrenceDay 1
EHSTaskRecurrenceEndDate EHSTaskRecurrenceEndDate 1
EHSTaskRecurrenceEndType EHSTaskRecurrenceEndType 1
EHSTaskRecurrenceFirstDueDate EHSTaskRecurrenceFirstDueDate 1
EHSTaskRecurrenceInterval EHSTaskRecurrenceInterval 1
EHSTaskRecurrenceIsByDueDate EHSTaskRecurrenceIsByDueDate 1
EHSTaskRecurrenceMonth EHSTaskRecurrenceMonth 1
EHSTaskRecurrenceOffset EHSTaskRecurrenceOffset 1
EHSTaskRecurrenceType EHSTaskRecurrenceType 4
EHSTaskRecurrenceWeekDay EHSTaskRecurrenceWeekDay 1
EHSTaskStartBeforeUnit EHSTaskStartBeforeUnit 1
EHSTaskStartBeforeValue EHSTaskStartBeforeValue 1
EHSTaskStartDate EHSTaskStartDate 1
EHSTaskTitle EHSTaskTitle 5
EHSTaskWorkflowEvent EHSTaskDefinitionType 5

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.

-- EHSTask Definition
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_EHSTASKDEFINITION (
    EHSTASKDEFINITIONUUID,
    EHSTASKHOSTOBJECTINSTANCE,
    _CMPLNCRQMTAUTHZNFIELDS,
    _EHSCMPLNCSCENAUTHZNFIELDS,
    _EHSCTRLIMPLMTNAUTHZNFIELDS,
    _EHSRSKASSESSMENTAUTHZNFIELDS,
    _EHSRSKASSMT2RSKCTRLAUTHZNFLD,
    _EHSTASKADAPTERCLASS,
    _EHSTASKAPPROVINGUSER,
    _EHSTASKASSIGNEDUSER,
    _EHSTASKDEFINITIONEXECUTION,
    _EHSTASKDEFINITIONMAINTENANCE,
    _EHSTASKDEFINITIONMOC,
    _EHSTASKDEFINITIONREFERENCE,
    _EHSTASKDEFINITIONTYPE,
    _EHSTASKDUEINUNIT,
    _EHSTASKOWNERUSER,
    _EHSTASKPLANNEDINSTANCE,
    _EHSTASKPRIORITY,
    _EHSTASKRECURRENCEMONTH,
    _EHSTASKRECURRENCEOFFSET,
    _EHSTASKRECURRENCETYPE,
    _EHSTASKRECURRENCEWEEKDAY,
    _EHSTASKSTARTBEFOREUNIT,
    _INCIDENTAUTHORIZATIONFIELDS,
    _INCIDENTTASKREFACCRESTRICTED,
    EHSLOCATIONUUID,
    EHSTASKAPPROVERLOCROLE,
    EHSTASKAPPROVINGUSER,
    EHSTASKASSIGNEDLOCROLE,
    EHSTASKASSIGNEDTYPE,
    EHSTASKASSIGNEDUSER,
    EHSTASKDEFINITIONISPAUSED,
    EHSTASKDEFINITIONSTATUS,
    EHSTASKDESCRIPTION,
    EHSTASKDUEDATE,
    EHSTASKDUEINUNIT,
    EHSTASKDUEINVALUE,
    EHSTASKHOSTOBJECTADAPTERCLASS,
    EHSTASKHOSTOBJECTINSTANCEUUID,
    EHSTASKID,
    EHSTASKISDUEONSAMEDAY,
    EHSTASKISRECURRINGONFRIDAY,
    EHSTASKISRECURRINGONMONDAY,
    EHSTASKISRECURRINGONSATURDAY,
    EHSTASKISRECURRINGONSUNDAY,
    EHSTASKISRECURRINGONTHURSDAY,
    EHSTASKISRECURRINGONTUESDAY,
    EHSTASKISRECURRINGONWEDNESDAY,
    EHSTASKMIGRATIONSOURCE,
    EHSTASKOWNERUSER,
    EHSTASKPRIORITY,
    EHSTASKRECURRENCEDAY,
    EHSTASKRECURRENCEENDDATE,
    EHSTASKRECURRENCEENDTYPE,
    EHSTASKRECURRENCEFIRSTDUEDATE,
    EHSTASKRECURRENCEINTERVAL,
    EHSTASKRECURRENCEISBYDUEDATE,
    EHSTASKRECURRENCEMONTH,
    EHSTASKRECURRENCEOFFSET,
    EHSTASKRECURRENCETYPE,
    EHSTASKRECURRENCEWEEKDAY,
    EHSTASKSTARTBEFOREUNIT,
    EHSTASKSTARTBEFOREVALUE,
    EHSTASKSTARTDATE,
    EHSTASKTITLE,
    EHSTASKWORKFLOWEVENT,
    PRIMARY KEY (EHSTASKDEFINITIONUUID, EHSTASKHOSTOBJECTINSTANCE)
);

Learn More