We have 100 records in table how to fetch 10 th record?

Categories >> Software >> ERP CRM >> SAP >> SAP ABAP
Suggest New Category

Question Posted / bsriabap

13 Answers
25522 Views
Accenture, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

We have 100 records in table how to fetch 10 th record?..

Answer / harish

Read table itab index 10

Is This Answer Correct ?

37 Yes

3 No

We have 100 records in table how to fetch 10 th record?..

Answer / prasad

READ TABLE itab INTO wa INDEX 10.

Is This Answer Correct ?

19 Yes

0 No

We have 100 records in table how to fetch 10 th record?..

Answer / buddula15

Using a normal SELECT statement, there is no provision to
specify a particular index number in the DB table for
fetching the required data. However, this can be done when
you are fetching data from an internal table.

Buddula

Is This Answer Correct ?

16 Yes

2 No

We have 100 records in table how to fetch 10 th record?..

Answer / rina patil

loop at itab.
if sy-tabix = 10.
read itab.
endif.
endloop.

Is This Answer Correct ?

12 Yes

4 No

We have 100 records in table how to fetch 10 th record?..

Answer / nilesh

The best method :
tables:LIKP.

select vbeln from likp into likp-vbeln .
if SY-DBCNT = 10.
exit.
endif.
endselect.

Is This Answer Correct ?

6 Yes

2 No

We have 100 records in table how to fetch 10 th record?..

Answer / krishna n

field-symbol:<ftab> type any standard table.
tables stdtable.
Assign stdtable to <ftab>.
Data ws like line type of stdtable.
Loop at <ftab> assigning ws with index 10.
write ws.
endloop.

Is This Answer Correct ?

1 Yes

0 No

We have 100 records in table how to fetch 10 th record?..

Answer / peednas

We Can Use Cursor To Get The 10Th Record from Data than
getting the table into internal table

Is This Answer Correct ?

0 Yes

0 No

We have 100 records in table how to fetch 10 th record?..

Answer / moulika

data : begin of itab occurs 0 with header line,
f1,
f2 type i,
end of itab .

loop at itab.
if sy-tabix = 10.
write : itab-f1,itab-f2.
exit.
endif.
endloop

Is This Answer Correct ?

1 Yes

5 No

We have 100 records in table how to fetch 10 th record?..

Answer / tushar

Select * from ..... package size 10.

Is This Answer Correct ?

0 Yes

4 No

We have 100 records in table how to fetch 10 th record?..

Answer / victor

You can use the limit in mysql :)

SELECT * FROM table LIMIT 9, 1;

Is This Answer Correct ?

0 Yes

9 No

Post New Answer