topic Re: using 'read table' command in Application Development and Automation Discussions

using 'read table' command

Former Member — Mon, 02 Apr 2007 12:53:45 GMT

how to read more than one record that matches with the key

read table itab with key k1 = v1 ........................

thanks and regards

Cnu

Former Member — Mon, 02 Apr 2007 12:58:03 GMT

if more than 1 record matches then we can't use READ tsatement instead we need to use LOOP statement....

Loop at itab1.

Loop at itab2 where key1 = itab1-key1.

<do ur statements>.

endloop.

RichHeilman — Mon, 02 Apr 2007 12:58:11 GMT

In that case, you should use the LOOP statement with a WHERE clause instead of the read statement.

loop at itab where k1 = v1.

endloop.

Regards,

Rich Heilman

Former Member — Mon, 02 Apr 2007 13:02:07 GMT

hi,

for more than one record,

u have to loop through the table. and u can add where condition to the loop statement to restrict entries.

regards,

madhu

johndeconinck — Mon, 02 Apr 2007 15:14:33 GMT

Or if conditions are more complex, you can exit the loop for the records you don't want:

Example:

loop at tab.

if tab-field1 cs 'A'.

exit.

endif.

do some stuff.

endloop.

Kind regards,

John.