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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

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

B1 8.8: Top 10 requests

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

46 columns | Print definition?B1 9.3  | CREATETIME

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPAdministration
1ARSTRoute Stages - History7CreateTimeGeneration TimeInt60
2OBPDBlocked Personal Data15CreateTimeCreation TimeInt110
3ODARData Archiving5CreateTimeArchive TimeInt60
4ORSTRoute Stages7CreateTimeGeneration TimeInt60
5OWFERWorkflow Error Message6CreateTimeCreate TimeInt110
6OWINWorkflow Engine Information10CreateTimeCreate TimeInt110
TOPBanking
7OITRInternal Reconciliation13CreateTimeCreation TimeInt60
TOPFinance
8AJDTJournal Entry - History47CreateTimeGeneration TimeInt60
9CASEInternal Recon. Upgrade 2007A3CreateTimeCreation TimeInt60
10OBTFJournal Voucher Entry47CreateTimeGeneration TimeInt60
11OJDTJournal Entry47CreateTimeGeneration TimeInt60
12OJSTTDS Adjustment9CreateTimeGeneration TimeInt110
TOPGeneral
13NFN5NF Skipped Numbers10CreateTimeCreation TimeInt110
14OBTABrazil - Tax Adjustment46CreateTimeGeneration TimeInt60
15OBVLSerial Numbers and Batch Valuation Log10CreateTimeGeneration TimeInt60
16OHMMSAP HANA Model Management11CreateTimeCreated at TimeInt110
17OKPIKey Performance Indicator Package21CreateTimeCreate TimeInt60
18OWPKDashboard Packages9CreateTimeCreate TimeInt60
19RADMResource Administration12CreateTimeCreation Time of DBInt1100
20RAMIRAMI16CreateTimeCreation TimeInt60
21RTPLTranslation Problems Log4CreateTimeGeneration TimeInt60
22UBVLSerial Numbers and Batch Valuation Log10CreateTimeGeneration TimeInt60
23WOBJObject Wizard42CreateTimeCreation TimeInt60
24WORFObject Wizard Related Files12CreateTimeCreation TimeInt60
TOPInventory and Production
25AINCInventory Counting30CreateTimeGeneration TimeInt60
26OAIMArchive Inventory Message23CreateTimeGeneration TimeInt60
27OICDInventory Counting Draft30CreateTimeGeneration TimeInt60
28OILMInventory Log Message32CreateTimeGeneration TimeInt60
29OINCInventory Counting30CreateTimeGeneration TimeInt60
30OITLInventory Transactions Log40CreateTimeCreation TimeInt600
31OIVLWhse Journal6CreateTimeGeneration TimeInt60
32ORTLResource Transaction Log15CreateTimeCreation TimeInt60
33OTNLCCD Log23CreateTimeGeneration TimeInt60
34SIVLWhse Journal6CreateTimeGeneration TimeInt60
35UILMIVI Inventory Log Message32CreateTimeGeneration TimeInt60
36UIVLWhse Journal6CreateTimeGeneration TimeInt60
TOPMarketing Documents
37ORCPRecurring Transaction Template14CreateTimeCreation TimeInt60
38OWDDDocs. for Confirmation12CreateTimeProduction TimeInt60
39WDD1Documents for Approval - Authorizers8CreateTimeRequest TimeInt60
TOPReports
40OLLRElectronic Report Generation Result4CreateTimeCreation TimeInt60
41OTRBTax Report Wizard for Brazil17CreateTimeGeneration TimeInt60
42RDC1Multilingual Report7CreateTimeCreate TimeInt110
TOPService
43ASCLHistory28createTimeCreation TimeInt60
44OREQExternal System Call Request5CreateTimeRequest Creation TimeInt110
45OSCLService Calls28createTimeCreation TimeInt60
46QUE2Queue Elements7createTimeCreation TimeInt60