1. Home
  2. Resources
  3. SAP Tables
  4. SOSP_S_WORKITEM_DETAIL - Workitem Detail Structure

SAP Table SOSP_S_WORKITEM_DETAIL

Workitem Detail Structure

SOSP_S_WORKITEM_DETAIL (Workitem Detail Structure) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link SOSP_S_WORKITEM_DETAIL to other SAP tables.

Source: SOSP_S_WORKITEM_DETAIL (Workitem Detail Structure)

SOSP_S_WORKITEM_DETAIL table fields

Field Data element Checktable Datatype Length Decimals
WORKITEM_ID Work item ID SWW_WIID NUMC 12 0
WI_RECIPIENT_ID User Name SYUNAME CHAR 12 0
WI_RECIPIENT_TYPE Role type S_OSP_DT_ROLE_TYPE CHAR 15 0
WI_CRUD_FLAG Current Workitem status code S_OSP_DT_CURR_STAT_CODE CHAR 12 0
WI_CRUD_FLAG_PREV Previous Workitem status code S_OSP_DT_PREV_STAT_CODE CHAR 12 0
WI_TEXT Work item text SWW_WITEXT CHAR 120 0
WI_DESCRIPTION STRG 0 0
WI_STATUS Processing Status of a Work Item SWW_WISTAT CHAR 12 0
WAITING Waiting (Also: Work Items in Resubmission)
READY Ready
SELECTED Reserved
STARTED In Process
ERROR Error
COMMITTED Executed (Only If Expl. End Confirmation Is Expected)
COMPLETED Completed
CANCELLED Logically Deleted
CHECKED In Preparation
EXCPCAUGHT Exception Caught
EXCPHANDLR Exception Being Handled
WI_STATUS_TEXT Workflow: Work Item Status SWW_STATXT CHAR 20 0
WI_TYPE Work item type SWW_WITYPE CHAR 1 0
P Work Item that Represents a Remote Work Item (Proxy WI)
E Work Item that Waits for an Event (Wait Step)
A Work Item that Represents a Work Queue
W Dialog Work Item; Represents a Single-Step Task
D Deadline Work Item; Notification upon Missed Deadline
N Notification Item (No Longer Used)
B Work Item for Background Step
F Workflow (Also Subworkflow)
C Work Item that Represents a Container Linkage
R Work Item that Represents a Remote Work Item (http)
X Work Item that Represents a Block
Q Work Item that Represents a Dialog Block
WI_LANGUAGE Language for Texts of a Work Item SWW_LANG LANG 1 0
WI_TASK_ID Task ID SWW_TASK CHAR 14 0
WI_STEP_ID Node Number SWD_NODEID NUMC 10 0
WI_TASK_ROLE_TYPE Role type S_OSP_DT_ROLE_TYPE CHAR 15 0
WI_PRIORITY Priority of a Work Item SWW_PRIO NUMC 1 0
1 1 Highest - Express
2 2 Very high
3 3 Higher
4 4 High
5 5 Medium
6 6 Low
7 7 Lower
8 8 Very low
9 9 Lowest
WI_CREATION_DATE Creation Date of Work Item SWW_CD DATS 8 0
WI_CREATION_TIME Creation Time of Work Item SWW_CT TIMS 6 0
WI_DEADLINE_DATE Latest End Date for Work Item SWW_LED DATS 8 0
WI_DEADLINE_TIME Latest end time for work item SWW_LET TIMS 6 0
WI_DEADLINE_STATUS Deadline Status of a Work Item SWW_WIDHST NUMC 4 0
0000 Deadline Not Yet Reached
8990 Requested Start
8996 Latest Start
8997 Requested End
8998 Latest End
WI_FORW_BY (Last) forwarder of work item SWW_FORWBY CHAR 12 0
WI_FORW_NAME Name of Last Forwarder SWR_FORNAM CHAR 40 0
PARENT_WI_ID Work item ID SWW_WIID NUMC 12 0
WORKFLOW_ID Task ID SWW_TASK CHAR 14 0
WF_STATUS Processing Status of a Work Item SWW_WISTAT CHAR 12 0
WAITING Waiting (Also: Work Items in Resubmission)
READY Ready
SELECTED Reserved
STARTED In Process
ERROR Error
COMMITTED Executed (Only If Expl. End Confirmation Is Expected)
COMPLETED Completed
CANCELLED Logically Deleted
CHECKED In Preparation
EXCPCAUGHT Exception Caught
EXCPHANDLR Exception Being Handled
WF_CREATOR_ID User Name SYUNAME CHAR 12 0
WF_CREATOR_NAME WF Initiator/Creator name S_OSP_DT_CREATOR_NAME CHAR 40 0
WF_CREATOR_LANGUAGE Recipient's default language S_OSP_DT_RECIPIENT_LANG LANG 1 0
WF_CREATION_DATE Creation Date of Work Item SWW_CD DATS 8 0
WF_CREATION_TIME Creation Time of Work Item SWW_CT TIMS 6 0
WF_REVIEWER_WF Task ID SWW_TASK CHAR 14 0
APPL_ID Application ID S_OSP_DT_APPL_ID CHAR 6 0
APPL_INSTANCE_ID WAPI: Instance ID of Persistent Object Reference SWRSIBFID CHAR 70 0
APPL_STATUS_CURR Current Workitem status code S_OSP_DT_CURR_STAT_CODE CHAR 12 0
APPL_STATUS_PREV Previous Workitem status code S_OSP_DT_PREV_STAT_CODE CHAR 12 0
APPL_REQUESTOR_ID User Name SYUNAME CHAR 12 0
APPL_REQUESTOR_NAME Application Initiator/Requestor name S_OSP_DT_REQUESTOR_NAME CHAR 40 0
APPL_REQUESTOR_LANGUAGE Recipient's default language S_OSP_DT_RECIPIENT_LANG LANG 1 0
CRT_TASK_FLAG Flag S_OSP_DT_FLAG CHAR 1 0
SYSTEM_TIMEZONE Time Zone TIMEZONE CHAR 6 0
SUB_WF_WI_ID Work item ID SWW_WIID NUMC 12 0
SUB_WF_WI_TYPE Work item type SWW_WITYPE CHAR 1 0
P Work Item that Represents a Remote Work Item (Proxy WI)
E Work Item that Waits for an Event (Wait Step)
A Work Item that Represents a Work Queue
W Dialog Work Item; Represents a Single-Step Task
D Deadline Work Item; Notification upon Missed Deadline
N Notification Item (No Longer Used)
B Work Item for Background Step
F Workflow (Also Subworkflow)
C Work Item that Represents a Container Linkage
R Work Item that Represents a Remote Work Item (http)
X Work Item that Represents a Block
Q Work Item that Represents a Dialog Block
SUB_WORKFLOW_ID Task ID SWW_TASK CHAR 14 0
SUB_WORKFLOW_TYPE Type of Workflow Definition: Standard, Checklist, Ad Hoc, .. SWD_WFTYPE NUMC 4 0
0000 Standard Workflow
0001 Ad Hoc Agent Assignment Is Possible
0002 Portrays Checklist
0004 Supports Forms
0008 Has a Review Workflow
0016 Review Workflow
0032 Insertable Ad Hoc Workflow
0064 Has an Insertable Ad Hoc Workflow
0128 Generated Workflow (Not Modifiable)
0256 Message-Based Workflow
0512 Guided Procedure Workflow
CLNT_FORWARDING_FLAG Flag S_OSP_DT_FLAG CHAR 1 0
CLNT_SUBSTITUTION_FLAG Flag S_OSP_DT_FLAG CHAR 1 0