EHFNDD_TSKT_ROOT

Transparent Table Application Table
36 Fields 1 CDS Views

Task Template Root

EHFNDD_TSKT_ROOT is an SAP database table in S/4HANA. Task Template Root. It contains 36 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_EHSTaskTemplate view_entity from BASIC Task Template Root

Fields (36)

KeyField Data ElementDescription DomainTypeLength
KEY client abap.clnt
KEY ehstasktemplateuuid ehfnd_task_template_uuid
ehstaskhostobjectinstanceuuid ehfnd_task_def_host_obj_uuid Host Obj. UUID
ehstaskhostobjectadapterclass ehfnd_wff_class Class Name
ehstaskworkflowevent ehfnd_task_def_type Task Type
ehstaskpriority ehfnd_task_def_priority_code Priority
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
ehslocationuuid ehfnd_location_uuid_ref Location
ehstaskassignedlocrole ehfnd_tdef_assignee_loc_role Assignee Location Role
ehstaskapproverlocrole ehfnd_tdef_approver_loc_role Approver Location Role
ehstasktemplatestatuscode ehfnd_task_template_status

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 Template Root
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EHFNDD_TSKT_ROOT (
    CLIENT,                         -- abap.clnt
    EHSTASKTEMPLATEUUID,            -- ehfnd_task_template_uuid
    EHSTASKHOSTOBJECTINSTANCEUUID,  -- Host Obj. UUID [ehfnd_task_def_host_obj_uuid]
    EHSTASKHOSTOBJECTADAPTERCLASS,  -- Class Name [ehfnd_wff_class]
    EHSTASKWORKFLOWEVENT,           -- Task Type [ehfnd_task_def_type]
    EHSTASKPRIORITY,                -- Priority [ehfnd_task_def_priority_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]
    EHSLOCATIONUUID,                -- Location [ehfnd_location_uuid_ref]
    EHSTASKASSIGNEDLOCROLE,         -- Assignee Location Role [ehfnd_tdef_assignee_loc_role]
    EHSTASKAPPROVERLOCROLE,         -- Approver Location Role [ehfnd_tdef_approver_loc_role]
    EHSTASKTEMPLATESTATUSCODE,      -- ehfnd_task_template_status
    PRIMARY KEY (CLIENT, EHSTASKTEMPLATEUUID)
);

Learn More