topic Re: avoiding endselect in Application Development and Automation Discussions

avoiding endselect

Former Member — Fri, 15 Dec 2006 16:43:30 GMT

hi,

i'm doing a select on a table and i want to avoid the endselect . is there anyway to code this in order to avoid the select...endselect.

your help will be appreciated.

Regards,

ravi.

SELECT number date time

INTO (v_number, v_date, v_time)

FROM ztable

UP TO 1 ROWS

WHERE zpro = sy-repid AND

werks IN r_plant

ORDER BY number descending.

ENDSELECT.

Re: avoiding endselect

Former Member — Fri, 15 Dec 2006 16:46:19 GMT

write as select single...

SELECT single number date time

INTO (v_number, v_date, v_time)

FROM ztable

WHERE zpro = sy-repid AND

werks IN r_plant

ORDER BY number descending.

up to 1 rows also is not a problem (select...endselect) as it will fetch only 1 record and it wont hit the database too much...

Message was edited by:

Ramesh Babu Chirumamilla

Re: avoiding endselect

alison_lloyd — Fri, 15 Dec 2006 16:46:35 GMT

What are the key fields in ZTABLE and why do you want to get rid of endselect?

Re: avoiding endselect

Former Member — Fri, 15 Dec 2006 16:46:39 GMT

hi,

SELECT single number date time

INTO (v_number, v_date, v_time)

FROM ztable

UP TO 1 ROWS

WHERE zpro = sy-repid AND

werks IN r_plant

ORDER BY number descending.

This should work.

Regards,

Vinod.

Re: avoiding endselect

Former Member — Fri, 15 Dec 2006 16:49:03 GMT

Try:


data: begin of itab occurs 0,
        v_number like ztable-number,
        v_date   like ztable-date,
        v_time   like ztable-time,
      end of itab.

SELECT number date time
  INTO table itab
  FROM ztable
  UP TO 1 ROWS
  WHERE zpro = sy-repid AND
        werks IN r_plant
        ORDER BY number descending.

Rob

Re: avoiding endselect

Former Member — Fri, 15 Dec 2006 17:00:47 GMT

Ramesh,

im getting incorrect spelling or comma error. even thing seems to be perfect but i dont understand why?

Regards,

ravi.

Re: avoiding endselect

Former Member — Fri, 15 Dec 2006 17:09:46 GMT

That's because of the error in your original statment. If you put the data directly into the table or work area, you will avoid the problem.

rob

Re: avoiding endselect

suresh_s9 — Tue, 19 Dec 2006 04:58:57 GMT

Fine ur answer...

But before we going to use Select Single we must be knw the filed/fields wch r in where condition is key field or not...if it is key field it is better suppose it is not key filed "Up to 1 rows" is only better thing...

anyhow for select single no need endselect.

for up to 1 rows alos we can avoid endselect by using TABLE key word..