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.82OACT1085G/L AccountsFinance
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 OACT
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]char10NN, Y Allow NULL? 
6GroupsMain Groupnvarchar80 Allow NULL? 
7BudgetBudgetchar10NN, Y Allow NULL? 
8FrozenAccount on Hold [Y/N]char10NN, Y Allow NULL? 
9Free_2Free 2char10 Allow NULL? 
10PostableAccount [Active/Title]char10YN, Y Allow NULL? 
11FixedMain Accountchar10 Allow NULL? 
12LevelsAccount Levelint602 Allow NULL? 
13ExportCodeData Export Codenvarchar100 Allow NULL? 
14GrpLineSerial No. in Groupint110 Allow NULL? 
15FatherNumParent Account Keynvarchar150 Allow NULL? 
16AccntntCodExternal Codenvarchar120 Allow NULL? 
17CashBoxCapital Account [Y/N]char10NN, Y Allow NULL? 
18GroupMaskGroup Maskint601 Allow NULL? 
19RateTransFor Conversion Differenceschar10YN, Y Allow NULL? 
20TaxIncomeTax Definitionchar10NN, Y Allow NULL? 
21ExmIncomeTax Definitionchar10NN, Y Allow NULL? 
22ExtrMatchExternal Reconciliation No.int110 Allow NULL? 
23IntrMatchInternal Reconciliation No.int110 Allow NULL? 
24ActTypeAccount Categorychar10NE, I, N Allow NULL? 
25TransferedYear Transfer [Y/N]char10NN, Y Allow NULL? 
26BlncTrnsfrBalances Transferred [Y/N]char10NN, Y Allow NULL? 
27OverTypeLoading Typechar10NN, Y Allow NULL? 
28OverCodeLoading Factor Codenvarchar80OOCR Allow NULL? 
29SysMatchSystem Reconciliation No.int110-1 Allow NULL? 
30PrevYearThere are accounts from the previous yearchar10NN, Y Allow NULL? 
31ActCurrAccount Currencynvarchar30 Allow NULL? 
32RateDifActRate Differences Accountnvarchar150 Allow NULL? 
33SysTotalBalance in System Currencynum196 Allow NULL? 
34FcTotalBalance in Account Currencynum196 Allow NULL? 
35ProtectedProtected Account [Y/N]char10NN, Y Allow NULL? 
36RealAcctReconciled Account [Y/N]char10NN, Y Allow NULL? 
37AdvanceLiable for Advanceschar10YN, Y Allow NULL? 
38CreateDateCreation Datedate80
39UpdateDateDate of Updatedate80
40FrgnNameForeign Namenvarchar1000 Allow NULL? 
41DetailsDetailsnvarchar2540 Allow NULL? 
42ExtraSumAdditional Amountnum196 Allow NULL? 
43ProjectProject Codenvarchar200OPRJ Allow NULL? 
44RevalMatchRevaluation Coordinated [Yes/No]char10NN, Y Allow NULL? 
45DataSourceData Sourcechar10NA, D, I, M, N, O, P, T, U Allow NULL? 
46LocMthLC Reconciliationchar10YN, Y Allow NULL? 
47MTHCounterMTH Counterint110 Allow NULL? 
48BNKCounterBNK Counterint110 Allow NULL? 
49UserSignUser Signatureint60OUSR Allow NULL? 
50LocManTranLock Manual Transactionchar10NN, Y Allow NULL? 
51LogInstancLog Instanceint600 Allow NULL? 
52ObjTypeObject Typenvarchar2001 Allow NULL? 
53ValidForActivechar10NN, Y Allow NULL? 
54ValidFromActive Fromdate80
55ValidToActive Todate80
56ValidCommActive Remarksnvarchar300 Allow NULL? 
57FrozenForInactivechar10NN, Y Allow NULL? 
58FrozenFromInactive Fromdate80
59FrozenToInactive Todate80
60FrozenCommInactive Remarksnvarchar300 Allow NULL? 
61CounterCounterint1100 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]char10NN, Y Allow NULL? 
74ExchRateExchange Rate Differenceschar10YN, Y Allow NULL? 
75RevalAcctRevaluation Accountnvarchar150 Allow NULL? 
76LastRevBalLast Revaluation Balancenum196 Allow NULL? 
77LastRevDatLast Revaluation Datedate80
78DfltVatDefault VAT Groupnvarchar80OVTG Allow NULL? 
79VatChangeAllow Change VAT Groupchar10YN, Y 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, P, R 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 Relevantchar10NN, Y Allow NULL? 
95Dim1RelvntDimension 1 Relevantchar10NN, Y Allow NULL? 
96Dim2RelvntDimension 2 Relevantchar10NN, Y Allow NULL? 
97Dim3RelvntDimension 3 Relevantchar10NN, Y Allow NULL? 
98Dim4RelvntDimension 4 Relevantchar10NN, Y Allow NULL? 
99Dim5RelvntDimension 5 Relevantchar10NN, Y Allow NULL? 
100AccrualTypAccrual Typechar10NC, I, N, P Allow NULL? 
101DatevAcctDATEV Accountint110 Allow NULL? 
102DatevAutoADATEV Automatic Accountchar10NN, Y Allow NULL? 
103DatevFirstFirst Data Entrychar10YN, Y Allow NULL? 
104SnapShotIdSnapshot IDint1100 Allow NULL? 
105PCN874RptPCN 874 Report Relevantchar10NN, Y Allow NULL? 
106BPLIdAssigned Branchint110OBPL Allow NULL? 
107BPLNameBranch Namenvarchar1000 Allow NULL? 
108VATRegNumVAT Reg. Numbernvarchar320 Allow NULL? 
NamePrimaryUniqueTypeColumns
PRIMARYNoYesAcctCode
INTER_KEYNoNoFatherNum
CURRENCYNoNoActCurr
FORMATNoNoFormatCode
COUNTERNoNoCounter