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
6/ISDFPS/CHVW_E34External Batch Where-Used List
7FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9BSEG345Accounting Document Segment
10FMARCPAR4Parallelization of FMARC_BATCH

B1 9.2: Top 10 requests

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

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OINM101Whse Journal
10OSRN20Serial Numbers Master Data

69 columns | Print definition?B1 9.3  | 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
57OPRRGoods Return Request167BPLNameBranch NamenVarChar1000
58OQUTSales Quotation167BPLNameBranch NamenVarChar1000
59ORDNReturns167BPLNameBranch NamenVarChar1000
60ORDRSales Order167BPLNameBranch NamenVarChar1000
61ORINA/R Credit Memo167BPLNameBranch NamenVarChar1000
62ORPCA/P Credit Memo167BPLNameBranch NamenVarChar1000
63ORPDGoods Return167BPLNameBranch NamenVarChar1000
64ORRRReturn Request167BPLNameBranch NamenVarChar1000
65OSFCSelf Credit Memo167BPLNameBranch NamenVarChar1000
66OSFISelf Invoice167BPLNameBranch NamenVarChar1000
67OTPIPurchase Tax Invoice43BPLNameBranch NamenVarChar1000
68OTSISales Tax Invoice43BPLNameBranch NamenVarChar1000
69OTXDTax Invoice Draft43BPLNameBranch NamenVarChar1000