SWWWIHEAD

Transparent Table Application Table
69 Fields 51 CDS Views

Workflow Runtime: Header Table for All Work Item Types

SWWWIHEAD is an SAP database table in S/4HANA. Workflow Runtime: Header Table for All Work Item Types. It contains 69 fields. 51 CDS views read from this table.

CDS Views using this table (51)

ViewTypeJoinVDMDescription
C_ADM_WORKFLOWLOG view from CONSUMPTION Workflow Administration Workflow Log
C_EHSSimpleTask view from CONSUMPTION EHS Simple Task
I_ADM_WORKFLOW view from COMPOSITE Workflow work items
I_ADM_WORKFLOWTASK_BASE view from BASIC Workflow work items
I_CAWorkflowTaskURL view from BASIC Workflow work item URL
I_DocLatestWorkflow view inner BASIC one document to latest workflow
I_EHSTaskInstanceTitleText view union COMPOSITE EHS Task Instance Title Text
I_LglTransWorkflowTaskTitle view from BASIC Legal Transaction task title
I_MyChemicalApprovalRole view left_outer COMPOSITE Chemical Approval Role
I_WFI_INST view_entity inner Application Objects with WF Instances
I_WORKFLOW_INSTANCE view inner Workflow Instances
I_WORKFLOWCLOUDREP_NRTASKSUSER view inner Retrieves the number of direct assigned tasks per user
I_WorkflowLatestTask view inner BASIC workflow latest task
I_WorkflowRecipients view inner COMPOSITE Workflow Task Recipient
I_WorkflowRecipients_V2 view inner COMPOSITE Workflow Task Recipient
I_WorkflowTask view from BASIC Workflow work items
I_WorkflowTaskCount view from BASIC Exposes the number of tasks
I_WorkflowTaskRecipient view union BASIC Work item recipients
I_WorkflowTaskRecipient view from BASIC Work item recipients
I_WorkflowTaskResult view left_outer BASIC Workflow Task Result
I_WorkflowTaskTitle view inner BASIC Work item title
I_WorkflowTaskTitle view union BASIC Work item title
I_WorkflowTaskTitleFallback view from Work item title fallback
I_WorkflowTaskURL view from BASIC Workflow work item URL
P_EHSTaskInstanceDefGUID view from BASIC Information about the definition GUID of task instances
P_EHSWorkflowHeader view from COMPOSITE EHS Workflow Header
P_EHSWorkflowTask view from BASIC EHS Workflow Task
P_Facvd_Ver_Diag_Max_Timestamp view inner BASIC Workflow Latest Dialog timestamp
P_Facvd_Wf_Task_Max_Timestamp view inner BASIC max timestamp of workflow
P_LglCntntMWorkflowTask view from BASIC Private View for Workflow Task
P_MyChemicalApprovals view left_outer COMPOSITE My chemical approvals
P_WorkflowPresentDialogItem view inner BASIC Present User Dialog Item
P_WorkflowToObject view inner BASIC Workflow to Object Private
P_WorkflowVerifyDialogItem view inner BASIC Workflow Verify Dialog Item
R_WorkflowInstance view_entity from Workflow instances
R_WorkflowWorkItem view_entity from Workitem instances
SWF_DAAG_EMPTY_TOP_WIID view from WF instances with empty TOP_WI_ID
SWF_DAAG_NON_FINAL_CHILDREN view left_outer WF instances with non-final tasks
SWF_DAAG_NON_FINAL_CHILDREN view from WF instances with non-final tasks
SWF_DAAG_NUMBER_WI_PER_TASK view inner average number of work items for each task
SWF_DAAG_NUMBER_WI_PER_TASK view from average number of work items for each task
SWF_DAAG_RETENTION_SETTINGS view from Retention times of final WF instances
SWF_FLEX_I_PROCESS view left_outer Workflow
SWF_SDM_SWWWIHEAD view from Workflow: join SDM state to SWWWIHEAD
SWW_DATAAGING_INCONSISTENT view from Workflow: Work items inconsistent aging
SWW_DATAAGING_INCONSISTENT view left_outer Workflow: Work items inconsistent aging
SWW_SDDL_SWW_USRATT view left_outer Workflow: Work item custom values
SWW_SDDL_SWWLOGHIST view left_outer Workflow: Work item log
SWW_SDDL_SWWWIHEAD view from Workflow: Work item header
SWW_SWWWIHEAD view from Workflow: Private CDS for Workflow Header
SWW_SWWWIHEAD_V view from wrapper for swwwihead repl. note_* fields

