Regarding SELECT statement

[Former Member]

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.

[Former Member]

used <b>upto 50 rows..</b>

[Former Member]

yes, like

Select * from VBAK INTO I_VBAK. upto rows 50.

More details you can take online help.

Regards

Shashi

[Former Member]

SELECT *

FROM VBAK

INTO TABLE T_VBAK

<b> UP TO 50 ROWS.</b>

[anversha_s]

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

[Former Member]

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

[Former Member]

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.

<b>parameters: p_rows type i.</b>

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

inner join makt on mara_{matnr = makt}matnr <b>up to p_rows rows</b>.

loop at itab.

write:/ itab-matnr, itab-maktx.

endloop.

OR

Select * from VBAK INTO I_VBAK upto 50 rows .

Naveen

[Former Member]

HI Deep,

U can use the fallowing statement

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

Regards,

Kasi. S

[former_member215243]

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