topic how to avoid time out error in abap program in Application Development and Automation Discussions

how to avoid time out error in abap program

Former Member — Wed, 26 Mar 2008 13:13:38 GMT

How to avoid time out error in abap program

based on performance wise i want please help

Re: how to avoid time out error in abap program

Former Member — Wed, 26 Mar 2008 13:16:33 GMT

You need to improve the performance of the report

or contact your basis to increase the time limit

otherwise schedule a background job for the same

Regards

Shiva

Re: how to avoid time out error in abap program

Sm1tje — Wed, 26 Mar 2008 13:18:12 GMT

Simple hints.

Do NOT use select within select or within loop statements, try and use joins, try and use FOR ALL ENTRIES.

For select use key fields of fields from table index.

These are just some guidelines, but in general this strongly depends on your selection conditions and the number of tables you have to get your data from.

You have to be a bit more specific for us to help you.

Also have a look at transaction SE30 and click the button TIPS AND TRICKS.

Re: how to avoid time out error in abap program

Former Member — Wed, 26 Mar 2008 13:18:46 GMT

The final option is to use a commit work in your program. This resets the clock so to speak .

I do not recomment this though.

Re: how to avoid time out error in abap program

rahulkavuri — Wed, 26 Mar 2008 13:19:03 GMT

What he says is right, there is one more way make it run in the background mode

Re: how to avoid time out error in abap program

Former Member — Wed, 26 Mar 2008 13:22:51 GMT

Timeout occurs when a statement exceeds its time limit.To avoid this we need to tune the statements.

I can give give you few tips for tune a select stament.

1.The order of the feilds in the select statement should be same as the order of fields in the database table.

2.It is always advisible to use the key fields when you are using the where clause.

3. Sort the internal table while using the for all entreis statements.

4.Use index in where clause if necessary.

5.When you have a read statement user binary search but before this a sort statement should be there.

6. Check your program with the Tcode ST05 and check which statement takes much time based on that tune that.