topic Re: select statement in Application Development and Automation Discussions

select statement

Former Member — Fri, 23 Feb 2007 09:04:07 GMT

Hi,

I have a select statement to get the records based on some condition. I got say 1000 records. Now i need this selection for only first 250 records. Can we restict the select statement to get only the first 250 records. If so pls let me know the code how to write the select statement.

Also i don't want the code between select and endselect.

Regards,

Ramesh

Re: select statement

Former Member — Fri, 23 Feb 2007 09:05:39 GMT

You can say SELECT.....

..... UP TO n ROWS

Re: select statement

Former Member — Fri, 23 Feb 2007 09:06:05 GMT

Hello,

SELECT * FROM MARA

UP TO 250 rows

This will select only frist 250 rows.

VAsanth

Re: select statement

Former Member — Fri, 23 Feb 2007 09:07:17 GMT

Select... Upto 250 rows solves your purpose.

Regards,

Re: select statement

Former Member — Fri, 23 Feb 2007 09:08:17 GMT

YOu have to use select * from <table> up to 250 rows into wa where..

endselect.

If you want to restrict the number or records you have to use the endselect.

Other wise, you have to move the data that is selected into another internal table.

loop at itab from 1 to 250.

move-corresponding itab to itab_new.

append itab_new.

endloop.

Regards,

Ravi

Re: select statement

Former Member — Fri, 23 Feb 2007 09:08:41 GMT

hi ramesh,

do this way ..

select * from mara into table it_mara where <conditions>.

if sy-subrc = 0.
  loop at it_mara.
     lv_tabix = sy-tabix.
       if lv_tabix  >  '250'.
         delete it_mara index sy-tabix.  
       endif. 
  endloop.
endif.

Regards,

santosh

Message was edited by:

Santosh Kumar Patha

Re: select statement

Former Member — Fri, 23 Feb 2007 09:09:09 GMT

Use select upto clause.

Regards,

Prasanth

Re: select statement

Former Member — Fri, 23 Feb 2007 09:14:42 GMT

Hi,

The thing is if i give up to N rows its checking the table for the first 250 records only. But i have my data in around 1000th record in the table. Here its not getting this field for my condition given.

For example if i got some around 1000 records for the select condition, i need only firat 250 records of this.

Regards,

Ramesh

Re: select statement

Former Member — Fri, 23 Feb 2007 09:17:27 GMT

hi Ramesh,

did u check my reply?? ..

Regards,

Santosh

Re: select statement

Former Member — Fri, 23 Feb 2007 09:18:30 GMT

SELECT * FROM MARA 
               INTO itab               
               UP TO 250 rows
               WHERE xxxxxxxx

DATA itab TYPE SCUSTOM. 

SELECT * FROM SCUSTOM INTO TABLE itab 
            UP TO 3 ROWS 
          WHERE CUSTTYPE = 'B' 
         ORDER BY DISCOUNT DESCENDING. 
  WRITE: / WA_SCUSTOM-ID, WA_SCUSTOM-NAME, WA_SCUSTOM-DISCOUNT. 
ENDSELECT.

Use <b>order by field</b>, hope this solves.

Re: select statement

Former Member — Fri, 23 Feb 2007 09:24:04 GMT

Hi,

SELECT  *  FROM VBAK
                  INTO IT_TAB           
                  UP TO 250 ROWS

reward if useful.