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
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
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
Administration
ProductVersionTableColumnsIndexesDescriptionModule
1Business One8.82AINF1941Company InfoAdministration
SQL:  selectupdate insert create

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

SELECT Version, CompnyName, Flags, InfoL1, InfoL2, InfoA1, InfoA2, ACTStamp, ADMStamp, RTTStamp, CINFStamp, LawsSet, EnblVatGrp, EnblVTGPmn, VatOOS_O, VatOOS_I, VatStnd_O, VatStnd_I, VatExmpt_O, VatExmpt_I, VatHalf_O, VatHalf_I, VatZrRt_O, VatZrRt_I, MaxActGrps, EnblDctSrc, EnblRCN, EnblCorINV, EnblCshRep, EnblIRTRep, EnblTrnRep, EnblVPMRep, EnblACTRep, EnblFTZ, EnblSlfPCH, EnblPCHUpd, EnblRsvINV, EnblRTDnld, RTTDnldAdr, ZPrcCode, EnblExpns, EnblRtrRep, IsEC, EnblCshDsc, EnblLostCD, NumActLvls, EnblRealRD, EnblVTGNoD, EnblGLManP, EnblOptVIP, EnblActCrC, EnblFrnAct, EnblECAct, EnblECRpt, EnblRound, EnblPrVatS, EnblYrTrns, EnblActTtl, EnblDocWrn, ActSegNum, EnbSgmnAct, SizeOfSeg0, SizeOfSeg1, SizeOfSeg2, SizeOfSeg3, SizeOfSeg4, SizeOfSeg5, SizeOfSeg6, SizeOfSeg7, SizeOfSeg8, SizeOfSeg9, Rprt1099, MultiAddss, EnbDunning, EnbQtyEDln, Itw1Date, Itw1Time, Itw1Count, EnbPayRef, EnblDfrTax, EnblClsPr, EnblTaxEL, EnableBOE, EnableWHT, EnblEquVat, EnblFAsset, EnblDoubt, RateBase, BOEStatClo, ARDocsInWT, BISBnkCnt, BISRBnkCd, BISRBnkAc, BISRBranch, EnblBPConn, EnblVATDat, EnblStAgRp, EnblCARepo, EnblMatRev, EnblMBPRec, CshDscGros, EnblTaxInv, EnblCorAct, EnblRuDIP, EnblCurDec, EnblPayMtd, EnblBaseUn, EnblVATAna, EnblExREnh, VATGrpCal, MaxChoose, EnblInfla, EnblLAWHT, EnblRTWHT, ChkQunty, SriMngSys, BtchMngSys, SriCreatIn, EnblFolio, EnblDocSbT, IepsPayer, DaysOrdCnc, EnblLATaxS, PercOfAcq, MinBaseDoc, EnblDpmJdt, EnblDownP, EnblNDdctC, DocNmMtd, DoFilter, EnblOnPDCh, EnblOnWnCr, EnblDefInx, EnblMxComm, EnblIndxOp, EnblSbtCVo, MinAmntOAP, CredSumm, PostdChk, PostdCred, CredVend, WkoStatus, DispTrByDf, stampTax, MinAmntAL, BlockZeroQ, AutoCrIns, EnbRepomo, RFCValidat, MxDcsInPmt, RelStkNoPr, CashDisc, EnableSMS, EnblIndic, EnbFedTax, EnblCounty, Language, ChkIntgUpd, ChkIntgCre, BisBnkAcKy, EnbZeroDec, EnbDecWord, ChkWrdOnly, EnBnkStmnt, CalcVatGrp, TaxSysType, ESEnabled, RateTotal, CompanyHis, EnblAssVal, CompanySta, eFRTActLvs, TaxGrpType, InstallNo, IsOldPA, EnbNegDoc, Algo, ArcComp, UpdatedTF, DARDBGUID, NegStoLv, SPNEnabled, PrsWkCntEb, DashbdEb, BoxEffDate, LogInstanc, UpdateDate, UserSign2, SnapShotId, CreatedBy, B1SgtEb, IsHConEnv, B1BuzzEb, IMCEEnable FROM AINF
ColumnFieldDescriptionSQL TypeLengthDecimalsRelationDefault ValueConstraintsSQL Create Statement
1VersionVersionint110 Allow NULL? 
2CompnyNameCompany Namenvarchar1000 Allow NULL? 
3FlagsFlagsnvarchar500NNNNNNNNNNNNNNNNNNNNNNNNNNNNNN Allow NULL? 
4InfoL1Info L1int110 Allow NULL? 
5InfoL2Info L2int110 Allow NULL? 
6InfoA1Info A1nvarchar1280 Allow NULL? 
7InfoA2Info A2nvarchar500 Allow NULL? 
8ACTStampACT Stampint1100 Allow NULL? 
9ADMStamp((int1100 Allow NULL? 
10RTTStampRTT Stampint1100 Allow NULL? 
11CINFStampCINF Stampint1100 Allow NULL? 
12LawsSetLaws Setnvarchar30 Allow NULL? 
13EnblVatGrpTax Systemchar10C, L, O Allow NULL? 
14EnblVTGPmnUse Tax Groups in Paymentschar10N, Y Allow NULL? 
15VatOOS_OTax Definitionnvarchar80 Allow NULL? 
16VatOOS_ITax Exempt Revenue Accountnvarchar80 Allow NULL? 
17VatStnd_OTax Standard Onvarchar80 Allow NULL? 
18VatStnd_ITax Standard Invarchar80 Allow NULL? 
19VatExmpt_OTax Exempt Onvarchar80 Allow NULL? 
20VatExmpt_ITax Exempt Invarchar80 Allow NULL? 
21VatHalf_OTax Definitionnvarchar80 Allow NULL? 
22VatHalf_ITax Definitionnvarchar80 Allow NULL? 
23VatZrRt_OTax Zero Rate Onvarchar80 Allow NULL? 
24VatZrRt_ITax Zero Rate Invarchar80 Allow NULL? 
25MaxActGrpsMax. No. of Account Groupsint110 Allow NULL? 
26EnblDctSrcEnable Deduction at Sourcechar10N, Y Allow NULL? 
27EnblRCNEnable Retail Chain Storeschar10N, Y Allow NULL? 
28EnblCorINVEnable Correction Invoicechar10N, Y Allow NULL? 
29EnblCshRepEnable Cash Reportchar10N, Y Allow NULL? 
30EnblIRTRepEnable Interest Reportchar10N, Y Allow NULL? 
31EnblTrnRepEnable Turnover Reportchar10N, Y Allow NULL? 
32EnblVPMRepEnable Payments Reportchar10N, Y Allow NULL? 
33EnblACTRepEnable Adv. Corp. Tax Reportchar10N, Y Allow NULL? 
34EnblFTZEnable Free Trade Zonechar10N, Y Allow NULL? 
35EnblSlfPCHEnable Self A/P Invoicechar10N, Y Allow NULL? 
36EnblPCHUpdEnable Purchase Trans. Updatechar10N, Y Allow NULL? 
37EnblRsvINVEnable Reserve Invoicechar10N, Y Allow NULL? 
38EnblRTDnldEnable Rates Downloadchar10N, Y Allow NULL? 
39RTTDnldAdrRates Download Web Addressnvarchar2540 Allow NULL? 
40ZPrcCodeZero Center Codenvarchar80 Allow NULL? 
41EnblExpnsEnable Freight Managementchar10N, Y Allow NULL? 
42EnblRtrRepEnable Returns Reportchar10N, Y Allow NULL? 
43IsECEuropean Countrieschar10N, Y Allow NULL? 
44EnblCshDscEnable Cash Discountschar10N, V, Y Allow NULL? 
45EnblLostCDEnable Lost Cash Discountchar10N, Y Allow NULL? 
46NumActLvlsNo. of Account Group Levelsint110 Allow NULL? 
47EnblRealRDEnable Realized Rate Diff.char10N, Y Allow NULL? 
48EnblVTGNoDEnable Tax on Down Paymentchar10YN, Y Allow NULL? 
49EnblGLManPEnable Manual Postings in Control Accountchar10N, Y Allow NULL? 
50EnblOptVIPEnable Optional Tax in Paymentschar10N, Y Allow NULL? 
51EnblActCrCEnable Account Currency Changechar10N, Y Allow NULL? 
52EnblFrnActEnable Foreign Item Accountchar10N, Y Allow NULL? 
53EnblECActEnable EU Item Accountchar10N, Y Allow NULL? 
54EnblECRptEnable 349 Reportchar10N, Y Allow NULL? 
55EnblRoundEnable Roundingchar10N, Y Allow NULL? 
56EnblPrVatSEnable Print Tax Amountchar10N, Y Allow NULL? 
57EnblYrTrnsEnable Year Transferchar10A, N, Y Allow NULL? 
58EnblActTtlEnable Account Titlechar10N, Y Allow NULL? 
59EnblDocWrnEnable No Base Doc. Alertchar10N, Y Allow NULL? 
60ActSegNumNo. of Segmentsint600 Allow NULL? 
61EnbSgmnActEnable Account Segmentationchar10N, Y Allow NULL? 
62SizeOfSeg0Size of Segment 0int600 Allow NULL? 
63SizeOfSeg1Size of Segment 1int600 Allow NULL? 
64SizeOfSeg2Size of Segment 2int600 Allow NULL? 
65SizeOfSeg3Size of Segment 3int600 Allow NULL? 
66SizeOfSeg4Size of Segment 4int600 Allow NULL? 
67SizeOfSeg5Size of Segment 5int600 Allow NULL? 
68SizeOfSeg6Size of Segment 6int600 Allow NULL? 
69SizeOfSeg7Size of Segment 7int600 Allow NULL? 
70SizeOfSeg8Size of Segment 8int600 Allow NULL? 
71SizeOfSeg9Size of Segment 9int600 Allow NULL? 
72Rprt10991099 Reportchar10N, Y Allow NULL? 
73MultiAddssMulti Addresschar10N, Y Allow NULL? 
74EnbDunningEnable Dunningchar10YN, Y Allow NULL? 
75EnbQtyEDlnAllow Qty in Delivery Note to Exceed Base Doc. Qtychar10N, Y Allow NULL? 
76Itw1DateNext Alert Datedate80
77Itw1TimeNext Alert Timeint110 Allow NULL? 
78Itw1CountITW1 Counterint110 Allow NULL? 
79EnbPayRefCalculate Payment Ref. No.char10I, N, Y Allow NULL? 
80EnblDfrTaxEnable Deferred Taxchar10N, Y Allow NULL? 
81EnblClsPrEnable Period-End Closingchar10N, Y Allow NULL? 
82EnblTaxELEnable Tax Exemption Letterchar10N, Y Allow NULL? 
83EnableBOEEnable Bills of Exchangechar10NN, Y Allow NULL? 
84EnableWHTEnable WTaxchar10N, Y Allow NULL? 
85EnblEquVatEnable Equalization Taxchar10N, Y Allow NULL? 
86EnblFAssetEnable Fixed Assetschar10N, Y Allow NULL? 
87EnblDoubtEnable Doubtful Debtschar10N, Y Allow NULL? 
88RateBaseBase Date for Exchange Ratechar10PP, T Allow NULL? 
89BOEStatCloAllow Closed Status for Bill of Exchangechar10N, Y Allow NULL? 
90ARDocsInWTEnable WTax in A/R Docschar10N, Y Allow NULL? 
91BISBnkCntBISR Bank Countrynvarchar30 Allow NULL? 
92BISRBnkCdBISR Bank No.nvarchar300 Allow NULL? 
93BISRBnkAcBISR Bank Accountnvarchar500 Allow NULL? 
94BISRBranchBISR Branchnvarchar500 Allow NULL? 
95EnblBPConnEnable BP Cards Connectionchar10N, Y Allow NULL? 
96EnblVATDatEnable VAT Datechar10N, Y Allow NULL? 
97EnblStAgRpEnable Stock Aging Reportchar10N, Y Allow NULL? 
98EnblCARepoEnable Control Acct Repostingchar10N, Y Allow NULL? 
99EnblMatRevEnable Inventory Revaluationchar10N, Y Allow NULL? 
100EnblMBPRecEnable Multiple BPs Reconcil.char10N, Y Allow NULL? 
101CshDscGrosCash Discount Flag For CN, HKchar10N Allow NULL? 
102EnblTaxInvEnable Tax Invoiceschar10N, Y Allow NULL? 
103EnblCorActEnable Correspondence of Acctschar10N, Y Allow NULL? 
104EnblRuDIPEnable RU Delivery & Invoicechar10N, Y Allow NULL? 
105EnblCurDecEnable Decimal Placeschar10N, Y Allow NULL? 
106EnblPayMtdEnable Payment Method on Inv.char10N, Y Allow NULL? 
107EnblBaseUnEnable UoM on Invoicechar10N, Y Allow NULL? 
108EnblVATAnaEnable VAT Analytics Reportchar10N, Y Allow NULL? 
109EnblExREnhEnable Frgn. Curr. Valuationchar10N, Y Allow NULL? 
110VATGrpCalEnable VAT Calculation by Grpchar10N, Y Allow NULL? 
111MaxChooseNo. of Choose from List Rowsint1100 Allow NULL? 
112EnblInflaEnable Inflationchar10N, Y Allow NULL? 
113EnblLAWHTEnable Latin America WHTchar10N, Y Allow NULL? 
114EnblRTWHTEnable Rounding Type WHTchar10N, Y Allow NULL? 
115ChkQuntyEnable Check Quantity In RDRchar10YN, Y Allow NULL? 
116SriMngSysSRI Management Systemchar10RA, R Allow NULL? 
117BtchMngSysBatch Management Systemchar10RA, R Allow NULL? 
118SriCreatInAuto SRI creation on receiptchar10NN, Y Allow NULL? 
119EnblFolioEnable Folio Numbersnvarchar20CL, MX, N Allow NULL? 
120EnblDocSbTEnable Document Subtypenvarchar20CL, MX, N Allow NULL? 
121IepsPayerIEPS Payerschar10NN, Y Allow NULL? 
122DaysOrdCncDefault Days for Ord. Canc.int11030 Allow NULL? 
123EnblLATaxSEnable Latin America Tax Syschar10N, Y Allow NULL? 
124PercOfAcqPercent of Total Acquisitionnum196 Allow NULL? 
125MinBaseDocMinimum Base Amount per Docnum196 Allow NULL? 
126EnblDpmJdtCreate JE Rows in Down Pmntchar10N, Y Allow NULL? 
127EnblDownPDown Paymentchar10N, Y Allow NULL? 
128EnblNDdctCEnable Non Deduct VAT Per Cardchar10N, Y Allow NULL? 
129DocNmMtdEnable Sharing Serieschar10N, Y Allow NULL? 
130DoFilterData Ownership Indicationchar10NN, Y Allow NULL? 
131EnblOnPDChEnable Opened Postdated Checkschar10N, Y Allow NULL? 
132EnblOnWnCrOpen Window for Credit Voucherchar10N, Y Allow NULL? 
133EnblDefInxEnable Define Indexeschar10N, Y Allow NULL? 
134EnblMxCommEnable Max Commitmentchar10N, Y Allow NULL? 
135EnblIndxOpEnable Index Optionchar10N, Y Allow NULL? 
136EnblSbtCVoEnable Submit Credit Voucherchar10N, Y Allow NULL? 
137MinAmntOAPMinimum Amount for Appndix O&Pnum196 Allow NULL? 
138CredSummCredit Card Summarychar10N, Y Allow NULL? 
139PostdChkPostdated Checkchar10N, Y Allow NULL? 
140PostdCredPostdated Credit Voucherchar10N, Y Allow NULL? 
141CredVendCredit Vendorschar10N, Y Allow NULL? 
142WkoStatusOld Work Order Statuschar10N, Y Allow NULL? 
143DispTrByDfDisplay Transactions by Dfltchar10YN, Y Allow NULL? 
144stampTaxDefault Stamp Taxnvarchar80OVTG Allow NULL? 
145MinAmntALMinimum Amount for Annual Listnum196 Allow NULL? 
146BlockZeroQBlock Stock Negative Quantitychar10YN, Y Allow NULL? 
147AutoCrInsAuto Create Customer Eq Cardchar10NN, Y Allow NULL? 
148EnbRepomoEnable Inflation for Cash Actchar10N, Y Allow NULL? 
149RFCValidatEnable RFC Validationschar10N, Y Allow NULL? 
150MxDcsInPmtMax. Number of Documents in Paymentint1100 Allow NULL? 
151RelStkNoPrEnable Stock Release without Item Costchar10NN, Y Allow NULL? 
152CashDiscCash Discount In Documentchar10N, Y Allow NULL? 
153EnableSMSEnable SMSchar10N, Y Allow NULL? 
154EnblIndicEnable Indicatorchar10N, Y Allow NULL? 
155EnbFedTaxEnable Federal Tax IDchar10N, Y Allow NULL? 
156EnblCountyEnable Countychar10N, Y Allow NULL? 
157LanguageLanguage on Create Companyint60 Allow NULL? 
158ChkIntgUpdCheck Data Integrity On Updatechar10YN, Y Allow NULL? 
159ChkIntgCreCheck Data Integrity On Createchar10YN, Y Allow NULL? 
160BisBnkAcKyBISR Bank Account Keyint110DSC1 Allow NULL? 
161EnbZeroDecEnable Print Check Show Zero Decimalchar10NN, Y Allow NULL? 
162EnbDecWordShow Check Decimal in Wordschar10YN, Y Allow NULL? 
163ChkWrdOnlyAdd the Word Only in Checkschar10N, Y Allow NULL? 
164EnBnkStmntBank Statement Processingchar10NN, Y Allow NULL? 
165CalcVatGrpGroup Lines in VAT Calculationchar10N, Y Allow NULL? 
166TaxSysTypeDefines Tax Calculation Systemchar10A, B, C, M, S Allow NULL? 
167ESEnabledIs Event Sender enabled?char10NC, N, Y Allow NULL? 
168RateTotalUse rate for minor total calc.char10NN, Y Allow NULL? 
169CompanyHisCreate/Upgrade Historytext160
170EnblAssValEnable Assessable Valuechar10NN, Y Allow NULL? 
171CompanyStaCompany Statuschar10UA, I, P, S, U, V Allow NULL? 
172eFRTActLvsNo. of Levels in Elect. FRTint110 Allow NULL? 
173TaxGrpTypeDefines Tax Grouping Typechar10CC, J Allow NULL? 
174InstallNoInstallation Numbernvarchar300 Allow NULL? 
175IsOldPAIs Old for PAchar10NN, Y Allow NULL? 
176EnbNegDocEnable Negative Total in Docchar10 Allow NULL? 
177AlgoEncryption Algorithmint60 Allow NULL? 
178ArcCompArchived Companychar10NN, Y Allow NULL? 
179UpdatedTFIs Updated Tax Formulachar10NN, Y Allow NULL? 
180DARDBGUIDReadonly DB GUID for Archivingnvarchar320 Allow NULL? 
181NegStoLvNegative Inv.: Check Levelchar10IC, I, W Allow NULL? 
182SPNEnabledEnable Transact. Notificationchar10Y Allow NULL? 
183PrsWkCntEbPersonal Work Center Enabledchar10N Allow NULL? 
184DashbdEbDashboard Enabledchar10NN, Y Allow NULL? 
185BoxEffDateBox: Effective From Datedate80
186LogInstancLog Instanceint600 Allow NULL? 
187UpdateDateDate of Updatedate80
188UserSign2Updating Userint60OUSR Allow NULL? 
189SnapShotIdSnapshot IDint1100 Allow NULL? 
190CreatedByCreated Bychar10NN, P, W Allow NULL? 
191B1SgtEbB1 Suggest: Enablechar10Y Allow NULL? 
192IsHConEnvIs in High Concurrency Envchar10NN, Y Allow NULL? 
193B1BuzzEbEnable Streamwork Widgetchar10N Allow NULL? 
194IMCEEnableIMCE Enablechar10NN, Y Allow NULL? 
NamePrimaryUniqueTypeColumns
PRIMARYNoYesVersion, LogInstanc