Hi All,
We just have DP, no SNP. And also we extract forecast out of DP (LC) to a flat file through a Z program.
Now I have a new reqmt. We have some 100+ products (product no. for ex. 12345670000). These products are parent products. After the flat file extraction, the Demand on these Parent product is split into few child products (say, 12345670011, 12345670022, 12345670033, etc.. keeping the initial 9 digits same u2013 so it indicates they are one product family. The split proportions are controlled manually as per the demand). These Child products are sent further to supply chain planning. Now itu2019s planned to do this split work within DP. For some reasons, we can directly forecast child products in DP.
I am not sure which method will give the solution.
I plan to do this: Create a new PA with 3 KFs. Copy the forecast into new PA to KF1 which is input FCST. And other 2 are: APODPDANT, Final Fcst KFs. Now when the APDPDANT maintained values manually, and multiply these proportions with the values of the products in KF1 will give me the Final Fcst KF. I am confused here how to do that (regard to the CVCs, how do I assign only the parent product to child products...) and any macro can address this reqmt?
In the new PA, (MPOS), I will create the CVCs with child products also, which are not available in the current PA. So will it be a problem in TSCOPY from old PA to new PA if I copy? (I believe data will appear only on the corresponding products, leaving the child products with blank data)
We will still be adjusting the proportions manually in the future too. (We wonu2019t calculate from history).
But we need to automate this process, so that we extract forecast out of this new PA.
Any help will be highly appreciated.
Thanks
Venkat