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
Showing results for 
Search instead for 
Did you mean: 
Read only

Frusterating report time out problems...

Former Member
0 Likes
362

Hi all,

I have designed a supply/demand report using the MD_MRP_LIST_API. I filter the record set by user select options date, MRP controller, stock segment, responsible person...etc. and display the result in a ALV grid. Problem is the report times out if not run in batch. Other programmers are resolving this issue by creating a set of variants to use as input to execute this job in batch once every hour...outputting the result to a series of flat files. I can then create a set of shells of the original program...applying a subset of the user select options to the various flat files...and then displaying the result. That all seems so hokey tho? I feel like I'm doing something wrong...I come from a JAVA background and I don't understand why this is so difficult. First of all...the API takes for ever to collect the data!! What's with that? Can't SAP provide an API that is more efficient? Second...can I create a view of the data using the API that is already stored in the DB, just waiting for me to grab it, manipulate and display? Third...can't I page? You know...display a subset of the data set while the rest of the program is working to collect more data. Straighten me out here guys...I want to learn how to do this right!!!

regards,

Mat

2 REPLIES 2
Read only

Former Member
0 Likes
318

Do you pass the planning senarion (PLSCN)?

Rob

Read only

0 Likes
318

Yea...there is a default set for planning scenario. The problem is there might be 30,000+ materials associated with a stock segment...and I have to iterate over the API to collect the data for each material. The API is incredibly slow. Other developers must have similar problems with this API...how do you overcome this issue? Can I display just part of the data while waiting for the API to finish running against all of materials? How about a view? Can I build a view using the API that will be populated with data and stored in the db...just waiting for me to filter and display? How do you guys deal with these performance issues? Waiting ten minutes for a report to display data because the API takes all that time to process a few thousand records is crazy? Come on...what's the secret?

Mat