biuan SAP® BUSINESS ONE SDK
API OSRQ
OSRQ - Serial No. Quantities Table

SBO SQL database table details

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

Table relationship map

SELECT statement

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

Related information


OSRQ SQL Table

Items OITM SQL Table

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