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
Inventory and Production
ProductVersionTableColumnsIndexesDescriptionModule
1Business One8.82OINM10110Whse JournalInventory and Production
SQL:  selectupdate insert create

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

SELECT TransNum, TransType, CreatedBy, BASE_REF, DocLineNum, DocDate, DocDueDate, CardCode, CardName, Ref1, Ref2, Comments, JrnlMemo, DocTime, ItemCode, Dscription, InQty, OutQty, Price, Currency, Rate, VendorNum, SerialNum, Warehouse, TreeType, SlpCode, TaxDate, DataSource, PrjCode, UserSign, BlockNum, ImportLog, UseDocPric, Location, CalcPrice, OpenQty, Instance, LastInst, RevalTotal, BaseCurr, ApplObj, AppObjAbs, AppObjType, StockAct, TrnsfrAct, PriceDifAc, VarianceAc, ReturnAct, ExcRateAct, ClearAct, CostAct, WipAct, Balance, CreateDate, BaseLine, TransValue, PriceDiff, TransSeq, InvntAct, RemMethod, OpenValue, SubLineNum, AppObjLine, Expenses, OpenExp, Allocation, OpenAlloc, ExpAlloc, OExpAlloc, OpenPDiff, ExchDiff, OpenEDiff, NegInvAdjs, OpenNegInv, NegStckAct, BTransVal, VarVal, BExpVal, CogsVal, BNegAVal, IOffIncAcc, IOffIncVal, DOffDecAcc, DOffDecVal, DecAcc, DecVal, WipVal, WipVarAcc, WipVarVal, IncAct, IncVal, ExpCAcc, CostMethod, OcrCode, BaseQty, PrevTrans, HTransSeq, OcrCode2, OcrCode3, OcrCode4, OcrCode5 FROM OINM
ColumnFieldDescriptionSQL TypeLengthDecimalsRelationDefault ValueConstraintsSQL Create Statement
1TransNumTransaction Numberint110 Allow NULL? 
2TransTypeTransaction Typeint110-1(-=(-, -1=All Transactions, -2=Opening Balance, 10000071=Inventory Posting, 132=Correction Invoice, 13=A/R Invoice, 14=A/R Credit Memo, 15=Delivery, 162=Inventory Revaluation, 16=Returns, 18=A/P Invoice, 19=A/P Credit Memo, 20=Goods Receipt, 21=Goods Return, 310000001=Initial Quantity, 58=Stock Update, 59=Goods Receipt, 60=Goods Issue, 67= Allow NULL? 
3CreatedByDocument Key Createdint110 Allow NULL? 
4BASE_REFBase Referencenvarchar110 Allow NULL? 
5DocLineNumRow Number in Documentint60 Allow NULL? 
6DocDatePosting Datedate80
7DocDueDateDue Datedate80
8CardCodeCustomer/Vendor Codenvarchar150OCRD Allow NULL? 
9CardNameCustomer/Vendor Namenvarchar1000 Allow NULL? 
10Ref1Reference1nvarchar110 Allow NULL? 
11Ref2Reference 2nvarchar110 Allow NULL? 
12CommentsRemarksnvarchar2540 Allow NULL? 
13JrnlMemoJournal Remarksnvarchar500 Allow NULL? 
14DocTimeGeneration Timeint60 Allow NULL? 
15ItemCodeItem No.nvarchar200OITM Allow NULL? 
16DscriptionItem Descriptionnvarchar1000 Allow NULL? 
17InQtyReceipt Quantitynum196 Allow NULL? 
18OutQtyIssue Quantitynum196 Allow NULL? 
19PricePricenum196 Allow NULL? 
20CurrencyPrice Currencynvarchar30OCRN Allow NULL? 
21RateCurrency Pricenum196 Allow NULL? 
22VendorNumVendor Catalog No.nvarchar170 Allow NULL? 
23SerialNumSerial Numbernvarchar170 Allow NULL? 
24WarehouseWarehouse Codenvarchar80OWHS Allow NULL? 
25TreeTypeBOM Typechar10NA=Assembly, I=BOM Component Item, N=Not a BOM, S=Sales Allow NULL? 
26SlpCodeSales Employeeint60OSLP-1 Allow NULL? 
27TaxDateDocument Datedate80
28DataSourceData 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? 
29PrjCodeProject Codenvarchar80OPRJ Allow NULL? 
30UserSignUser Signatureint60OUSR Allow NULL? 
31BlockNumBlock Numbernvarchar1000 Allow NULL? 
32ImportLogImport Lognvarchar200 Allow NULL? 
33UseDocPricUse Document Pricechar10NN=No, Y=Yes Allow NULL? 
34LocationLocationint110OLCT Allow NULL? 
35CalcPriceCalculated Pricenum196 Allow NULL? 
36OpenQtyOpen Quantitynum196 Allow NULL? 
37InstanceInstanceint1100 Allow NULL? 
38LastInstLast Instanceint110 Allow NULL? 
39RevalTotalInventory Revaluation Totalnum196 Allow NULL? 
40BaseCurrBase Document Currencynvarchar30 Allow NULL? 
41ApplObjApplied Objectint110 Allow NULL? 
42AppObjAbsApplied Object Abs Entryint110 Allow NULL? 
43AppObjTypeApplied Object Typechar10 Allow NULL? 
44StockActInventory Accountnvarchar150OACT Allow NULL? 
45TrnsfrActTransfer Accountnvarchar150OACT Allow NULL? 
46PriceDifAcPrice Difference Accountnvarchar150OACT Allow NULL? 
47VarianceAcVariance Accountnvarchar150OACT Allow NULL? 
48ReturnActReturning Accountnvarchar150OACT Allow NULL? 
49ExcRateActExchange Rate Differences Acctnvarchar150OACT Allow NULL? 
50ClearActGoods Clearing Accountnvarchar150OACT Allow NULL? 
51CostActCOGS Accountnvarchar150OACT Allow NULL? 
52WipActWIP Inventory Accountnvarchar150OACT Allow NULL? 
53BalanceStock Balancenum196 Allow NULL? 
54CreateDateCreation Datedate80
55BaseLineBase Row Numberint110-1 Allow NULL? 
56TransValueTransaction Valuenum196 Allow NULL? 
57PriceDiffValue Posted - Price Diff Acctnum196 Allow NULL? 
58TransSeqTransaction Sequence No.int1100 Allow NULL? 
59InvntActInventory Accountnvarchar150OACT Allow NULL? 
60RemMethodQuantity Removal Methodchar10UI=Issue, R=Revaluation, U=Unspecified Allow NULL? 
61OpenValueOpen Valuenum196 Allow NULL? 
62SubLineNumSub Line Numberint110-1 Allow NULL? 
63AppObjLineApplied Object Lineint60-1 Allow NULL? 
64ExpensesInventory Expensesnum196 Allow NULL? 
65OpenExpOpen Expenses Valuenum196 Allow NULL? 
66AllocationAllocation Amountnum196 Allow NULL? 
67OpenAllocOpen Allocation Valuenum196 Allow NULL? 
68ExpAllocExpenses Allocation Valuenum196 Allow NULL? 
69OExpAllocOpen Expenses Allocation Valuenum196 Allow NULL? 
70OpenPDiffOpen Price Diff. Valuenum196 Allow NULL? 
71ExchDiffExchange Rate Difference Valuenum196 Allow NULL? 
72OpenEDiffOpen Exchange Rate Diff. Valuenum196 Allow NULL? 
73NegInvAdjsNegative Inventory Adjustmentnum196 Allow NULL? 
74OpenNegInvOpen Negative Adjustmentnum196 Allow NULL? 
75NegStckActNegative Inventory Adjustmentnvarchar150OACT Allow NULL? 
76BTransValBase Transaction Valuenum196 Allow NULL? 
77VarValVariance Valuenum196 Allow NULL? 
78BExpValBase Freight Valuenum196 Allow NULL? 
79CogsValCOGS Valuenum196 Allow NULL? 
80BNegAValBase Negative Adjustment Amtnum196 Allow NULL? 
81IOffIncAccInventory Offset Increase Acctnvarchar150OACT Allow NULL? 
82IOffIncValInv. Offset Increase Valuenum196 Allow NULL? 
83DOffDecAccInventory Offset Decrease Acctnvarchar150OACT Allow NULL? 
84DOffDecValInv. Offset Decrease Valuenum196 Allow NULL? 
85DecAccG/L Decrease Accountnvarchar150OACT Allow NULL? 
86DecValG/L Decrease Valuenum196 Allow NULL? 
87WipValWIP Inventory Valuenum196 Allow NULL? 
88WipVarAccWIP Variance Accountnvarchar150OACT Allow NULL? 
89WipVarValWIP Variance Valuenum196 Allow NULL? 
90IncActG/L Increase Accountnvarchar150 Allow NULL? 
91IncValG/L Increase Valuenum196 Allow NULL? 
92ExpCAccExpense Clearing Accountnvarchar150OACT Allow NULL? 
93CostMethodCosting Methodchar10NA=Moving Average, F=FIFO, N=None, S=Standard Allow NULL? 
94OcrCodeDistribution Rulenvarchar80OOCR Allow NULL? 
95BaseQtyQuantity drawn from base doc.num196 Allow NULL? 
96PrevTransPrevious Trans. Sequenceint1100 Allow NULL? 
97HTransSeqHistory Trans. Sequenceint110 Allow NULL? 
98OcrCode2Distribution Rule2nvarchar80OOCR Allow NULL? 
99OcrCode3Distribution Rule3nvarchar80OOCR Allow NULL? 
100OcrCode4Distribution Rule4nvarchar80OOCR Allow NULL? 
101OcrCode5Distribution Rule5nvarchar80OOCR Allow NULL? 
NamePrimaryUniqueTypeColumns
PRIMARYNoYesNUM, INSTANCE
CARDNoNoCARD_CODE
ITEMNoNoITEM_CODE, WAREHOUSE
CURRENCYNoNoCURRENCY
DOCDATENoNoDATE
DOCENTRYNoNoCREATED_BY, TYPE, LINE_NUM
TRANSSEQNoYesTRANS_SEQUENCE
APPOBJNoNoAPPL_OBJECT, APPL_OBJ_ABS, APPL_OBJ_TYPE
OPENQTYCOMNoNoITEM_CODE, NUM, INSTANCE, OPEN_QTY
OPENQTYWHNoNoITEM_CODE, WAREHOUSE, NUM, INSTANCE, OPEN_QTY