topic Re: can we apply select statement on internal table. in Application Development and Automation Discussions

can we apply select statement on internal table.

Former Member — Mon, 09 Jul 2007 20:28:48 GMT

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

Former Member — Mon, 09 Jul 2007 20:29:55 GMT

No, but you can READ it instead.

Rob

Former Member — Mon, 09 Jul 2007 20:37:55 GMT

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.

Read table it_case where key eq 'xxx'.

bye

Gabriel

mohammed_moqeeth — Tue, 10 Jul 2007 03:10:22 GMT

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

Cheers !

Moqeeth.

Former Member — Tue, 10 Jul 2007 03:13:10 GMT

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 — Tue, 10 Jul 2007 04:07:15 GMT

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