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

85 columns | Print definition?B1 9.2  | DOCTYPE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPAdministration
1DAR1Data Archive - Transaction Log3DocTypeDocument TypenVarChar200
2DAR2Data Archive - Transaction Log4DocTypeDocument TypeInt110
3DAR3Data Archive - Handwritten Documents3DocTypeDocument TypenVarChar200
4FTT1Financial Template Import - Files8DocTypeTemplate TypeVarChar10BB=Balance Sheet, P=Profit and Loss, C=Trial Balance, F=Statement of Cash Flows, 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, H=Asset History Sheet, G=Others, I=Taxable Profit and Lo
5OTCXTax Code Determination3DocTypeDocument TypeInt1100=Item, 1=Service, 2=Item & Service
TOPBanking
6ARCTIncoming Payment - History3DocTypeDocument TypeVarChar10CC=Customer, A=Account, S=Vendor, P=P.L.A, D=Yes, T=TDS
7BNK2Bank 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,
8ODTYBoE Document Type2DocTypeDocument TypenVarChar20
9OPDFPayment Draft3DocTypeDocument TypeVarChar10C=Customer, A=Account, S=Vendor, P=P.L.A, D=TDS
10OPYMPayment Methods for Payment Wizard36DocTypeBoE Document TypenVarChar20
11ORCTIncoming Payment3DocTypeDocument TypeVarChar10CC=Customer, A=Account, S=Vendor, P=P.L.A, T=Tax, D=TDS
12OVPMOutgoing Payments3DocTypeDocument TypeVarChar10SC=Customer, A=Account, S=Vendor, P=P.L.A, T=Tax, D=TDS
TOPBusiness Partners
13ACP1Campaign - BPs29DocTypeDocument TypenVarChar200-1P=Opportunities, Q=Sales Quotations, O=Sales Orders, D=Deliveries, I=A/R Invoices
14CPN1Campaign - BPs29DocTypeDocument TypenVarChar200-197=Opportunities, 23=Sales Quotations, 17=Sales Orders, 15=Deliveries, 13=A/R Invoices
15OCLGActivities14DocTypeLinked DocumentnVarChar200-113=A/R Invoice, 14=A/R Credit Memo, 15=Delivery, 16=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 Entry, 46=Outgoing Payment, 57=Checks for Payment, 59=Goods Receipt, 60=Goods Issue, 1250000001=Inventory Tr
TOPFinance
16AFADAsset Document - History31DocTypeDocument TypenVarChar150PLPL=Ordinary Depreciation, UP=Unplanned Depreciation, SD=Special Depreciation, AP=Appreciation, TR=Asset Transfer, NC=Sales, SC=Scrapping, TC=Asset Class Transfer
17AJDTJournal Entry - History52DocTypeDocument TypenVarChar600
18GBI7GBI Row 7 - Accounting Vouchers4DocTypeDocument TypenVarChar120
19OACDCredit Memo31DocTypeDocument TypenVarChar150PLPL=Ordinary Depreciation, UP=Unplanned Depreciation, SD=Special Depreciation, AP=Appreciation, TR=Asset Transfer, NC=Sales, SC=Scrapping, TC=Asset Class Transfer
20OACQCapitalization31DocTypeDocument TypenVarChar150PLPL=Ordinary Depreciation, UP=Unplanned Depreciation, SD=Special Depreciation, AP=Appreciation, TR=Asset Transfer, NC=Sales, SC=Scrapping, TC=Asset Class Transfer
21OBTFJournal Voucher Entry52DocTypeTransact. TypenVarChar600
22OFRTFinancial Report Templates3DocTypeTemplate TypeVarChar10BB=Balance Sheet, P=Profit and Loss, C=Trial Balance, F=Statement of Cash Flows, 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, H=Asset History Sheet, G=Others, I=Taxable Profit and Lo
23OFTRTransfer31DocTypeDocument TypenVarChar150PLPL=Ordinary Depreciation, UP=Unplanned Depreciation, SD=Special Depreciation, AP=Appreciation, TR=Asset Transfer, NC=Sales, SC=Scrapping, TC=Asset Class Transfer
24OJDTJournal Entry52DocTypeDocument TypenVarChar600
25OMDPManual Depreciation31DocTypeDocument TypenVarChar150PLPL=Ordinary Depreciation, UP=Unplanned Depreciation, SD=Special Depreciation, AP=Appreciation, TR=Asset Transfer, NC=Sales, SC=Scrapping, TC=Asset Class Transfer
26ORTIRetirement31DocTypeDocument TypenVarChar150PLPL=Ordinary Depreciation, UP=Unplanned Depreciation, SD=Special Depreciation, AP=Appreciation, TR=Asset Transfer, NC=Sales, SC=Scrapping, TC=Asset Class Transfer
27OVTRTax Report17DocTypeA/P or A/RVarChar10PP=Purchasing Documents, R=Sales Documents
TOPGeneral
28ITMRITMR80DocTypeDocument TypenVarChar40
29OBVLSerial Numbers and Batch Valuation Log4DocTypeTransact. TypeInt110-1
30ODW1Default Open Documents2DocTypeOpen Document TypeInt110
31UBVLSerial Numbers and Batch Valuation Log4DocTypeTransact. TypeInt110-1
TOPInventory and Production
32OIGEGoods Issue3DocTypeDocument TypeVarChar10II=Item, S=Service
33OIGNGoods Receipt3DocTypeDocument TypeVarChar10II=Item, S=Service
34OITLInventory Transactions Log8DocTypeTransact. TypeInt110-1
35ORTLResource Transaction Log3DocTypeTransact. TypeInt110
36OWTQInventory Transfer Request3DocTypeDocument TypeVarChar10II=Item, S=Service
37OWTRInventory Transfer3DocTypeDocument TypeVarChar10II=Item, S=Service
TOPMarketing Documents
38ADOCInvoice - History3DocTypeDocument TypeVarChar10II=Item, S=Service
39ATX1Tax Invoice - History - Rows4DocTypeDocument TypeVarChar10II=Invoice, P=Payment, J=Journal Entry, C=Correction Invoice, L=Landed Cost
40ATXITax Invoice - History3DocTypeDocument TypeVarChar10II=Invoice, P=Payment, J=Journal Entry, C=Correction Invoice, D=Down Payment, A=Alteration Invoice, B=Alteration Correction Invoice
41DWZ2Dunning 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, 46=Outgoing Payments
42DWZ4Dunning Wizard Array 4-Paging Grid10DocTypeSource 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
43GPA1Gross Profit Adjustment - Documents5DocTypeDocument TypenVarChar200
44GPA5Product Cost Adjustment - Recalculation of Product Cost9DocTypeChooseVarChar10II=Issue for Production, R=Receipt from Production
45GPA9Applied Gross Profit Adjustments4DocTypeDocument TypenVarChar200
46IVM1Invoice Mapping Object Details3DocTypeDocument TypenVarChar200
47MIN1Monthly Invoice Report Document Information4DocTypeDocument Object IDnVarChar20013=A/R Invoice, 14=A/R Credit Memo
48MIN2Item Imformation of MI3DocTypeDocument TypenVarChar20013=A/R Invoice, 14=A/R Credit Memo
49MIV1A/P Monthly Invoice - Document4DocTypeDocument Object IDnVarChar20018=A/P Invoice, 19=A/P Credit Memo
50MIV2A/P Monthly Invoice - Item3DocTypeDocument TypenVarChar20018=A/P Invoice, 19=A/P Credit Memo
51OCINA/R Correction Invoice3DocTypeDocument TypeVarChar10II=Item, S=Service
52OCPIA/P Correction Invoice3DocTypeDocument TypeVarChar10II=Item, S=Service
53OCPVA/P Correction Invoice Reversal3DocTypeDocument TypeVarChar10II=Item, S=Service
54OCSIA/R Correction Invoice3DocTypeDocument TypeVarChar10II=Item, S=Service
55OCSVA/R Correction Invoice Reversal3DocTypeDocument TypeVarChar10II=Item, S=Service
56ODLNDelivery3DocTypeDocument TypeVarChar10II=Item, S=Service
57ODPIA/R Down Payment3DocTypeDocument TypeVarChar10II=Item, S=Service
58ODPOA/P Down Payment3DocTypeDocument TypeVarChar10II=Item, S=Service
59ODRFDrafts3DocTypeDocument TypeVarChar10II=Item, S=Service
60OIEIIncoming Excise Invoice3DocTypeDocument TypeVarChar10II=Item, S=Service
61OINVA/R Invoice3DocTypeDocument TypeVarChar10II=Item, S=Service
62OOEIOutgoing Excise Invoice3DocTypeDocument TypeVarChar10II=Item, S=Service
63OPCHA/P Invoice3DocTypeDocument TypeVarChar10II=Item, S=Service
64OPDNGoods Receipt PO3DocTypeDocument TypeVarChar10II=Item, S=Service
65OPORPurchase Order3DocTypeDocument TypeVarChar10II=Item, S=Service
66OPQTPurchase Quotation3DocTypeDocument TypeVarChar10II=Item, S=Service
67OPRQPurchase Request3DocTypeDocument TypeVarChar10II=Item, S=Service
68OQUTSales Quotation3DocTypeDocument TypeVarChar10II=Item, S=Service
69ORDNReturns3DocTypeDocument TypeVarChar10II=Item, S=Service
70ORDRSales Order3DocTypeDocument TypeVarChar10II=Item, S=Service
71ORINA/R Credit Memo3DocTypeDocument TypeVarChar10II=Item, S=Service
72ORPCA/P Credit Memo3DocTypeDocument TypeVarChar10II=Item, S=Service
73ORPDGoods Return3DocTypeDocument TypeVarChar10II=Item, S=Service
74OTPIPurchase Tax Invoice3DocTypeDocument TypeVarChar10II=Invoice, J=Journal Entry, C=Correction Invoice, D=Down Payment, A=Alteration Invoice, B=Alteration Correction Invoice
75OTSISales Tax Invoice3DocTypeDocument TypeVarChar10II=Invoice, P=Payment, J=Journal Entry, C=Correction Invoice, A=Alteration Invoice, B=Alteration Correction Invoice
76OTXDTax Invoice Draft3DocTypeDocument TypeVarChar10II=Invoice, P=Payment, J=Journal Entry, C=Correction Invoice, D=Down Payment, A=Alteration Invoice, B=Alteration Correction Invoice
77TGPAGross Profit Adjustment - Log6DocTypeDocument TypenVarChar200
78TPI1Purchase Tax Invoice - Rows4DocTypeDocument TypeVarChar10II=Invoice, P=Payment, J=Journal Entry, C=Correction Invoice, D=Down Payment, L=Landed Cost
79TSI1Sales Tax Invoice - Rows14DocTypeDocument TypeVarChar10II=Invoice, P=Payment, J=Journal Entry, C=Correction Invoice, L=Landed Cost
80TXD1Tax Invoice Drafts - Rows4DocTypeDocument TypeVarChar10II=Invoice, P=Payment, J=Journal Entry, C=Correction Invoice, R=Payment Request, L=Landed Cost
81VRT2Tax Invoice Report Grid Info16DocTypeDocument TypeInt11013=A/R Invoice, 14=A/R Credit Memo, 203=A/R Down Payment
TOPMRP
82MSN5MRP-Specific Document2DocTypeDocument TypenVarChar200
TOPReports
83EBL1E-Balance Report Data6DocTypeDocument TypeVarChar100=XBRL
84ECDW1ECD Wizard - Rows 12DocTypeTemplate TypeVarChar10B=Balance Sheet, P=Profit and Loss
85ORFLAlready 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