biuan SAP® BUSINESS ONE SDK
API OIWB
OIWB - Items - Warehouse Counting Data Backup Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEAbs. EntryInt
11
PRIMARYYes
ItemCode KEY UNIQUEItem No.nVarChar
20OITM
Items
SYSTEM_KEYYes
WhsCodeWarehouse CodenVarChar
8OWHS
Warehouses
CountedCounted QuantityNum
20
WasCountedCounted Yes/NoVarChar
Y) Yes
N) No
1
N

Table relationship map

SELECT statement

SELECT OIWB.AbsEntry AS 'Abs. Entry', OIWB.ItemCode AS 'Item No.', OIWB.WhsCode AS 'Warehouse Code', OIWB.Counted AS 'Counted Quantity', OIWB.WasCounted AS 'Counted Yes/No' FROM OIWB AS OIWB

Related information


OIWB SQL Table

Items OITM 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