biuan SAP® BUSINESS ONE SDK
API OFCT / Sales Forecast
OFCT - Sales Forecast Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsID KEY UNIQUEInternal NumberInt
11
PRIMARYYes
Code KEY UNIQUEForecast CodenVarChar
16
FCT_CODEYes
NameForecast NamenVarChar
100
UserSignUser SignatureInt
6OUSR
Users
StartDateForecast Start DateDate
8
EndDateForecast End DateDate
8
FormViewForecast Form ViewVarChar
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



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