| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /AIF/RUNNING_WF | Running Workflow for AIF | 5 | WI_ID | Work item ID | nvarchar | 12 | 0 | | |
2 | /AIF/TICKETS | Ticket content table for Ticket System | 4 | WI_ID | Work item ID | nvarchar | 12 | 0 | | |
3 | /OPT/CT_LG_HIST | Log event history | 10 | WI_ID | Work item ID | nvarchar | 12 | 0 | | |
4 | /OPT/MAN_NOTIF | Manager Escalation Notification | 2 | WI_ID | Work item ID | nvarchar | 12 | 0 | | |
5 | /OPT/SIN_NOTIF | Single notification WI | 2 | WI_ID | Work item ID | nvarchar | 12 | 0 | | |
6 | /OPT/VIM_1PROC | Workflow Information for VIM Processes | 2 | WI_ID | Superordinate Work Item | nvarchar | 12 | 0 | | |
7 | /OPT/VIM_1WI_AGT | Current Agents of Work Items | 2 | WI_ID | Work item ID | nvarchar | 12 | 0 | | |
8 | /OPT/VT_AGENT | Work Item agents | 3 | WI_ID | Work item ID | nvarchar | 12 | 0 | | |
9 | /OPT/VT_WI | Reporting table: Workitems | 3 | WI_ID | Work item ID | nvarchar | 12 | 0 | | |
10 | /OPT/VT_WI_ACTN | Work Item Actions | 3 | WI_ID | Work item ID | nvarchar | 12 | 0 | | |
11 | /OPT/VT_WI_ACTV | Reporting table: Workitem activities | 3 | WI_ID | Work item ID | nvarchar | 12 | 0 | | |
12 | /OPT/VT_WI_AGNT | Reporting table: Current agents of workitems | 3 | WI_ID | Work item ID | nvarchar | 12 | 0 | | |
13 | /OPT/VT_WI_STEP1 | Work Item Steps - Copy of /opt/vt_wi_steps | 3 | WI_ID | Work item ID | nvarchar | 12 | 0 | | |
14 | /OPT/VT_WI_STEPS | Work Item Steps | 3 | WI_ID | Work item ID | nvarchar | 12 | 0 | | |
15 | /OPT/VT_WKT_PARK | Dialog Workitem Versus Parking Reason Mapping | 2 | WI_ID | Work item ID | nvarchar | 12 | 0 | | |
16 | /OPT/VT_WORKITE1 | Work Item Header Table - Copy of /opt/vt_workitem | 3 | WI_ID | Work item ID | nvarchar | 12 | 0 | | |
17 | /OPT/VT_WORKITEM | Work Item Header Table | 3 | WI_ID | Work item ID | nvarchar | 12 | 0 | | |
18 | /OPT/X149 | OPENTEXT: Approval Diagnostic data | 10 | WI_ID | Work item ID | nvarchar | 12 | 0 | | |
19 | /OPT/Y149 | OPENTEXT: Approval Diagnostic data | 10 | WI_ID | Work item ID | nvarchar | 12 | 0 | | |
20 | /OPT/Z149 | OPENTEXT: Approval Diagnostic data | 10 | WI_ID | Work item ID | nvarchar | 12 | 0 | | |
21 | /ORS/DIAGNOSTICS | OPENTEXT: Approval Diagnostic data | 10 | WI_ID | Work item ID | nvarchar | 12 | 0 | | |
22 | /OTEB/SWF_TACT | xIM activities business data | 7 | WI_ID | SAP Workflow ID | nvarchar | 12 | 0 | | |
23 | /OTEB/SWF_TMPSEL | Temporary save of selected actkeys (several workitems exist) | 4 | WI_ID | Work item ID | nvarchar | 12 | 0 | | |
24 | BBP_WFL_TRACE1A | BBP_WFL_TRACE1A | 13 | WI_ID | Work item ID | nvarchar | 12 | 0 | | |
25 | BBP_WFL_TRACE_A | BBP_WFL_TRACE_A | 13 | WI_ID | | nvarchar | 12 | 0 | | |
26 | GRFNMWRTINSTWI | MSMP Runtime - Work Item execution context cache | 2 | WI_ID | Work item ID | nvarchar | 12 | 0 | | |
27 | GRFNOWPDEBUG | OWP debug table | 1 | WI_ID | Work item ID | nvarchar | 12 | 0 | | |
28 | GRFNOWPINBNDDMS | Offline Working Process Inbound DMS PDF mapping | 2 | WI_ID | Work item ID | nvarchar | 12 | 0 | | |
29 | GRFNOWPJOBINDEX | OWP Sub Job Index Table | 4 | WI_ID | Work item ID | nvarchar | 12 | 0 | | |
30 | GRFNOWPSIKITM | Offine Working Process sick workitem stack | 2 | WI_ID | Work item ID | nvarchar | 12 | 0 | | |
31 | J_1I_EXIM_WF_LOG | EXIM : Workflow Log | 4 | WI_ID | Work item ID | nvarchar | 12 | 0 | | |
32 | S610E | S610 - Structural information | 4 | WI_ID | WIS: Work item ID | nvarchar | 12 | 0 | | |
33 | SWF_UNIT_MON | Workflow: Unit Monitoring | 5 | WI_ID | Work item ID | nvarchar | 12 | 0 | | |
34 | SWWBCSHEAD | Workflow: Demo for BCS Status | 4 | WI_ID | Work item ID | nvarchar | 12 | 0 | | |
35 | SWWOUTBOX | Workflow Outbox (Work Item - Processor - Timestamp) | 4 | WI_ID | Work item ID | nvarchar | 12 | 0 | | |
36 | SWWWITEXT | Workflow Runtime: Work Item Texts | 2 | WI_ID | Work item ID | nvarchar | 12 | 0 | | |
37 | SWW_PROPERTIES | Workflow Runtime: Workflow Attributes (System) | 8 | WI_ID | Work item ID | nvarchar | 12 | 0 | | |
38 | SWW_USRATT | Workflow Runtime: User Attributes | 3 | WI_ID | Work item ID | nvarchar | 12 | 0 | | |
39 | T7INPEW10 | P2E: Policy Workflow Log Table for Reminder Mails | 9 | WI_ID | Workflow ID | nvarchar | 12 | 0 | | |
40 | T7INPEW9 | P2E: Workflow Log Table for Resubmission and Reminder Mails | 9 | WI_ID | Workflow ID | nvarchar | 12 | 0 | | |
41 | T7INPEWA | P2E: Workflow Log Table for Reminder Mails-Initator:HR Admin | 11 | WI_ID | Workflow ID | nvarchar | 12 | 0 | | |
42 | ZARIXBC2 | Archive Information Structure SAP_O_2_WI_001 | 2 | WI_ID | Work item ID | nvarchar | 12 | 0 | | |
43 | ZARIXBC3 | Archive Information Structure WORKITEM | 2 | WI_ID | Work item ID | nvarchar | 12 | 0 | | |
TOPBusiness Process Engine |
44 | SWFRXIPRC | XI-Adapter: Process-Dependent Message Data | 3 | WI_ID | Work item ID | nvarchar | 12 | 0 | | |
45 | SWFXIPROCMSGREL | Relationship Between Process Instances in XI Messages | 3 | WI_ID | Work item ID | nvarchar | 12 | 0 | | |
46 | SWFXIUSERINFO | User Contexts in Integration Processes | 2 | WI_ID | Work item ID | nvarchar | 12 | 0 | | |
TOPBW Service API |
47 | ROPC_WFBOR | Workflow Processes Started | 6 | WI_ID | Work item ID | nvarchar | 12 | 0 | | |
TOPClaims Management |
48 | ICLACTIVITY | Tasks in Claim | 52 | WI_ID | Work item ID | nvarchar | 12 | 0 | | |
49 | ICLEACTIVITY | Tasks in Claim Bundle | 40 | WI_ID | Work item ID | nvarchar | 12 | 0 | | |
50 | ICSACTIVITY | Activity in the Claim | 52 | WI_ID | Work item ID | nvarchar | 12 | 0 | | |
51 | ICSEACTIVITY | Task in Claim Bundle Shadow Table | 40 | WI_ID | Work item ID | nvarchar | 12 | 0 | | |
TOPCross-Application Components |
52 | /OPT/VIM_HD_DP | VIM IE Monitor: Header Data for DP Invoices | 8 | WI_ID | VIM IE Monitor: data Element for WORK ITEM ID | nvarchar | 12 | 0 | | |
53 | /OPT/VIM_NPO_WID | VIM IE Monitortable: WI Header Data for NPO Invoices | 5 | WI_ID | Work item ID | nvarchar | 12 | 0 | | |
54 | /OPT/VIM_NPO_WIH | VIM IE Monitortable: WI Header Data for NPO Invoices | 5 | WI_ID | VIM IE Monitor: data Element for WORK ITEM ID | nvarchar | 12 | 0 | | |
55 | /OPT/VIM_PO_WID | VIM Report: WI Header Data for PO Invoices | 6 | WI_ID | Work item ID | nvarchar | 12 | 0 | | |
56 | /OPT/VIM_PO_WIH | VIM Report: WI Header Data for PO Invoices | 6 | WI_ID | VIM IE Monitor: data Element for WORK ITEM ID | nvarchar | 12 | 0 | | |
57 | BPMWITSTP | BPM Extractors: Workitem Last Changed Timestamp | 2 | WI_ID | Work item ID | nvarchar | 12 | 0 | | |
58 | SWKEXEID | Workflow: GUID for Work Item Execution | 2 | WI_ID | Work item ID | nvarchar | 12 | 0 | | |
TOPData Collection |
59 | S300 | WIS: Organization view | 8 | WI_ID | WIS: Work item ID | nvarchar | 12 | 0 | | |
60 | S300E | S300 - Structural Information | 3 | WI_ID | WIS: Work item ID | nvarchar | 12 | 0 | | |
61 | S301 | WIS: Process view | 8 | WI_ID | WIS: Work item ID | nvarchar | 12 | 0 | | |
62 | S301E | S301 - Structural Information | 3 | WI_ID | WIS: Work item ID | nvarchar | 12 | 0 | | |
63 | S302 | WIS: Object view | 8 | WI_ID | WIS: Work item ID | nvarchar | 12 | 0 | | |
64 | S302E | S302 - Structural Information | 3 | WI_ID | WIS: Work item ID | nvarchar | 12 | 0 | | |
65 | S303 | WIS: Group view | 8 | WI_ID | WIS: Work item ID | nvarchar | 12 | 0 | | |
66 | S303E | S303 - Structural Information | 3 | WI_ID | WIS: Work item ID | nvarchar | 12 | 0 | | |
67 | S304 | WIS: Sample scenario | 8 | WI_ID | WIS: Work item ID | nvarchar | 12 | 0 | | |
68 | S304E | S304 - Structural Information | 3 | WI_ID | WIS: Work item ID | nvarchar | 12 | 0 | | |
69 | S610 | BC610 Example info structure | 9 | WI_ID | WIS: Work item ID | nvarchar | 12 | 0 | | |
TOPFinancial Accounting |
70 | /OPT/VT_WI_AGENT | Reporting table: Current agents of workitems | 3 | WI_ID | Work item ID | nvarchar | 12 | 0 | | |
71 | /OPT/VT_WORK | Work Item Header Table - Real Time | 3 | WI_ID | Work item ID | nvarchar | 12 | 0 | | |
TOPOrganizational Management |
72 | SWWUSERWI | Current Work Items Assigned to a User | 3 | WI_ID | Work item ID | nvarchar | 12 | 0 | | |
TOPOverhead Cost Controlling |
73 | PFSWP | Period-End Partner: Log (Workflow Log Information) | 5 | WI_ID | Workflow: Work item ID of an activity in a workflow | nvarchar | 12 | 0 | | |
TOPProduct Data Replication |
74 | CRWB_BADI_BL2UPS | UPS Entries for Baseline (Workflow Dependent) | 2 | WI_ID | Work item ID | nvarchar | 12 | 0 | | |
75 | CRWB_BADI_INITWF | Mapping Initial Order ID to Workflow ID | 3 | WI_ID | Work item ID | nvarchar | 12 | 0 | | |
TOPPublic Sector Contract Accounts Receivable and Payable |
76 | DFMCA_WIHEAD | Additional Data for Workflow Item | 2 | WI_ID | Work item ID | nvarchar | 12 | 0 | | |
77 | DFMCA_WIHEADH | Additional Data for Workflow Item (History) | 2 | WI_ID | Work item ID | nvarchar | 12 | 0 | | |
TOPRuntime |
78 | SWFGPROLEINST | Guided Procedures: Role Instance | 5 | WI_ID | Work item ID | nvarchar | 12 | 0 | | |
TOPSAP Business Workflow |
79 | SWFMIG_INST_DATA | Process instance data | 2 | WI_ID | WORK ITEM ID | nvarchar | 12 | 0 | | |
80 | SWFRCRLINST | Correlation Runtime: Instances | 12 | WI_ID | Work item ID | nvarchar | 12 | 0 | | |
81 | SWFREXTPROC | Workflow: Relation Between Work Item and External Process | 2 | WI_ID | Work item ID | nvarchar | 12 | 0 | | |
82 | SWFRPROCTR | Workflow: Process Data (Default Table) | 2 | WI_ID | Work item ID | nvarchar | 12 | 0 | | |
83 | SWFRSTP | Workflow: Step Data (Default Table) | 2 | WI_ID | Work item ID | nvarchar | 12 | 0 | | |
84 | SWFRWLCEVT | Workflow - Worklist Client: Work Item Events | 2 | WI_ID | Work item ID | nvarchar | 12 | 0 | | |
85 | SWFWSEXEID | WebFlow: GUID of a Work Item Execution | 2 | WI_ID | Work item ID | nvarchar | 12 | 0 | | |
86 | SWF_MLOBJ | Workflow: Relation Mail/Work Item | 3 | WI_ID | Work item ID | nvarchar | 12 | 0 | | |
87 | SWF_TRC_WF_DAT | Workflow-Trace: Data Entries | 17 | WI_ID | Superordinate Work Item | nvarchar | 12 | 0 | | |
88 | SWF_TRC_WF_SEL | Workflow Trace: Selection Conditions for Trace Start | 12 | WI_ID | Superordinate Work Item | nvarchar | 12 | 0 | | |
89 | SWF_WFPREC | WF: Recovery information for Workflow Wizards | 4 | WI_ID | Work item ID | nvarchar | 12 | 0 | | |
90 | SWPNODELOG | Workflow: Instance Data of Nodes of a Workflow Execution | 22 | WI_ID | Context Work Item of Node (Block Item, Flow Item) | nvarchar | 12 | 0 | | |
91 | SWPSTEPLOG | Workflow: Instance Data of Steps of a Workflow Execution | 11 | WI_ID | Workflow: Work item ID of an activity in a workflow | nvarchar | 12 | 0 | | |
92 | SWP_NODEWI | WF: Work items for nodes in a workflow definition | 3 | WI_ID | Work item ID | nvarchar | 12 | 0 | | |
93 | SWP_SUSPEN | Workflow instances: Suspended work item callbacks | 3 | WI_ID | Workflow: Work item whose callback must be repeated | nvarchar | 12 | 0 | | |
94 | SWTRQTRACE | Workflow: Trace Table for Requests | 4 | WI_ID | Work item ID | nvarchar | 12 | 0 | | |
95 | SWT_LOGCAT | Workflow trace catalog | 10 | WI_ID | Work item ID | nvarchar | 12 | 0 | | |
96 | SWWBINDEF | Obsolete 6.1/ Workflow Runtime - Save Bindin... | 2 | WI_ID | Work item ID | nvarchar | 12 | 0 | | |
97 | SWWCNTP0 | Workflow Container: XML Database (P0) | 2 | WI_ID | Work item ID | nvarchar | 12 | 0 | | |
98 | SWWCNTPADD | Workflow Runtime: Persistence for Additional Container (XML) | 3 | WI_ID | Work item ID | nvarchar | 12 | 0 | | |
99 | SWWEI | Workflow Runtime: Work Items of Type E (Event Items) | 2 | WI_ID | Work item ID | nvarchar | 12 | 0 | | |
100 | SWWLOGHIST | Workflow Runtime: History of a Work Item | 2 | WI_ID | Work item ID | nvarchar | 12 | 0 | | |
101 | SWWLOGPARA | Obsolete 4.6/ WIM Log Table: Actions on WIs - Parameters | 2 | WI_ID | Work item ID | nvarchar | 12 | 0 | | |
102 | SWWORGTASK | Workflow Runtime: Assignment of WIs to Org. Unit/Task | 2 | WI_ID | Work item ID | nvarchar | 12 | 0 | | |
103 | SWWRUNMETH | Obsolete 6.1/ Workflow Runtime - Save Methods | 2 | WI_ID | Work item ID | nvarchar | 12 | 0 | | |
104 | SWWSWPRET | Obsolete 6.1/ Workflow Runtime - Save Modele... | 2 | WI_ID | Work item ID | nvarchar | 12 | 0 | | |
105 | SWWWIAGENT | Workflow Runtime: Agents for Execution of a Work Item | 2 | WI_ID | Work item ID | nvarchar | 12 | 0 | | |
106 | SWWWIDEADL | Workflow Runtime: Deadline Data for Work Items | 2 | WI_ID | Work item ID | nvarchar | 12 | 0 | | |
107 | SWWWIDH | Workflow Runtime: Deadline Monitoring of Work Items | 2 | WI_ID | Work item ID | nvarchar | 12 | 0 | | |
108 | SWWWIHEAD | Workflow Runtime: Header Table for All Work Item Types | 2 | WI_ID | Work item ID | nvarchar | 12 | 0 | | |
109 | SWWWIRET | Workflow Runtime: Return Values of Method Call | 2 | WI_ID | Work item ID | nvarchar | 12 | 0 | | |
110 | SWW_CONT | Workflow Runtime: Work Item Data Container | 2 | WI_ID | Work item ID | nvarchar | 12 | 0 | | |
111 | SWW_CONTOB | Workflow Runtime: Work Item Data Container (Only Objects) | 2 | WI_ID | Work item ID | nvarchar | 12 | 0 | | |
112 | SWW_EVENTCRL | Workflow: Correlations for Events in Workflow | 4 | WI_ID | Work item ID | nvarchar | 12 | 0 | | |
113 | SWW_EVENTS | Workflow: Events in Workflow | 3 | WI_ID | Work item ID | nvarchar | 12 | 0 | | |
114 | SWW_WI2OBJ | Workflow Runtime: Relation of Work Item to Object | 3 | WI_ID | Work item ID | nvarchar | 12 | 0 | | |
115 | SWW_WIREGISTER | Workflow: Registration of a Work Item | 4 | WI_ID | Work item ID | nvarchar | 12 | 0 | | |
116 | SWXML_CONT | WF: Table for Saving Containers as XML | 2 | WI_ID | Work item ID | nvarchar | 12 | 0 | | |
117 | SWZAI | Header Table for all Properties of a Work Queue | 2 | WI_ID | ID of a work queue | nvarchar | 12 | 0 | | |
118 | SWZAIENTRY | Object Table for Work Queues (Entries) | 2 | WI_ID | Work item ID | nvarchar | 12 | 0 | | |
TOPTransport Management System |
119 | CTWFPROPOS | Transport Proposal: Header | 11 | WI_ID | Work item ID | nvarchar | 12 | 0 | | |