Fields (69)

KeyField Data ElementDescription DomainTypeLength
KEY client mandt Client
KEY wi_id sww_wiid Work Item ID
wi_type sww_witype Type
wi_creator sww_objid Creator
wi_lang sww_lang Language
wi_text sww_witext Work item text
wi_rhtext sww_rhtext Task text
wi_stat sww_wistat Status
wi_cd sww_cd Creation Date
wi_ct sww_ct Creation Time
wi_aed sww_aed Done On
wi_aagent sww_aagent Agent
wi_aaddr swwaddress Address
wi_cruser sww_cruser Creator
wi_craddr swwaddress Address
wi_chckwi sww_chckwi Workflow
wi_cbfb sww_cbfb Callback Funct. Mod.
wi_rh_task sww_task Task
wi_prio sww_prio Priority
wi_confirm sww_wiconf Confirm
wi_comp_ev sww_compev Completion by event
wi_forw_by sww_forwby Forwarder
wi_disable sww_disabl Lock flag
wi_reject sww_reject Rejectable
tclass hr_task_cl Classification
note_exist sww_noteex Attachments
notify sww_notify Notif. of completion
retry_cnt sww_retcnt Repeat counter
max_retry sww_retcnt Repeat counter
rc_modeled sww_rcmodl RC modeled
cb_done sww_cbdone Callback flag
syncchain sww_chain Synch. chain
no_deadl sww_deadfl Deadlines
wi_dh_stat sww_widhst Deadline Status
wi_release sysaprl SAP Release
wlc_displ sww_moddis Modeled display
wi_restlog swd_nolog Minimize Number of Entries in Workflow Log
remote_id sww_wiid Work Item ID
remote_sys logsys Logical system
status_evt sww_staevt Status event
timeout swd_bi_w_o Time Until Timeout
wf_type swd_wftype Workflow type
wlc_flags sww_wlc_flags Attributes
top_wi_id swfrtwiid Top Level Workflow
def_guid swfrdguid Unique ID
exec_time swfrexectm Duration
note_count swfrnotecn Attachments
prs_profil swd_persid Persistence Profile
crea_tmp swfrcrets Created
check_stat sww_chksta After Condition
blocktype swp_blocktype Block Type
parent_wi swfrparwi Parent Work Item
rndnumber swf_rndnum Random Number
wfd_id swd_wfd_id Workflow definition
wfd_version swd_versio Version
wfd_exetyp swd_exetyp Type
proccat swd_proccat Process Category
top_task sww_top_task Top Task
aging_state sww_daag_version Data Aging Version
aging_temperature sww_daag_temperature Aging Temperature
wlc_flags_ext sww_wlc_flags_ext Attributes (Ext.)
wi_aed_timestamp swf_aed_timestamp Completed
reference_nodeid swd_reference_nodeid Reference-Step
step_id swd_step_id Step Id
agent_rule_id swd_agent_rule_id Agent Rule Id
wi_text_id sww_witextid Work Item Text ID
cpwf_handle swf_cpwf_handle WF Handle ID
wi_mod_timestamp swf_modified_timestamp Modified at
wi_mod_by swf_modified_by Modified by

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.

