Excel Copy paste not working after multiple drilldowns

[Former Member]

Hi

We are seeing that when we do multiple drilldowns in DP planning books and you paste a bunch of numbers from excel, the totals are not getting updated. The system is strangely not even recognizing some of the numbers pasted, even though they are still displayed. When we save and refresh, these numbers not recognized disappear and the numbers counted into totals before stays.

Example:

We have a region named NA100 that has 2 plants and each plant has 2 materials.

We load region NA100 into DP planning books, then drill down to both plants, copy from excel and paste 1000 and 2000 as forecast for each plant. The system counts these into totals and show the Total for both plants as 3000 at regiona NA100 level.

But if I drill down another level to materials:  now I have region NA100 - Plants 1 and 2 and each plant has 2 materials ( total 4 materials). Then I am copy pasting forecast for the 4 materials, let's say 100, 250, 300& 400 at the lowest level and press enter or save, the system is inconsistent and is not always considering all 4 numbers into totals. Some time I am seeing only 350 taking 100 and 250 into consideration, even though the system displays 300 and 40, it is not counting them into totals.

Has any one seen this behavior? This looks like a bug but could not find any SAP notes directly addressing this...

Thanks,

KP

[Former Member]

Hi KP,

Can you provide your system version, Enhancement pack number and SP level? It may be helpful.

Did you first download an Excel file from the DP planning book to make sure the syntax and format is correct for the upload?

The following SAP Notes may be helpful:

1404581 Unexpected values after Excel upload to planning grid
1600340 - SDP94 - uploading from file fails
1777321 - SDP94: Excel upload is not working

Best regards,

Mike

[Former Member]

Hi Mike

We are on SCM 7 SAPKY70005

The problem is more about copy paste from an excel sheet than importing and exporting from excel.

[Former Member]

Hi kp APO,

Check your source spreadsheet carefully for formatting. It may be something like numbers vs. text.

Just a guess.

You are working in DP, right?

Best regards,

Mike

[former_member1080376]

Hi KA, did you find the root cause for this behavior ??

Best regards

Jan Juhl

[Former Member]

Any suggestions please?

[m_manimaran]

Hi KP,

Please try entering values for only one plant Material level. If that aggregation works fine, then try to do it for both plants. This will help you to pin-point the issue.

Regards,

Manimaran M.

[alok_jaiswal]

Hi KP,

You can try using the upload functionality which is there in Interactive planning book to upload the keyfigure values from Excel to Planning Book.

This way values will get uploaded and aggregation/disaggregation will take place at correct level as per the configuration in planning area.

Regards,

Alok