SWWWIHEAD

Transparent Table Application Table
72 Fields 54 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 72 fields. 54 CDS views read from this table.

CDS Views using this table (54)

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_PPS_PurContrWrkflwDetailBase view_entity from BASIC PPS Purchase Doc workflow objectID
I_PPS_PurOrdWorkFlwDetailsBase view_entity from BASIC PPS Purchase Order Workflow Details Base
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 from BASIC Work item recipients
I_WorkflowTaskRecipient view union 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
P_EHSWorkflowHeader view from COMPOSITE
P_EHSWorkflowTask view from BASIC
P_Facvd_Ver_Diag_Max_Timestamp view inner BASIC
P_Facvd_Wf_Task_Max_Timestamp view inner BASIC
P_LglCntntMWorkflowTask view from BASIC Private View for Workflow Task
P_MyChemicalApprovals view left_outer COMPOSITE
P_PPS_PurOrdWorkflow_Header view_entity from BASIC
P_WorkflowPresentDialogItem view inner BASIC
P_WorkflowToObject view inner BASIC
P_WorkflowVerifyDialogItem view inner BASIC
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 from average number of work items for each task
SWF_DAAG_NUMBER_WI_PER_TASK view inner 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 (72)

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
handle SWT_HANDL_ Trace ID
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
xmlprot SWD_XMLPRT Transfer format
wait4cb SWD_WAIT4C Wait for feedback
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]
    HANDLE,             -- Trace ID [SWT_HANDL_]
    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]
    XMLPROT,            -- Transfer format [SWD_XMLPRT]
    WAIT4CB,            -- Wait for feedback [SWD_WAIT4C]
    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