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

59 columns | Print definition?B1 8.8  | DOCTYPE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPAdministration
1DAR1Data Archive - Transaction Log3DocTypeDocument TypenVarChar200
2DAR2Data Archive - Transaction Log4DocTypeDocument TypeInt110
3DAR3Data Archive - Handwritten Documents3DocTypeDocument TypenVarChar200
TOPBanking
4ARCTIncoming Payment - History3DocTypeDocument TypeVarChar10CA=Account, C=Customer, D=Yes, P=P.L.A, S=Vendor, T=TDS
5BNK2Bank 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
6ODTYBoE Document Type2DocTypeDocument TypenVarChar20
7OPDFPayment Draft3DocTypeDocument TypeVarChar10CA=Account, C=Customer, D=TDS, P=P.L.A, S=Vendor
8OPYMPayment Methods for Payment Wizard36DocTypeBoE Document TypenVarChar20
9ORCTIncoming Payment3DocTypeDocument TypeVarChar10CA=Account, C=Customer, D=TDS, P=P.L.A, S=Vendor, T=Tax
10OVPMOutgoing Payments3DocTypeDocument TypeVarChar10SA=Account, C=Customer, D=TDS, P=P.L.A, S=Vendor, T=Tax
TOPBusiness Partners
11OCLGActivities14DocTypeLinked DocumentnVarChar200-1132=Correction Invoice, 13=A/R Invoice, 140000009=Outgoing Excise Invoice, 140000010=Incoming Excise Invoice, 14=A/R Credit Memo, 15=Delivery notes, 162=Material Revaluation, 163=Correction A/P Invoice, 164=Correction A/P Invoice Reversal, 165=Correction A/R Invoice, 166=Correction A/R Invoice Reversal, 16=A/R Return, 17=Sales Order, 18=A/
TOPFinance
12AJDTJournal Entry - History52DocTypeDocument TypenVarChar120
13GBI7GBI Row 7 - Accounting Vouchers4DocTypeDocument TypenVarChar120
14OBTFJournal Voucher Entry52DocTypeTransact. TypenVarChar120
15OFRTFinancial Report Templates3DocTypeDocument TypeVarChar10BA=Cost Accounting, B=Balance Sheet, C=Trial Balance, D=Profit Distribution, E=Asset Devalue Provision, F=Cash Flow, L=e-Balance Sheet, O=e-Profit and Loss, P=Profit and Loss, R=Shareholder's Rights and Interests Changing, S=Sales Unit, T=Form 6111, V=VAT Payable Detail
16OJDTJournal Entry52DocTypeDocument TypenVarChar120
17OVTRTax Report17DocTypeA/P or A/RVarChar10PP=Purchasing Documents, R=Sales Documents
TOPInventory and Production
18OIGEGoods Issue3DocTypeDocument TypeVarChar10II=Item, S=Service
19OIGNGoods Receipt3DocTypeDocument TypeVarChar10II=Item, S=Service
20OITLInventory Transactions Log8DocTypeTransact. TypeInt110-1
21OWTRInventory Transfer3DocTypeDocument TypeVarChar10II=Item, S=Service
TOPMarketing Documents
22ADOCInvoice - History3DocTypeDocument TypeVarChar10II=Item, S=Service
23ATX1Tax Invoice - History - Rows4DocTypeDocument TypeVarChar10II=Invoice, J=Journal Entry, P=Payment, R=Payment Request
24ATXITax Invoice - History3DocTypeDocument TypeVarChar10II=Invoice, J=Journal Entry, P=Payment
25DWZ2Dunning Wizard Array 2-Invoice Filter17DocTypeSource TableInt110-2=Open Balance, -3=Close Balance, 13=A/R Invoice, 14=A/R Credit Memo, 165=Correction A/R Invoice, 203=Down Payment Incoming, 24=Incoming Payment, 30=Journal Transactions
26MIN1Monthly Invoice Report Document Information4DocTypeDocument Object IDnVarChar20013=A/R Invoice, 14=A/R Credit Memo
27MIN2Item Imformation of MI3DocTypeDocument TypenVarChar20013=A/R Invoice, 14=A/R Credit Memo
28MIV1A/P Monthly Invoice - Document4DocTypeDocument Object IDnVarChar20018=A/P Invoice, 19=A/P Credit Memo
29MIV2A/P Monthly Invoice - Item3DocTypeDocument TypenVarChar20018=A/P Invoice, 19=A/P Credit Memo
30OCINA/R Correction Invoice3DocTypeDocument TypeVarChar10II=Item, S=Service
31OCPIA/P Correction Invoice3DocTypeDocument TypeVarChar10II=Item, S=Service
32OCPVA/P Correction Invoice Reversal3DocTypeDocument TypeVarChar10II=Item, S=Service
33OCSIA/R Correction Invoice3DocTypeDocument TypeVarChar10II=Item, S=Service
34OCSVA/R Correction Invoice Reversal3DocTypeDocument TypeVarChar10II=Item, S=Service
35ODLNDelivery3DocTypeDocument TypeVarChar10II=Item, S=Service
36ODPIA/R Down Payment3DocTypeDocument TypeVarChar10II=Item, S=Service
37ODPOA/P Down Payment3DocTypeDocument TypeVarChar10II=Item, S=Service
38ODRFDrafts3DocTypeDocument TypeVarChar10II=Item, S=Service
39OIEIIncoming Excise Invoice3DocTypeDocument TypeVarChar10II=Item, S=Service
40OINVA/R Invoice3DocTypeDocument TypeVarChar10II=Item, S=Service
41OOEIOutgoing Excise Invoice3DocTypeDocument TypeVarChar10II=Item, S=Service
42OPCHA/P Invoice3DocTypeDocument TypeVarChar10II=Item, S=Service
43OPDNGoods Receipt PO3DocTypeDocument TypeVarChar10II=Item, S=Service
44OPORPurchase Order3DocTypeDocument TypeVarChar10II=Item, S=Service
45OQUTSales Quotation3DocTypeDocument TypeVarChar10II=Item, S=Service
46ORDNReturns3DocTypeDocument TypeVarChar10II=Item, S=Service
47ORDRSales Order3DocTypeDocument TypeVarChar10II=Item, S=Service
48ORINA/R Credit Memo3DocTypeDocument TypeVarChar10II=Item, S=Service
49ORPCA/P Credit Memo3DocTypeDocument TypeVarChar10II=Item, S=Service
50ORPDGoods Return3DocTypeDocument TypeVarChar10II=Item, S=Service
51OTPIPurchase Tax Invoice3DocTypeDocument TypeVarChar10II=Invoice, J=Journal Entry, P=Payment
52OTSISales Tax Invoice3DocTypeDocument TypeVarChar10II=Invoice, J=Journal Entry, P=Payment
53OTXDTax Invoice Draft3DocTypeDocument TypeVarChar10II=Invoice, J=Journal Entry, P=Payment
54TPI1Purchase Tax Invoice - Rows4DocTypeDocument TypeVarChar10II=Invoice, J=Journal Entry, P=Payment
55TSI1Sales Tax Invoice - Rows14DocTypeDocument TypeVarChar10II=Invoice, J=Journal Entry, P=Payment
56TXD1Tax Invoice Drafts - Rows4DocTypeDocument TypeVarChar10II=Invoice, J=Journal Entry, P=Payment, R=Payment Request
57VRT2Tax Invoice Report Grid Info16DocTypeDocument TypeInt11013=A/R Invoice, 14=A/R Credit Memo, 203=A/R Down Payment
TOPReports
58ORFLAlready 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
59OOPRSales Opportunity46DocTypeLinked Document TypenVarChar20-113=Sales Invoices, 15=Delivery Notes, 17=Sales Orders, 23=Quotations