SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

Schema:
 Module:  Table: 
Column: 
Searchbeta 

icon of database logic symbol SAP  TABLESv1Made in Britain

JDETables.com - the webs number one JD Edwards Table Definition reference

ERP 6.0: Top 10 requests

TableColumnsDescription
1TJKWE15IS-M/SD: WBZ, Order Data for Inbound Processing
2RSADMINC96Customizing Table General BW
3BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
4/OTX/RM_TELIB24Enterprise Library Server Settings
5UMV_TR1259Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6/ISDFPS/CHVW_E34External Batch Where-Used List
7FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9BSEG345Accounting Document Segment
10FMARCPAR4Parallelization of FMARC_BATCH

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5OJDT100Journal Entry
6INV1265A/R Invoice - Rows
7OPCH386A/P Invoice
8JDT1124Journal Entry - Rows
9OPOR386Purchase Order
10OVTG52Tax Definition

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OINM101Whse Journal
10OSRN20Serial Numbers Master Data

119 columns | Print definition?ERP 6.0  | WI_ID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/AIF/RUNNING_WFRunning Workflow for AIF5WI_IDWork item IDnvarchar120
2/AIF/TICKETSTicket content table for Ticket System4WI_IDWork item IDnvarchar120
3/OPT/CT_LG_HISTLog event history10WI_IDWork item IDnvarchar120
4/OPT/MAN_NOTIFManager Escalation Notification2WI_IDWork item IDnvarchar120
5/OPT/SIN_NOTIFSingle notification WI2WI_IDWork item IDnvarchar120
6/OPT/VIM_1PROCWorkflow Information for VIM Processes2WI_IDSuperordinate Work Itemnvarchar120
7/OPT/VIM_1WI_AGTCurrent Agents of Work Items2WI_IDWork item IDnvarchar120
8/OPT/VT_AGENTWork Item agents3WI_IDWork item IDnvarchar120
9/OPT/VT_WIReporting table: Workitems3WI_IDWork item IDnvarchar120
10/OPT/VT_WI_ACTNWork Item Actions3WI_IDWork item IDnvarchar120
11/OPT/VT_WI_ACTVReporting table: Workitem activities3WI_IDWork item IDnvarchar120
12/OPT/VT_WI_AGNTReporting table: Current agents of workitems3WI_IDWork item IDnvarchar120
13/OPT/VT_WI_STEP1Work Item Steps - Copy of /opt/vt_wi_steps3WI_IDWork item IDnvarchar120
14/OPT/VT_WI_STEPSWork Item Steps3WI_IDWork item IDnvarchar120
15/OPT/VT_WKT_PARKDialog Workitem Versus Parking Reason Mapping2WI_IDWork item IDnvarchar120
16/OPT/VT_WORKITE1Work Item Header Table - Copy of /opt/vt_workitem3WI_IDWork item IDnvarchar120
17/OPT/VT_WORKITEMWork Item Header Table3WI_IDWork item IDnvarchar120
18/OPT/X149OPENTEXT: Approval Diagnostic data10WI_IDWork item IDnvarchar120
19/OPT/Y149OPENTEXT: Approval Diagnostic data10WI_IDWork item IDnvarchar120
20/OPT/Z149OPENTEXT: Approval Diagnostic data10WI_IDWork item IDnvarchar120
21/ORS/DIAGNOSTICSOPENTEXT: Approval Diagnostic data10WI_IDWork item IDnvarchar120
22/OTEB/SWF_TACTxIM activities business data7WI_IDSAP Workflow IDnvarchar120
23/OTEB/SWF_TMPSELTemporary save of selected actkeys (several workitems exist)4WI_IDWork item IDnvarchar120
24BBP_WFL_TRACE1ABBP_WFL_TRACE1A13WI_IDWork item IDnvarchar120
25BBP_WFL_TRACE_ABBP_WFL_TRACE_A13WI_IDnvarchar120
26GRFNMWRTINSTWIMSMP Runtime - Work Item execution context cache2WI_IDWork item IDnvarchar120
27GRFNOWPDEBUGOWP debug table1WI_IDWork item IDnvarchar120
28GRFNOWPINBNDDMSOffline Working Process Inbound DMS PDF mapping2WI_IDWork item IDnvarchar120
29GRFNOWPJOBINDEXOWP Sub Job Index Table4WI_IDWork item IDnvarchar120
30GRFNOWPSIKITMOffine Working Process sick workitem stack2WI_IDWork item IDnvarchar120
31J_1I_EXIM_WF_LOGEXIM : Workflow Log4WI_IDWork item IDnvarchar120
32S610ES610 - Structural information4WI_IDWIS: Work item IDnvarchar120
33SWF_UNIT_MONWorkflow: Unit Monitoring5WI_IDWork item IDnvarchar120
34SWWBCSHEADWorkflow: Demo for BCS Status4WI_IDWork item IDnvarchar120
35SWWOUTBOXWorkflow Outbox (Work Item - Processor - Timestamp)4WI_IDWork item IDnvarchar120
36SWWWITEXTWorkflow Runtime: Work Item Texts2WI_IDWork item IDnvarchar120
37SWW_PROPERTIESWorkflow Runtime: Workflow Attributes (System)8WI_IDWork item IDnvarchar120
38SWW_USRATTWorkflow Runtime: User Attributes3WI_IDWork item IDnvarchar120
39T7INPEW10P2E: Policy Workflow Log Table for Reminder Mails9WI_IDWorkflow IDnvarchar120
40T7INPEW9P2E: Workflow Log Table for Resubmission and Reminder Mails9WI_IDWorkflow IDnvarchar120
41T7INPEWAP2E: Workflow Log Table for Reminder Mails-Initator:HR Admin11WI_IDWorkflow IDnvarchar120
42ZARIXBC2Archive Information Structure SAP_O_2_WI_0012WI_IDWork item IDnvarchar120
43ZARIXBC3Archive Information Structure WORKITEM2WI_IDWork item IDnvarchar120
TOPBusiness Process Engine
44SWFRXIPRCXI-Adapter: Process-Dependent Message Data3WI_IDWork item IDnvarchar120
45SWFXIPROCMSGRELRelationship Between Process Instances in XI Messages3WI_IDWork item IDnvarchar120
46SWFXIUSERINFOUser Contexts in Integration Processes2WI_IDWork item IDnvarchar120
TOPBW Service API
47ROPC_WFBORWorkflow Processes Started6WI_IDWork item IDnvarchar120
TOPClaims Management
48ICLACTIVITYTasks in Claim52WI_IDWork item IDnvarchar120
49ICLEACTIVITYTasks in Claim Bundle40WI_IDWork item IDnvarchar120
50ICSACTIVITYActivity in the Claim52WI_IDWork item IDnvarchar120
51ICSEACTIVITYTask in Claim Bundle Shadow Table40WI_IDWork item IDnvarchar120
TOPCross-Application Components
52/OPT/VIM_HD_DPVIM IE Monitor: Header Data for DP Invoices8WI_IDVIM IE Monitor: data Element for WORK ITEM IDnvarchar120
53/OPT/VIM_NPO_WIDVIM IE Monitortable: WI Header Data for NPO Invoices5WI_IDWork item IDnvarchar120
54/OPT/VIM_NPO_WIHVIM IE Monitortable: WI Header Data for NPO Invoices5WI_IDVIM IE Monitor: data Element for WORK ITEM IDnvarchar120
55/OPT/VIM_PO_WIDVIM Report: WI Header Data for PO Invoices6WI_IDWork item IDnvarchar120
56/OPT/VIM_PO_WIHVIM Report: WI Header Data for PO Invoices6WI_IDVIM IE Monitor: data Element for WORK ITEM IDnvarchar120
57BPMWITSTPBPM Extractors: Workitem Last Changed Timestamp2WI_IDWork item IDnvarchar120
58SWKEXEIDWorkflow: GUID for Work Item Execution2WI_IDWork item IDnvarchar120
TOPData Collection
59S300WIS: Organization view8WI_IDWIS: Work item IDnvarchar120
60S300ES300 - Structural Information3WI_IDWIS: Work item IDnvarchar120
61S301WIS: Process view8WI_IDWIS: Work item IDnvarchar120
62S301ES301 - Structural Information3WI_IDWIS: Work item IDnvarchar120
63S302WIS: Object view8WI_IDWIS: Work item IDnvarchar120
64S302ES302 - Structural Information3WI_IDWIS: Work item IDnvarchar120
65S303WIS: Group view8WI_IDWIS: Work item IDnvarchar120
66S303ES303 - Structural Information3WI_IDWIS: Work item IDnvarchar120
67S304WIS: Sample scenario8WI_IDWIS: Work item IDnvarchar120
68S304ES304 - Structural Information3WI_IDWIS: Work item IDnvarchar120
69S610BC610 Example info structure9WI_IDWIS: Work item IDnvarchar120
TOPFinancial Accounting
70/OPT/VT_WI_AGENTReporting table: Current agents of workitems3WI_IDWork item IDnvarchar120
71/OPT/VT_WORKWork Item Header Table - Real Time3WI_IDWork item IDnvarchar120
TOPOrganizational Management
72SWWUSERWICurrent Work Items Assigned to a User3WI_IDWork item IDnvarchar120
TOPOverhead Cost Controlling
73PFSWPPeriod-End Partner: Log (Workflow Log Information)5WI_IDWorkflow: Work item ID of an activity in a workflownvarchar120
TOPProduct Data Replication
74CRWB_BADI_BL2UPSUPS Entries for Baseline (Workflow Dependent)2WI_IDWork item IDnvarchar120
75CRWB_BADI_INITWFMapping Initial Order ID to Workflow ID3WI_IDWork item IDnvarchar120
TOPPublic Sector Contract Accounts Receivable and Payable
76DFMCA_WIHEADAdditional Data for Workflow Item2WI_IDWork item IDnvarchar120
77DFMCA_WIHEADHAdditional Data for Workflow Item (History)2WI_IDWork item IDnvarchar120
TOPRuntime
78SWFGPROLEINSTGuided Procedures: Role Instance5WI_IDWork item IDnvarchar120
TOPSAP Business Workflow
79SWFMIG_INST_DATAProcess instance data2WI_IDWORK ITEM IDnvarchar120
80SWFRCRLINSTCorrelation Runtime: Instances12WI_IDWork item IDnvarchar120
81SWFREXTPROCWorkflow: Relation Between Work Item and External Process2WI_IDWork item IDnvarchar120
82SWFRPROCTRWorkflow: Process Data (Default Table)2WI_IDWork item IDnvarchar120
83SWFRSTPWorkflow: Step Data (Default Table)2WI_IDWork item IDnvarchar120
84SWFRWLCEVTWorkflow - Worklist Client: Work Item Events2WI_IDWork item IDnvarchar120
85SWFWSEXEIDWebFlow: GUID of a Work Item Execution2WI_IDWork item IDnvarchar120
86SWF_MLOBJWorkflow: Relation Mail/Work Item3WI_IDWork item IDnvarchar120
87SWF_TRC_WF_DATWorkflow-Trace: Data Entries17WI_IDSuperordinate Work Itemnvarchar120
88SWF_TRC_WF_SELWorkflow Trace: Selection Conditions for Trace Start12WI_IDSuperordinate Work Itemnvarchar120
89SWF_WFPRECWF: Recovery information for Workflow Wizards4WI_IDWork item IDnvarchar120
90SWPNODELOGWorkflow: Instance Data of Nodes of a Workflow Execution22WI_IDContext Work Item of Node (Block Item, Flow Item)nvarchar120
91SWPSTEPLOGWorkflow: Instance Data of Steps of a Workflow Execution11WI_IDWorkflow: Work item ID of an activity in a workflownvarchar120
92SWP_NODEWIWF: Work items for nodes in a workflow definition3WI_IDWork item IDnvarchar120
93SWP_SUSPENWorkflow instances: Suspended work item callbacks3WI_IDWorkflow: Work item whose callback must be repeatednvarchar120
94SWTRQTRACEWorkflow: Trace Table for Requests4WI_IDWork item IDnvarchar120
95SWT_LOGCATWorkflow trace catalog10WI_IDWork item IDnvarchar120
96SWWBINDEFObsolete 6.1/ Workflow Runtime - Save Bindin...2WI_IDWork item IDnvarchar120
97SWWCNTP0Workflow Container: XML Database (P0)2WI_IDWork item IDnvarchar120
98SWWCNTPADDWorkflow Runtime: Persistence for Additional Container (XML)3WI_IDWork item IDnvarchar120
99SWWEIWorkflow Runtime: Work Items of Type E (Event Items)2WI_IDWork item IDnvarchar120
100SWWLOGHISTWorkflow Runtime: History of a Work Item2WI_IDWork item IDnvarchar120
101SWWLOGPARAObsolete 4.6/ WIM Log Table: Actions on WIs - Parameters2WI_IDWork item IDnvarchar120
102SWWORGTASKWorkflow Runtime: Assignment of WIs to Org. Unit/Task2WI_IDWork item IDnvarchar120
103SWWRUNMETHObsolete 6.1/ Workflow Runtime - Save Methods2WI_IDWork item IDnvarchar120
104SWWSWPRETObsolete 6.1/ Workflow Runtime - Save Modele...2WI_IDWork item IDnvarchar120
105SWWWIAGENTWorkflow Runtime: Agents for Execution of a Work Item2WI_IDWork item IDnvarchar120
106SWWWIDEADLWorkflow Runtime: Deadline Data for Work Items2WI_IDWork item IDnvarchar120
107SWWWIDHWorkflow Runtime: Deadline Monitoring of Work Items2WI_IDWork item IDnvarchar120
108SWWWIHEADWorkflow Runtime: Header Table for All Work Item Types2WI_IDWork item IDnvarchar120
109SWWWIRETWorkflow Runtime: Return Values of Method Call2WI_IDWork item IDnvarchar120
110SWW_CONTWorkflow Runtime: Work Item Data Container2WI_IDWork item IDnvarchar120
111SWW_CONTOBWorkflow Runtime: Work Item Data Container (Only Objects)2WI_IDWork item IDnvarchar120
112SWW_EVENTCRLWorkflow: Correlations for Events in Workflow4WI_IDWork item IDnvarchar120
113SWW_EVENTSWorkflow: Events in Workflow3WI_IDWork item IDnvarchar120
114SWW_WI2OBJWorkflow Runtime: Relation of Work Item to Object3WI_IDWork item IDnvarchar120
115SWW_WIREGISTERWorkflow: Registration of a Work Item4WI_IDWork item IDnvarchar120
116SWXML_CONTWF: Table for Saving Containers as XML2WI_IDWork item IDnvarchar120
117SWZAIHeader Table for all Properties of a Work Queue2WI_IDID of a work queuenvarchar120
118SWZAIENTRYObject Table for Work Queues (Entries)2WI_IDWork item IDnvarchar120
TOPTransport Management System
119CTWFPROPOSTransport Proposal: Header11WI_IDWork item IDnvarchar120