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
2FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
3/ISDFPS/CHVW_E34External Batch Where-Used List
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
7JDT1124Journal Entry - Rows
8OPOR386Purchase Order
9OACT114G/L Accounts
10OUSR101Users

B1 8.8: Top 10 requests

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

53 columns | Print definition?B1 8.82  | PRINTED

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPBanking
1ABOEBill of Exchange for Payment - History21PrintedPrintedVarChar10NN=No, Y=Yes
2ACHOChecks for Payment - History20PrintedPrintedVarChar10NN=No, Y=Yes
3ARCTIncoming Payment - History6PrintedPrintedVarChar10N
4OBOEBill of Exchange for Payment21PrintedPrintedVarChar10NN=No, Y=Yes
5OCHDChecks for Payment Drafts20PrintedPrintedVarChar10NN=No, Y=Yes
6OCHOChecks for Payment20PrintedPrintedVarChar10NN=No, Y=Yes
7ODPSDeposit21PrintedOriginal/CopyVarChar10N
8OPDFPayment Draft6PrintedPrintedVarChar10N
9ORCTIncoming Payment6PrintedPrintedVarChar10N
10OVPMOutgoing Payments6PrintedPrintedVarChar10N
TOPFinance
11AJDTJournal Entry - History51PrintedPrintedVarChar10N
12OBTFJournal Voucher Entry51PrintedPrintedVarChar10N
13OJDTJournal Entry51PrintedPrintedVarChar10N
TOPInventory and Production
14APKLPick List - History10PrintedPrintedVarChar10NY=Copy, N=Original
15AWORProduction Order - History27PrintedPrintedVarChar10N
16OENTShipping Types4PrintedPrintedVarChar10NY=Copy, N=Original
17OIGEGoods Issue6PrintedPrintedVarChar10N
18OIGNGoods Receipt6PrintedPrintedVarChar10N
19OMRLAdvanced Inventory Revaluation7PrintedPrintedVarChar10NY=Copy, N=Original
20OPKLPick List10PrintedPrintedVarChar10NY=Copy, N=Original
21OWORProduction Order27PrintedPrintedVarChar10N
22OWTQInventory Transfer Request6PrintedPrintedVarChar10N
23OWTRInventory Transfer6PrintedPrintedVarChar10N
24UWORProduction Order27PrintedPrintedVarChar10N
TOPMarketing Documents
25ADOCInvoice - History6PrintedPrintedVarChar10N
26ATXITax Invoice - History6PrintedPrintedVarChar10N
27OCINA/R Correction Invoice6PrintedPrintedVarChar10N
28OCPIA/P Correction Invoice6PrintedPrintedVarChar10N
29OCPVA/P Correction Invoice Reversal6PrintedPrintedVarChar10N
30OCSIA/R Correction Invoice6PrintedPrintedVarChar10N
31OCSVA/R Correction Invoice Reversal6PrintedPrintedVarChar10N
32ODLNDelivery6PrintedPrintedVarChar10N
33ODPIA/R Down Payment6PrintedPrintedVarChar10N
34ODPOA/P Down Payment6PrintedPrintedVarChar10N
35ODRFDrafts6PrintedPrintedVarChar10N
36OIEIIncoming Excise Invoice6PrintedPrintedVarChar10N
37OINVA/R Invoice6PrintedPrintedVarChar10N
38OOEIOutgoing Excise Invoice6PrintedPrintedVarChar10N
39OPCHA/P Invoice6PrintedPrintedVarChar10N
40OPDNGoods Receipt PO6PrintedPrintedVarChar10N
41OPORPurchase Order6PrintedPrintedVarChar10N
42OPQTPurchase Quotation6PrintedPrintedVarChar10N
43OQUTSales Quotation6PrintedPrintedVarChar10N
44ORDNReturns6PrintedPrintedVarChar10N
45ORDRSales Order6PrintedPrintedVarChar10N
46ORINA/R Credit Memo6PrintedPrintedVarChar10N
47ORPCA/P Credit Memo6PrintedPrintedVarChar10N
48ORPDGoods Return6PrintedPrintedVarChar10N
49OSALOutgoing4PrintedPrintedVarChar10NY=Copy, N=Original
50OTPIPurchase Tax Invoice6PrintedPrintedVarChar10N
51OTRATransition4PrintedPrintedVarChar10NY=Copy, N=Original
52OTSISales Tax Invoice6PrintedPrintedVarChar10N
53OTXDTax Invoice Draft6PrintedPrintedVarChar10N