|
|
DTW Sales Forecast - Rows
API Sales Forecast / Sales Forecast Lines
FCT1 - Sales Forecast - Rows Table
Sales Forecast Lines SalesForecast_Lines Object· Table: FCT1
Parent: Sales Forecast SalesForecast Object· Table: OFCT
Sales Forecast OFCT SQL Table
Items OITM SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | AbsID KEY UNIQUE | Internal Number | Int | 11 | OFCT Sales Forecast | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| LineID | Row Number | Int | 11 | |||||
| ItemCode | Item No. | nVarChar | 20 | OITM Items | ||||
| Date | Day Forecasted | Date | 8 | |||||
| Quantity | Quantity | Num | 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
SalesForecast
Object
SalesForecast_Lines
Method
Property
ItemNo
DB
Quantity
DB
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates