Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

first two entries

Former Member
0 Likes
1,431

how to get first two entries from a table.

regards,

pradeep

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
1,403
select * from ztable into table itab up to 2 rows.

how to get first two entries from a table.

regards,

pradeep

10 REPLIES 10
Read only

Former Member
0 Likes
1,404
select * from ztable into table itab up to 2 rows.
Read only

0 Likes
1,403

Hi,

Use it.

select * from <tablename) into table <internal table> up to 2 rows.

reward if helpful

Regards

Azad.

Read only

Former Member
0 Likes
1,403

read table itab with index 1.

read table itab with index 2.

Reward points if helpful

Read only

Former Member
0 Likes
1,403

select <field names> from <table name> into table <internal table name>upto 2 rows.

regards,

srinivas

<b>*reward for useful answers*</b>

Read only

Former Member
0 Likes
1,403

select *

from (tablename)

into table itab

up to 2 rows.

Read only

Former Member
0 Likes
1,403

Hi,

Try like this:

select * up to 2 rows from mara into table i_mara.

Regards,

Bhaskar

Read only

Former Member
0 Likes
1,403

how to read first 2 rows from a structure.

regards

pradeep

Read only

0 Likes
1,403

Structure or internal table ??

Read only

0 Likes
1,403

internal table

thanks

Read only

0 Likes
1,403

hi, actualy my program is i have to call a function module which dmu_mat_bom_read

and pass the values material , plant bom_alt bom_usage and information should go back to bom_item table after that i get 8 records , from the i should read first two entries where item_category = n and 1st entrywhere item_category = l...can any please tell me how to do that..

regards,

pradeep.