topic Re: query statement for internal table in Application Development and Automation Discussions

query statement for internal table

Former Member — Thu, 27 Dec 2007 10:21:47 GMT

is it possible to use a select statement to select data from an internal table? if yes, can anyone show me the codes to it? thx

Re: query statement for internal table

former_member386202 — Thu, 27 Dec 2007 10:23:43 GMT

Hi,

No you cant use . USe READ TABLE statement to read data from internal table.

READ TABLE ITAB INDEX 10.

READ TABLE ITAB WITH KEY.....

Regards,

PRashant

Re: query statement for internal table

dhruv_shah3 — Thu, 27 Dec 2007 10:25:17 GMT

Hi,

Use the Read table for reading the data from the internal table

inside the loop statement.

Regards,

Re: query statement for internal table

Former Member — Thu, 27 Dec 2007 10:25:52 GMT

hi,

if use read table how am i suppose to retrieve the number of records given a specific condition from a internal table.

Re: query statement for internal table

Former Member — Thu, 27 Dec 2007 10:51:28 GMT

Hi,

You use SELECT statement to read data from database table but not from Internal table.

For reading data from Internal table, you have to use READ statement.

To know more information on READ statement, Place cursor on READ statement and press F1.

Thanks.

Regards,

Hari

Re: query statement for internal table

Former Member — Thu, 27 Dec 2007 11:04:36 GMT

Hi,

It is not possible to write a select statement on internal table. You can use read statement on internal table.

Thanks,

Sri.

Re: query statement for internal table

Former Member — Thu, 27 Dec 2007 11:09:53 GMT

Hi Daphne,

You use SELECT statement to read data from database table but not from Internal table.

For reading data from Internal table, you have to use READ statement.

Syntax:

READ TABLE itab { table_key

| free_key

| index } result.

Effect of using read statement:

This statement reads a row from internal table itab. You have to specify the row by either naming values table_key for the table key, a free condition free_key or an index index. The latter choice is possible only for index tables. The output result result determines when and where the row contents are read.

If the row to be read is not uniquely specified, the first suitable row is read. In the case of index tables, this row has the lowest table index of all matching rows.

Reward if usefull

thanks

swaroop

Re: query statement for internal table

Former Member — Thu, 27 Dec 2007 12:14:31 GMT

hi,

use read table with key into wa...

( and then specify ur unique key)

try f1 help for read.if a record with the specified key is found then sy-subrc = 0 and wa will contain the record read.

hope this solves ur problem.

Re: query statement for internal table

ThomasZloch — Thu, 27 Dec 2007 12:25:05 GMT

for that purpose use LOOP AT ... TRANSPORTING NO FIELDS WHERE ...

and increase a counter inside the loop.

Cheers

Thomas

Re: query statement for internal table

Former Member — Fri, 28 Dec 2007 07:20:17 GMT

thx all people. my qn is solved

Re: query statement for internal table

Former Member — Fri, 28 Dec 2007 07:36:54 GMT

solved