biuan SAP® BUSINESS ONE SDK
DTW Sales Forecast - Rows
API Sales Forecast / Sales Forecast Lines
FCT1 - Sales Forecast - Rows Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsID KEY UNIQUEInternal NumberInt
11OFCT
Sales Forecast
PRIMARYYes
LineIDRow NumberInt
11
ItemCodeItem No.nVarChar
20OITM
Items
DateDay ForecastedDate
8
QuantityQuantityNum
20

Table relationship map

SELECT statement

SELECT FCT1.AbsID AS 'Internal Number', FCT1.LineID AS 'Row Number', FCT1.ItemCode AS 'Item No.', FCT1.Date AS 'Day Forecasted', FCT1.Quantity AS 'Quantity' FROM FCT1 AS FCT1

Related information


Sales Forecast Lines SalesForecast_Lines Object· Table: FCT1
SalesForecast_Lines is a child object of SalesForecast object and represents sales forecast of items and their quantity for a specified day. Source table: FCT1.
   Parent: Sales Forecast SalesForecast Object· Table: OFCT
Sales Forecast OFCT SQL Table

Items OITM SQL Table



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