on 08-24-2010 10:09 AM
Hi,
Is there any possibility to upload data from Excel to the KF in SNP Planning book?
Any transaction or any standard program or anyothher means of uploading possibility...please post the details.
Thanks for the help,
Sai Ganesh
Hi Sai,
Like in DP, upload from excel functionality is not there in SNP. Hence you may have to choose for other routes. you can choose different route based on your requirement and what key figure you would like to populate.
1. If you have small qty of data than you can simply copy paste in planning book based on whether key figure is editable or not.
2. If you have large dataset than you can create infocube and than release directly from infocube to SNP planning area using /sapapo/release_cube_to_snp. but here you have limitation. you can only release data for forecast categories i.e. FA, FB, FC and FD.
3. If you wish to release data for other key figures than..you have to add that data to time series planning area (automate process like upload to infocube --> release to TS planning area --> release to SNP). than use extended release in /sapapo/mc90 or /sapapo/lcin Tcode. Here you can release data for forecast, SNP planned orders, External procurement orders, distribution demand (SNP planned for Depl confirmed) and choose respective keyfigure.
If above three options are not relevant for your requirement than the only option I see is custom developement.
Hope this help.
Regards,
Harshil Desai
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Ok
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Sai,
We can load the Excel Data in to SNP KF in the Planning book from the interactive demand planning screen,for this you have to download the existing data in to Excel and this gives you a template of how to upload the data,then you have to modify your data as per the template and upload it.
But this is preferable only if you have to upload the data once in a while,but if you have to do it on a regular basis then you should go for custom development.
Hope this helps.
Best Regards,
Chandu.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Chandu,
Thanks for the update.
1. Atfirst, I download the data from Planning Book to Excel sheet.
2. Next step --> What is the Transaction or Program or how to upload the data from Excel sheet to Planning Book KF? What is the interface between Excel Sheet and Planning Book?
Thanks for your help.
Regards,
Sai Ganesh
User | Count |
---|---|
15 | |
4 | |
3 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.