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
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
7OSRN20Serial Numbers Master Data
8OOCR9Loading Factors
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 TypeVarChar10CC=Customer, A=Account, S=Vendor, P=P.L.A, D=Yes, T=TDS
5BNK2Bank Statement - Recommendation List5DocTypeDocument TypeInt6015=Delivery, 16=Returns, 203=A/R Down Payment, 13=A/R Invoice, 14=A/R Credit Memo, 132=Correction Invoice, 20=Goods Receipt PO, 21=Goods Returns, 204=A/P Down Payment, 18=A/P Invoice, 19=A/P Credit Memo, 24=Incoming Payment, 25=Deposit, 46=Payment Advice, 57=Checks for Payment, 76=Postdated Deposit, -2=Opening Balance, -3=Closing Balance,
6ODTYBoE Document Type2DocTypeDocument TypenVarChar20
7OPDFPayment Draft3DocTypeDocument TypeVarChar10CC=Customer, A=Account, S=Vendor, P=P.L.A, D=TDS
8OPYMPayment Methods for Payment Wizard36DocTypeBoE Document TypenVarChar20
9ORCTIncoming Payment3DocTypeDocument TypeVarChar10CC=Customer, A=Account, S=Vendor, P=P.L.A, T=Tax, D=TDS
10OVPMOutgoing Payments3DocTypeDocument TypeVarChar10SC=Customer, A=Account, S=Vendor, P=P.L.A, T=Tax, D=TDS
TOPBusiness Partners
11OCLGActivities14DocTypeLinked DocumentnVarChar200-113=A/R Invoice, 14=A/R Credit Memo, 15=Delivery notes, 16=A/R Return, 17=Sales Order, 18=A/P Invoice, 19=A/P Credit Memo, 20=Goods Receipt PO, 21=Goods Return, 22=Purchase order, 23=Sales Quotation, 24=Incoming Payment, 25=Deposit, 30=Journal Transaction, 46=Outgoing Payment, 57=Check for Payment, 59=Goods Receipt (inv), 60=Goods Issue (in
TOPFinance
12AJDTJournal Entry - History52DocTypeDocument TypenVarChar120
13GBI7GBI Row 7 - Accounting Vouchers4DocTypeDocument TypenVarChar120
14OBTFJournal Voucher Entry52DocTypeTransact. TypenVarChar120
15OFRTFinancial Report Templates3DocTypeDocument TypeVarChar10BB=Balance Sheet, P=Profit and Loss, C=Trial Balance, F=Cash Flow, S=Sales Unit, T=Form 6111, A=Cost Accounting, E=Asset Devalue Provision, R=Shareholder's Rights and Interests Changing, D=Profit Distribution, V=VAT Payable Detail, L=e-Balance Sheet, O=e-Profit and Loss
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, P=Payment, J=Journal Entry, R=Payment Request
24ATXITax Invoice - History3DocTypeDocument TypeVarChar10II=Invoice, P=Payment, J=Journal Entry
25DWZ2Dunning Wizard Array 2-Invoice Filter17DocTypeSource TableInt11013=A/R Invoice, 203=Down Payment Incoming, 165=Correction A/R Invoice, 14=A/R Credit Memo, 24=Incoming Payment, 30=Journal Transactions, -2=Open Balance, -3=Close Balance
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, P=Payment, J=Journal Entry
52OTSISales Tax Invoice3DocTypeDocument TypeVarChar10II=Invoice, P=Payment, J=Journal Entry
53OTXDTax Invoice Draft3DocTypeDocument TypeVarChar10II=Invoice, P=Payment, J=Journal Entry
54TPI1Purchase Tax Invoice - Rows4DocTypeDocument TypeVarChar10II=Invoice, P=Payment, J=Journal Entry
55TSI1Sales Tax Invoice - Rows14DocTypeDocument TypeVarChar10II=Invoice, P=Payment, J=Journal Entry
56TXD1Tax Invoice Drafts - Rows4DocTypeDocument TypeVarChar10II=Invoice, P=Payment, J=Journal Entry, 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-123=Quotations, 17=Sales Orders, 15=Delivery Notes, 13=Sales Invoices