SAP Business One table finder
Search 83 SAP B1 tables by code, meaning or field name. See line tables and the key fields to join on.
OQUT Sales QuotationSales
Related: QUT1 lines, QUT3 freight
Key fields: DocEntry, DocNum, CardCode, DocDate, DocTotal
ORDR Sales OrderSales
Related: RDR1 lines, RDR3 freight
Key fields: DocEntry, DocNum, CardCode, DocStatus, DocDueDate
ODLN DeliverySales
Related: DLN1 lines
Key fields: DocEntry, DocNum, CardCode, DocDate
ORDN Sales ReturnSales
Related: RDN1 lines
Key fields: DocEntry, DocNum, CardCode
OINV A/R InvoiceSales
Related: INV1 lines, INV3 freight, INV5 withholding tax, INV6 installments
Key fields: DocEntry, DocNum, CardCode, DocTotal, PaidToDate, DocStatus
ORIN A/R Credit MemoSales
Related: RIN1 lines
Key fields: DocEntry, DocNum, CardCode, DocTotal
ODPI A/R Down PaymentSales
Related: DPI1 lines
Key fields: DocEntry, DocNum, CardCode, DocTotal
ORRR Return RequestSales
Related: RRR1 lines
Key fields: DocEntry, DocNum, CardCode
OSLP Sales EmployeesSales
Related: OINV.SlpCode, ORDR.SlpCode
Key fields: SlpCode, SlpName, Commission
OPRQ Purchase RequestPurchasing
Related: PRQ1 lines
Key fields: DocEntry, DocNum, ReqDate, Requester
OPQT Purchase QuotationPurchasing
Related: PQT1 lines
Key fields: DocEntry, DocNum, CardCode
OPOR Purchase OrderPurchasing
Related: POR1 lines
Key fields: DocEntry, DocNum, CardCode, DocStatus
OPDN Goods Receipt PO (GRPO)Purchasing
Related: PDN1 lines
Key fields: DocEntry, DocNum, CardCode
ORPD Goods ReturnPurchasing
Related: RPD1 lines
Key fields: DocEntry, DocNum, CardCode
OPCH A/P InvoicePurchasing
Related: PCH1 lines, PCH5 withholding tax
Key fields: DocEntry, DocNum, CardCode, DocTotal, PaidToDate
ORPC A/P Credit MemoPurchasing
Related: RPC1 lines
Key fields: DocEntry, DocNum, CardCode
ODPO A/P Down PaymentPurchasing
Related: DPO1 lines
Key fields: DocEntry, DocNum, CardCode
OIPF Landed CostsPurchasing
Related: IPF1 lines, IPF2 cost lines
Key fields: DocEntry, DocNum
OCRD Business PartnersBusiness Partners
Related: CRD1 addresses, OCPR contacts, CRD7 tax IDs
Key fields: CardCode, CardName, CardType, LicTradNum, Balance, CreditLine
CRD1 BP AddressesBusiness Partners
Related: OCRD.CardCode
Key fields: CardCode, Address, AdresType, Street, City, Country
OCPR BP Contact PersonsBusiness Partners
Related: OCRD.CardCode
Key fields: CntctCode, CardCode, Name, Tel1, E_MailL
OCRG BP GroupsBusiness Partners
Related: OCRD.GroupCode
Key fields: GroupCode, GroupName, GroupType
OCTG Payment TermsBusiness Partners
Related: OCRD.GroupNum
Key fields: GroupNum, PymntGroup, ExtraDays
OITM ItemsInventory
Related: ITM1 prices, OITW warehouse stock, OITB groups
Key fields: ItemCode, ItemName, OnHand, AvgPrice, InvntItem, SellItem, PrchseItem
OITW Item Warehouse StockInventory
Related: OITM.ItemCode, OWHS.WhsCode
Key fields: ItemCode, WhsCode, OnHand, IsCommited, OnOrder
OITB Item GroupsInventory
Related: OITM.ItmsGrpCod
Key fields: ItmsGrpCod, ItmsGrpNam
OWHS WarehousesInventory
Related: OITW.WhsCode, OBIN bins
Key fields: WhsCode, WhsName, BinActivat
ITM1 Item PricesInventory
Related: OITM.ItemCode, OPLN.ListNum
Key fields: ItemCode, PriceList, Price, Currency
OPLN Price ListsInventory
Related: ITM1.PriceList
Key fields: ListNum, ListName, BASE_NUM, Factor
OSPP Special Prices (BP)Inventory
Related: SPP1 periods, SPP2 quantities
Key fields: ItemCode, CardCode, Price, Discount
OIGN Goods Receipt (Inventory)Inventory
Related: IGN1 lines
Key fields: DocEntry, DocNum, DocDate
OIGE Goods Issue (Inventory)Inventory
Related: IGE1 lines
Key fields: DocEntry, DocNum, DocDate
OWTQ Inventory Transfer RequestInventory
Related: WTQ1 lines
Key fields: DocEntry, DocNum, Filler, ToWhsCode
OWTR Inventory TransferInventory
Related: WTR1 lines
Key fields: DocEntry, DocNum, Filler, ToWhsCode
OINM Inventory Audit (old journal)Inventory
Related: Superseded by OIVL in 9.x+
Key fields: TransNum, ItemCode, InQty, OutQty, Warehouse
OIVL Inventory Transactions LogInventory
Related: IVL1 cost layers
Key fields: TransSeq, ItemCode, LocCode, InQty, OutQty, TransValue
OINC Inventory CountingInventory
Related: INC1 lines
Key fields: DocEntry, DocNum, CountDate
OIQR Inventory PostingInventory
Related: IQR1 lines
Key fields: DocEntry, DocNum
OBTN Batch Numbers (master)Inventory
Related: OBTQ quantities, OBTW warehouse details
Key fields: AbsEntry, ItemCode, DistNumber, ExpDate, MnfDate
OBTQ Batch Quantities per WarehouseInventory
Related: OBTN.AbsEntry = MdAbsEntry
Key fields: ItemCode, WhsCode, Quantity, MdAbsEntry
OSRN Serial Numbers (master)Inventory
Related: OSRQ quantities
Key fields: AbsEntry, ItemCode, DistNumber, Status
OBIN Bin LocationsInventory
Related: OIBQ bin quantities
Key fields: AbsEntry, BinCode, WhsCode
OUOM Units of MeasureInventory
Related: OUGP UoM groups, UGP1
Key fields: UomEntry, UomCode, UomName
OITT Bill of MaterialsProduction
Related: ITT1 components
Key fields: Code, TreeType, Qauntity, ToWH
OWOR Production OrderProduction
Related: WOR1 components
Key fields: DocEntry, DocNum, ItemCode, PlannedQty, CmpltQty, Status
ORSC ResourcesProduction
Related: RSC4 capacities
Key fields: VisResCode, ResName, ResType
OACT Chart of AccountsFinance
Related: JDT1.Account
Key fields: AcctCode, AcctName, CurrTotal, Postable, GroupMask
OJDT Journal Entry (header)Finance
Related: JDT1 lines
Key fields: TransId, RefDate, TransType, BaseRef, Memo
JDT1 Journal Entry LinesFinance
Related: OJDT.TransId
Key fields: TransId, Line_ID, Account, ShortName, Debit, Credit
OBTF Journal VouchersFinance
Related: BTF1 lines
Key fields: BatchNum, TransId
ORCT Incoming PaymentsFinance
Related: RCT2 invoices paid, RCT1 checks, RCT3 credit cards
Key fields: DocEntry, DocNum, CardCode, DocTotal, CashSum, TrsfrSum
OVPM Outgoing PaymentsFinance
Related: VPM2 invoices paid, VPM1 checks
Key fields: DocEntry, DocNum, CardCode, DocTotal
OCHH Checks for Payment (received)Finance
Related: ORCT
Key fields: CheckKey, CheckNum, BankCode, CheckSum, Deposited
ODPS DepositsFinance
Related: DPS1 lines
Key fields: DeposId, DeposDate, BanckAcct
OPRC Profit Centers / Cost CentersFinance
Related: OOCR distribution rules
Key fields: PrcCode, PrcName, DimCode
OOCR Distribution RulesFinance
Related: OCR1 lines
Key fields: OcrCode, OcrName, DimCode
OPRJ ProjectsFinance
Related: Used on documents and JDT1.Project
Key fields: PrjCode, PrjName, Active
OCRN CurrenciesFinance
Related: ORTT exchange rates
Key fields: CurrCode, CurrName
ORTT Exchange RatesFinance
Related: OCRN.CurrCode
Key fields: RateDate, Currency, Rate
OSTC Tax CodesFinance
Related: STC1 tax types
Key fields: Code, Name, Rate
OVTG Tax Groups (VAT)Finance
Related: Used on lines (VatGroup)
Key fields: Code, Name, Rate, Category
OFPR Posting PeriodsFinance
Related: OACP period definitions
Key fields: AbsEntry, Code, F_RefDate, T_RefDate, PeriodStat
OBNK Bank Statement LinesBanking
Related: Reconciliation
Key fields: AcctCode, Sequence, DueDate, Memo
DSC1 House Bank AccountsBanking
Related: ODSC banks
Key fields: BankCode, Account, GLAccount
OSCL Service CallsService
Related: SCL1 solutions, SCL5 activities
Key fields: callID, customer, subject, status, priority
OINS Customer Equipment CardService
Related: OSCL.insID
Key fields: insID, itemCode, manufSN, customer
OCTR Service ContractsService
Related: CTR1 items
Key fields: ContractID, CstmrCode, StartDate, EndDate
OCLG ActivitiesCRM
Related: OCRD.CardCode
Key fields: ClgCode, CardCode, Action, Recontact, Notes
OOPR Sales OpportunitiesCRM
Related: OPR1 stages
Key fields: OpprId, CardCode, MaxSumLoc, Status
OHEM EmployeesAdministration
Related: HEM6 roles
Key fields: empID, firstName, lastName, dept, manager
OUSR UsersAdministration
Related: UserSign on every document
Key fields: USERID, USER_CODE, U_NAME, E_Mail, Locked
OADM Company DetailsAdministration
Related: ADM1 extra details
Key fields: CompnyName, MainCurncy, SysCurrncy, TaxIdNum
ONNM Document NumberingAdministration
Related: NNM1 series
Key fields: ObjectCode, AutoKey, DfltSeries
NNM1 Numbering SeriesAdministration
Related: Series on every document
Key fields: Series, SeriesName, NextNumber, ObjectCode
OWDD Approval RequestsApprovals
Related: WDD1 approval steps
Key fields: WddCode, ObjType, DocEntry, OwnerID, Status
OWTM Approval TemplatesApprovals
Related: WTM1 originators, WTM2 stages
Key fields: WtmCode, Name, Active
OALR Alerts / Internal MessagesAdministration
Related: ALR1, AIB1 recipients
Key fields: Code, Subject, UserSign
ADOC Document History (log)Administration
Related: Archived versions of OINV/ORDR…
Key fields: DocEntry, ObjType, LogInstanc
CUFD User-Defined Fields (definitions)Customization
Related: UFD1 valid values
Key fields: TableID, FieldID, AliasID, Descr
OUTB User-Defined Tables (definitions)Customization
Related: Tables named @NAME
Key fields: TableName, Descr, ObjectType
OUQR Saved QueriesCustomization
Related: OQCN query categories
Key fields: IntrnalKey, QCategory, QName, QString
CSHS Formatted SearchesCustomization
Related: Links OUQR to form fields
Key fields: FormID, ItemID, ColID, QueryId
RDOC Report & Layout DefinitionsCustomization
Related: Crystal and PLD layouts
Key fields: DocCode, DocName, TypeCode
No table found. Ask our developers →
Three steps, no signup
Type what you need
Search by table code (OINV), by meaning (invoice, batch, approval) or by field name (CardCode).
See the line tables
Each result shows the header table, its line tables and the fields you usually join on.
Write the query
Use the key fields to join tables, or send the result to the SQL to HANA converter.
Questions about this tool
Where are A/R invoices stored in SAP Business One?
The invoice header is in OINV and the lines are in INV1. They join on DocEntry. Open balance is DocTotal minus PaidToDate.
What is the difference between OITM and OITW?
OITM is the item master with totals for all warehouses. OITW holds the stock of each item per warehouse: OnHand, IsCommited (committed) and OnOrder.
Which table holds batch numbers and expiry dates?
OBTN is the batch master with DistNumber and ExpDate. OBTQ holds the batch quantity per warehouse and joins to OBTN on OBTN.AbsEntry = OBTQ.MdAbsEntry.
How do I find user-defined fields and tables?
CUFD lists every user-defined field (TableID, AliasID, Descr). OUTB lists user-defined tables, which are stored in the database with an @ prefix, for example @MY_TABLE.
Are the table names the same on SQL Server and HANA?
Yes. Only the query syntax changes: on HANA column names must be written in double quotes, for example T0."CardCode".
Built for SAP Business One teams
Need this inside SAP Business One?
We build add-ons, reports and integrations for SAP B1 on SQL Server and HANA. Tell us what you need and get a fixed price, usually within 24 hours.