EHFNDW_TDEF_ROOT

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_EHSTASKDEFINITIONTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EHFNDW_TDEF_ROOT (
    MANDT,                           -- 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]
    EHSLOCATIONUUID,                 -- Location [ehfnd_location_uuid_ref]
    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]
    EHSTASKDUEDATE,                  -- Due Date [ehfnd_task_def_due_date]
    EHSTASKISDUEONSAMEDAY,           -- Due Same Day [ehfnd_task_def_due_same_day]
    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]
    EHSTASKID,                       -- ID [ehfnd_task_def_id]
    EHSTASKMIGRATIONSOURCE,          -- Migr. Source [ehfnd_task_def_migration_src]
    EHSTASKASSIGNEDTYPE,             -- Assignment Type of Assignee [ehfnd_tdef_assignee_type_char]
    EHSTASKASSIGNEDLOCROLE,          -- Assignee Location Role [ehfnd_tdef_assignee_loc_role]
    EHSTASKAPPROVERTYPE,             -- Assignment Type of Approver [ehfnd_tdef_approver_type_char]
    EHSTASKAPPROVERLOCROLE,          -- Approver Location Role [ehfnd_tdef_approver_loc_role]
    EHSTASKDEFINITIONMANAGEACTION,   -- Action TaskDef [ehfnd_wff_task_manage_action]
    EHSTASKINSTANCEDISPLAYACTION,    -- Action TaskInst [ehfnd_wff_task_display_action]
    EHSTASKISENABLEDFORREFERENCING,  -- Enable Reference [ehfnd_wff_ref_ind]
    EHSATTACHMENTSERVICEFILEID,      -- File ID [ehfnd_ats_file_id]
    EHSTSKDEFSRCEDOCPAGENUMBER,      -- ehfnd_task_def_document_page
    EHSTSKDEFSRCEDOCTXTFRAGMENTID,   -- ehfnd_task_def_doc_fragment_id
    EHSATTACHMENTSERVICEOBJECTTYPE,  -- ehfnd_ats_object_type
    EHSATTACHMENTSERVICEOBJECTKEY,   -- ehfnd_ats_object_key
    INCIDENTHASACCESSRESTRICTION,    -- Restricted [ehhss_per_inv_confid_ts]
    ACTIVEUUID,                      -- Key [/bobf/uuid]
    HASACTIVEENTITY,                 -- Has active [sdraft_has_active]
    PRIMARY KEY (MANDT, EHSTASKDEFINITIONUUID)
);