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
Forecast export to SAP
Each GBU will a specific job scheduled in SAP, Below is 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 | 4: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 |
Data fields and Calculations for the forecast export to SAP( example of TS):
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 \\wdcdyap21.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).
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
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: |
