SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

www.saptables.net

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
1BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
2/ISDFPS/CHVW_E34External Batch Where-Used List
3FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
4FMARCPAR4Parallelization of FMARC_BATCH
5CEKRS5Movement type parameters for automatic ERS
6AUDLORIPR7KPro: Logical Information Object Attribute Values
7FCO_DOC_HEAD61Failure Cost Document Header
8FMIA65Actual Line Item Table for Funds Management
9/OPT/Z1344Reporting table: Text table for exception definitions
10PEG_TMTNS2Pegging: Movement Types Explicitly Not Supported

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OCRD332Business Partner
3OINV386A/R Invoice
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPOR386Purchase Order
8JDT1124Journal Entry - Rows
9OACT114G/L Accounts
10OUSR101Users

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2OINV268A/R Invoice
3OPCH268A/P Invoice
4OSRN20Serial Numbers Master Data
5OIVL77Whse Journal
6OVPM154Outgoing Payments
7ORCT154Incoming Payment
8OBOT10Bill Of Exchang Transaction
9OOCR9Loading Factors
10JDT1110Journal Entry - Rows
PHPRef.com - the webs number one PHP Function reference tool

38 columns | Print definition?B1 9.2  | CREATETIME

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