EHFNDW_TASK_PLAN

Transparent Table Application Table
19 Fields 2 CDS Views

I_EHSTASKDEFINITIONTP I_EHSTASKPLANNEDINSTANCETP

EHFNDW_TASK_PLAN is an SAP database table in S/4HANA. I_EHSTASKDEFINITIONTP I_EHSTASKPLANNEDINSTANCETP. It contains 19 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_EHFNDV_TASK_PLAN_M view union COMPOSITE Migration View for EHFNDD_TASK_PLAN & EHFNDW_TASK_PLAN
P_EHSTASKPLANNEDINST_MIGR view union COMPOSITE Migration View for EHFNDD_TASK_PLAN & EHFNDW_TASK_PLAN

Fields (19)

KeyField Data ElementDescription DomainTypeLength
KEY mandt 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
activeuuid /bobf/uuid Key
hasactiveentity sdraft_has_active Has active

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.

-- I_EHSTASKDEFINITIONTP I_EHSTASKPLANNEDINSTANCETP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EHFNDW_TASK_PLAN (
    MANDT,                        -- 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]
    ACTIVEUUID,                   -- Key [/bobf/uuid]
    HASACTIVEENTITY,              -- Has active [sdraft_has_active]
    PRIMARY KEY (MANDT, EHSPLANNEDTASKUUID)
);

Learn More