SAP Tables - SAP Business One/ERP Table Definition reference

 Module:  Table: 

icon of database logic symbol SAP  TABLESv1Made in Britain - the webs number one JD Edwards Table Definition reference

ERP 6.0: Top 10 requests

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

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

2ORCT154Incoming Payment
3OINV268A/R Invoice
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction
1Business One9.3OACT1236G/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, SCAdjust, BPLId, BPLName, SubLedgerN, VATRegNum, ActId, ClosingAcc, PurpCode, RefCode, BlocManPos, PriAccCode, CstAccOnly, AlloweFrom, AllowedTo, BalanceA, RmrkTmpt, CemRelvnt, CemCode FROM OACT


ColumnFieldDescriptionSQL TypeLengthDecimalsRelationDefault ValueConstraintsSQL Create Statement
1AcctCodeAccount Codenvarchar150 Allow NULL? 
2AcctNameAccount Namenvarchar1000 Allow NULL? 
3CurrTotalCurrent Balancenum196 Allow NULL? 
4EndTotalOpening Balancenum196 Allow NULL? 
5FinanseCash Accountchar10NN=No, Y=Yes Allow NULL? 
6GroupsMain Groupnvarchar80 Allow NULL? 
7BudgetBudgetchar10NN=No, Y=Yes Allow NULL? 
8FrozenAccount on Hold [Y/N]char10NN=No, Y=Yes Allow NULL? 
9Free_2Free 2char10 Allow NULL? 
10PostableAccount [Active/Title]char10YN=Title Account, Y=Active Account 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 Codenvarchar150 Allow NULL? 
17CashBoxCapital Account [Y/N]char10NN=No, Y=Yes Allow NULL? 
18GroupMaskGroup Maskint601 Allow NULL? 
19RateTransFor Conversion Differenceschar10YN=No, Y=Yes Allow NULL? 
20TaxIncomeTax Definitionchar10NN=No, Y=Yes Allow NULL? 
21ExmIncomeTax Definitionchar10NN=No, Y=Yes Allow NULL? 
22ExtrMatchExternal Reconciliation No.int110 Allow NULL? 
23IntrMatchInternal Reconciliation No.int110 Allow NULL? 
24ActTypeAccount Typechar10NE=Expenditure, I=Sales, N=Other Allow NULL? 
25TransferedYear Transfer [Y/N]char10NN=No, Y=Yes Allow NULL? 
26BlncTrnsfrBalances Transferred [Y/N]char10NN=No, Y=Yes Allow NULL? 
27OverTypeLoading Typechar10NN=None, Y=Yes Allow NULL? 
28OverCodeLoading Factor Codenvarchar80OOCR Allow NULL? 
29SysMatchSystem Reconciliation No.int110-1 Allow NULL? 
30PrevYearThere are accounts from the previous yearchar10NN=No, Y=Yes Allow NULL? 
31ActCurrAccount Currencynvarchar30OCRN Allow NULL? 
32RateDifActRate Differences Accountnvarchar150 Allow NULL? 
33SysTotalBalance in System Currencynum196 Allow NULL? 
34FcTotalBalance in Account Currencynum196 Allow NULL? 
35ProtectedConfidential Accountchar10NN=No, Y=Yes Allow NULL? 
36RealAcctIndexed Accountchar10NN=No, Y=Yes Allow NULL? 
37AdvanceAdvance Paymentschar10YN=No, Y=Yes Allow NULL? 
38CreateDateCreation Datedate80
39UpdateDateDate of Updatedate80
40FrgnNameForeign Namenvarchar1000 Allow NULL? 
41DetailsDetailsnvarchar2540 Allow NULL? 
42ExtraSumAdditional Amountnum196 Allow NULL? 
43ProjectProject Codenvarchar200OPRJ Allow NULL? 
44RevalMatchRevaluation Coordinatedchar10NN=No, Y=Yes Allow NULL? 
45DataSourceData Sourcechar10NA=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Update Allow NULL? 
46LocMthLC Reconciliationchar10YN=No, Y=Yes Allow NULL? 
47MTHCounterMTH Counterint110 Allow NULL? 
48BNKCounterBNK Counterint110 Allow NULL? 
49UserSignUser Signatureint60OUSR Allow NULL? 
50LocManTranControl Accountchar10NN=No, Y=Yes Allow NULL? 
51LogInstancLog Instanceint1100 Allow NULL? 
52ObjTypeObject Typenvarchar200ADP11 Allow NULL? 
53ValidForActivechar10NN=No, Y=Yes Allow NULL? 
54ValidFromActive Fromdate80
55ValidToActive Todate80
56ValidCommActive Remarksnvarchar300 Allow NULL? 
57FrozenForInactivechar10NN=No, Y=Yes 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=No, Y=Yes Allow NULL? 
74ExchRateExchange Rate Differenceschar10YN=No, Y=Yes Allow NULL? 
75RevalAcctRevaluation Accountnvarchar150 Allow NULL? 
76LastRevBalLast Revaluation Balancenum196 Allow NULL? 
77LastRevDatLast Revaluation Datedate80
78DfltVatDefault VAT Groupnvarchar80OVTG Allow NULL? 
79VatChangeAllow Change VAT Groupchar10YN=No, Y=Yes 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=Purchasing Tax Account, R=Sales Tax Account Allow NULL? 
88AcctStrLeAccount Structure Levelnvarchar20 Allow NULL? 
89MeaUnitMeasurement Unitnvarchar100 Allow NULL? 
90BalDirectDirection of Balancenvarchar4000, 1=Credit, 2=Debit Allow NULL? 
91UserSign2Updating Userint60OUSR Allow NULL? 
92PlngLevelB1i Info for Integrationnvarchar20 Allow NULL? 
93MultiLinkAllow Multiple Linkingchar10NN=No, Y=Yes Allow NULL? 
94PrjRelvntProject Relevantchar10NN=No, Y=Yes Allow NULL? 
95Dim1RelvntDimension 1 Relevantchar10NN=No, Y=Yes Allow NULL? 
96Dim2RelvntDimension 2 Relevantchar10NN=No, Y=Yes Allow NULL? 
97Dim3RelvntDimension 3 Relevantchar10NN=No, Y=Yes Allow NULL? 
98Dim4RelvntDimension 4 Relevantchar10NN=No, Y=Yes Allow NULL? 
99Dim5RelvntDimension 5 Relevantchar10NN=No, Y=Yes Allow NULL? 
100AccrualTypAccrual Typechar10NC=Calculation Account, I=Calculation Interim Account, N=None, P=Posting Account Allow NULL? 
101DatevAcctDATEV Accountnvarchar80 Allow NULL? 
102DatevAutoADATEV Automatic Accountchar10NN=No, Y=Yes Allow NULL? 
103DatevFirstFirst Data Entrychar10YN=No, Y=Yes Allow NULL? 
104SnapShotIdSnapshot IDint1100 Allow NULL? 
105PCN874RptPCN 874 Report Relevantchar10NN=No, Y=Yes Allow NULL? 
106SCAdjustSC Adjustmentchar10NN=No, Y=Yes Allow NULL? 
107BPLIdAssigned Branchint110OBPL Allow NULL? 
108BPLNameBranch Namenvarchar1000 Allow NULL? 
109SubLedgerNSubledger No.nvarchar600 Allow NULL? 
110VATRegNumVAT Reg. Numbernvarchar320 Allow NULL? 
111ActIdAccount Identifiernvarchar2100 Allow NULL? 
112ClosingAccG/L Account Closingnvarchar150 Allow NULL? 
113PurpCodeAccount Purpose Codenvarchar2001=Contas de ativo, 02=Contas de Passivo, 03=Patrimônio Líquido, 04=Contas de Resultado, 05=Contas de Compensação, 09=Outras Allow NULL? 
114RefCodeReferential Account Codenvarchar300 Allow NULL? 
115BlocManPosBlock Manual Postingchar10NN=No, Y=Yes Allow NULL? 
116PriAccCodePrimary Closing Accountnvarchar150OACT Allow NULL? 
117CstAccOnlyCost Account Onlychar10NN=NO, Y=YES Allow NULL? 
118AlloweFromAccount Balance Allowed Fromnum196 Allow NULL? 
119AllowedToAccount Balance Allowed Tonum196 Allow NULL? 
120BalanceAAccount Balance Allowedchar10NN=NO, Y=YES Allow NULL? 
121RmrkTmptRemark Text Templateint110OTTR Allow NULL? 
122CemRelvntCost Element Relevantchar10NN=No, Y=Yes Allow NULL? 
123CemCodeCost Element Codenvarchar200OCEM Allow NULL?