a. Data fields and Calculations in Dynasys
The Final forecast is elaborated though several successive calculations
Example of TS :
b. Forecast export to SAP
Files for SAP are generated at different frequencies and time slots, depending on the GBU.
Either Dynasys sends files by email to RPA, or MFT is in charge of catching files from Dynasys server.
| Instance | GBU | Frequency | Job | Approximative Running time (CET) | Data exported |
| DP1 | TS | Every 6th of the month | Dscp DP1 Daily Static Dscp DP1 Sunday | 1am | Final forecast ETD |
| DP1 | TS/WK excluded | Every 6th of the month | Dscp DP1 Daily Static Dscp DP1 Sunday | 1am | Final forecast ETD |
| DP1 | TS/NV | Every 6th of the month | Dscp DP1 Daily Static Dscp DP1 Sunday | 1am | Final forecast ETD |
| DP1 | TS | Every Saturday | Dscp DP1 Saturday | 2pm | Final forecast ETD |
| DP2 | Composite | Manual flag in DSCP (mid month) + Every weekday Every Saturday Every Sunday | Dscp DP2 Daily Dynamic Dscp DP2 Daily Static Dscp DP2 Sunday | 6.30am 4.30am 4.30am | Final forecast |
| DP3 | Novecare | Every Saturday | Dscp DP3 Saturday | 2pm | Final forecast ETD |
| DP3 | O&G | Every Saturday | Dscp DP3 Saturday | 2pm | Final forecast ETD |
| DP5 | SpecialChem | Every 28th of the month | Dscp DP5 Daily Static Dscp DP5 Sunday | 1am 12am | Final forecast ETD |
| DiP3 | Novecare | Every Sunday | Dscp DiP3 Sunday | 1pm | Planned orders, target stock |
| DiP4 | Perox | Everyday | Dscp DiP4 Daily Export SAP | 11.55pm | Constraint demand |
| DSCP1 | SA&D | Everyday | Dscp1_Daily_Static | 0.30am | Constraint demand |
c. Import in SAP
Transaction code ZWPP_PIR_UPLOAD( program:ZWPMR0001C) is using to upload the forecast from Dynasys to SAP, there are jobs scheduled in SAP by weekly or monthly to do this uploading automatically in both PF1 and WP1.
After MRP run, SAP will generate planned independent requirements for planning or Long term Planning.
procedure to be used for WP1 :
DynaSys DP - Export Independent Requirement
Each GBU will a specific job scheduled in SAP. Below the jobs available in WP1 and PF1:
| System | GBU | Frequency | Job | Running time(CET) |
| WP1 | Composite | monthly-every 18th | PP_RCS_FC_UPLD_CM_WW | 0:10 |
| WP1 | Special chem | monthly-every 28th | PP_FC_UPLD_CH_WW | 74:00 |
| WP1 | TS | monthly-every 6th | PP_RCS_FC_UPLD_TSEXMNTH_WW | 9:00 |
| WP1 | TS | monthly-every 6th | PP_RCS_FC_UPLD_TSMONTHLY_WW | 7:00 |
| WP1 | TS/NV | monthly-every 6th | PP_RCS_FC_UPLD_TSNVMNTH_WW | 8:00 |
| WP1 | TS | every Saturday | RCS_PP_FC_UPLD_TSWK_WW | 23:00 |
| WP1 | Novecare | every Saturday | ZWPMR0001C(will change to IBM job) | 18:00 |
| PF1 | Special chem | every Saturday | FCST_UPLOAD_CH_WW_00 | 23:00 |
d. Manual output the forecast from Dynasys to SAP
1> Login AP21 with the admin access, and manual trigger the Macro( ensure there is no background running), take Special chem as an example:
After the Macro done, go to \\acew1pdscp21.eua.solvay.com\DynaSys\ITF\Files\Out\FCST\WP1 to check if the CSV file was generated correctly.
The CSV under folder WP1 or PF1 will get transferred to SAP and meanwhile this file will be copied to folder BKUP after 5 minutes, If there is any problem for the MFT Jobs please contact the MFT team(sneh.anshu-ext@solvay.com)
2> check the CSV file in SAP
Use AL11 and go to Directory: /exploit/PP/data/DYN/FCST, you can see the file size and what time it got generated.
for PF1 go to Directory:/exploit_ERP/PP/data/DYN/FCST
Be noted, the MFT will only work for the production environments, if we need to some tests in the background run from server, in QF1 we need to ask MFT team to help to manual upload the csv file to AL11 directory, if it is in WQ1 we can upload by program ZWFAU01000.
double click the file to see if it can be opened.
3> Run ZWPP_PIR_UPLOAD, select the correct variant:
4> Execute the program, there will be a loading log after complete the loading, and two log files also will send to the users if they have maintained the email address in ZDP_EMAIL_PIR( this function now only in WP1).
e. Verify the forecast in SAP
Check the import through SQ00 1/3
Check the import through SQ00 2/3
Check the import through SQ00 3/3
f. Forecast Individually checking
( Indépendant requ is the result of the netting in dynasys)
Dynasys S&OP Planning and Interface.
Please don't use MD04 to check the forecast, the data shows in MD04 is deducted by the sales order allocation.
You can use MD63 to check the full loaded forecast from Dynasys.
| # | Description | Screenshot |
|---|---|---|
| 1 | Forecast from plant 0294 material 143509 (WP1) |
|
| 2 | same with the import file Use SAP transaction code AL11 for WP1 go to Directory: /exploit/PP/data/DYN/FCST, you can see the file size and what time it got generated. for PF1 go to Directory: /exploit_ERP/PP/data/DYN/FCST | *Directory: /exploit/PP/data/DYN/FCST
|
| 3 | In Dynasys shipments requirements: | |
To check the Qty from DIP to DP was aligned. FCST export from DIP: | ||
| FCST export from DP: |
