biuan SAP® BUSINESS ONE SDK
API OBBQ
OBBQ - Item - Serial/Batch - Bin Accumulator Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEInternal NumberInt
11
PRIMARYYes
ItemCodeItem CodenVarChar
20OITM
Items
SnBMDAbs KEY UNIQUEBatch MD Internal NumberInt
11OBTN
Batch Numbers Master Data
BUSINESS_KYes
BinAbs KEYBin Internal NumberInt
11OBIN
Bin Location
BIN_ABSNo
OnHandQtyOn-Hand QuantityNum
20
WhsCodeWarehouse CodenVarChar
8OWHS
Warehouses

Table relationship map

SELECT statement

SELECT OBBQ.AbsEntry AS 'Internal Number', OBBQ.ItemCode AS 'Item Code', OBBQ.SnBMDAbs AS 'Batch MD Internal Number', OBBQ.BinAbs AS 'Bin Internal Number', OBBQ.OnHandQty AS 'On-Hand Quantity', OBBQ.WhsCode AS 'Warehouse Code' FROM OBBQ AS OBBQ

Related information


Bin Location OBIN SQL Table

Items OITM SQL Table

Batch Numbers Master Data OBTN 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. Icons by Icons8 Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates