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

65 columns | Print definition?B1 9.2  | BPLNAME

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPAdministration
1DGP4Business Place List4BPLNameBusiness Place NamenVarChar1000
TOPBanking
2ACHOChecks for Payment - History51BPLNameBranch NamenVarChar1000
3ARCTIncoming Payment - History167BPLNameBranch NamenVarChar1000
4BNK2Bank Statement - Recommendation List29BPLNameBranch NamenVarChar1000
5OCHDChecks for Payment Drafts51BPLNameBranch NamenVarChar1000
6OCHOChecks for Payment51BPLNameBranch NamenVarChar1000
7OITRInternal Reconciliation25BPLNameBranch NamenVarChar1000
8OPDFPayment Draft167BPLNameBranch NamenVarChar1000
9ORCTIncoming Payment167BPLNameBranch NamenVarChar1000
10OVPMOutgoing Payments167BPLNameBranch NamenVarChar1000
TOPBusiness Partners
11ABPLBusiness Place2BPLNameBranch NamenVarChar1000
12OBPLBusiness Place2BPLNameBranch NamenVarChar1000
TOPFinance
13AACTG/L Account - History108BPLNameBranch NamenVarChar1000
14AFADAsset Document - History42BPLNameBranch NamenVarChar1000
15AJD1Journal Entry - History - Rows119BPLNameBranch NamenVarChar1000
16BTF1Journal Voucher - Rows119BPLNameBranch NamenVarChar1000
17JDT1Journal Entry - Rows119BPLNameBranch NamenVarChar1000
18OACDCredit Memo42BPLNameBranch NamenVarChar1000
19OACQCapitalization42BPLNameBranch NamenVarChar1000
20OACTG/L Accounts108BPLNameBranch NamenVarChar1000
21OFARFixed Asset Revaluation15BPLNameBranch NamenVarChar1000
22OFTRTransfer42BPLNameBranch NamenVarChar1000
23OMDPManual Depreciation42BPLNameBranch NamenVarChar1000
24ORTIRetirement42BPLNameBranch NamenVarChar1000
TOPInventory and Production
25AINCInventory Counting24BPLNameBranch NamenVarChar1000
26AIQIInventory Opening Balance31BPLNameBranch NamenVarChar1000
27AIQRInventory Posting32BPLNameBranch NamenVarChar1000
28OICDInventory Counting Draft24BPLNameBranch NamenVarChar1000
29OIGEGoods Issue167BPLNameBranch NamenVarChar1000
30OIGNGoods Receipt167BPLNameBranch NamenVarChar1000
31OINCInventory Counting24BPLNameBranch NamenVarChar1000
32OIODInventory Opening Balance Draft31BPLNameBranch NamenVarChar1000
33OIPDInventory Posting Draft32BPLNameBranch NamenVarChar1000
34OIQIInventory Opening Balance31BPLNameBranch NamenVarChar1000
35OIQRInventory Posting32BPLNameBranch NamenVarChar1000
36OWTQInventory Transfer Request167BPLNameBranch NamenVarChar1000
37OWTRInventory Transfer167BPLNameBranch NamenVarChar1000
TOPMarketing Documents
38ADOCInvoice - History167BPLNameBranch NamenVarChar1000
39ATXITax Invoice - History43BPLNameBranch NamenVarChar1000
40OCINA/R Correction Invoice167BPLNameBranch NamenVarChar1000
41OCPIA/P Correction Invoice167BPLNameBranch NamenVarChar1000
42OCPVA/P Correction Invoice Reversal167BPLNameBranch NamenVarChar1000
43OCSIA/R Correction Invoice167BPLNameBranch NamenVarChar1000
44OCSVA/R Correction Invoice Reversal167BPLNameBranch NamenVarChar1000
45ODLNDelivery167BPLNameBranch NamenVarChar1000
46ODPIA/R Down Payment167BPLNameBranch NamenVarChar1000
47ODPOA/P Down Payment167BPLNameBranch NamenVarChar1000
48ODRFDrafts167BPLNameBranch NamenVarChar1000
49OIEIIncoming Excise Invoice167BPLNameBranch NamenVarChar1000
50OINVA/R Invoice167BPLNameBranch NamenVarChar1000
51OOEIOutgoing Excise Invoice167BPLNameBranch NamenVarChar1000
52OPCHA/P Invoice167BPLNameBranch NamenVarChar1000
53OPDNGoods Receipt PO167BPLNameBranch NamenVarChar1000
54OPORPurchase Order167BPLNameBranch NamenVarChar1000
55OPQTPurchase Quotation167BPLNameBranch NamenVarChar1000
56OPRQPurchase Request167BPLNameBranch NamenVarChar1000
57OQUTSales Quotation167BPLNameBranch NamenVarChar1000
58ORDNReturns167BPLNameBranch NamenVarChar1000
59ORDRSales Order167BPLNameBranch NamenVarChar1000
60ORINA/R Credit Memo167BPLNameBranch NamenVarChar1000
61ORPCA/P Credit Memo167BPLNameBranch NamenVarChar1000
62ORPDGoods Return167BPLNameBranch NamenVarChar1000
63OTPIPurchase Tax Invoice43BPLNameBranch NamenVarChar1000
64OTSISales Tax Invoice43BPLNameBranch NamenVarChar1000
65OTXDTax Invoice Draft43BPLNameBranch NamenVarChar1000