how to avoid time out error in abap program

[Former Member]

How to avoid time out error in abap program

based on performance wise i want please help

[Former Member]

Hi

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

[Former Member]

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.

[Sm1tje]

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.

[rahulkavuri]

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

[Former Member]

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.