============================================================

============================================================

SAFIR OVERVIEW


  • Universe: GL_SAFIR.unx

SAFIR : Spring Actual Forecast Integrated Reporting (Spring = Budget; Actual = Realized)

Regarding the forecast data, SAFIR is focus on the Finances, Sales, and Manufacture data in future, this function is orientate by GBU

Since 2018, for PEPOL only, forecast also sent from DYNASYS (source code ZD30)


  • Available objects in BI4

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,

Road Map Finance and Sale function, For long term(5 year) forecast. 
Fields : Forecast Qty, Forecast Sales, Forecast 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 & INTERFACES


QUIKLOAD

  • Budget Data

==> 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 is upload by Quikload(TMP_GL_FORECAST_RM)

 

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

 

EXCHANGE RATE

BFC will send 2 exchange rate to SAFIR which will save in table TTX_CARAT, For Prompt Currency objects 
  1, Budget exchange rate
  2, BFR exchange rate, It also user for Smart, Road Map

 

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:


BI4 CORE REPORTS

In Enterprise BOXI Core Report In QV

|

  • No labels