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

50 columns | Print definition?B1 9.3  | ID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPAdministration
1ACFPCFOP for Nota Fiscal1IDCFOP IDInt110
2ATSCCST Code for Nota Fiscal1IDCST Internal KeyInt110
3AWEXWorkflow Engine Execution Entity1IdIDInt110
4AWMGWorkflow Manager1IDWorkflow IDInt110
5AWTSWorkflow Engine Task Table1IdIDInt110
6CHENCaching Update Notification2IDIDInt110
7OBMIBrazilian Multi-Indexer1IDUnique IDInt110
8OBSIBrazil String Indexer5IDUnique IDInt110
9OCFPCFOP for Nota Fiscal1IDCFOP IDInt110
10OSULSupport User Login Record1IDMain IDInt110
11OSUSSupport Usage Statistics4IDIDnVarChar2540
12OTIZCompany Time Zone1IdIndexInt110
13OTSCCST Code for Nota Fiscal1IDCST Internal KeyInt110
14OUSGUsage of Nota Fiscal1IDUsage IDInt110
15OWEXWorkflow Engine Execution Entity1IdIDIdentity110
16OWINWorkflow Engine Information1IdIDInt110
17OWJBWorkflow Job Entity1IdIDInt110
18OWMGWorkflow Manager1IDWorkflow IDIdentity110
19OWTIWorkflow Timer Definition1IdIDIdentity110
20OWTJWorkflow Timer Job1IdIDIdentity110
21OWTSWorkflow Engine Task Table1IdIDIdentity110
TOPFinance
22OSHRShareholder's Rights and Interests Report History1IdIdentityInt110
TOPGeneral
23BSJ1Backend Scheduling Sub Tasks1IDJob IDInt110
24EBCFGEBCFG1IdnVarChar500
25ECLGFECLGF1IdTransaction IdnVarChar1000
26ECLGTECLGT1Idtransaction idnVarChar1000
27ECLOGECLOG1IdnVarChar1000
28ELCFGELCFG1IdnVarChar500
29EMERREMERR1IDError IDIdentity110
30EMMSGEMMSG1IDMessage IDnVarChar600
31EPSRVEPSRV1Idauto generated idIdentity110
32IMGDTUser Delete Group Log Time1IdInternal NumberIdentity110
33IMGLGGroup Message Log1IdInternal NumberIdentity110
34IMGP1Group User1IdInternal NumberIdentity110
35IMGRPGroup Master Data1IdGroup IdIdentity110
36IMLTMDeparture Time1IdInternal NumberIdentity110
37IMPLGPrivate Message Log1IdInternal NumberIdentity110
38IMQSGQuestion Suggestions1IdInternal NumberIdentity110
39OBBIBrazil Beverage Indexer5IDIDInt110
40OBFIBrazil Fuel Indexer5IDIDInt110
41OBNIBrazil Numeric Indexer5IDIDInt110
42OBSJBackend scheduling job1IDJob IDInt110
43ORCJResource Capacity Log1IdPrimary KeyInt110
44OUALUser Action Log1IdIDIdentity110
45OWWTWorkbench1IDWorkbench Template IDInt110
46SEWH1SEWH13IDAddOn IDInt110
47SFDKSFDK1IDFeedback DIInt110
48SSENSSEN1IDSession IDnVarChar1280
49TZLITZLI1IdidInt110
TOPReports
50OCRTCRDB Tables Tree List1IDIDInt110