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
7OVTG52Tax Definition
8OPCH386A/P Invoice
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

B1 8.8: Top 10 requests

2OINV268A/R Invoice
3ORCT154Incoming Payment
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OOCR9Loading Factors
7OPCH268A/P Invoice
8JDT1110Journal Entry - Rows
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction
Inventory and Production
1Business One8.82OITM2607ItemsInventory and Production
SQL:  selectupdate insert create

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

SELECT ItemCode, ItemName, FrgnName, ItmsGrpCod, CstGrpCode, VatGourpSa, CodeBars, VATLiable, PrchseItem, SellItem, InvntItem, OnHand, IsCommited, OnOrder, IncomeAcct, ExmptIncom, MaxLevel, DfltWH, CardCode, SuppCatNum, BuyUnitMsr, NumInBuy, ReorderQty, MinLevel, LstEvlPric, LstEvlDate, CustomPer, Canceled, MnufctTime, WholSlsTax, RetilrTax, SpcialDisc, DscountCod, TrackSales, SalUnitMsr, NumInSale, Consig, QueryGroup, Counted, OpenBlnc, EvalSystem, UserSign, FREE, PicturName, Transfered, BlncTrnsfr, UserText, SerialNum, CommisPcnt, CommisSum, CommisGrp, TreeType, TreeQty, LastPurPrc, LastPurCur, LastPurDat, ExitCur, ExitPrice, ExitWH, AssetItem, WasCounted, ManSerNum, SHeight1, SHght1Unit, SHeight2, SHght2Unit, SWidth1, SWdth1Unit, SWidth2, SWdth2Unit, SLength1, SLen1Unit, Slength2, SLen2Unit, SVolume, SVolUnit, SWeight1, SWght1Unit, SWeight2, SWght2Unit, BHeight1, BHght1Unit, BHeight2, BHght2Unit, BWidth1, BWdth1Unit, BWidth2, BWdth2Unit, BLength1, BLen1Unit, Blength2, BLen2Unit, BVolume, BVolUnit, BWeight1, BWght1Unit, BWeight2, BWght2Unit, FixCurrCms, FirmCode, LstSalDate, QryGroup1, QryGroup2, QryGroup3, QryGroup4, QryGroup5, QryGroup6, QryGroup7, QryGroup8, QryGroup9, QryGroup10, QryGroup11, QryGroup12, QryGroup13, QryGroup14, QryGroup15, QryGroup16, QryGroup17, QryGroup18, QryGroup19, QryGroup20, QryGroup21, QryGroup22, QryGroup23, QryGroup24, QryGroup25, QryGroup26, QryGroup27, QryGroup28, QryGroup29, QryGroup30, QryGroup31, QryGroup32, QryGroup33, QryGroup34, QryGroup35, QryGroup36, QryGroup37, QryGroup38, QryGroup39, QryGroup40, QryGroup41, QryGroup42, QryGroup43, QryGroup44, QryGroup45, QryGroup46, QryGroup47, QryGroup48, QryGroup49, QryGroup50, QryGroup51, QryGroup52, QryGroup53, QryGroup54, QryGroup55, QryGroup56, QryGroup57, QryGroup58, QryGroup59, QryGroup60, QryGroup61, QryGroup62, QryGroup63, QryGroup64, CreateDate, UpdateDate, ExportCode, SalFactor1, SalFactor2, SalFactor3, SalFactor4, PurFactor1, PurFactor2, PurFactor3, PurFactor4, SalFormula, PurFormula, VatGroupPu, AvgPrice, PurPackMsr, PurPackUn, SalPackMsr, SalPackUn, SCNCounter, ManBtchNum, ManOutOnly, DataSource, validFor, validFrom, validTo, frozenFor, frozenFrom, frozenTo, BlockOut, ValidComm, FrozenComm, LogInstanc, ObjType, SWW, Deleted, DocEntry, ExpensAcct, FrgnInAcct, ShipType, GLMethod, ECInAcct, FrgnExpAcc, ECExpAcc, TaxType, ByWh, WTLiable, ItemType, WarrntTmpl, BaseUnit, CountryOrg, StockValue, Phantom, IssueMthd, FREE1, PricingPrc, MngMethod, ReorderPnt, InvntryUom, PlaningSys, PrcrmntMtd, OrdrIntrvl, OrdrMulti, MinOrdrQty, LeadTime, IndirctTax, TaxCodeAR, TaxCodeAP, OSvcCode, ISvcCode, ServiceGrp, NCMCode, MatType, MatGrp, ProductSrc, ServiceCtg, ItemClass, Excisable, ChapterID, NotifyASN, ProAssNum, AssblValue, DNFEntry, UserSign2, Spec, TaxCtg, Series, Number, FuelCode, BeverTblC, BeverGrpC, BeverTM, Attachment, AtcEntry, ToleranDay FROM OITM
ColumnFieldDescriptionSQL TypeLengthDecimalsRelationDefault ValueConstraintsSQL Create Statement
1ItemCodeItem No.nvarchar200 Allow NULL? 
2ItemNameItem Descriptionnvarchar1000 Allow NULL? 
3FrgnNameDescription in Foreign Lang.nvarchar1000 Allow NULL? 
4ItmsGrpCodItem Groupint60OITB100 Allow NULL? 
5CstGrpCodeCustoms Groupint60OARG-1 Allow NULL? 
6VatGourpSaSales Tax Definitionnvarchar80OVTG Allow NULL? 
7CodeBarsBar Codenvarchar160 Allow NULL? 
8VATLiableTax Definitionchar10YN, Y Allow NULL? 
9PrchseItemPurchase Item [Yes/No]char10YN, Y Allow NULL? 
10SellItemSales Item [Yes/No]char10YN, Y Allow NULL? 
11InvntItemInventory Item [Yes/No]char10YN, Y Allow NULL? 
12OnHandIn Stocknum196 Allow NULL? 
13IsCommitedQty Ordered by Customersnum196 Allow NULL? 
14OnOrderQty Ordered from Vendorsnum196 Allow NULL? 
15IncomeAcctRevenue Accountnvarchar150OACT Allow NULL? 
16ExmptIncomExempt Revenue Accountnvarchar150OACT Allow NULL? 
17MaxLevelMaximum Inventory Levelnum196 Allow NULL? 
18DfltWHDefault Warehousenvarchar80 Allow NULL? 
19CardCodePreferred Vendornvarchar150OCRD Allow NULL? 
20SuppCatNumMfr Catalog No.nvarchar170 Allow NULL? 
21BuyUnitMsrPurchasing UoMnvarchar200 Allow NULL? 
22NumInBuyNo. of Items per Purchase Unitnum196 Allow NULL? 
23ReorderQtyPref. Qty in Purchase Unitsnum196 Allow NULL? 
24MinLevelMinimum Inventory Levelnum196 Allow NULL? 
25LstEvlPricLast Evaluated Pricenum196 Allow NULL? 
26LstEvlDateDate of Last Reval. Pricedate80
27CustomPerCustoms Ratenum196 Allow NULL? 
28CanceledCanceled Item [Yes/No]char10NN, Y Allow NULL? 
29MnufctTimeProduction Date in Daysint110 Allow NULL? 
30WholSlsTaxTax Rate for Wholesalerchar10 Allow NULL? 
31RetilrTaxSales Tax in %char10 Allow NULL? 
32SpcialDiscSpecial Discount %num196 Allow NULL? 
33DscountCodDiscount Codeint60 Allow NULL? 
34TrackSalesFollow-Up [Yes/No]char10NN, Y Allow NULL? 
35SalUnitMsrSales UoMnvarchar200 Allow NULL? 
36NumInSaleNo. of Items per Sales Unitnum196 Allow NULL? 
37ConsigConsignment Goods Whsenum196 Allow NULL? 
38QueryGroupPropertiesint1100 Allow NULL? 
39CountedQuantity Counted in Inventorynum196 Allow NULL? 
40OpenBlncInitial Stocknum196 Allow NULL? 
41EvalSystemValuation Methodchar10A, F, S Allow NULL? 
42UserSignUser Signatureint60OUSR Allow NULL? 
43FREEFree [Yes/No]char10NN, Y Allow NULL? 
44PicturNamePicturenvarchar2000 Allow NULL? 
45TransferedYear Transfer [Y/N]char10NN, Y Allow NULL? 
46BlncTrnsfrBalances transferred [Yes/No]char10NN, Y Allow NULL? 
47UserTextItem Remarkstext160
48SerialNumSerial Numbernvarchar170 Allow NULL? 
49CommisPcnt% Commission for Itemnum196 Allow NULL? 
50CommisSumTotal Commission for Itemnum196 Allow NULL? 
51CommisGrpCommission Groupint600 Allow NULL? 
52TreeTypeBOM Typechar10NA, N, P, S, T Allow NULL? 
53TreeQtyNo. of Unitsnum196 Allow NULL? 
54LastPurPrcLast Purchase Pricenum196 Allow NULL? 
55LastPurCurLast Purchase Currencynvarchar30 Allow NULL? 
56LastPurDatLast Purchase Datedate80
57ExitCurIssue Currencynvarchar30 Allow NULL? 
58ExitPriceIssue Pricenum196 Allow NULL? 
59ExitWHRelease Warehousenvarchar80 Allow NULL? 
60AssetItemFixed Assetschar10NN, Y Allow NULL? 
61WasCountedCountedchar10NN, Y Allow NULL? 
62ManSerNumSerial No. Managementchar10NN, Y Allow NULL? 
63SHeight1Height 1 - Sales Unitnum196 Allow NULL? 
64SHght1UnitHeight 1 - UoM for Salesint60 Allow NULL? 
65SHeight2Height 2 - Sales Unitnum196 Allow NULL? 
66SHght2UnitHeight 2 - UoM for Salesint60 Allow NULL? 
67SWidth1Width 1 - Sales Unitnum196 Allow NULL? 
68SWdth1UnitWidth 1 - UoM for Salesint60 Allow NULL? 
69SWidth2Width 2 - Sales Unitnum196 Allow NULL? 
70SWdth2UnitWidth 2 - UoM for Salesint60 Allow NULL? 
71SLength1Length 1 - Sales Unitnum196 Allow NULL? 
72SLen1UnitLength 1 - UoM for Salesint60 Allow NULL? 
73Slength2Length 2 - Sales Unitnum196 Allow NULL? 
74SLen2UnitLength 2 - UoM for Salesint60 Allow NULL? 
75SVolumeVolume - Sales Unitnum196 Allow NULL? 
76SVolUnitVolume - UoM for Salesint60 Allow NULL? 
77SWeight1Weight 1 - Sales Unitnum196 Allow NULL? 
78SWght1UnitWeight 1 - UoM for Salesint60 Allow NULL? 
79SWeight2Weight 2 - Sales Unitnum196 Allow NULL? 
80SWght2UnitWeight 2 - UoM for Salesint60 Allow NULL? 
81BHeight1Height 1 - Purchasing Unitnum196 Allow NULL? 
82BHght1UnitHeight 1 - UoM for Purchasingint60 Allow NULL? 
83BHeight2Height 2 - Purchasing Unitnum196 Allow NULL? 
84BHght2UnitHeight 2 - UoM for Purchasingint60 Allow NULL? 
85BWidth1Width 1 - Purchasing Unitnum196 Allow NULL? 
86BWdth1UnitWidth 1 - UoM for Purchasingint60 Allow NULL? 
87BWidth2Width 2 - Purchasing Unitnum196 Allow NULL? 
88BWdth2UnitWidth 2 - UoM for Purchasingint60 Allow NULL? 
89BLength1Length 1 - Purchase Unitnum196 Allow NULL? 
90BLen1UnitLength 1 - UoM for Purchasingint60 Allow NULL? 
91Blength2Length 2 - Purchase Unitnum196 Allow NULL? 
92BLen2UnitLength 2 - UoM for Purchasingint60 Allow NULL? 
93BVolumeQuantity - Purchasing Unitnum196 Allow NULL? 
94BVolUnitVolume - UoM for Purchasingint60 Allow NULL? 
95BWeight1Weight 1 - Purchasing Unitnum196 Allow NULL? 
96BWght1UnitWeight 1 - UoM for Purchasingint60 Allow NULL? 
97BWeight2Weight 2 - Purchasing Unitnum196 Allow NULL? 
98BWght2UnitWeight 2 - UoM for Purchasingint60 Allow NULL? 
99FixCurrCmsCurrency of Fixed Commissionnvarchar30 Allow NULL? 
100FirmCodeManufacturerint60OMRC-1 Allow NULL? 
101LstSalDateLast Sale Datedate80
102QryGroup1Property 1char10NN, Y Allow NULL? 
103QryGroup2Property 2char10NN, Y Allow NULL? 
104QryGroup3Property 3char10NN, Y Allow NULL? 
105QryGroup4Property 4char10NN, Y Allow NULL? 
106QryGroup5Property 5char10NN, Y Allow NULL? 
107QryGroup6Property 6char10NN, Y Allow NULL? 
108QryGroup7Property 7char10NN, Y Allow NULL? 
109QryGroup8Property 8char10NN, Y Allow NULL? 
110QryGroup9Property 9char10NN, Y Allow NULL? 
111QryGroup10Property 10char10NN, Y Allow NULL? 
112QryGroup11Property 11char10NN, Y Allow NULL? 
113QryGroup12Property 12char10NN, Y Allow NULL? 
114QryGroup13Property 13char10NN, Y Allow NULL? 
115QryGroup14Property 14char10NN, Y Allow NULL? 
116QryGroup15Property 15char10NN, Y Allow NULL? 
117QryGroup16Property 16char10NN, Y Allow NULL? 
118QryGroup17Property 17char10NN, Y Allow NULL? 
119QryGroup18Property 18char10NN, Y Allow NULL? 
120QryGroup19Property 19char10NN, Y Allow NULL? 
121QryGroup20Property 20char10NN, Y Allow NULL? 
122QryGroup21Property 21char10NN, Y Allow NULL? 
123QryGroup22Property 22char10NN, Y Allow NULL? 
124QryGroup23Property 23char10NN, Y Allow NULL? 
125QryGroup24Property 24char10NN, Y Allow NULL? 
126QryGroup25Property 25char10NN, Y Allow NULL? 
127QryGroup26Property 26char10NN, Y Allow NULL? 
128QryGroup27Property 27char10NN, Y Allow NULL? 
129QryGroup28Property 28char10NN, Y Allow NULL? 
130QryGroup29Property 29char10NN, Y Allow NULL? 
131QryGroup30Property 30char10NN, Y Allow NULL? 
132QryGroup31Property 31char10NN, Y Allow NULL? 
133QryGroup32Property 32char10NN, Y Allow NULL? 
134QryGroup33Property 33char10NN, Y Allow NULL? 
135QryGroup34Property 34char10NN, Y Allow NULL? 
136QryGroup35Property 35char10NN, Y Allow NULL? 
137QryGroup36Property 36char10NN, Y Allow NULL? 
138QryGroup37Property 37char10NN, Y Allow NULL? 
139QryGroup38Property 38char10NN, Y Allow NULL? 
140QryGroup39Property 39char10NN, Y Allow NULL? 
141QryGroup40Property 40char10NN, Y Allow NULL? 
142QryGroup41Property 41char10NN, Y Allow NULL? 
143QryGroup42Property 42char10NN, Y Allow NULL? 
144QryGroup43Property 43char10NN, Y Allow NULL? 
145QryGroup44Property 44char10NN, Y Allow NULL? 
146QryGroup45Property 45char10NN, Y Allow NULL? 
147QryGroup46Property 46char10NN, Y Allow NULL? 
148QryGroup47Property 47char10NN, Y Allow NULL? 
149QryGroup48Property 48char10NN, Y Allow NULL? 
150QryGroup49Property 49char10NN, Y Allow NULL? 
151QryGroup50Property 50char10NN, Y Allow NULL? 
152QryGroup51Property 51char10NN, Y Allow NULL? 
153QryGroup52Property 52char10NN, Y Allow NULL? 
154QryGroup53Property 53char10NN, Y Allow NULL? 
155QryGroup54Property 54char10NN, Y Allow NULL? 
156QryGroup55Property 55char10NN, Y Allow NULL? 
157QryGroup56Property 56char10NN, Y Allow NULL? 
158QryGroup57Property 57char10NN, Y Allow NULL? 
159QryGroup58Property 58char10NN, Y Allow NULL? 
160QryGroup59Property 59char10NN, Y Allow NULL? 
161QryGroup60Property 60char10NN, Y Allow NULL? 
162QryGroup61Property 61char10NN, Y Allow NULL? 
163QryGroup62Property 62char10NN, Y Allow NULL? 
164QryGroup63Property 63char10NN, Y Allow NULL? 
165QryGroup64Property 64char10NN, Y Allow NULL? 
166CreateDateProduction Datedate80
167UpdateDateDate of Updatedate80
168ExportCodeData Export Codenvarchar200 Allow NULL? 
169SalFactor1Sales Factor 1num196 Allow NULL? 
170SalFactor2Sales Factor 2num196 Allow NULL? 
171SalFactor3Sales Factor 3num196 Allow NULL? 
172SalFactor4Sales Factor 4num196 Allow NULL? 
173PurFactor1Purchasing Factor 1num196 Allow NULL? 
174PurFactor2Purchasing Factor 2num196 Allow NULL? 
175PurFactor3Purchasing Factor 3num196 Allow NULL? 
176PurFactor4Purchasing Factor 4num196 Allow NULL? 
177SalFormulaSales Formulanvarchar400 Allow NULL? 
178PurFormulaPurchasing Formulanvarchar400 Allow NULL? 
179VatGroupPuPurchase Tax Definitionnvarchar80OVTG Allow NULL? 
180AvgPriceItem Costnum196 Allow NULL? 
181PurPackMsrPackaging UoM (Purchasing)nvarchar80 Allow NULL? 
182PurPackUnQuantity per Packaging UoMnum196 Allow NULL? 
183SalPackMsrSales Packnvarchar80 Allow NULL? 
184SalPackUnPackaging UoM (Sales)num196 Allow NULL? 
185SCNCounterSCN Counterint60 Allow NULL? 
186ManBtchNumManage Batch No. [Yes/No]char10NN, Y Allow NULL? 
187ManOutOnlyManage SN Only on Exitchar10NN, Y Allow NULL? 
188DataSourceData Sourcechar10NA, D, I, M, N, O, P, T, U Allow NULL? 
189validForActivechar10NN, Y Allow NULL? 
190validFromActive Fromdate80
191validToActive Todate80
192frozenForInactivechar10NN, Y Allow NULL? 
193frozenFromInactive Fromdate80
194frozenToInactive Todate80
195BlockOutForce selection of serial no.char10YN, Y Allow NULL? 
196ValidCommActive Remarksnvarchar300 Allow NULL? 
197FrozenCommInactive Remarksnvarchar300 Allow NULL? 
198LogInstancLog Instanceint600 Allow NULL? 
199ObjTypeObject Typenvarchar2004 Allow NULL? 
200SWWAdditional Identifiernvarchar160 Allow NULL? 
201DeletedDeletedchar10NN, Y Allow NULL? 
202DocEntryInternal Numberint110 Allow NULL? 
203ExpensAcctExpense Accountnvarchar150OACT Allow NULL? 
204FrgnInAcctRevenue Account - Foreignnvarchar150OACT Allow NULL? 
205ShipTypeShipping Typeint60OSHP Allow NULL? 
206GLMethodSet G/L Account bychar10WC, L, W Allow NULL? 
207ECInAcctRevenue Account - EUnvarchar150 Allow NULL? 
208FrgnExpAccExpense Account - Foreignnvarchar150 Allow NULL? 
209ECExpAccExpense Account - EUnvarchar150 Allow NULL? 
210TaxTypeTax Typechar10YN, U, Y Allow NULL? 
211ByWhInventory Management by Whsechar10 Allow NULL? 
212WTLiableWTax Liablechar10YN, Y Allow NULL? 
213ItemTypeItem Typechar10II, L, T Allow NULL? 
214WarrntTmplWarranty Templatenvarchar200 Allow NULL? 
215BaseUnitBase Unit Namenvarchar200 Allow NULL? 
216CountryOrgCountry of Originnvarchar30 Allow NULL? 
217StockValueInventory Valuenum196 Allow NULL? 
218PhantomPhantom Itemchar10NN, Y Allow NULL? 
219IssueMthdIssue Methodchar10B, M Allow NULL? 
220FREE1Yield in %char10 Allow NULL? 
221PricingPrcPricing Percentagenum196 Allow NULL? 
222MngMethodManagement Methodchar10RA, R Allow NULL? 
223ReorderPntReorder Pointnum196 Allow NULL? 
224InvntryUomInventory UoMnvarchar200 Allow NULL? 
225PlaningSysPlanning Methodchar10NM, N Allow NULL? 
226PrcrmntMtdProcurement Methodchar10BB, M Allow NULL? 
227OrdrIntrvlOrder Intervalsint60 Allow NULL? 
228OrdrMultiOrder Multiplenum196 Allow NULL? 
229MinOrdrQtyMinimum Order Quantitynum196 Allow NULL? 
230LeadTimeLead Timeint110 Allow NULL? 
231IndirctTaxIndirect Taxchar10NN, Y Allow NULL? 
232TaxCodeARTax Code (A/R)nvarchar80OSTC Allow NULL? 
233TaxCodeAPTax Code (A/P)nvarchar80OSTC Allow NULL? 
234OSvcCodeOutgoing Service Codeint110OSCD-1 Allow NULL? 
235ISvcCodeIncoming Service Codeint110OSCD-1 Allow NULL? 
236ServiceGrpService Groupint110OSGP-1 Allow NULL? 
237NCMCodeNCM Codeint110ONCM-1 Allow NULL? 
238MatTypeMaterial Typenvarchar30OMTP1 Allow NULL? 
239MatGrpMaterial Groupint110OMGP-1 Allow NULL? 
240ProductSrcProduct Sourcechar1011, 2, 3, 4 Allow NULL? 
241ServiceCtgService Categoryint110OSCG-1-1 Allow NULL? 
242ItemClassService or Materialchar1021, 2 Allow NULL? 
243ExcisableExcisable [Yes/No]char10NN, Y Allow NULL? 
244ChapterIDChapter IDint110OCHP-1 Allow NULL? 
245NotifyASNNotification Availed SN.nvarchar400 Allow NULL? 
246ProAssNumProvisional Assessment No.nvarchar200 Allow NULL? 
247AssblValueAssessable Valuenum196 Allow NULL? 
248DNFEntryDNF Code Entryint110ODNF-1 Allow NULL? 
249UserSign2Updating Userint60OUSR Allow NULL? 
250SpecItem Specificationnvarchar300 Allow NULL? 
251TaxCtgTax Categorynvarchar40 Allow NULL? 
252SeriesSeriesint60NNM1 Allow NULL? 
253NumberNumberint110 Allow NULL? 
254FuelCodeFuelint110OBFI-1 Allow NULL? 
255BeverTblCBeverage Tablenvarchar20OBSI Allow NULL? 
256BeverGrpCBeverage Groupnvarchar20OBSI Allow NULL? 
257BeverTMBeverage Brandint110OBNI-1 Allow NULL? 
259AtcEntryAttachment Entryint110 Allow NULL? 
260ToleranDayTolerance Daysint110 Allow NULL?