biuan SAP® BUSINESS ONE SDK
SQL Inventory and Production / Cycle Count Determination
API OCCS
OCCS - Cycle Count Determination Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
WhsCode KEY UNIQUEWarehouse CodenVarChar
8
PRIMARYYes
CycleTypeCycle TypeVarChar
G) Item Group
S) Sublevel
1
G
CycleByCycle ByInt
0
1) Warehouse Sublevel 1
2) Warehouse Sublevel 2
3) Warehouse Sublevel 3
4) Warehouse Sublevel 4
6
0

SELECT statement

SELECT OCCS.WhsCode AS 'Warehouse Code', OCCS.CycleType AS 'Cycle Type', OCCS.CycleBy AS 'Cycle By' FROM OCCS AS OCCS

Related information
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