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
3OVPM154Outgoing Payments
4OIVL77Whse Journal
5ORCT154Incoming Payment
6OPCH268A/P Invoice
7OOCR9Loading Factors
8OSRN20Serial Numbers Master Data
9JDT1110Journal Entry - Rows
10OBOT10Bill Of Exchang Transaction
PHPRef.com - the webs number one PHP Function reference tool

99 columns | Print definition?B1 8.8  | CARDCODE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPAdministration
1DAR2Data Archive - Transaction Log7CardCodeCustomer/Vendor CodenVarChar150
2DGP1Customer List2CardCodeCustomer CodenVarChar150
3OSRLSerial Numbers3CardCodeCustomer CodenVarChar150
TOPBanking
4ABOEBill of Exchange for Payment - History17CardCodeBP CodenVarChar150
5ARCTIncoming Payment - History9CardCodeBP CodenVarChar150
6OBCGBank Charge for Bank Transfers1CardCodeBP CodenVarChar150
7OBNKExternal Bank Statement Received17CardCodeBP CodenVarChar150
8OBOEBill of Exchange for Payment17CardCodeBP CodenVarChar150
9OCHHCheck Register8CardCodeCustomer CodenVarChar150
10OCRHCredit Card Management25CardCodeCustomer CodenVarChar150
11OCRVCredit Payments19CardCodeCustomer CodenVarChar150
12OPDFPayment Draft9CardCodeCustomer/Vendor CodenVarChar150
13ORCTIncoming Payment9CardCodeCustomer/Vendor CodenVarChar150
14OVPMOutgoing Payments9CardCodeCustomer/Vendor CodenVarChar150
15PWZ1Payment Wizard - Rows 12CardCodeBP CodenVarChar150
16PWZ3Payment Wizard - Rows 33CardCodeVendor CodenVarChar150
17PWZ4Payment Wizard - Rows 43CardCodeVendor's Card codenVarChar150
18PWZ5Payment Wizard - Rows 54CardCodeCard CodenVarChar150
TOPBusiness Partners
19ACPRContact Persons - History2CardCodeBP CodenVarChar150
20ACR1Business Partner Addresses - History2CardCodeBP CodenVarChar150
21ACR2Bussiness Partners - Payment Methods-History1CardCodeBP CodenVarChar150
22ACR3Business Partner Control Accounts - History1CardCodeBP CodenVarChar150
23ACR4Allowed WTax Codes for BP - History1CardCodeBP CodenVarChar150
24ACR5BP Payment Dates1CardCodeBP CodenVarChar150
25ACRBBusiness Partner Bank Accounts - History2CardCodeBP CodenVarChar150
26ACRDBusiness Partners - History1CardCodeBP CodenVarChar150
27CRD1Business Partners - Addresses2CardCodeBP CodenVarChar150
28CRD2Bussiness Partners - Payment Methods1CardCodeBP CodenVarChar150
29CRD3BP Control Account1CardCodeBP CodenVarChar150
30CRD4Allowed WTax Codes for BP1CardCodeBP CodenVarChar150
31CRD5BP Payment Dates1CardCodeBP CodenVarChar150
32CRD6BP's Payer Name1CardCodeBP CodenVarChar150
33CRD7Fiscal IDs for BP Master Data1CardCodeBP CodenVarChar250
34OCLGActivities2CardCodeBP CodenVarChar150
35OCPRContact Persons2CardCodeBP CodenVarChar150
36OCRBBP - Bank Account2CardCodeBP CodenVarChar150
37OCRDBusiness Partner1CardCodeBP CodenVarChar150
38ODDTWithholding Tax Deduction Hierarchy2CardCodeBP CodenVarChar150
39OSCNCustomer/Vendor Cat. No.2CardCodeBP CodenVarChar150
TOPFinance
40OACMAccumulation2CardCodeCustomer/Vendor CodenVarChar150
TOPInventory and Production
41AITMItems - History19CardCodePreferred VendornVarChar150
42AWORProduction Order - History19CardCodeCustomer CodenVarChar150
43IPF1Landed Costs - Rows25CardCodeVendor CodenVarChar150
44OENTShipping Types8CardCodeBP CodenVarChar150
45OIBTBatch No. for Item17CardCodeBP CodenVarChar150
46OIGEGoods Issue13CardCodeExpense AccountnVarChar150
47OIGNGoods Receipt13CardCodeRevenue AccountnVarChar150
48OINMWhse Journal8CardCodeCustomer/Vendor CodenVarChar150
49OIPFLanded Costs5CardCodeVendor CodenVarChar150
50OITLInventory Transactions Log17CardCodeBP CodenVarChar150
51OITMItems19CardCodePreferred VendornVarChar150
52OSPGSpecial Prices for Groups1CardCodeBP CodenVarChar150
53OSPPSpecial Prices2CardCodeBP CodenVarChar150
54OSRISerial Numbers for Items20CardCodeBP CodenVarChar150
55OWKOProduction Instructions9CardCodeSold-to Party CodenVarChar150
56OWORProduction Order19CardCodeCustomer CodenVarChar150
57OWTRInventory Transfer13CardCodeCustomer/Vendor CodenVarChar150
58SPP1Special Prices - Data Areas2CardCodeBP CodenVarChar150
59SPP2Special Prices - Quantity Areas2CardCodeBP CodenVarChar150
60UITMItems19CardCodePreferred VendornVarChar150
61UWKOProduction Instructions9CardCodeSold-To-Party CodenVarChar150
62UWORProduction Order19CardCodeCustomer CodenVarChar150
TOPMarketing Documents
63ADOCInvoice - History13CardCodeBP CodenVarChar150
64ATXITax Invoice - History10CardCodeCustomer CodenVarChar150
65DWZ1Dunning Wizard Array1 - BP Filter2CardCodeBP Card CodenVarChar150
66DWZ2Dunning Wizard Array 2-Invoice Filter2CardCodeBP Card CodenVarChar150
67OCINA/R Correction Invoice13CardCodeCustomer/Vendor CodenVarChar150
68OCPIA/P Correction Invoice13CardCodeCustomer/Vendor CodenVarChar150
69OCPVA/P Correction Invoice Reversal13CardCodeCustomer/Vendor CodenVarChar150
70OCSIA/R Correction Invoice13CardCodeCustomer/Vendor CodenVarChar150
71OCSVA/R Correction Invoice Reversal13CardCodeCustomer/Vendor CodenVarChar150
72ODLNDelivery13CardCodeCustomer/Vendor CodenVarChar150
73ODPIA/R Down Payment13CardCodeCustomer/Vendor CodenVarChar150
74ODPOA/P Down Payment13CardCodeCustomer/Vendor CodenVarChar150
75ODRFDrafts13CardCodeBP CodenVarChar150
76OIEIIncoming Excise Invoice13CardCodeCustomer/Vendor CodenVarChar150
77OINVA/R Invoice13CardCodeCustomer/Vendor CodenVarChar150
78OOEIOutgoing Excise Invoice13CardCodeCustomer/Vendor CodenVarChar150
79OPCHA/P Invoice13CardCodeCustomer/Vendor CodenVarChar150
80OPDNGoods Receipt PO13CardCodeCustomer/Vendor CodenVarChar150
81OPORPurchase Order13CardCodeCustomer/Vendor CodenVarChar150
82OQUTSales Quotation13CardCodeCustomer/Vendor CodenVarChar150
83ORDNReturns13CardCodeCustomer/Vendor CodenVarChar150
84ORDRSales Order13CardCodeCustomer/Vendor CodenVarChar150
85ORINA/R Credit Memo13CardCodeCustomer/Vendor CodenVarChar150
86ORPCA/P Credit Memo13CardCodeCustomer/Vendor CodenVarChar150
87ORPDGoods Return13CardCodeCustomer/Vendor CodenVarChar150
88OSALOutgoing8CardCodeBP CodenVarChar150
89OTPIPurchase Tax Invoice10CardCodeCustomer CodenVarChar150
90OTRATransition8CardCodeBP CodenVarChar150
91OTSISales Tax Invoice10CardCodeCustomer CodenVarChar150
92OTXDTax Invoice Draft10CardCodeCustomer CodenVarChar150
93OVRTTax Invoice Report4CardCodeReceipt BP CodenVarChar150
TOPMRP
94ORCMRecommendation Data9CardCodePreferred VendornVarChar150
TOPReports
95AMD1Amout Differences Report Lines5CardCodeBP CodenVarChar150
96OAMDAmount Differences Report4CardCodeBP CodenVarChar150
97RDFLDocument Standards4CardCodeBP CodenVarChar150-1
98SRT2Korean Summary Report - Rows24CardCodeBP Code on OCRDnVarChar150
TOPSales Opportunities
99OOPRSales Opportunity2CardCodeBP CodenVarChar150