topic Re: Select * from itab. in Application Development and Automation Discussions

Select * from itab.

muhammad_sohail — Thu, 28 May 2009 08:23:19 GMT

Dear All,

Can i select the data from itab.

e.g; Select * from itab into another_itab.

is it possible?

Thanks and Regards,

Muhammad Sohail

Re: Select * from itab.

Former Member — Thu, 28 May 2009 08:24:36 GMT

You cannot perform Select operation on Internal tables. You need to do loop / read operations.

Hope this will help.

Re: Select * from itab.

Former Member — Thu, 28 May 2009 08:25:07 GMT

Hi,

No, it is not possible.

aonother_itab[] = itab[].

will be the right statement.

Regards,

Pankaj

Re: Select * from itab.

Former Member — Thu, 28 May 2009 08:25:49 GMT

No, you cannot use SELECT * from internal table. SELECT is used only for Database Table.

You can read a single records from Internal Table usong READ TABLE

Else you can loop through the records , using LOOP..ENDLOOP

Re: Select * from itab.

Former Member — Thu, 28 May 2009 08:42:20 GMT

Hi,

its not possible ,compulsary you have to mention database table.

Regards,

Madhu

Re: Select * from itab.

Former Member — Thu, 28 May 2009 08:44:23 GMT

Dear Muhammad Sohail,

you cannot apply select statement on internal table. Still you can do any operation like Loop, read table on internal table.

Hope this will help you to resolve your query.

Regards,

Vijay

Re: Select * from itab.

Former Member — Thu, 28 May 2009 08:53:18 GMT

Hi,

SELECT clause is purely database oriented.

If you want to read data from one internal table into another, try using the MOVE statement or as the others rightly put it, use a READ statement on the internal table or LOOP...ENDLOOP on it.

Re: Select * from itab.

Former Member — Thu, 28 May 2009 09:01:17 GMT

Hi,

Select is only for database fetch. If you already have data in the internal table and if you wish to move the data to another internal table, Inside, loop at itab1, you can use the MOVE statment, MOVE CORRESPONDING statement etc. and append it to the second internal table.

Else you can read the internal table 1 and can move the values to the internal table 2.

Regards

Ramesh Sundaram

Re: Select * from itab.

Former Member — Thu, 28 May 2009 09:03:01 GMT

Hi,

If we can achieve something in a simple fashion then why should we go for a complicated one..

To copy the contents of an one internal table to the other, just copy the bodies like this.



itab_2[] = itab_1[]

P.S : Use of select statements have performance issues as it increases the number of database hits.

From the above statements it should be quite clear that select is used for database tables only.

No we can't copy the contents of one internal table to other using select statement.

Regards

Abhinab Mishra

Re: Select * from itab.

Former Member — Thu, 28 May 2009 09:03:20 GMT

hi select statement is only for database query

you can use read table( for single line read) or loop at (for multi line read )

can u be more specific about your operation on itab.

Re: Select * from itab.

Former Member — Thu, 28 May 2009 09:21:02 GMT

hi,

You can select data from itab using Read / loop

Synatx :

read table itab with key

loop at itab where