topic Re: Regarding SELECT statement in Application Development and Automation Discussions

Regarding SELECT statement

Former Member — Thu, 23 Nov 2006 06:33:12 GMT

Hi All,

I have a question regarding SELECT statement in ABAP.

Can we restrict number of rows to be fetched from SELECT statement.

Ex: Select * from VBAK INTO I_VBAK.

Suppose i want to restrict above statement to fetch only 50 rows is it possible!

I don't want to fetch all the data and then delete rows more than 50 i want to restrict in Select statement itself.

Thanks in advance.

Thanks.

Deep.

Re: Regarding SELECT statement

Former Member — Thu, 23 Nov 2006 06:34:59 GMT

used upto 50 rows..

Re: Regarding SELECT statement

Former Member — Thu, 23 Nov 2006 06:35:15 GMT

yes, like

Select * from VBAK INTO I_VBAK. upto rows 50.

More details you can take online help.

Regards

Shashi

Re: Regarding SELECT statement

Former Member — Thu, 23 Nov 2006 06:35:17 GMT

SELECT *

FROM VBAK

INTO TABLE T_VBAK

UP TO 50 ROWS.

Re: Regarding SELECT statement

anversha_s — Thu, 23 Nov 2006 06:35:48 GMT

hi,

chk this.

Report Z_Difference 
Message-id 38 
Line-Size 80 
Line-Count 0 
No Standard Page Heading. 
* 
Start-Of-Selection. 
 
Data: w_Single type Posnr, 
t_Rows type standard table of Posnr 
initial size 0 
with header line. 
* 

Select Posnr 
into table t_Rows 
from zDifference 
up to 50 rows 
order by Posnr descending. 
* 

Write :/ 'Up to 1 rows :'. 

Loop at t_Rows. 
Write t_Rows. 
EndLoop.

rgds

anver

Re: Regarding SELECT statement

Former Member — Thu, 23 Nov 2006 06:36:37 GMT

Select * from vbak into table i_vbak up to 50 rows.

Re: Regarding SELECT statement

Former Member — Thu, 23 Nov 2006 06:37:13 GMT

hi,

Please see the following.

report znave_0001.

data: begin of itab occurs 0,

matnr type mara-matnr,

maktx type makt-maktx,

end of itab.

parameters: p_rows type i.

select mara_{matnr makt}maktx into table itab from mara

inner join makt on mara_{matnr = makt}matnr up to p_rows rows.

loop at itab.

write:/ itab-matnr, itab-maktx.

endloop.

Select * from VBAK INTO I_VBAK upto 50 rows .

Naveen

Re: Regarding SELECT statement

Former Member — Thu, 23 Nov 2006 06:37:21 GMT

HI Deep,

U can use the fallowing statement

Select * from VBAK INTO Table I_VBAK up to 50 rows.

Regards,

Kasi. S

Re: Regarding SELECT statement

former_member215243 — Thu, 23 Nov 2006 06:37:55 GMT

Hi Deep,

U cud use 'UP TO 50 ROWS' in ur select query. Check the following code.

DATA: WA_SCUSTOM TYPE SCUSTOM.

SELECT * FROM SCUSTOM INTO WA_SCUSTOM UP TO 50 ROWS

WHERE CUSTTYPE = 'B'

ORDER BY DISCOUNT DESCENDING.

WRITE: / WA_SCUSTOM-ID, WA_SCUSTOM-NAME,

WA_SCUSTOM-DISCOUNT.

ENDSELECT.

Regards,

Johnson