|
|
SQL MRP / Sales Forecast
API OFCT / / Sales Forecast
OFCT - Sales Forecast Table
Sales Forecast SalesForecast Object· Table: OFCT
OFCT SQL Table
Users OUSR SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | AbsID KEY UNIQUE | Internal Number | Int | 11 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| Code KEY UNIQUE | Forecast Code | nVarChar | 16 | FCT_CODE | Yes | |||
| Name | Forecast Name | nVarChar | 100 | |||||
| UserSign | User Signature | Int | 6 | OUSR Users | ||||
| StartDate | Forecast Start Date | Date | 8 | |||||
| EndDate | Forecast End Date | Date | 8 | |||||
| FormView | Forecast Form View | VarChar | D) Daily W) Weekly M) Monthly | 1 | D |
Table relationship map
SELECT statement
SELECT
OFCT.AbsID AS 'Internal Number',
OFCT.Code AS 'Forecast Code',
OFCT.Name AS 'Forecast Name',
OFCT.UserSign AS 'User Signature',
OFCT.StartDate AS 'Forecast Start Date',
OFCT.EndDate AS 'Forecast End Date',
OFCT.FormView AS 'Forecast Form View'
FROM OFCT AS OFCT
Related information
Sales Forecast SalesForecast Object· Table: OFCT
SalesForecast is a business object that represents the sales forecast for a specified period. The sales forecast is required for planning the purchase and production of items in the MRP module.
This object enables you to:
Add a sales forecast....
OFCT SQL Table
Users OUSR SQL Table
SalesForecast
Enumeration
Method
Object
SalesForecast_Lines FCT1
Property
ForecastCode
DB
ForecastName
DB
Numerator
DB
View
DB
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates