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

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