How to load the data from flat file ( ex excel ) to Planning area directly

[Former Member]

Hi all ,

How can i load thedata fro m flat file directly to Planning area .

PLease help me in this.

Regards,

Chandu .

[Former Member]

This message was moderated.

[I813660]

Hello Chandu,

What exactly you want to load?

Is it new cvc's or the key figure values?

I believe that what you want is to load key figure values, in this case you'll need to have a excel sheet prepared to be loaded to APO. You can not simply load any sheet there.

My recommendation is to take intially this step:

Transaction /SAPAPO/SDP94, load a plannong book/data view, load a selection and load data to the planning grid.

Now find the button right over the grid called "save locally", push it and a pop-up will appear, here make the option "prepare the file to upload" and save.

Now use the saved file and this one can be used to be loaded for this planning book/data view.

Hope this could help here.

Thanks,

Luiz GIani

[Former Member]

Hi,

I think we have a number of valid suggestions shared by our friends. I would like to add one more to that which will give you a very powerful utility.

You can quickly put together an ABAP program using function module BAPI_PBSRVAPS_CHANGEKEYFIGVAL2. This will enable you to directly upload data from a file into the planning book/planning area.

The BAPI can do everything so how modular you wan the program is left to your innovation.

Hope this helps.

Thanks

Mani Suresh

[Former Member]

How can i load the data from flat file directly to Planning area?

Go to the POS (/n/sapapo/msdp_admin), right click, select 'Char combinations-Maintain'. Select "Create Characteristic Combinations" if already you hve created some CVCs. (If this is first time, choose "Create single Char Comb."). Choose any option other than "create manually". Now, chosse "From file" for the 'Load from' option and proceed. Please check the box for "Adjust Time series Objects".

Hope this answers your question.

Regards,

Guru Charan.

[Former Member]

Hi,

Just to clarify.

The last reply discusses upload of file data to create master data - CVCs.

Earlier replies talked about transaction data upload in interactive demand planning.

Regards

Datta

[Former Member]

Hi Chandu,

The best recommended practice is to upload directly into the planning book

rather than in the planning area.

If you upload it in the planning book, it indirectly gets uploaded in

the planning area as well.

Hence you can use /SAPAPO/SDP94 for this purpose

Regards

R. Senthil Mareeswaran.

[Former Member]

Thanks for your replay ..

Can you elabrate the steps how can i do that .

Thanks in advance

regards,

Chandu

[digambar_narkhede]

Hi Chandu ,

This is a standard functionality available from SCM 5.0 onwards,this option is available in interactive planning book workspace toolbar (just near to Distribution icon on the line of Graphic,Graphic icons) for download in CSV file and also upload from CSV .

One icon is for download and another for upload after doing the changes.

Please refer link [Uploading and Downloading Planning Data to Planning Book |http://help.sap.com/saphelp_scm50/helpdata/en/e2/1e2980c5314ad3aa76be32e7e29696/frameset.htm]_(http://help.sap.com/saphelp_scm50/helpdata/en/e2/1e2980c5314ad3aa76be32e7e29696/frameset.htm)_

This gives stepwise process.

regards,

Digambar

[digambar_narkhede]

If you are using version APO 5.0 + then you can directly upload the data in planning book(planning area) from an excel file.

Regards,

Digambar

[Former Member]

Hi,

Please check following URL - SAP Help for upload / download from interactive demand planning;

http://help.sap.com/saphelp_scm70/helpdata/en/fd/b3bca1be07413fb6f99163c36cf299/frameset.htm

Please note Excel Upload works only within SCM Demand Planning. SNP is not supported ( SCM 7.0)

Regards

Datta

[Former Member]

Thanks for your replay.

I am using SCM 5.0, actually i want to download one key figure data from planning book ( interactive damand plan) and made some changes and need to upload the data back to same planning book . Please help how can i do this , plz let me know detail steps.

Thanks in advance !

Regards,

Chandu

[Former Member]

download one key figure data from planning book ( interactive damand plan) and made some changes and need to upload the data back to same planning book

But, may I know why you are thinking of downloading, changing and uploading for just changing the figures for a particular key figure. You can do it in the planning book itself.

However, not all the key-figures can be changed. But, what type of key-figure you are speaking here? Is it like 'Forecast' for which the value is based on other key-figures, or is like a key-figure where some manual adjustments are to be done--so that it can be manually edited? However, in both the cases, the data can be changed in the planning book only. In first case, you can change the values of dependant key-figures and in the second case, you can change the key-figures directly.

And please note that you can change the values of the key-figures only at the detailed level. So, after loading the data in the book, use drill-down option, maintain the data at the detailed level, change the figures, and automatically, this gets reflected at the higher level.

In case you are unable to change the values, go to the 'Design' mode of the book, right-click your key-figure, under "Selected Rows", uncheck "Output Only" option. In case you are unable to see that option, then you are not authorised to change that. See if you can change the authorisations by going to the "Data View" tab in planning book configuration (/n/sapapo/sdp8b), and change the value of Status to 3.

Hope your query is answered with different solutions offered by many of the sdn colleagues here.

Regards,

Guru Charan.

[Former Member]

Hi Chandu

To download data for only for 1 key figiure, while in the planning book, select only that key figure for which you want to download the data using the filter. Then click on the 'save locally' icon and the save the file locally in your hard drive. You will see data only on that key figure in that downloaded file. Make the changes in that file and save the file as a csv file and then upload the file using the Upload data icon.

Let me know if this helps.

Rgds, Sandeep

[Former Member]

Hello all,

I have a follow up question to this discussion.

I am trying to do something similar but my question is how do we manage to upload if the number of products are large. Say the transaction data which i receive from customer is at product level (least level) and i get 20-50 products , each with its own forecast for 1 year horizon, which is updated weekly.

So is it feasible to ask planners to enter forecast values for each product and upload it one by one?

What is the best way to upload the customer forecast key figure which we receive in excel sheets ( 30+) and each sheet with 10-50 different product)

Please let me know if i am missing something fundamental here as i am relatively new to this field?

Thank you ,

Sai