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
8/OPT/Z1344Reporting table: Text table for exception definitions
9FMIA65Actual Line Item Table for Funds Management
10PEG_TMTNS2Pegging: Movement Types Explicitly Not Supported

B1 9.2: Top 10 requests

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

B1 8.8: Top 10 requests

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

71 columns | Print definition?B1 8.82  | SERIES

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPAdministration
1CSN1Certificate Series - Series2SeriesSeriesInt60
2DAR1Data Archive - Transaction Log20SeriesSeriesInt60
3NNM1Documents Numbering - Series2SeriesSeriesInt600
4NNM2Series Default3SeriesSeriesInt60
5NNM3Documents Numbering -Belgium Series2SeriesSeriesInt600
6NNM4Electronic Series2SeriesSeriesInt60
7NNM5Document Numbering - Removed Serial Numbers2SeriesSeriesInt60
8ODGPDocument Generation Parameter Sets10SeriesSeriesInt60
TOPBanking
9ARCTIncoming Payment - History62SeriesSeriesInt60
10ODPSDeposit35SeriesSeriesInt60
11OPDFPayment Draft62SeriesSeriesInt60
12ORCTIncoming Payment62SeriesSeriesInt60
13OTPWTax Payment Wizard9SeriesWizard SeriesInt60
14OVPMOutgoing Payments62SeriesSeriesInt60
TOPBusiness Partners
15ACRDBusiness Partners - History298SeriesSeriesInt60
16OCRDBusiness Partner298SeriesSeriesInt60
TOPFinance
17AJDTJournal Entry - History41SeriesSeriesInt600
18OBTFJournal Voucher Entry41SeriesSeriesInt600
19OJDTJournal Entry41SeriesSeriesInt600
TOPInventory and Production
20AITMItems - History252SeriesSeriesInt60
21AMRVInventory Revaluation - History13SeriesSeriesInt600
22AWORProduction Order - History3SeriesSeriesInt600
23OENTShipping Types37SeriesSeriesInt60
24OIGEGoods Issue70SeriesSeriesInt60
25OIGNGoods Receipt70SeriesSeriesInt60
26OIPFLanded Costs43SeriesSeriesInt60
27OITMItems252SeriesSeriesInt60
28OMRLAdvanced Inventory Revaluation3SeriesSeriesInt600
29OMRVInventory Revaluation13SeriesSeriesInt60
30OWKOProduction Instructions22SeriesSeriesInt60
31OWORProduction Order3SeriesSeriesInt600
32OWTQInventory Transfer Request70SeriesSeriesInt60
33OWTRInventory Transfer70SeriesSeriesInt60
34SITMItems252SeriesSeriesInt60
35UITMItems252SeriesSeriesInt60
36UWKOProduction Instructions22SeriesSeriesInt60
37UWORProduction Order3SeriesSeriesInt600
TOPMarketing Documents
38ADOCInvoice - History70SeriesSeriesInt60
39ATXITax Invoice - History14SeriesSeriesInt600
40OCINA/R Correction Invoice70SeriesSeriesInt60
41OCPIA/P Correction Invoice70SeriesSeriesInt60
42OCPVA/P Correction Invoice Reversal70SeriesSeriesInt60
43OCSIA/R Correction Invoice70SeriesSeriesInt60
44OCSVA/R Correction Invoice Reversal70SeriesSeriesInt60
45ODLNDelivery70SeriesSeriesInt60
46ODPIA/R Down Payment70SeriesSeriesInt60
47ODPOA/P Down Payment70SeriesSeriesInt60
48ODRFDrafts70SeriesSeriesInt60
49ODWZDunning Wizard37SeriesSeriesInt600
50OIEIIncoming Excise Invoice70SeriesSeriesInt60
51OINVA/R Invoice70SeriesSeriesInt60
52OMINA/R Monthly Invoice16SeriesSeriesInt60
53OMIVA/P Monthly Invoice16SeriesSeriesInt60
54OOEIOutgoing Excise Invoice70SeriesSeriesInt60
55OPCHA/P Invoice70SeriesSeriesInt60
56OPDNGoods Receipt PO70SeriesSeriesInt60
57OPORPurchase Order70SeriesSeriesInt60
58OPQTPurchase Quotation70SeriesSeriesInt60
59OQUTSales Quotation70SeriesSeriesInt60
60ORDNReturns70SeriesSeriesInt60
61ORDRSales Order70SeriesSeriesInt60
62ORINA/R Credit Memo70SeriesSeriesInt60
63ORPCA/P Credit Memo70SeriesSeriesInt60
64ORPDGoods Return70SeriesSeriesInt60
65OSALOutgoing37SeriesSeriesInt60
66OTPIPurchase Tax Invoice14SeriesSeriesInt600
67OTRATransition37SeriesSeriesInt60
68OTSISales Tax Invoice14SeriesSeriesInt600
69OTXDTax Invoice Draft14SeriesSeriesInt600
TOPService
70ASCLHistory60SeriesSeriesInt60
71OSCLService Calls60SeriesSeriesInt60