P_EHSWORKFLOWTASK

CDS View

P_EHSWORKFLOWTASK is a CDS View in S/4HANA. It contains 12 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_EHSTaskPlannedWorkflowHead view inner BASIC EHS Task Planned Workflow Header
P_EHSTaskInstanceDefGUID view inner BASIC

Fields (12)

KeyField CDS FieldsUsed in Views
EHSTaskInstanceStepNodeID EHSTaskInstanceStepNodeID 1
TopLevelWorkflowTask TopLevelWorkflowTask 1
TopLevelWorkflowTaskDefinition WorkflowTaskDefinition 1
WorkflowTaskCreatedByUser WorkflowTaskCreatedByUser 1
WorkflowTaskDefinition WorkflowTaskDefinition 1
WorkflowTaskDefinitionExeType WorkflowTaskDefinitionExeType 1
WorkflowTaskDefinitionVersion WorkflowTaskDefinitionVersion 1
WorkflowTaskName WorkflowTaskName 1
WorkflowTaskPriority WorkflowTaskPriority 1
WorkflowTaskStatus WorkflowTaskStatus 1
WrkflwTskCompletionUTCDateTime WrkflwTskCompletionUTCDateTime 1
WrkflwTskCreationUTCDateTime WrkflwTskCreationUTCDateTime 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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_EHSWORKFLOWTASK (
    EHSTASKINSTANCESTEPNODEID,
    TOPLEVELWORKFLOWTASK,
    TOPLEVELWORKFLOWTASKDEFINITION,
    WORKFLOWTASKCREATEDBYUSER,
    WORKFLOWTASKDEFINITION,
    WORKFLOWTASKDEFINITIONEXETYPE,
    WORKFLOWTASKDEFINITIONVERSION,
    WORKFLOWTASKNAME,
    WORKFLOWTASKPRIORITY,
    WORKFLOWTASKSTATUS,
    WRKFLWTSKCOMPLETIONUTCDATETIME,
    WRKFLWTSKCREATIONUTCDATETIME
);