topic Re: Report Timeout in Application Development and Automation Discussions

Report Timeout

Former Member — Thu, 02 Aug 2007 13:57:02 GMT

Dear All,

I have made a report that fetches data from table BSEG, BKPF, etc.

Thus it timeouts. Is there any way I can upgrade my code for getting the O/P earlier ??

Please help.

Re: Report Timeout

vikram_maduri2 — Thu, 02 Aug 2007 13:59:43 GMT

Hi,

This is due to huge number of records.

U can use selction screen & specify Parameters or Select-options.There the data will be less & U can get the data soon.

Re: Report Timeout

Former Member — Thu, 02 Aug 2007 14:07:18 GMT

Sugestions (maybe already you doing so...)

1) You can improve performance by using in where clause same order as in the tables.

2) By fetching all data to itabs and working with itabs (iternal tables).

3) To minimize data to work with by exact keys and fetching only needed fields.

also you can just make background run...

Regards

Yossi

Re: Report Timeout

Former Member — Thu, 02 Aug 2007 14:07:31 GMT

Hi,

Usually those two table will contains large number of records.so, that the queries will take a lot of time to select the data.The best way to avoid is u can use INDEXES or Possible key fields to speedd up it.

If it helps REWARD..

rgds

harris

Re: Report Timeout

Former Member — Thu, 02 Aug 2007 14:13:36 GMT

first get the data into i_bseg and i_bkpf etc.... based on your conditions and then the whole data into i_out another final internal table. then display the output.

regards,

srinivas

<b>reward for useful answers</b>

Re: Report Timeout

Former Member — Thu, 02 Aug 2007 14:22:50 GMT

Very difficult to say without seeing your code. Would you please post it?

rob

Re: Report Timeout

Former Member — Thu, 02 Aug 2007 14:41:49 GMT

Hi,

BSEG AND BKPF contains huge amount of data that’s why it is showing the message as timeout.

In select statements use Indexes and before read statements use sort statement.

In selection screen use date range.

By using the above steps it may be useful to u to avoid timed out message.

Reward points if useful.

Thanks & Regards,

Vasudeva Rao.