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
7/OPT/Z1344Reporting table: Text table for exception definitions
8FCO_DOC_HEAD61Failure Cost Document Header
9FMIA65Actual Line Item Table for Funds Management
10PEG_TMTNS2Pegging: Movement Types Explicitly Not Supported

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
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
3OVPM154Outgoing Payments
4OIVL77Whse Journal
5ORCT154Incoming Payment
6OPCH268A/P Invoice
7OOCR9Loading Factors
8OSRN20Serial Numbers Master Data
9JDT1110Journal Entry - Rows
10OBOT10Bill Of Exchang Transaction
PHPRef.com - the webs number one PHP Function reference tool
Reports
ProductVersionTableColumnsIndexesDescriptionModule
1Business One8.82OFLT1861Report - Selection CriteriaReports
SQL:  selectupdate insert create

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

SELECT FormNum, QueryStr, ItmOrCrd, CardInclud, CardFrom1, CardTo1, CardExclud, CardFrom2, CardTo2, ClienGroup, VendGroup, ClntQryGrp, VeQryGroup, ItmInclud, ItmFrom1, ItmTo1, ItmExclud, ItmFrom2, ItmTo2, ItmGroup, ItQryGroup, WhsInclude, WhsFrom1, WhsTo1, WhsExclude, WhsFrom2, WhsTo2, FromAcct, ToAcct, GroupMask, FromDate, ToDate, FrmDueDate, ToDueDate, FromDate3, ToDate3, FromDate4, ToDate4, SourceType, FrmTrnsNum, ToTrnsNum, FromRef1, ToRef1, FromRef2, ToRef2, FrmTrnsCod, ToTrnsCod, FromSum, ToSum, FrmFRNAmnt, ToFRNAmnt, MemoIn, SortField1, Break1, SortField2, Break2, SortField3, Break3, Display, PrntCutDat, CheckBox0, CheckBox1, CheckBox2, CheckBox3, CheckBox4, CheckBox5, CheckBox6, CheckBox7, CheckBox8, CheckBox9, ShowZero, DateCheck, DueCheck, CutCheck, CutByObj, ObjectC1, ObjectC2, ObjectC3, ObjectC4, ObjectC5, ObjectC6, ObjectC7, ObjectC8, ObjectC9, ObjectC10, ObjectC11, ObjectC12, ObjectC13, ObjectC14, ObjectC15, ObjectC16, FromAmount, ToAmount, FrmSalsMan, ToSalsMan, USER_CHK1, USER_CHK2, USER_CHK3, USER_CHK4, USER_CHK5, UseSort, Sort1Up, Sort2Up, Sort3Up, FromAmnt2, ToAmount2, TaxDateFro, TaxDateTo, FinancYear, BdgtScenar, CompFolder, CheckBox10, FROM_FC, TO_FC, FCCurrency, TaxCheck, DateType, DateType2, FromPrject, ToProject, TemplateId, ShowLeads, MthDate, AccntntCod, UserSign, BlcNunFrom, BlcNunTo, ImpLogFrom, ImpLogTo, FolderNum, MainField, TransMode, MonthMode, CheckBox11, FromIdc, ToIdc, IgnoreAdj, RefNumFrom, RefNumTo, PymNumfrom, PymNumTo, BankFrom, BankTo, DpstFrom, DpstTo, DpstType, ObjectC17, ObjectC18, ObjectC19, ObjAbs, AddBTF, FilePath, DpsBnkActF, DpsBnkActT, FromKey, ToKey, ObjectC20, ObjectC21, ObjectC22, ObjectC23, ObjectC25, USER_CHK6, OcrChkDim2, OcrChkDim3, OcrChkDim4, OcrChkDim5, OcrFrom2, OcrFrom3, OcrFrom4, OcrFrom5, OcrTo2, OcrTo3, OcrTo4, OcrTo5, TaxAdjRep, ObjectC26, CBFilter, OBIncluded, OBFilter, ExportCurr, CBIncluded, SlpFrom, SlpTo, CBUDF, CBREF, CheckBoxB FROM OFLT
ColumnFieldDescriptionSQL TypeLengthDecimalsRelationDefault ValueConstraintsSQL Create Statement
1FormNumForm Numbernvarchar200 Allow NULL? 
2QueryStrQuerynvarchar2500 Allow NULL? 
3ItmOrCrdItems or BPchar10YN, Y Allow NULL? 
4CardIncludBP Areachar10YN, Y Allow NULL? 
5CardFrom1From BPnvarchar150OCRD Allow NULL? 
6CardTo1To BPnvarchar150OCRD Allow NULL? 
7CardExcludExcluding BPchar10NN, Y Allow NULL? 
8CardFrom2BP Rejectednvarchar150 Allow NULL? 
9CardTo2BP Rejectednvarchar150 Allow NULL? 
10ClienGroupCustomer Groupint60 Allow NULL? 
11VendGroupVendor Groupint60 Allow NULL? 
12ClntQryGrpCustomer Propertiesnvarchar2500 Allow NULL? 
13VeQryGroupVendor Propertiesnvarchar2500 Allow NULL? 
14ItmIncludItem Rangechar10YN, Y Allow NULL? 
15ItmFrom1From Itemnvarchar200OITM Allow NULL? 
16ItmTo1To Itemnvarchar200OITM Allow NULL? 
17ItmExcludExcluding Materialschar10NN, Y Allow NULL? 
18ItmFrom2Item Rejectednvarchar200OITM Allow NULL? 
19ItmTo2Item Rejectednvarchar200OITM Allow NULL? 
20ItmGroupItem Groupint60OITB Allow NULL? 
21ItQryGroupItem Propertiesnvarchar2500 Allow NULL? 
22WhsIncludeWarehouse Rangechar10YN, Y Allow NULL? 
23WhsFrom1From Warehousenvarchar80OWHS Allow NULL? 
24WhsTo1To Warehousenvarchar80OWHS Allow NULL? 
25WhsExcludeExcluding Warehouseschar10NN, Y Allow NULL? 
26WhsFrom2Warehouse Rejectednvarchar80 Allow NULL? 
27WhsTo2Warehouse Rejectednvarchar80 Allow NULL? 
28FromAcctFrom Accountnvarchar150 Allow NULL? 
29ToAcctTo Accountnvarchar150 Allow NULL? 
30GroupMaskGroup Masknvarchar120 Allow NULL? 
31FromDateFrom Posting Datedate80
32ToDateTo Posting Datedate80
33FrmDueDateDue Date Fromdate80
34ToDueDateDue Date Todate80
35FromDate3From Date 3date80
36ToDate3To Date 3date80
37FromDate4From Date 4date80
38ToDate4To Date 4date80
39SourceTypeOriginal Journalint60-1(-, -1, -2, -3, 13, 132, 14, 15, 16, 162, 163, 18, 19, 20, 203, 204, 21, 24, 25, 30, 46, 57, 58, 59, 60, 67, 68, 69, 76 Allow NULL? 
40FrmTrnsNumFrom Transaction No.int110 Allow NULL? 
41ToTrnsNumTo Transaction No.int110 Allow NULL? 
42FromRef1From Reference 1nvarchar1000 Allow NULL? 
43ToRef1To Reference 1nvarchar1000 Allow NULL? 
44FromRef2From Reference 2nvarchar1000 Allow NULL? 
45ToRef2To Reference 2nvarchar1000 Allow NULL? 
46FrmTrnsCodFrom Transaction Codenvarchar40 Allow NULL? 
47ToTrnsCodTo Transaction Codenvarchar40 Allow NULL? 
48FromSumFrom Amountnum196 Allow NULL? 
49ToSumTo Amountnum196 Allow NULL? 
50FrmFRNAmntFrom FC Amountnum196 Allow NULL? 
51ToFRNAmntTo FC Amountnum196 Allow NULL? 
52MemoInDetails Containednvarchar500 Allow NULL? 
53SortField1Sort Field 1int60-1 Allow NULL? 
54Break1Subtotal by Sort 1char10NN, Y Allow NULL? 
55SortField2Sort Field 2int60-1 Allow NULL? 
56Break2Subtotal by Sort 2char10NN, Y Allow NULL? 
57SortField3Sort Field 3int60-1 Allow NULL? 
58Break3Subtotal by Sort 3char10NN, Y Allow NULL? 
59DisplayDisplaychar10LB, L, T Allow NULL? 
60PrntCutDatPrint Date Selection Criteriachar10YN, Y Allow NULL? 
61CheckBox0Check box 0char10NN, Y Allow NULL? 
62CheckBox1Check box 1char10NN, Y Allow NULL? 
63CheckBox2Check box 2char10NN, Y Allow NULL? 
64CheckBox3Check box 3char10NN, Y Allow NULL? 
65CheckBox4Check box 4char10NN, Y Allow NULL? 
66CheckBox5Check box 5char10NN, Y Allow NULL? 
67CheckBox6Check box 6char10NN, Y Allow NULL? 
68CheckBox7Check box 7char10NN, Y Allow NULL? 
69CheckBox8Check box 8char10NN, Y Allow NULL? 
70CheckBox9Check box 9char10NN, Y Allow NULL? 
71ShowZeroDisplay Zero Balanceschar10NN, Y Allow NULL? 
72DateCheckConfirm Date Rangechar10NN, Y Allow NULL? 
73DueCheckConfirm Due Date Rangechar10NN, Y Allow NULL? 
74CutCheckConfirm Date Selectn Criteriachar10NN, Y Allow NULL? 
75CutByObjSelection Criteria by Objectchar10NN, Y Allow NULL? 
76ObjectC1C1char10NN, Y Allow NULL? 
77ObjectC2C2char10NN, Y Allow NULL? 
78ObjectC3C3char10NN, Y Allow NULL? 
79ObjectC4C4char10NN, Y Allow NULL? 
80ObjectC5C5char10NN, Y Allow NULL? 
81ObjectC6C6char10NN, Y Allow NULL? 
82ObjectC7C7char10NN, Y Allow NULL? 
83ObjectC8C8char10NN, Y Allow NULL? 
84ObjectC9C9char10NN, Y Allow NULL? 
85ObjectC10C10char10NN, Y Allow NULL? 
86ObjectC11C11char10NN, Y Allow NULL? 
87ObjectC12C12char10NN, Y Allow NULL? 
88ObjectC13C13char10NN, Y Allow NULL? 
89ObjectC14C14char10NN, Y Allow NULL? 
90ObjectC15C15char10NN, Y Allow NULL? 
91ObjectC16C16char10NN, Y Allow NULL? 
92FromAmountFrom Amountnum196 Allow NULL? 
93ToAmountTo Amountnum196 Allow NULL? 
94FrmSalsManFrom Sales Employeeint60 Allow NULL? 
95ToSalsManTo Sales Employeeint60 Allow NULL? 
96USER_CHK1User CheckBox 1char10NN, Y Allow NULL? 
97USER_CHK2User CheckBox 2char10NN, Y Allow NULL? 
98USER_CHK3User CheckBox 3char10NN, Y Allow NULL? 
99USER_CHK4System Currrencychar10NN, Y Allow NULL? 
100USER_CHK5System and Local Currencychar10NN, Y Allow NULL? 
101UseSortSortchar10NN, Y Allow NULL? 
102Sort1UpSort1char10YN, Y Allow NULL? 
103Sort2UpSort2char10YN, Y Allow NULL? 
104Sort3UpSort3char10YN, Y Allow NULL? 
105FromAmnt2From Quantity Releasenum196 Allow NULL? 
106ToAmount2For Quantity Releasenum196 Allow NULL? 
107TaxDateFroLower Limit for Tax Datadate80
108TaxDateToTop Limit for Document Datesdate80
109FinancYearStart of Fiscal Yeardate80
110BdgtScenarBudget Scenarioint110 Allow NULL? 
111CompFolderCompany Databasenvarchar1000 Allow NULL? 
112CheckBox10Exapan Check Box 1char10NN, Y Allow NULL? 
113FROM_FCForeign Currency fromnum196 Allow NULL? 
114TO_FCForeign Currency tonum196 Allow NULL? 
115FCCurrencyForeign Currencynvarchar30 Allow NULL? 
116TaxCheckConfirm Document Date Rangechar10NN, Y Allow NULL? 
117DateTypeSelection Criteria Typechar10RD, R, T Allow NULL? 
118DateType2Selection Criteria Typechar10RD, R, T Allow NULL? 
119FromPrjectFrom Projectnvarchar200OPRJ Allow NULL? 
120ToProjectTo Projectnvarchar200OPRJ Allow NULL? 
121TemplateIdTemplateint1100 Allow NULL? 
122ShowLeadsDisplay Leadschar10NN, Y Allow NULL? 
123MthDateReconciliation Datechar10NN, Y Allow NULL? 
124AccntntCodExternal Codechar10NN, Y Allow NULL? 
125UserSignUser Signatureint60OUSR Allow NULL? 
126BlcNunFromBlock Number Fromnvarchar1000 Allow NULL? 
127BlcNunToBlock Number Tonvarchar1000 Allow NULL? 
128ImpLogFromImport Log Fromnvarchar200 Allow NULL? 
129ImpLogToImport Log Tonvarchar200 Allow NULL? 
130FolderNumFolder Numberchar101 Allow NULL? 
131MainFieldMain Fieldint6023 Allow NULL? 
132TransModeTransaction Modechar10YN, Y Allow NULL? 
133MonthModeMonth Totals Modechar10NN, Y Allow NULL? 
134CheckBox11Expan Check Box 11char10NN, Y Allow NULL? 
135FromIdcIndicator Fromnvarchar20 Allow NULL? 
136ToIdcIndicator Tonvarchar20 Allow NULL? 
137IgnoreAdjIgnore Adjustmentschar10NN, Y Allow NULL? 
138RefNumFromFrom Reference No.nvarchar2540 Allow NULL? 
139RefNumToTo Reference No.nvarchar2540 Allow NULL? 
140PymNumfromPayment No. Fromint110 Allow NULL? 
141PymNumToTo Payment No.int110 Allow NULL? 
142BankFromFrom Bank Codenvarchar300 Allow NULL? 
143BankToTo Bank Codenvarchar300 Allow NULL? 
144DpstFromFrom Deposit Codeint110 Allow NULL? 
145DpstToTo Deposit Codeint110 Allow NULL? 
146DpstTypeDeposit Typechar10 Allow NULL? 
147ObjectC17Obj C17char10NN, Y Allow NULL? 
148ObjectC18Obj C18char10NN, Y Allow NULL? 
149ObjectC19Obj C19char10NN, Y Allow NULL? 
150ObjAbsDocument Internal Numberint110 Allow NULL? 
151AddBTFAdd Journal Voucherschar10NN, Y Allow NULL? 
152FilePathFile Pathtext160
153DpsBnkActFFrom Deposit Bank Accountnvarchar500 Allow NULL? 
154DpsBnkActTTo Deposit Bank Accountnvarchar500 Allow NULL? 
155FromKeyFrom Keyint110 Allow NULL? 
156ToKeyTo Keyint110 Allow NULL? 
157ObjectC20Object C20char10NN, Y Allow NULL? 
158ObjectC21Object C21char10NN, Y Allow NULL? 
159ObjectC22Object C22char10NN, Y Allow NULL? 
160ObjectC23Object C23char10NN, Y Allow NULL? 
161ObjectC25Object C25char10NN, Y Allow NULL? 
162USER_CHK6Include CB in P/L Accountschar10NN, Y Allow NULL? 
163OcrChkDim2Checkbox for Dimension 2char10NN, Y Allow NULL? 
164OcrChkDim3Checkbox for Dimension 3char10NN, Y Allow NULL? 
165OcrChkDim4Checkbox for Dimension 4char10NN, Y Allow NULL? 
166OcrChkDim5Checkbox for Dimension 5char10NN, Y Allow NULL? 
167OcrFrom2From Costing Code 2nvarchar80OOCR Allow NULL? 
168OcrFrom3From Costing Code 3nvarchar80OOCR Allow NULL? 
169OcrFrom4From Costing Code 4nvarchar80OOCR Allow NULL? 
170OcrFrom5From Costing Code 5nvarchar80OOCR Allow NULL? 
171OcrTo2To Costing Code 2nvarchar80OOCR Allow NULL? 
172OcrTo3To Costing Code 3nvarchar80OOCR Allow NULL? 
173OcrTo4To Costing Code 4nvarchar80OOCR Allow NULL? 
174OcrTo5To Costing Code 5nvarchar80OOCR Allow NULL? 
175TaxAdjRepObject C24text160N, Y
176ObjectC26Object C26char10NN, Y Allow NULL? 
177CBFilterClosing Balances Filterchar1021, 2 Allow NULL? 
178OBIncludedAdd Opening Balance for Periodchar10NN, Y Allow NULL? 
179OBFilterOpening Balances Filterchar1011, 2 Allow NULL? 
180ExportCurrExport Currencychar10LL, S Allow NULL? 
181CBIncludedAdd Closing Balanceschar10NN, Y Allow NULL? 
182SlpFromSlp Fromnvarchar1550 Allow NULL? 
183SlpToSlp Tonvarchar1550 Allow NULL? 
184CBUDFUser-Defined Fieldschar10NN, Y Allow NULL? 
185CBREFReference Fieldschar10NN, Y Allow NULL? 
186CheckBoxBCheck Box B Branchchar10NN, Y Allow NULL? 
NamePrimaryUniqueTypeColumns
PRIMARYNoYesFormNum, UserSign