EHFNDD_TASK_PLAN

Transparent Table Application Table
17 Fields 4 CDS Views

Planned Task Instances Database Table

EHFNDD_TASK_PLAN is an SAP database table in S/4HANA. Planned Task Instances Database Table. It contains 17 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
E_EHSTaskPlannedInstance view from EXTENSION Extension view EHS Task Planned Instance
I_EHSTaskPlannedInstance view from BASIC EHS Planned Task Instance
P_EHFNDV_TASK_PLAN_M view from COMPOSITE
P_EHSTASKPLANNEDINST_MIGR view from COMPOSITE

Fields (17)

KeyField Data ElementDescription DomainTypeLength
KEY sapclient mandt Client
KEY ehsplannedtaskuuid ehfnd_task_planned_uuid Planned Task
ehstaskdefinitionuuid ehfnd_task_definition_uuid Task Definition
workflowtaskinternalid sww_wiid Work Item ID
ehstasktimezone tznzone Time Zone
ehstaskstartdatetime ehfnd_task_plan_start_timestmp Start Timestamp
ehstaskstartdate ehfnd_task_plan_start_date Start Date
ehstaskduedate ehfnd_task_plan_due_date Due Date
ehstaskinstcecompletiondate ehfnd_task_plan_compl_date Completion Date
ehstaskassignedbp ehfnd_task_plan_assignee_bp Assignee
ehstaskapprovingbp ehfnd_task_plan_approver_bp Approver
ehstaskownerbp ehfnd_task_plan_owner_bp Owner
ehsplannedtaskid ehfnd_task_planned_id ID
ehstaskinstanceprocessorbp ehfnd_task_plan_cur_proc_bp Current Processor
ehstaskassignedlocrole ehfnd_tdef_assignee_loc_role Assignee Location Role
ehstaskapproverlocrole ehfnd_tdef_approver_loc_role Approver Location Role
migrationstatus sdm_status_value_done status value done

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.

-- Planned Task Instances Database Table
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EHFNDD_TASK_PLAN (
    SAPCLIENT,                    -- Client [mandt]
    EHSPLANNEDTASKUUID,           -- Planned Task [ehfnd_task_planned_uuid]
    EHSTASKDEFINITIONUUID,        -- Task Definition [ehfnd_task_definition_uuid]
    WORKFLOWTASKINTERNALID,       -- Work Item ID [sww_wiid]
    EHSTASKTIMEZONE,              -- Time Zone [tznzone]
    EHSTASKSTARTDATETIME,         -- Start Timestamp [ehfnd_task_plan_start_timestmp]
    EHSTASKSTARTDATE,             -- Start Date [ehfnd_task_plan_start_date]
    EHSTASKDUEDATE,               -- Due Date [ehfnd_task_plan_due_date]
    EHSTASKINSTCECOMPLETIONDATE,  -- Completion Date [ehfnd_task_plan_compl_date]
    EHSTASKASSIGNEDBP,            -- Assignee [ehfnd_task_plan_assignee_bp]
    EHSTASKAPPROVINGBP,           -- Approver [ehfnd_task_plan_approver_bp]
    EHSTASKOWNERBP,               -- Owner [ehfnd_task_plan_owner_bp]
    EHSPLANNEDTASKID,             -- ID [ehfnd_task_planned_id]
    EHSTASKINSTANCEPROCESSORBP,   -- Current Processor [ehfnd_task_plan_cur_proc_bp]
    EHSTASKASSIGNEDLOCROLE,       -- Assignee Location Role [ehfnd_tdef_assignee_loc_role]
    EHSTASKAPPROVERLOCROLE,       -- Approver Location Role [ehfnd_tdef_approver_loc_role]
    MIGRATIONSTATUS,              -- status value done [sdm_status_value_done]
    PRIMARY KEY (SAPCLIENT, EHSPLANNEDTASKUUID)
);

Learn More