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

CSV File upload in DP Planning book swap the data among materials??

Hello Experts,

I am trying to upload Forecast Data for one of the Keyfigure for roughly 700+ materials directly into DP Planning Book. I am able to upload the data but unfortunately the Forecast data I uploads, gets swap out among other materials!!

I know the reason why it's doing that..Actually, the way Planning Book (SAP) sort the materials while fetching them into Planning Book is not right. Those materials are not not being sorted in Chronological (Neigher ascending nor descending) orders. They sorted randomly. Now, when I extract that file to upload the forecast values later, those materials in file does not carry any sort pattern. So, difficult for us to copy/paste data into the file for 700+ parts in a single shot. If I just upload the file with acsending/descending materials# order, SAP doesn't look at the correcsonding values for respective materials I am loading. These values gets swap out among different materials and makes a mess. How would I sort the materials in orders so that I can extract the file and load my forecast values simply by copy/paste?

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Dec 28, 2016 at 11:10 AM

    Hi Anu,

    Are you drilling down to some characteristic(s) before extracting/downloading the data from planning book? If yes,indeed the characteristic values get sorted...

    May be you can explain the replication steps a bit more.

    Thanks & Regards,

    Sonali

    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.