DP- Excel Upload Issue

[Former Member]

Hi All,

I am using SCM 5.0 DP module.

I am facing some problem while uploading Historical Sales data from excel file to Planning book.

Steps

1. I download the planning book data by clicking on "Save Locally" at that time I select "Prepare file for upload at later time" and select "Save Additionla information in file"

Use comma as separator.

file saved in desktop as csv file.

2. I opend the saved file in notepad and modify the data.

3. Go to Planning Book, click on "Upload data"

Select file name and check it and then click on "Upload File".

Upload is successful..but interestingly : System doesn't show modified data or even old data.

All data are deleted and Planning book is blank.

Any thought on this issue?

Thanks,

Vipul Shah

[Former Member · Accepted solution]

Hi

There is the same problem in SCM 5.1 and there is a note fix for it:

[1131260 - Excel Upload not Working Properly|https://websmp130.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/sapnotes/index2.htm?numm=1131260&nlang=EN&smpsrv=https%3a%2f%2fwebsmp103%2esap-ag%2ede]

However this is down as relevant only for 5.1 but I am sure it will fix 5.0 as well. It may be worth opening an OSS Message on this point.

Regards

Ian

[Former Member · Accepted solution]

Please upgrade your Support Pack upto 12 or high...

After that this issue will get resolved.

[Former Member]

Upgrade your present SAP GUI version to 7.10 version of SAP GUI and test your scenario.

[Former Member]

GUI is 7.10 but still facing the problem....

Might be Support pack issue! currently it is 9

[Former Member]

Hello,

In the past we also faced similar issue on SCM 5.0 SP 09.

After Support pack upgrade to 11 it got resolved.

Please check your Support pack as well as GUI Support Pack.

Get the latest one.