-- Workflow Runtime: Header Table for All Work Item Types
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SWWWIHEAD (
    CLIENT,             -- Client [mandt]
    WI_ID,              -- Work Item ID [sww_wiid]
    WI_TYPE,            -- Type [sww_witype]
    WI_CREATOR,         -- Creator [sww_objid]
    WI_LANG,            -- Language [sww_lang]
    WI_TEXT,            -- Work item text [sww_witext]
    WI_RHTEXT,          -- Task text [sww_rhtext]
    WI_STAT,            -- Status [sww_wistat]
    WI_CD,              -- Creation Date [sww_cd]
    WI_CT,              -- Creation Time [sww_ct]
    WI_AED,             -- Done On [sww_aed]
    WI_AAGENT,          -- Agent [sww_aagent]
    WI_AADDR,           -- Address [swwaddress]
    WI_CRUSER,          -- Creator [sww_cruser]
    WI_CRADDR,          -- Address [swwaddress]
    WI_CHCKWI,          -- Workflow [sww_chckwi]
    WI_CBFB,            -- Callback Funct. Mod. [sww_cbfb]
    WI_RH_TASK,         -- Task [sww_task]
    WI_PRIO,            -- Priority [sww_prio]
    WI_CONFIRM,         -- Confirm [sww_wiconf]
    WI_COMP_EV,         -- Completion by event [sww_compev]
    WI_FORW_BY,         -- Forwarder [sww_forwby]
    WI_DISABLE,         -- Lock flag [sww_disabl]
    WI_REJECT,          -- Rejectable [sww_reject]
    TCLASS,             -- Classification [hr_task_cl]
    NOTE_EXIST,         -- Attachments [sww_noteex]
    NOTIFY,             -- Notif. of completion [sww_notify]
    RETRY_CNT,          -- Repeat counter [sww_retcnt]
    MAX_RETRY,          -- Repeat counter [sww_retcnt]
    RC_MODELED,         -- RC modeled [sww_rcmodl]
    CB_DONE,            -- Callback flag [sww_cbdone]
    SYNCCHAIN,          -- Synch. chain [sww_chain]
    NO_DEADL,           -- Deadlines [sww_deadfl]
    WI_DH_STAT,         -- Deadline Status [sww_widhst]
    WI_RELEASE,         -- SAP Release [sysaprl]
    WLC_DISPL,          -- Modeled display [sww_moddis]
    WI_RESTLOG,         -- Minimize Number of Entries in Workflow Log [swd_nolog]
    REMOTE_ID,          -- Work Item ID [sww_wiid]
    REMOTE_SYS,         -- Logical system [logsys]
    STATUS_EVT,         -- Status event [sww_staevt]
    TIMEOUT,            -- Time Until Timeout [swd_bi_w_o]
    WF_TYPE,            -- Workflow type [swd_wftype]
    WLC_FLAGS,          -- Attributes [sww_wlc_flags]
    TOP_WI_ID,          -- Top Level Workflow [swfrtwiid]
    DEF_GUID,           -- Unique ID [swfrdguid]
    EXEC_TIME,          -- Duration [swfrexectm]
    NOTE_COUNT,         -- Attachments [swfrnotecn]
    PRS_PROFIL,         -- Persistence Profile [swd_persid]
    CREA_TMP,           -- Created [swfrcrets]
    CHECK_STAT,         -- After Condition [sww_chksta]
    BLOCKTYPE,          -- Block Type [swp_blocktype]
    PARENT_WI,          -- Parent Work Item [swfrparwi]
    RNDNUMBER,          -- Random Number [swf_rndnum]
    WFD_ID,             -- Workflow definition [swd_wfd_id]
    WFD_VERSION,        -- Version [swd_versio]
    WFD_EXETYP,         -- Type [swd_exetyp]
    PROCCAT,            -- Process Category [swd_proccat]
    TOP_TASK,           -- Top Task [sww_top_task]
    AGING_STATE,        -- Data Aging Version [sww_daag_version]
    AGING_TEMPERATURE,  -- Aging Temperature [sww_daag_temperature]
    WLC_FLAGS_EXT,      -- Attributes (Ext.) [sww_wlc_flags_ext]
    WI_AED_TIMESTAMP,   -- Completed [swf_aed_timestamp]
    REFERENCE_NODEID,   -- Reference-Step [swd_reference_nodeid]
    STEP_ID,            -- Step Id [swd_step_id]
    AGENT_RULE_ID,      -- Agent Rule Id [swd_agent_rule_id]
    WI_TEXT_ID,         -- Work Item Text ID [sww_witextid]
    CPWF_HANDLE,        -- WF Handle ID [swf_cpwf_handle]
    WI_MOD_TIMESTAMP,   -- Modified at [swf_modified_timestamp]
    WI_MOD_BY,          -- Modified by [swf_modified_by]
    PRIMARY KEY (CLIENT, WI_ID)
);

Learn More