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

27 columns | Print definition?ERP 6.0  | WORKITEM_ID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/OPT/AT_APPR_HISApproval History for Level Based Approvals19WORKITEM_IDWork item IDnvarchar120
2/OPT/AT_LBA_LOGApproval History for Level Based Approvals20WORKITEM_IDWork item IDnvarchar120
3/ORS/APPR_LOGApproval Log2WORKITEM_IDWork item IDnvarchar120
4/SAPSRM/D_WF_030Change Pointer for Offline Approval2WORKITEM_IDWork item IDnvarchar120
5/SAPSRM/D_WF_031Send Change Pointers for Offline Approval2WORKITEM_IDWork item IDnvarchar120
6/XFT/EPA_DELDECLRejected Documents9WORKITEM_IDWork item IDnvarchar120
7/XFT/EPA_DELMDATManually Set Deletion Date10WORKITEM_IDWork item IDnvarchar120
8/XFT/EPA_DELRUNNRunning Deletion Processes9WORKITEM_IDWork item IDnvarchar120
9/XFT/EPA_TPROTLog21WORKITEM_IDWork Item IDnvarchar120
10/XLSO/MANDT_WITMWork item for mandatory trainings9WORKITEM_IDWork item IDnvarchar120
TOPBasis Components
11/XFT/INV_Q_9Workflow work item process ID assignment3WORKITEM_IDWork item IDnvarchar120
12/XFT/INV_Q_9_SWorkflow work item process ID assignment3WORKITEM_IDWork item IDnvarchar120
TOPClinical System
13N1RAD_TASK_CATCategories - Radiological Task Assignments2WORKITEM_IDRadiological Task Keynvarchar330
14N2RAD_FWL_ITEMi.s.h.med Radiology Findings Work Station: Findings Tasks2WORKITEM_IDRadiological Task Keynvarchar330
TOPCollections Management
15UDM_CCT_ATTRCustomer Contact23WORKITEM_IDKey of Worklist Itemvarbinary160
16UDM_WL_ITEMWorklist Item2WORKITEM_IDKey of Worklist Itemvarbinary160
17UDM_WL_ITEM_DValuation Details for Worklist Items3WORKITEM_IDKey of Worklist Itemvarbinary160
18UDM_WL_ITEM_DELDeleted Worklist Entries2WORKITEM_IDKey of Worklist Itemvarbinary160
19UDM_WL_LAST_ITEMCollection Specialist's Items4WORKITEM_IDKey of Worklist Itemvarbinary160
TOPFinancial Accounting
20/OPT/VIM_1LOGDocument Log14WORKITEM_IDWork item IDnvarchar120
21/OPT/VIM_8LOGOpenText VIM Document Log13WORKITEM_IDWork item IDnvarchar120
TOPKnowledge Management and Collaboration
22SUWLNOTIFCFGTBLConfiguration table for UWL java-side notifications2WORKITEM_IDWork item IDnvarchar120
TOPOffice Suite Program
23SOSP_T_BKTWIHISTTable for maintaining the step history3WORKITEM_IDWork item IDnvarchar120
24SOSP_T_BKT_PERFMBook Keeping table for Performance3WORKITEM_IDWork item IDnvarchar120
TOPPersonnel Time Management
25PTREQ_HEADERRequest Header18WORKITEM_IDWork item IDnvarchar120
TOPShift Planning
26HRSP_POOL_RQSTNSResource Procurement (Without Strings)18WORKITEM_IDObject keynvarchar700
TOPWeb Channel Builder
27COM_WCB_CFG_WFWCB Configuration Approval Status Details11WORKITEM_IDWork item IDnvarchar120