SAP Table SWR_WIDTL

WAPI: Detailed Information About Work Item

SWR_WIDTL (WAPI: Detailed Information About Work Item) 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 SWR_WIDTL to other SAP tables.

Source: SWR_WIDTL (WAPI: Detailed Information About Work Item)

SWR_WIDTL table fields

Field Data element Checktable Datatype Length Decimals
WI_ID Work item ID SWW_WIID NUMC 12 0
WI_TEXT Work item text SWW_WITEXT CHAR 120 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_TYPETEXT Work Item Type SWW_TYPTXT CHAR 20 0
WI_LANG Language for Texts of a Work Item SWW_LANG LANG 1 0
WI_LANGTEXT Workflow: Language Text SWW_LANTXT CHAR 16 0
WI_RH_TASK Task ID SWW_TASK CHAR 14 0
WI_RHTEXT Short Text from Task SWW_RHTEXT CHAR 40 0
WI_PRIO 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_PRIOTEXT Workflow: Priority SWL_PRITXT CHAR 25 0
WI_STAT 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_STATTEXT Workflow: Work Item Status SWW_STATXT CHAR 20 0
WI_DH_STAT 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_DH_STATTEXT Workflow: Work Item Status SWW_STATXT CHAR 20 0
WI_CD Creation Date of Work Item SWW_CD DATS 8 0
WI_CT Creation Time of Work Item SWW_CT TIMS 6 0
WI_CD_FTD Creation date of work item (formatted) SWR_CD_F CHAR 20 0
WI_CT_FTD Creation time of work item (formatted) SWR_CT_F CHAR 20 0
WI_CR_TIMEIO Workflow: Creation Time/Date SWR_CRTIIO CHAR 32 0
WI_DSD Requested Start Date for Work Item SWW_DSD DATS 8 0
WI_DST Requested start time for work item SWW_DST TIMS 6 0
WI_DSD_FTD Requested Start Date of a Work Item (Formatted) SWR_DSD_F CHAR 20 0
WI_DST_FTD Requested Start Time of a Work Item (Formatted) SWR_DST_F CHAR 20 0
WI_DS_TIMEIO Workflow: Date/Time for Submission Deadline SWR_DSTIIO CHAR 32 0
WI_LSD Latest Start Date for Work Item SWW_LSD DATS 8 0
WI_LST Latest start time for work item SWW_LST TIMS 6 0
WI_LSD_FTD Latest Start Date of a Work Item (Formatted) SWR_LSD_F CHAR 20 0
WI_LST_FTD Latest Start Time of a Work Item (Formatted) SWR_LST_F CHAR 20 0
WI_LS_TIMEIO Workflow: Date/Time for Latest Start SWR_LSTIIO CHAR 32 0
WI_DED Requested End Date for Work Item SWW_DED DATS 8 0
WI_DET Requested end time for work item SWW_DET TIMS 6 0
WI_DED_FTD Required End Date/Time of a Work Item (Formatted) SWR_DED_F CHAR 20 0
WI_DET_FTD Required End Time of a Work Item (Formatted) SWR_DET_F CHAR 20 0
WI_DE_TIMEIO Workflow: Date/Time for Required End SWR_DETIIO CHAR 32 0
WI_LED Latest End Date for Work Item SWW_LED DATS 8 0
WI_LET Latest end time for work item SWW_LET TIMS 6 0
WI_LED_FTD Latest end date of a work item (formatted) SWR_LED_F CHAR 20 0
WI_LET_FTD Latest End Time of a Work Item (Formatted) SWR_LET_F CHAR 20 0
WI_LE_TIMEIO Workflow: Date/Time of Deadline SWR_LETIIO CHAR 32 0
WI_AAGENT Actual Agent of Work Item SWW_AAGENT CHAR 12 0
WI_AA_NAME Name of Actual Agent SWR_AGTNAM CHAR 40 0
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
WI_CHCKWI Superordinate Work Item SWW_CHCKWI NUMC 12 0
TOP_WI_ID Workflow: Unique ID of Top-Level Instance (6.1/get) SWFRTWIID NUMC 12 0
NOTE_COUNT Number of Attachments SWFRNOTECN INT4 10 0
EXEC_TIME Workflow: De Facto Execution Time in Sec (6.1/get) SWFREXECTM INT4 10 0
WI_AED End Date of Work Item SWW_AED DATS 8 0
WI_AET Current end time of work item SWW_AET TIMS 6 0
WI_AED_FTD End Date of a Work Item (Formatted) SWR_AED_F CHAR 20 0
WI_AET_FTD Actual End Time of Work Item (Formatted) SWR_AET_F CHAR 20 0
WI_AE_TIMEIO Workflow: Time for Actual End SWR_AETIIO CHAR 32 0