Access grant:
The loading is done using an Excel file.
The BW transaction to be used is ZBW_SD_PC
Using this transaction, it is possible to enter new forecasts or update existing one and load data for both system : WP1 (Rhodia legacy) and PF1 (Solvay legacy).
Refer to the WIKI page :
https://wiki.solvay.com/display/TECHREP/Forecast#Forecast-HowtodownloadForecastfromBWsystem
Loading frequency using the BW transaction is up to the user.
Once data is loaded it is integrated in the Global Sales solution and in the CRM-analytics dashboard during the night job.
If you load several versions during the day only the last one will be loaded in BW during the night.
Description | Data Format | Mandatory / Optionnal | Remark |
Version | BUDGET, BFR03, BFR06, BFR09 | Mandatory – key for update | BUDGET=BFR12 |
ERP Source | PF1_020 (for PF1) WP1_400 (for RCS) NERP001 Chemplex NERP006 Itanbul Kimya | Mandatory – key for update | Global Sales does not contain other sources as in the P&L |
Year & Month of forecast | YYYYMM | Mandatory – key for update | |
BFC GBU | BFC format (2 digits), for example SD = Soda Ash | Mandatory – key for update | |
Legal Company code | 4 digits | Optional – key for update | Warning : it’s NOT the PRS code |
BFC Group of Activity | 5 digits | Optional | = BFC BU |
BFC Sub-activity | 4 digits | Optional | = BFC Market |
Sales Rep | Optional | ||
Ship-to Country | 2 digits | Optional | (1) See next slide |
Ship-to Zone | Optional | (1) See next slide | |
Ship-to KA | GRCL****** | Optional | (3) See next slide |
Ship-to code | 10 digits max : 1234567890 | Optional | (1) See next slide |
Distribution Channel | Optional | ||
Product Hierarchy/LIP03 | Product line level 3 for RCS (LIP003) Product hierarchy for PF1 (example MHE) | Optional | (2) See next slide |
Product | Commercial product for RCS (example 90031318) Material group for PF1 (example Z10-12791) | Optional | (2) See next slide |
Material Code | Should exist in Material master data | Optional | (2) See next slide |
Unit Quantity | KG | Mandatory | Only KG could be loaded |
Financial Forecast Quantity | without decimal places | Mandatory | |
Currency code | EUR | Mandatory | Only EUR could be loaded |
Financial Forecast Sales | without decimal places | Mandatory | |
Financial Forecast Contrib | without decimal places | Mandatory | |
Enterprise Segment | 10 char | Optional | |
Sold to | 10 digits max : 1234567890 | Optional | Available since end of January 2021 |