can we apply select statement on internal table.

[Former Member]

can we apply select statement on internal table.if yes thrn let me know how to do.

[Former Member]

No, but you can READ it instead.

Rob

[Former Member]

Hello,

No you cant....but you can do it as Rob said, or try looping under the table with a were restriction.

loop at it_case where key eq = 'xxx'

endloop.

or

Read table it_case where key eq 'xxx'.

bye

Gabriel

[mohammed_moqeeth]

Dear Sachin,

You cannot use SELECT statement on internal table.

If you want to select some rows from internal table you can LOOP the table or you can READ the table.

<u>Please check the following links for your kind reference:</u>

<b>http://help.sap.com/saphelp_nw04/helpdata/en/fc/eb35de358411d1829f0000e829fbfe/content.htm

http://www.sap-img.com/ab009.htm

http://www.itsmarc.com/crs/Clas0302.htm

http://www.sapdevelopment.co.uk/tips/tips_itab.htm

http://searchsap.techtarget.com/search/1,293876,sid21,00.html?query=whatisinternaltable&bucket=ALL</b>

Cheers !

Moqeeth.

[Former Member]

Hi Sachin,

The select statement is to get the data from DB table. So you can't use it with internal tables.

Regards,

Atish

[Former Member]

Hi,

The select statement will not use in internal table, if you want to see the internal table value use loop statement.

EXAMPLE:

**************

LOOP AT ITAB.

WRITE: 'MATERIAL NO', ITAB-MATNR.

ENDLOOP.

IF USEFULL REWARD