topic Re: first two entries in Application Development and Automation Discussions

first two entries

Former Member — Wed, 25 Jul 2007 14:12:09 GMT

how to get first two entries from a table.

regards,

pradeep

Re: first two entries

Former Member — Wed, 25 Jul 2007 14:13:16 GMT

select * from ztable into table itab up to 2 rows.

Re: first two entries

Former Member — Wed, 25 Jul 2007 14:14:24 GMT

read table itab with index 1.

read table itab with index 2.

Reward points if helpful

Re: first two entries

Former Member — Wed, 25 Jul 2007 14:14:48 GMT

Hi,

Use it.

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

reward if helpful

Regards

Azad.

Re: first two entries

Former Member — Wed, 25 Jul 2007 14:14:58 GMT

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

regards,

srinivas

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

Re: first two entries

Former Member — Wed, 25 Jul 2007 14:19:55 GMT

select *

from (tablename)

into table itab

up to 2 rows.

Re: first two entries

Former Member — Wed, 25 Jul 2007 14:21:01 GMT

Hi,

Try like this:

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

Regards,

Bhaskar

Re: first two entries

Former Member — Wed, 25 Jul 2007 15:31:34 GMT

how to read first 2 rows from a structure.

regards

pradeep

Re: first two entries

Former Member — Wed, 25 Jul 2007 15:33:03 GMT

Structure or internal table ??

Re: first two entries

Former Member — Wed, 25 Jul 2007 15:34:23 GMT

internal table

thanks

Re: first two entries

Former Member — Wed, 25 Jul 2007 15:47:24 GMT

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.