biuan SAP® BUSINESS ONE SDK
API OBTQ
OBTQ - Batch No. Quantities Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
ItemCode KEY UNIQUEItem CodenVarChar
20OITM
Items
SYSTEM_KEYYes
SysNumberSystem NumberInt
11OBTN
Batch Numbers Master Data
WhsCodeWarehouse CodenVarChar
8OWHS
Warehouses
QuantityQuantityNum
20
CommitQtyCommitted QuantityNum
20
CountQtyCounted QuantityNum
20
AbsEntry KEY UNIQUEabs entryInt
11
PRIMARYYes
MdAbsEntryMD Abs EntryInt
11OBTN
Batch Numbers Master Data
TrackingNtCCD Tracking NoteInt
11OTCN
Tracking Note
TrackiNtLnCCD Tracking Note LineInt
11TCN1
Tracking Note - Line Data
CCDQuantCCD QuantityNum
20

Table relationship map

SELECT statement

SELECT OBTQ.ItemCode AS 'Item Code', OBTQ.SysNumber AS 'System Number', OBTQ.WhsCode AS 'Warehouse Code', OBTQ.Quantity AS 'Quantity', OBTQ.CommitQty AS 'Committed Quantity', OBTQ.CountQty AS 'Counted Quantity', OBTQ.AbsEntry AS 'abs entry', OBTQ.MdAbsEntry AS 'MD Abs Entry', OBTQ.TrackingNt AS 'CCD Tracking Note', OBTQ.TrackiNtLn AS 'CCD Tracking Note Line', OBTQ.CCDQuant AS 'CCD Quantity' FROM OBTQ AS OBTQ

Related information


OBTQ SQL Table

Items OITM SQL Table

Batch Numbers Master Data OBTN SQL Table

Tracking Note OTCN SQL Table

Tracking Note - Line Data TCN1 SQL Table

Warehouses OWHS SQL Table



SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates