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

B1 9.2: Top 10 requests

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

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction
Finance
ProductVersionTableColumnsIndexesDescriptionModule
1Business One8.82AACP1431Periods Category-LogFinance
SQL:  selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT AbsEntry, PeriodCat, FinancYear, Year, PeriodName, SubType, PeriodNum, F_RefDate, T_RefDate, F_DueDate, T_DueDate, F_TaxDate, T_TaxDate, LogInstanc, UpdateDate, UserSign, LinkAct_1, LinkAct_2, LinkAct_3, LinkAct_4, LinkAct_5, LinkAct_6, ComissAct, LinkAct_8, LinkAct_9, LinkAct_10, LinkAct_11, LinkAct_12, LinkAct_13, LinkAct_14, LinkAct_15, LinkAct_16, LinkAct_17, LinkAct_18, DfltIncom, ExmptIncom, DfltExpn, ForgnIncm, ECIncome, ForgnExpn, DfltRateDi, DecresGlAc, LinkAct_27, DftStockOB, LinkAct_19, LinkAct_20, LinkAct_21, LinkAct_22, LinkAct_23, LinkAct_24, LinkAct_25, LinkAct_26, IncresGlAc, RturnngAct, COGM_Act, AlocCstAct, VariancAct, PricDifAct, CDownPymnt, VDownPymnt, CBoERcvble, CBoEOnClct, CBoEPresnt, CBoEDiscnt, CUnpaidBoE, VBoEPayble, VAsstBoEPy, COpenDebts, VOpenDebts, PurchseAct, PaReturnAc, PaOffsetAc, LinkAct_28, ExDiffAct, BalanceAct, BnkChgAct, LinkAct_29, LinkAct_30, IncmAcct, ExpnAcct, VatRevAct, ExpClrAct, ExpOfstAct, CostRevAct, RepomoAct, WipVarAcct, SaleVatOff, PurcVatOff, DpmSalAct, DpmPurAct, ExpVarAct, CostOffAct, ECExepnses, StockAct, DflInPrcss, DfltInCstm, DfltProfit, DfltLoss, VAssets, StockRvAct, StkRvOfAct, WipAcct, DfltCard, ShpdGdsAct, GlRvOffAct, OverpayAP, UndrpayAP, OverpayAR, UndrpayAR, ARCMAct, ARCMExpAct, ARCMFrnAct, ARCMEUAct, APCMAct, APCMFrnAct, APCMEUAct, NegStckAct, StkInTnAct, GLGainXdif, GLLossXdif, AmountDiff, SlfInvIncm, SlfInvExpn, OnHoldAct, PlaAct, ICClrAct, OCClrAct, PurBalAct, WhICenAct, WhOCenAct, SalDpmInt, PurDpmInt, ExrateOnDt, UserSign2, EURecvAct, EUPayAct, WipOffset, StockOffst, DunIntrst, DunFee, SnapShotId, TDSInterst, TDSCharges FROM AACP
ColumnFieldDescriptionSQL TypeLengthDecimalsRelationDefault ValueConstraintsSQL Create Statement
1AbsEntryInternal Numberint1100 Allow NULL? 
2PeriodCatPeriod Categorynvarchar100 Allow NULL? 
3FinancYearBeginning of Financial Yeardate80
4YearFinancial Yearint60 Allow NULL? 
5PeriodNamePeriod Namenvarchar200 Allow NULL? 
6SubTypeSub-Period Typechar10YD, M, Q, Y Allow NULL? 
7PeriodNumNumber of Periodsint110 Allow NULL? 
8F_RefDatePosting Date Fromdate80
9T_RefDatePosting Date Todate80
10F_DueDateDue Date Fromdate80
11T_DueDateDue Date Todate80
12F_TaxDateDocument Date Fromdate80
13T_TaxDateDocument Date Todate80
14LogInstancLog Instanceint60 Allow NULL? 
15UpdateDateDate of Updatedate80
16UserSignUser Signatureint60OUSR Allow NULL? 
17LinkAct_1Domestic Accounts Receivablenvarchar150OACT Allow NULL? 
18LinkAct_2Checks Receivednvarchar150OACT Allow NULL? 
19LinkAct_3Cash on Handnvarchar150OACT Allow NULL? 
20LinkAct_4Accountnvarchar150OACT Allow NULL? 
21LinkAct_5Sales Tax Accountnvarchar150OACT Allow NULL? 
22LinkAct_6Customer's Deduction at Sourcenvarchar150OACT Allow NULL? 
23ComissActCredit Card Deposit Feenvarchar150OACT Allow NULL? 
24LinkAct_8Purchase Taxnvarchar150OACT Allow NULL? 
25LinkAct_9Foreign Accounts Receivablenvarchar150OACT Allow NULL? 
26LinkAct_10Domestic Accounts Payablenvarchar150OACT Allow NULL? 
27LinkAct_11Foreign Accounts Payablenvarchar150OACT Allow NULL? 
28LinkAct_12Bank Transfernvarchar150OACT Allow NULL? 
29LinkAct_13Tax to Pay tonvarchar150OACT Allow NULL? 
30LinkAct_14Tax Definitionnvarchar150OACT Allow NULL? 
31LinkAct_15Equipment and Assetsnvarchar150OACT Allow NULL? 
32LinkAct_16Withholding Taxnvarchar150OACT Allow NULL? 
33LinkAct_17Advances on Corp. Income Taxnvarchar150OACT Allow NULL? 
34LinkAct_18Opening Balance Accountnvarchar150OACT Allow NULL? 
35DfltIncomRevenue Accountnvarchar150OACT Allow NULL? 
36ExmptIncomTax Exempt Revenue Accountnvarchar150OACT Allow NULL? 
37DfltExpnExpense Accountnvarchar150OACT Allow NULL? 
38ForgnIncmRevenue Account - Foreignnvarchar150OACT Allow NULL? 
39ECIncomeSales Revenue - EUnvarchar150OACT Allow NULL? 
40ForgnExpnExpense Account - Foreignnvarchar150OACT Allow NULL? 
41DfltRateDiEx. Rate Diff. in All Currencynvarchar150OACT Allow NULL? 
42DecresGlAcG/L Decrease Accountnvarchar150OACT Allow NULL? 
43LinkAct_27Automatic Reconciliation Diff.nvarchar150OACT Allow NULL? 
44DftStockOBAccount for Opening Whse Bal.nvarchar150OACT Allow NULL? 
45LinkAct_19Cash Discountnvarchar150OACT Allow NULL? 
46LinkAct_20Cash Discount Clearingnvarchar150OACT Allow NULL? 
47LinkAct_21Realized Exchange Diff. Lossnvarchar150OACT Allow NULL? 
48LinkAct_22Cash Discountnvarchar150OACT Allow NULL? 
49LinkAct_23Realized Exchange Diff. Lossnvarchar150OACT Allow NULL? 
50LinkAct_24Rounding Accountnvarchar150OACT Allow NULL? 
51LinkAct_25Realized Exchange Diff. Gainnvarchar150OACT Allow NULL? 
52LinkAct_26Realized Exchange Diff. Gainnvarchar150OACT Allow NULL? 
53IncresGlAcG/L Increase Accountnvarchar150OACT Allow NULL? 
54RturnngActSales Returns Accountnvarchar150OACT Allow NULL? 
55COGM_ActCost of Goods Sold Accountnvarchar150OACT Allow NULL? 
56AlocCstActAllocation Accountnvarchar150OACT Allow NULL? 
57VariancActVariance Accountnvarchar150OACT Allow NULL? 
58PricDifActPrice Difference Accountnvarchar150OACT Allow NULL? 
59CDownPymntCustomer Down Payment Accountnvarchar150OACT Allow NULL? 
60VDownPymntVendor Down Payment Accountnvarchar150OACT Allow NULL? 
61CBoERcvbleBoE Accounts Receivablenvarchar150OACT Allow NULL? 
62CBoEOnClctBill of Exchange on Collectionnvarchar150OACT Allow NULL? 
63CBoEPresntBill of Exchange Presentationnvarchar150OACT Allow NULL? 
64CBoEDiscntBill of Exchange Discountednvarchar150OACT Allow NULL? 
65CUnpaidBoEUnpaid Bill of Exchangenvarchar150OACT Allow NULL? 
66VBoEPaybleBoE Accounts Payablenvarchar150OACT Allow NULL? 
67VAsstBoEPyBoE Accounts Payablenvarchar150OACT Allow NULL? 
68COpenDebtsCustomer Doubtful Debts Acctnvarchar150OACT Allow NULL? 
69VOpenDebtsVendor Doubtful Debts Accountnvarchar150OACT Allow NULL? 
70PurchseActPurchase Accountnvarchar150OACT Allow NULL? 
71PaReturnAcPurchase Return Accountnvarchar150OACT Allow NULL? 
72PaOffsetAcPurchase Offset Accountnvarchar150OACT Allow NULL? 
73LinkAct_28Period-End Closing Accountnvarchar150OACT Allow NULL? 
74ExDiffActExchange Rate Difference Acctnvarchar150OACT Allow NULL? 
75BalanceActGoods Clearing Accountnvarchar150OACT Allow NULL? 
76BnkChgActBank Charge Accountnvarchar150OACT Allow NULL? 
77LinkAct_29Other Receivablenvarchar150OACT Allow NULL? 
78LinkAct_30Other Payablenvarchar150OACT Allow NULL? 
79IncmAcctDef. Inv. Reval. Revenue Acctnvarchar150OACT Allow NULL? 
80ExpnAcctDef. Inventory Reval. Expensenvarchar150OACT Allow NULL? 
81VatRevActVAT in Revenue Accountnvarchar150OACT Allow NULL? 
82ExpClrActExpense Account for Taxnvarchar150OACT Allow NULL? 
83ExpOfstActExpense Offset Accountnvarchar150OACT Allow NULL? 
84CostRevActCOGS Revaluation Acctnvarchar150OACT Allow NULL? 
85RepomoActREPOMO Revaluation Accountnvarchar150OACT Allow NULL? 
86WipVarAcctWIP Inventory Variance Accountnvarchar150OACT Allow NULL? 
87SaleVatOffDown Payment Tax Offset Acctnvarchar150OACT Allow NULL? 
88PurcVatOffDown Payment Tax Offset Acctnvarchar150OACT Allow NULL? 
89DpmSalActPayment Advancesnvarchar150OACT Allow NULL? 
90DpmPurActPayment Advancesnvarchar150OACT Allow NULL? 
91ExpVarActExpense and Inventory Accountnvarchar150OACT Allow NULL? 
92CostOffActCost of Sale Rev. Offset Acctnvarchar150OACT Allow NULL? 
93ECExepnsesExpense Account - EUnvarchar150OACT Allow NULL? 
94StockActInventory Accountnvarchar150OACT Allow NULL? 
95DflInPrcssDefault for Stk Itm in Processnvarchar150OACT Allow NULL? 
96DfltInCstmDefault for Stock Item in Custnvarchar150OACT Allow NULL? 
97DfltProfitInventory Offset - Incr. Acctnvarchar150OACT Allow NULL? 
98DfltLossInventory Offset - Decr. Acctnvarchar150OACT Allow NULL? 
99VAssetsVendor Asset Accountnvarchar150OACT Allow NULL? 
100StockRvActInventory Revaluation Accountnvarchar150OACT Allow NULL? 
101StkRvOfActInvent Revaluation Offset Acctnvarchar150OACT Allow NULL? 
102WipAcctWIP Inventory Accountnvarchar150OACT Allow NULL? 
103DfltCardInvoice and Payment BPnvarchar150OCRD Allow NULL? 
104ShpdGdsActShipped Goods Accountnvarchar150OACT Allow NULL? 
105GlRvOffActG/L Revaluation Offset Accountnvarchar150OACT Allow NULL? 
106OverpayAPOverpayment A/P Accountnvarchar150OACT Allow NULL? 
107UndrpayAPUnderpayment A/P Accountnvarchar150OACT Allow NULL? 
108OverpayAROverpayment A/R Accountnvarchar150OACT Allow NULL? 
109UndrpayARUnderpayment A/R Accountnvarchar150OACT Allow NULL? 
110ARCMActSales Credit Accountnvarchar150OACT Allow NULL? 
111ARCMExpActTax Exempt Credit Accountnvarchar150OACT Allow NULL? 
112ARCMFrnActSales Credit Account - Foreignnvarchar150OACT Allow NULL? 
113ARCMEUActSales Credit Acct - EUnvarchar150OACT Allow NULL? 
114APCMActPurchase Credit Accountnvarchar150OACT Allow NULL? 
115APCMFrnActPurchase Credit Acct - Foreignnvarchar150OACT Allow NULL? 
116APCMEUActPurchase Credit Account - EUnvarchar150OACT Allow NULL? 
117NegStckActNegative Inventory Adj. Acctnvarchar150OACT Allow NULL? 
118StkInTnActStock In Transit Acctnvarchar150OACT Allow NULL? 
119GLGainXdifRealized Exchange Diff. Gainnvarchar150OACT Allow NULL? 
120GLLossXdifRealized Exchange Diff. Lossnvarchar150OACT Allow NULL? 
121AmountDiffAmount Differencesnvarchar150OACT Allow NULL? 
122SlfInvIncmSelf Invoice Revenue Accountnvarchar150OACT Allow NULL? 
123SlfInvExpnSelf Invoice Expense Accountnvarchar150OACT Allow NULL? 
124OnHoldActCapital Goods On Hold Accountnvarchar150OACT Allow NULL? 
125PlaActPLAnvarchar150OACT Allow NULL? 
126ICClrActIncoming CENVAT Clearing Acctnvarchar150OACT Allow NULL? 
127OCClrActOutgoing CENVAT Clearing Acctnvarchar150OACT Allow NULL? 
128PurBalActPurchase Balance Accountnvarchar150OACT Allow NULL? 
129WhICenActIncoming CENVAT Account (WH)nvarchar150OACT Allow NULL? 
130WhOCenActOutgoing CENVAT Account (WH)nvarchar150OACT Allow NULL? 
131SalDpmIntA/R DP Interimnvarchar150OACT Allow NULL? 
132PurDpmIntA/P DP Interimnvarchar150OACT Allow NULL? 
133ExrateOnDtEx Rate on Def Tax Accountnvarchar150OACT Allow NULL? 
134UserSign2Updating Userint60OUSR Allow NULL? 
135EURecvActEU Accounts Receivablenvarchar150OACT Allow NULL? 
136EUPayActEU Accounts Payablenvarchar150OACT Allow NULL? 
137WipOffsetWIP Offset P&L Accountnvarchar150OACT Allow NULL? 
138StockOffstInventory Offset P&L Accountnvarchar150OACT Allow NULL? 
139DunIntrstDunning Interestnvarchar150OACT Allow NULL? 
140DunFeeDunning Feenvarchar150OACT Allow NULL? 
141SnapShotIdSnapshot IDint1100 Allow NULL? 
142TDSInterstTDS Interest Acctnvarchar150OACT Allow NULL? 
143TDSChargesTDS Other Charges Acctnvarchar150OACT Allow NULL? 
NamePrimaryUniqueTypeColumns
PRIMARYNoYesAbsEntry, LogInstanc