1. Home
  2. Resources
  3. SAP Tables
  4. SWWVPUBLIC - Generated Table for View

SAP Table SWWVPUBLIC

Generated Table for View

SWWVPUBLIC (Generated Table for View) 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 SWWVPUBLIC to other SAP tables.

SWWVPUBLIC table fields

Field Data element Checktable Datatype Length Decimals
CLIENT Client MANDT T000 CLNT 3 0
WI_ID Work item ID SWW_WIID NUMC 12 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_CREATOR Creator of a work item SWW_OBJID CHAR 90 0
WI_LANG Language for Texts of a Work Item SWW_LANG T002 LANG 1 0
WI_TEXT Work item text SWW_WITEXT CHAR 120 0
WI_RHTEXT Short Text from Task SWW_RHTEXT CHAR 40 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_CD Creation Date of Work Item SWW_CD DATS 8 0
WI_CT Creation Time of Work Item SWW_CT TIMS 6 0
WI_AED End Date of Work Item SWW_AED DATS 8 0
WI_CRUSER User Who Created the Work Item SWW_CRUSER CHAR 12 0
WI_CRADDR Key for BOR Object of Type ADDRESS (SWWADDRKEY) SWWADDRESS CHAR 28 0
WI_AAGENT Actual Agent of Work Item SWW_AAGENT CHAR 12 0
WI_AADDR Key for BOR Object of Type ADDRESS (SWWADDRKEY) SWWADDRESS CHAR 28 0
WI_CHCKWI Superordinate Work Item SWW_CHCKWI SWWWIHEAD NUMC 12 0
WI_RH_TASK Task ID SWW_TASK CHAR 14 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_CONFIRM Indicator showing that end of processing must be confirmed SWW_WICONF CHAR 1 0
X Yes
NULL No
WI_FORW_BY (Last) forwarder of work item SWW_FORWBY CHAR 12 0
WI_DISABLE Flag: Work item is currently locked SWW_DISABL CHAR 1 0
X Yes
NULL No
WI_REJECT Indicator Denoting that Work Item Can Be Rejected by Agent SWW_REJECT CHAR 1 0
X Yes
NULL No
NOTE_EXIST Indicator Denoting that At Least One Note Exists for the WI SWW_NOTEEX CHAR 1 0
X Yes
NULL No
NO_DEADL Flag Denoting Whether WI Contains Deadline Data SWW_DEADFL CHAR 1 0
X Yes
NULL No
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

SWWVPUBLIC foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
SWWVPUBLIC CLIENT SWWVPUBLIC CLIENT T000 Clients MANDT
SWWVPUBLIC WI_CHCKWI SWWVPUBLIC CLIENT SWWWIHEAD Workflow Runtime: Header Table for All Work Item Types CLIENT
SWWVPUBLIC WI_CHCKWI SWWVPUBLIC WI_CHCKWI SWWWIHEAD Workflow Runtime: Header Table for All Work Item Types WI_ID
SWWVPUBLIC WI_LANG SWWVPUBLIC WI_LANG T002 Language Keys (Component BC-I18) SPRAS