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
2OCRD332Business Partner
3OINV386A/R Invoice
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
4OPCH268A/P Invoice
5OVPM154Outgoing Payments
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
Finance
ProductVersionTableColumnsIndexesDescriptionModule
1Business One8.82AACT1081G/L Account - HistoryFinance
SQL:  selectupdate insert create

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

SELECT AcctCode, AcctName, CurrTotal, EndTotal, Finanse, Groups, Budget, Frozen, Free_2, Postable, Fixed, Levels, ExportCode, GrpLine, FatherNum, AccntntCod, CashBox, GroupMask, RateTrans, TaxIncome, ExmIncome, ExtrMatch, IntrMatch, ActType, Transfered, BlncTrnsfr, OverType, OverCode, SysMatch, PrevYear, ActCurr, RateDifAct, SysTotal, FcTotal, Protected, RealAcct, Advance, CreateDate, UpdateDate, FrgnName, Details, ExtraSum, Project, RevalMatch, DataSource, LocMth, MTHCounter, BNKCounter, UserSign, LocManTran, LogInstanc, ObjType, ValidFor, ValidFrom, ValidTo, ValidComm, FrozenFor, FrozenFrom, FrozenTo, FrozenComm, Counter, Segment_0, Segment_1, Segment_2, Segment_3, Segment_4, Segment_5, Segment_6, Segment_7, Segment_8, Segment_9, FormatCode, CfwRlvnt, ExchRate, RevalAcct, LastRevBal, LastRevDat, DfltVat, VatChange, Category, TransCode, OverCode5, OverCode2, OverCode3, OverCode4, DfltTax, TaxPostAcc, AcctStrLe, MeaUnit, BalDirect, UserSign2, PlngLevel, MultiLink, PrjRelvnt, Dim1Relvnt, Dim2Relvnt, Dim3Relvnt, Dim4Relvnt, Dim5Relvnt, AccrualTyp, DatevAcct, DatevAutoA, DatevFirst, SnapShotId, PCN874Rpt, BPLId, BPLName, VATRegNum FROM AACT
ColumnFieldDescriptionSQL TypeLengthDecimalsRelationDefault ValueConstraintsSQL Create Statement
1AcctCodeAccount Codenvarchar150 Allow NULL? 
2AcctNameAccount Namenvarchar1000 Allow NULL? 
3CurrTotalCurrent Balancenum196 Allow NULL? 
4EndTotalOpening Balancenum196 Allow NULL? 
5FinanseCash Account [Y/N]char10NY, N Allow NULL? 
6GroupsMain Groupnvarchar80 Allow NULL? 
7BudgetBudgetchar10NY, N Allow NULL? 
8FrozenAccount on Hold [Y/N]char10NY, N Allow NULL? 
9Free_2Free2char10 Allow NULL? 
10PostableAccount Type [Active/Title]char10YY, N Allow NULL? 
11FixedPrimary Accountchar10 Allow NULL? 
12LevelsAccount Levelint602 Allow NULL? 
13ExportCodeData Export Codenvarchar100 Allow NULL? 
14GrpLineAccount Location in Groupint110 Allow NULL? 
15FatherNumParent Account Keynvarchar150 Allow NULL? 
16AccntntCodExternal Codenvarchar120 Allow NULL? 
17CashBoxPrimary Account [Y/N]char10NY, N Allow NULL? 
18GroupMaskGroup Maskint601 Allow NULL? 
19RateTransConversion Differenceschar10YY, N Allow NULL? 
20TaxIncomeTax Definitionchar10NY, N Allow NULL? 
21ExmIncomeTax Definitionchar10NY, N Allow NULL? 
22ExtrMatchExternal Reconciliation No.int110 Allow NULL? 
23IntrMatchInternal Reconciliation No.int110 Allow NULL? 
24ActTypeAccount Categorychar10NI, E, N Allow NULL? 
25TransferedYear Transferred [Y/N]char10NY, N Allow NULL? 
26BlncTrnsfrBalances Transferred [Y/N]char10NY, N Allow NULL? 
27OverTypeDistribution Rulechar10NN, Y Allow NULL? 
28OverCodeDistribution Rule Codenvarchar80OOCR Allow NULL? 
29SysMatchSystem Reconciliation No.int110-1 Allow NULL? 
30PrevYearTransferred from Prev. Yearchar10NY, N Allow NULL? 
31ActCurrAccount Currencynvarchar30 Allow NULL? 
32RateDifActRate Differences Acctnvarchar150 Allow NULL? 
33SysTotalBalance (SC)num196 Allow NULL? 
34FcTotalBalance (Account Currency)num196 Allow NULL? 
35ProtectedProtected Account [Y/N]char10NY, N Allow NULL? 
36RealAcctIndexed Account [Y/N]char10NY, N Allow NULL? 
37AdvanceLiable for Advanceschar10YY, N Allow NULL? 
38CreateDateCreation Datedate80
39UpdateDateDate of Updatedate80
40FrgnNameForeign Namenvarchar1000 Allow NULL? 
41DetailsDetails - Historynvarchar2540 Allow NULL? 
42ExtraSumAdditional Amountnum196 Allow NULL? 
43ProjectProject Codenvarchar200OPRJ Allow NULL? 
44RevalMatchRevaluation Coordinated [Yes/No]char10NY, N Allow NULL? 
45DataSourceData Sourcechar10NN, I, U, M, O, A, D, P, T Allow NULL? 
46LocMthReconciliation in LCchar10YY, N Allow NULL? 
47MTHCounterMTH Counterint110 Allow NULL? 
48BNKCounterBNK Counterint110 Allow NULL? 
49UserSignUser Signatureint60OUSR Allow NULL? 
50LocManTranLock Manual Transactionchar10NY, N Allow NULL? 
51LogInstancLog Instanceint600 Allow NULL? 
52ObjTypeObject Typenvarchar200 Allow NULL? 
53ValidForActivechar10NY, N Allow NULL? 
54ValidFromActive Fromdate80
55ValidToActive Todate80
56ValidCommActive Remarksnvarchar300 Allow NULL? 
57FrozenForInactivechar10NY, N Allow NULL? 
58FrozenFromInactive Fromdate80
59FrozenToInactive Todate80
60FrozenCommInactive Remarksnvarchar300 Allow NULL? 
61CounterBP Bank Accountint1100 Allow NULL? 
62Segment_0Segment 0nvarchar200 Allow NULL? 
63Segment_1Segment 1nvarchar200 Allow NULL? 
64Segment_2Segment 2nvarchar200 Allow NULL? 
65Segment_3Segment 3nvarchar200 Allow NULL? 
66Segment_4Segment 4nvarchar200 Allow NULL? 
67Segment_5Segment 5nvarchar200 Allow NULL? 
68Segment_6Segment 6nvarchar200 Allow NULL? 
69Segment_7Segment 7nvarchar200 Allow NULL? 
70Segment_8Segment 8nvarchar200 Allow NULL? 
71Segment_9Segment 9nvarchar200 Allow NULL? 
72FormatCodeFormat Codenvarchar2100 Allow NULL? 
73CfwRlvntCash Flow Relevant [Y/N]char10NY, N Allow NULL? 
74ExchRateExchange Rate Differenceschar10YY, N Allow NULL? 
75RevalAcctRevaluation Accountnvarchar150 Allow NULL? 
76LastRevBalLast Revaluation Balancenum196 Allow NULL? 
77LastRevDatLast Revaluation Datedate80
78DfltVatDefault VAT Groupnvarchar80OVTG Allow NULL? 
79VatChangeAllow Change VAT Groupchar10YY, N Allow NULL? 
80CategoryCategoryint110OACG Allow NULL? 
81TransCodeTransaction Codenvarchar40OTRC Allow NULL? 
82OverCode5Loading Factor Code 5nvarchar80OOCR Allow NULL? 
83OverCode2Loading Factor Code 2nvarchar80OOCR Allow NULL? 
84OverCode3Loading Factor Code 3nvarchar80OOCR Allow NULL? 
85OverCode4Loading Factor Code 4nvarchar80OOCR Allow NULL? 
86DfltTaxDefault Tax Codenvarchar80OSTC Allow NULL? 
87TaxPostAccDefault Tax Posting Accountchar10NN, R, P Allow NULL? 
88AcctStrLeAccount Structure Levelnvarchar20 Allow NULL? 
89MeaUnitMeasurement Unitnvarchar100 Allow NULL? 
90BalDirectDirection of Balancenvarchar4000, 1, 2 Allow NULL? 
91UserSign2Updating Userint60OUSR Allow NULL? 
92PlngLevelB1i Info for Integrationnvarchar20 Allow NULL? 
93MultiLinkAllow Multiple Linkingchar10NN, Y Allow NULL? 
94PrjRelvntProject Relevantchar10NY, N Allow NULL? 
95Dim1RelvntDimension 1 Relevantchar10NY, N Allow NULL? 
96Dim2RelvntDimension 2 Relevantchar10NY, N Allow NULL? 
97Dim3RelvntDimension 3 Relevantchar10NY, N Allow NULL? 
98Dim4RelvntDimension 4 Relevantchar10NY, N Allow NULL? 
99Dim5RelvntDimension 5 Relevantchar10NY, N Allow NULL? 
100AccrualTypAccrual Typechar10NN, P, C, I Allow NULL? 
101DatevAcctDATEV Accountint110 Allow NULL? 
102DatevAutoADATEV Automatic Accountchar10NY, N Allow NULL? 
103DatevFirstFirst Data Entrychar10YY, N Allow NULL? 
104SnapShotIdSnapshot IDint1100 Allow NULL? 
105PCN874RptPCN 874 Report Relevantchar10NY, N Allow NULL? 
106BPLIdAssigned Branchint110OBPL Allow NULL? 
107BPLNameBranch Namenvarchar1000 Allow NULL? 
108VATRegNumVAT Reg. Numbernvarchar320 Allow NULL? 
NamePrimaryUniqueTypeColumns
PRIMARYNoYesAcctCode, LogInstanc