Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

SCM Upgrade issue

Go to solution
Former Member

‎2010 Apr 29 12:25 AM

0 Likes
557

Hi,

We are doing the upgrade from SCM 5.0 to SCM 7.0 ..

When I'm trying to run the Report /SAPAPO/DELETE_PP_ORDER,Tthe Program /SAPAPO/DM_MATLOC_READ which has undergone some changes after the is causing the time out issue.

The use of temporary internal table u201Clt_matloc_id_tu201D is causing the performance issue. This happens when Program tries to delete the data from this temporary table (after it is done with the use of this table) and there is a large amount of data that has to be deleted..

Note : This was not there in there in the older version...The Job which runs the program is taking only 20 minuites and in the new version its 3hrs...

Any pointers to improove the performance of this prog...

Thanks

Lavanya

1 ACCEPTED SOLUTION
Read only

Go to solution
DavidLY
Product and Topic Expert
Product and Topic Expert

‎2010 Apr 29 1:37 AM

0 Likes
521

Hello,

Check SAP note 1434334.

Regards,

David

Hi,

We are doing the upgrade from SCM 5.0 to SCM 7.0 ..

When I'm trying to run the Report /SAPAPO/DELETE_PP_ORDER,Tthe Program /SAPAPO/DM_MATLOC_READ which has undergone some changes after the is causing the time out issue.

The use of temporary internal table u201Clt_matloc_id_tu201D is causing the performance issue. This happens when Program tries to delete the data from this temporary table (after it is done with the use of this table) and there is a large amount of data that has to be deleted..

Note : This was not there in there in the older version...The Job which runs the program is taking only 20 minuites and in the new version its 3hrs...

Any pointers to improove the performance of this prog...

Thanks

Lavanya

Reply
2 REPLIES 2
Read only

Go to solution
DavidLY
Product and Topic Expert
Product and Topic Expert

‎2010 Apr 29 1:37 AM

0 Likes
522

Hello,

Check SAP note 1434334.

Regards,

David

Read only

Go to solution
Former Member

‎2010 Apr 29 4:39 AM

0 Likes
521

Thank you so much David for you answer...But it seems that note can be applied only to releases 5 and 5.10.. Can you please let me know if there is any other note applicable in this area....

Thanks Again...

Lavanya..

Edited by: LAVANYA CHAVA on Apr 29, 2010 6:12 AM