topic Re: Runtime error for SELECT statement in Application Development and Automation Discussions

Runtime error for SELECT statement

Former Member — Thu, 16 Oct 2008 11:54:12 GMT

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

Re: Runtime error for SELECT statement

Former Member — Thu, 16 Oct 2008 11:56:29 GMT

what is the Dump says. show the message and error analysis.

Re: Runtime error for SELECT statement

Former Member — Thu, 16 Oct 2008 11:58:01 GMT

Don't use into corresponding fields .

insted of this define ITAB having only fields ur have written in select statement. and keep sequence in ITAB and SELECT similar.

like as u have now : budat pernr aufnr vornr

Regards

Sachin

Re: Runtime error for SELECT statement

Former Member — Thu, 16 Oct 2008 12:02:00 GMT

what is the order of your fields in the internal table it_vornr

just show the definition of the it_vornr.

Re: Runtime error for SELECT statement

Former Member — Thu, 16 Oct 2008 12:06:18 GMT

Always avoid using 'into corresponding fields' instead declare a internal table as your requirment including only the field in the table that you want as also said by others:

select budat pernr aufnr vornr from AFRU
into 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.

With luck,

Pritam.

Re: Runtime error for SELECT statement

asik_shameem — Thu, 16 Oct 2008 12:06:24 GMT

1. Try to put WHERE conditions for KEY FIELDS.

Solution: Create a RANGE for the key fields & put that in SELECT Query.

DATA: gr_rueck TYPE RANGES OF afru-rueck.
SELECT .. WHERE rueck IN gr_rueck.

2. Avoid using CORRESPONDING FIELDS OF TABLE in SELECT.

Solution: Change internal table fields ORDER.

TYPES: 
BEGIN OF TY_VORNR,
  budat TYPE ..
  pernr TYPE ..
  aufnr TYPE ..
  vornr TYPE ..
  ... " Other fields
END OF TY_VORNR.

SELECT .. INTO TABLE IT_VORNR ...

Re: Runtime error for SELECT statement

Former Member — Thu, 16 Oct 2008 12:06:27 GMT

Hi pavan,

Do not use "INTO CORRESPONDING FIELDS".Instead use the following code ;-

select budat pernr aufnr vornr from AFRU
into 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.

-Goodluck,

Bhumika

Re: Runtime error for SELECT statement

Former Member — Thu, 16 Oct 2008 14:51:21 GMT

Thanks

Re: Runtime error for SELECT statement

Former Member — Thu, 16 Oct 2008 15:28:29 GMT

hi ,

chek ur internal table it_vornr . Should not be empty .

regards

Neetesh