SAFIR OVERVIEW
Universe: GL_SAFIR
Regarding the forecast data, the universe is focus on the Finances, Sales, and Manufacture data in future, this function is orientate by GBU
Data in SAFIR:
GBR master data, Structure data:
Unique Ship to: Material: Structure Data
BUDGET(SPRING) Finance function, usually data will be entered in the beginning of each year.
Fields: Budget Qty, Budget Sales, Budget CM,
BFR(CASH REVIEW) Finance function, For short term forecast, usually data will be entered quarter by quarter
Fields: BFR Qty, BFR Sales, BFR CM,
SMART CRM function, data come from SMART-Forecast module
Fields: Smart Qty, Smart Sales
APO DPS function, data come from APO system
Fields: APO Sales Qty, APO statistical Qty, APO Budget Qty, APO DP Qty, APO DPC Qty
Data structure and interface,
Budget Data is upload by QuikLoad(TMP_GL_FORECAST_BUDGET), the format as below:
BFR data* is upload by QuikLoad(TMP_GL_FORECAST_BFR), the format as below: 
Road Map 
SMART data* is come from SMART system, data flat file will have following format:
C_CLI_UNIQUE | C_ARTICLE | C_ANNEE | C_MOIS | N_QTE_FCST_SMART | C_UF | N_PRIX_FCST_SMART | C_DEV | D_CHANGE_SMART | C_ENT_LOC |
Unique Ship to code | Material | Year | Month | Qty of Smart | UOM | Price | Currency | Change date | Enterprise code |
D_EXTRACT_SMART | C_FORECAST | C_USER | C_IECRA_LOC | C_CD_LOC | F_CREA | F_SUPP | C_CD | C_GRP_VEND |
|
| User ID | IECRA Code | DC code |
|
|
| Sales Group |
Note: no company code in the SMART-SAFIR interface.
APO data* is come from APO system, data flat file will have following main format:
C_ANNEE_MOIS | C_UF | C_CD | C_ENT | C_USINE | C_ARTICLE | C_CLI_UNIQUE | C_SA | C_GRP_VEND | C_OC | C_PART_ZI |
Year Month | UOM | DC code | Enterprise code | dispatch Plant code | Material code | Unique Ship to code | Division | Sales Group | Sales Org | Customer service office |
N_QTE_FCST_SALES | N_QTE_FCST_STAT | N_QTE_FCST_SPRING | N_QTE_FCST_DP | N_QTE_FCST_DPC |
Sales QTY | Statistical Qty | Budget Qty | DP Qty | DPC Qty |
SAFIR Exploitation: When the user upload the Budget, BFR data via QuikLoad, data file will be saved into BOXI server immediately, and wait for next SAFIR exploitation.
When APO generated the SAFIR data, system will send a message to BOXI, BOXI will start the SAFIR Exploitation.
BOXI will go to APO and SMART get the data file, and upload Budget, BFR, SMART & APO data into SAFIR
Usual SAFIR Exploitation start around 10:00AM SG time.
Check Error in REC table
Core report BUDGET & BFR CONTROL CWWSAFIR_001 in folder “10 – Data administration”
or RUL http//pilotcwebpp.priv.rhodia.com/exploit/errors_pe.htm
Data in SAFIR
Budget and BFR,
Usualy BU will have a report to extract the previous year sales data, download into excel, fill in the forecast data and upload it into SAFIR.
QL format is flexible for finance controlling:
They can enter the all detail on combination of Unique Ship to * Material
Like Novecare, one zone select one company, and they upload the detail of Ship to And Material.
They can only focus on the sales of company.
Like EP, there are only 96 records in 2013, for one company they only choose one ship to code and material code to upload the data
SMART, Not every Enterprise and every Zone use the Forecast function in SMART,
if you compare the Forecast Sales in SMART and Budget, you have a huge discrepancy.
APO,
Most of Enterprises are maintaining the forecast with APO:
The usage of SAFIR
In Enterprise BOXI Core Report In QV
|