Report Timeout

[Former Member]

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.

[vikram_maduri2]

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.

[Former Member]

Hi

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

[Former Member]

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

[Former Member]

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>

[Former Member]

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

rob

[Former Member]

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.