cancel
Showing results for 
Search instead for 
Did you mean: 

how to upload data from Excel sheet to one of the KF in SNP Planning book

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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

Answers (2)

Answers (2)

Former Member
0 Kudos

Ok

Former Member
0 Kudos

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.

Former Member
0 Kudos

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