Skip to Content
author's profile photo Former Member
0
Former Member

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

Posted on Jul 02, 2010 at 07:14 AM 353 Views

Hi all ,

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

PLease help me in this.

Regards,

Chandu .

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

5 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jul 05, 2010 at 02:03 PM
    1

    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

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member
      Jul 06, 2010 at 08:27 AM

      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

  • author's profile photo Digambar Narkhede
    Digambar Narkhede
    Posted on Jul 02, 2010 at 08:57 AM
    0

    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

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member
      Nov 22, 2011 at 09:12 PM

      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

    Comment on This Answer
  • author's profile photo Former Member
    Former Member
    Posted on Jul 02, 2010 at 09:54 AM
    0

    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.

    Add a comment
    10|10000 characters needed characters exceeded

    Comment on This Answer
  • author's profile photo Former Member
    Former Member
    Posted on Jul 02, 2010 at 10:05 AM
    0 
    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 29, 2011 at 01:44 PM
    0

    This message was moderated.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.