Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Runtime error for SELECT statement

Hi All,

I have written a SELECT statement as follows in my code.

select budat pernr aufnr vornr from AFRU

into corresponding fields of table it_vornr

for all entries in it_cats_tmp

where budat = it_cats_tmp-workdate

and pernr = it_cats_tmp-pernr

and aufnr = it_cats_tmp-rnplnr.

The table IT-CATS_TMP is having around 3000+ lines.

When control moves to this statement, the system is throwing Runtime error or its taking around 30 minutes time to execute.

If i query the same table (AFRU) in SE11 for the same set of conditions, the table displays relevent data immediately.

What might be the reason for this delay/Runtime Error?

Shall i need to change the syntax for better performance?

Your guidelines are highly appreciated......

Regards

Pavan

Tags:
Not what you were looking for? View more on this topic or Ask a question