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

67 columns | Print definition?B1 8.82  | DOCTYPE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPAdministration
1DAR1Data Archive - Transaction Log3DocTypeDocument TypenVarChar200
2DAR2Data Archive - Transaction Log4DocTypeDocument TypeInt110
3DAR3Data Archive - Handwritten Documents3DocTypeDocument TypenVarChar200
4ODW1Default Open Documents2DocTypeOpen Document TypeInt110
5OTCXTax Code Determination3DocTypeDocument TypeInt1100=Item, 1=Service, 2=Item & Service
TOPBanking
6ARCTIncoming Payment - History3DocTypeDocument TypeVarChar10C
7BNK2Bank Statement - Recommendation List5DocTypeDocument TypeInt60-1=All transactions, -2=Opening Balance, -3=Closing Balance, 132=Correction Invoice, 13=A/R Invoice, 14=A/R Credit Memo, 15=Delivery, 16=Returns, 18=A/P Invoice, 19=A/P Credit Memo, 203=A/R Down Payment, 204=A/P Down Payment, 20=Goods Receipt PO, 21=Goods Returns, 24=Incoming Payment, 25=Deposit, 30=Journal Entry, 46=Payment Advice, 57=Che
8ODTYBoE Document Type2DocTypeDocument TypenVarChar20
9OPDFPayment Draft3DocTypeDocument TypeVarChar10
10OPYMPayment Methods for Payment Wizard36DocTypeBoE Document TypenVarChar20
11ORCTIncoming Payment3DocTypeDocument TypeVarChar10C
12OVPMOutgoing Payments3DocTypeDocument TypeVarChar10S
TOPBusiness Partners
13ACP1Campaign - BPs29DocTypeDocument TypeVarChar10E
14CPN1Campaign - BPs29DocTypeDocument TypeVarChar10E
15OCLGActivities14DocTypeLinked DocumentnVarChar200-1
TOPFinance
16AJDTJournal Entry - History52DocTypeDocument TypenVarChar600
17GBI7GBI Row 7 - Accounting Vouchers4DocTypeDocument TypenVarChar120
18OBTFJournal Voucher Entry52DocTypeTransact. TypenVarChar600
19OFRTFinancial Report Templates3DocTypeDocument TypeVarChar10B
20OJDTJournal Entry52DocTypeDocument TypenVarChar600
21OVTRTax Report17DocTypeA/P or A/RVarChar10P
TOPInventory and Production
22OIGEGoods Issue3DocTypeDocument TypeVarChar10I
23OIGNGoods Receipt3DocTypeDocument TypeVarChar10I
24OITLInventory Transactions Log8DocTypeTransact. TypeInt110-1
25OWTQInventory Transfer Request3DocTypeDocument TypeVarChar10I
26OWTRInventory Transfer3DocTypeDocument TypeVarChar10I
TOPMarketing Documents
27ADOCInvoice - History3DocTypeDocument TypeVarChar10I
28ATX1Tax Invoice - History - Rows4DocTypeDocument TypeVarChar10II=Invoice, J=Journal Entry, P=Payment, R=Payment Request
29ATXITax Invoice - History3DocTypeDocument TypeVarChar10I
30DWZ2Dunning Wizard Array 2-Invoice Filter17DocTypeSource TableInt110
31IVM1Invoice Mapping Object Details3DocTypeDocument TypenVarChar200
32MIN1Monthly Invoice Report Document Information4DocTypeDocument Object IDnVarChar20013=A/R Invoice, 14=A/R Credit Memo
33MIN2Item Imformation of MI3DocTypeDocument TypenVarChar20013=A/R Invoice, 14=A/R Credit Memo
34MIV1A/P Monthly Invoice - Document4DocTypeDocument Object IDnVarChar20018=A/P Invoice, 19=A/P Credit Memo
35MIV2A/P Monthly Invoice - Item3DocTypeDocument TypenVarChar20018=A/P Invoice, 19=A/P Credit Memo
36OCINA/R Correction Invoice3DocTypeDocument TypeVarChar10I
37OCPIA/P Correction Invoice3DocTypeDocument TypeVarChar10I
38OCPVA/P Correction Invoice Reversal3DocTypeDocument TypeVarChar10I
39OCSIA/R Correction Invoice3DocTypeDocument TypeVarChar10I
40OCSVA/R Correction Invoice Reversal3DocTypeDocument TypeVarChar10I
41ODLNDelivery3DocTypeDocument TypeVarChar10I
42ODPIA/R Down Payment3DocTypeDocument TypeVarChar10I
43ODPOA/P Down Payment3DocTypeDocument TypeVarChar10I
44ODRFDrafts3DocTypeDocument TypeVarChar10I
45OIEIIncoming Excise Invoice3DocTypeDocument TypeVarChar10I
46OINVA/R Invoice3DocTypeDocument TypeVarChar10I
47OOEIOutgoing Excise Invoice3DocTypeDocument TypeVarChar10I
48OPCHA/P Invoice3DocTypeDocument TypeVarChar10I
49OPDNGoods Receipt PO3DocTypeDocument TypeVarChar10I
50OPORPurchase Order3DocTypeDocument TypeVarChar10I
51OPQTPurchase Quotation3DocTypeDocument TypeVarChar10I
52OQUTSales Quotation3DocTypeDocument TypeVarChar10I
53ORDNReturns3DocTypeDocument TypeVarChar10I
54ORDRSales Order3DocTypeDocument TypeVarChar10I
55ORINA/R Credit Memo3DocTypeDocument TypeVarChar10I
56ORPCA/P Credit Memo3DocTypeDocument TypeVarChar10I
57ORPDGoods Return3DocTypeDocument TypeVarChar10I
58OTPIPurchase Tax Invoice3DocTypeDocument TypeVarChar10I
59OTSISales Tax Invoice3DocTypeDocument TypeVarChar10I
60OTXDTax Invoice Draft3DocTypeDocument TypeVarChar10I
61TPI1Purchase Tax Invoice - Rows4DocTypeDocument TypeVarChar10II=Invoice, J=Journal Entry, P=Payment
62TSI1Sales Tax Invoice - Rows14DocTypeDocument TypeVarChar10II=Invoice, J=Journal Entry, P=Payment
63TXD1Tax Invoice Drafts - Rows4DocTypeDocument TypeVarChar10II=Invoice, J=Journal Entry, P=Payment, R=Payment Request
64VRT2Tax Invoice Report Grid Info16DocTypeDocument TypeInt11013=A/R Invoice, 14=A/R Credit Memo, 203=A/R Down Payment
TOPMRP
65MSN5MRP-Specific Document2DocTypeDocument TypenVarChar200
TOPReports
66ORFLAlready Displayed 347, 349 and WTax Reports2DocTypeDocument TypenVarChar20013=Invoice, 14=Revert Invoice, 18=Purchase, 19=Revert purchase, 203=A/R Down Payment, 204=A/P Down Payment
TOPSales Opportunities
67OOPRSales Opportunity46DocTypeLinked Document TypenVarChar20-113=Sales Invoices, 15=Delivery Notes, 17=Sales Orders, 23=Quotations