EHFNDD_TDEF_ROOT

Transparent Table Application Table
49 Fields 3 CDS Views

Task Definition Root Database Table

EHFNDD_TDEF_ROOT is an SAP database table in S/4HANA. Task Definition Root Database Table. It contains 49 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
E_EHSTaskDefinition view from EXTENSION Extension view for EHS Task Definition
I_EHSTaskDefinition view from BASIC EHSTask Definition
P_EHFNDV_TASK_PLAN_M view inner COMPOSITE Migration View for EHFNDD_TASK_PLAN & EHFNDW_TASK_PLAN

Fields (49)

KeyField Data ElementDescription DomainTypeLength
KEY sapclient mandt Client
KEY ehstaskdefinitionuuid ehfnd_task_definition_uuid Task Definition
creationutcdatetime timestampl Time Stamp
createdbyuser uname User Name
lastchangeutcdatetime timestampl Time Stamp
lastchangedbyuser uname User Name
ehstaskhostobjectinstanceuuid ehfnd_task_def_host_obj_uuid Host Obj. UUID
ehstaskhostobjectinstance sibfboriid Instance ID
ehstaskhostobjectadapterclass ehfnd_wff_class Class Name
ehstaskworkflowevent ehfnd_task_def_type Task Type
ehstaskpriority ehfnd_task_def_priority_code Priority
ehstaskassigneduser ehfnd_task_def_assignee_bp Assignee
ehstaskowneruser ehfnd_task_def_owner_bp Owner
ehstaskapprovinguser ehfnd_task_def_approver_bp Approver
ehstaskdefinitionstatus ehfnd_task_def_status_code Status
ehstasktitle ehfnd_task_definition_title Title
ehstaskdescription ehfnd_task_def_description Description
ehstaskstartdate ehfnd_task_def_start_date Start Date
ehstaskdueinvalue ehfnd_task_def_due_in_value Due In
ehstaskdueinunit ehfnd_task_def_due_in_unit Due In
ehstaskisdueonsameday ehfnd_task_def_due_same_day Due Same Day
ehstaskduedate ehfnd_task_def_due_date Due Date
ehstaskstartbeforevalue ehfnd_task_def_start_bef_value Start Before
ehstaskstartbeforeunit ehfnd_task_def_start_bef_unit Start Before
ehstaskrecurrenceisbyduedate ehfnd_task_def_recur_by_due_dt Due Date Based
ehstaskrecurrencetype ehfnd_task_def_recur_type_code Recurrence Type
ehstaskrecurrenceinterval ehfnd_task_def_recur_interval Recurrence
ehstaskisrecurringonmonday ehfnd_task_def_recur_on_mon Monday
ehstaskisrecurringontuesday ehfnd_task_def_recur_on_tue Tuesday
ehstaskisrecurringonwednesday ehfnd_task_def_recur_on_wed Wednesday
ehstaskisrecurringonthursday ehfnd_task_def_recur_on_thu Thursday
ehstaskisrecurringonfriday ehfnd_task_def_recur_on_fri Friday
ehstaskisrecurringonsaturday ehfnd_task_def_recur_on_sat Saturday
ehstaskisrecurringonsunday ehfnd_task_def_recur_on_sun Sunday
ehstaskrecurrenceday ehfnd_task_def_recurrence_day Day of Month
ehstaskrecurrencemonth ehfnd_task_def_recur_month Month of Year
ehstaskrecurrenceoffset ehfnd_task_def_recur_offset Recur. Offset
ehstaskrecurrenceweekday ehfnd_task_def_recur_weekday Weekday
ehstaskrecurrenceendtype ehfnd_task_def_recur_end_type Recur. End Type
ehstaskrecurrenceenddate ehfnd_task_def_recur_end_date Recur. End Date
ehstaskrecurrencefirstduedate ehfnd_task_def_first_due_date First Due Date
ehstaskdefinitionispaused ehfnd_task_def_is_paused Is Paused
ehslocationuuid ehfnd_location_uuid_ref Location
ehstaskid ehfnd_task_def_id ID
ehstaskmigrationsource ehfnd_task_def_migration_src Migr. Source
ehstaskassignedtype ehfnd_task_def_assignee_type Assignment Type of Assignee
ehstaskassignedlocrole ehfnd_tdef_assignee_loc_role Assignee Location Role
ehstaskapprovertype ehfnd_task_def_approver_type Assignment Type of Approver
ehstaskapproverlocrole ehfnd_tdef_approver_loc_role Approver Location Role

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 Definition Root Database Table
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EHFNDD_TDEF_ROOT (
    SAPCLIENT,                      -- Client [mandt]
    EHSTASKDEFINITIONUUID,          -- Task Definition [ehfnd_task_definition_uuid]
    CREATIONUTCDATETIME,            -- Time Stamp [timestampl]
    CREATEDBYUSER,                  -- User Name [uname]
    LASTCHANGEUTCDATETIME,          -- Time Stamp [timestampl]
    LASTCHANGEDBYUSER,              -- User Name [uname]
    EHSTASKHOSTOBJECTINSTANCEUUID,  -- Host Obj. UUID [ehfnd_task_def_host_obj_uuid]
    EHSTASKHOSTOBJECTINSTANCE,      -- Instance ID [sibfboriid]
    EHSTASKHOSTOBJECTADAPTERCLASS,  -- Class Name [ehfnd_wff_class]
    EHSTASKWORKFLOWEVENT,           -- Task Type [ehfnd_task_def_type]
    EHSTASKPRIORITY,                -- Priority [ehfnd_task_def_priority_code]
    EHSTASKASSIGNEDUSER,            -- Assignee [ehfnd_task_def_assignee_bp]
    EHSTASKOWNERUSER,               -- Owner [ehfnd_task_def_owner_bp]
    EHSTASKAPPROVINGUSER,           -- Approver [ehfnd_task_def_approver_bp]
    EHSTASKDEFINITIONSTATUS,        -- Status [ehfnd_task_def_status_code]
    EHSTASKTITLE,                   -- Title [ehfnd_task_definition_title]
    EHSTASKDESCRIPTION,             -- Description [ehfnd_task_def_description]
    EHSTASKSTARTDATE,               -- Start Date [ehfnd_task_def_start_date]
    EHSTASKDUEINVALUE,              -- Due In [ehfnd_task_def_due_in_value]
    EHSTASKDUEINUNIT,               -- Due In [ehfnd_task_def_due_in_unit]
    EHSTASKISDUEONSAMEDAY,          -- Due Same Day [ehfnd_task_def_due_same_day]
    EHSTASKDUEDATE,                 -- Due Date [ehfnd_task_def_due_date]
    EHSTASKSTARTBEFOREVALUE,        -- Start Before [ehfnd_task_def_start_bef_value]
    EHSTASKSTARTBEFOREUNIT,         -- Start Before [ehfnd_task_def_start_bef_unit]
    EHSTASKRECURRENCEISBYDUEDATE,   -- Due Date Based [ehfnd_task_def_recur_by_due_dt]
    EHSTASKRECURRENCETYPE,          -- Recurrence Type [ehfnd_task_def_recur_type_code]
    EHSTASKRECURRENCEINTERVAL,      -- Recurrence [ehfnd_task_def_recur_interval]
    EHSTASKISRECURRINGONMONDAY,     -- Monday [ehfnd_task_def_recur_on_mon]
    EHSTASKISRECURRINGONTUESDAY,    -- Tuesday [ehfnd_task_def_recur_on_tue]
    EHSTASKISRECURRINGONWEDNESDAY,  -- Wednesday [ehfnd_task_def_recur_on_wed]
    EHSTASKISRECURRINGONTHURSDAY,   -- Thursday [ehfnd_task_def_recur_on_thu]
    EHSTASKISRECURRINGONFRIDAY,     -- Friday [ehfnd_task_def_recur_on_fri]
    EHSTASKISRECURRINGONSATURDAY,   -- Saturday [ehfnd_task_def_recur_on_sat]
    EHSTASKISRECURRINGONSUNDAY,     -- Sunday [ehfnd_task_def_recur_on_sun]
    EHSTASKRECURRENCEDAY,           -- Day of Month [ehfnd_task_def_recurrence_day]
    EHSTASKRECURRENCEMONTH,         -- Month of Year [ehfnd_task_def_recur_month]
    EHSTASKRECURRENCEOFFSET,        -- Recur. Offset [ehfnd_task_def_recur_offset]
    EHSTASKRECURRENCEWEEKDAY,       -- Weekday [ehfnd_task_def_recur_weekday]
    EHSTASKRECURRENCEENDTYPE,       -- Recur. End Type [ehfnd_task_def_recur_end_type]
    EHSTASKRECURRENCEENDDATE,       -- Recur. End Date [ehfnd_task_def_recur_end_date]
    EHSTASKRECURRENCEFIRSTDUEDATE,  -- First Due Date [ehfnd_task_def_first_due_date]
    EHSTASKDEFINITIONISPAUSED,      -- Is Paused [ehfnd_task_def_is_paused]
    EHSLOCATIONUUID,                -- Location [ehfnd_location_uuid_ref]
    EHSTASKID,                      -- ID [ehfnd_task_def_id]
    EHSTASKMIGRATIONSOURCE,         -- Migr. Source [ehfnd_task_def_migration_src]
    EHSTASKASSIGNEDTYPE,            -- Assignment Type of Assignee [ehfnd_task_def_assignee_type]
    EHSTASKASSIGNEDLOCROLE,         -- Assignee Location Role [ehfnd_tdef_assignee_loc_role]
    EHSTASKAPPROVERTYPE,            -- Assignment Type of Approver [ehfnd_task_def_approver_type]
    EHSTASKAPPROVERLOCROLE,         -- Approver Location Role [ehfnd_tdef_approver_loc_role]
    PRIMARY KEY (SAPCLIENT, EHSTASKDEFINITIONUUID)
);

Learn More