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

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
WhsCode KEY UNIQUEWarehouse CodenVarChar
8
PRIMARYYes
EntryEntryInt
11
CycleCodeCycle CodeInt
6
AlertAlertVarChar
Y) Yes
N) No
1
N
DestUserDestination UserInt
6
NextDateNext Counting DateDate
8
TimeTimeInt
6
ExcldZrQtyExclude Zero QuantityVarChar
Y) Yes
N) No
1
Y
AlertedAlertedVarChar
N) No
Y) Yes
1
N
ChangExistChange Existing Items in DIVarChar
N) No
Y) Yes
1
N

SELECT statement

SELECT CCS1.WhsCode AS 'Warehouse Code', CCS1.Entry AS 'Entry', CCS1.CycleCode AS 'Cycle Code', CCS1.Alert AS 'Alert', CCS1.DestUser AS 'Destination User', CCS1.NextDate AS 'Next Counting Date', CCS1.Time AS 'Time', CCS1.ExcldZrQty AS 'Exclude Zero Quantity', CCS1.Alerted AS 'Alerted', CCS1.ChangExist AS 'Change Existing Items in DI' FROM CCS1 AS CCS1

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