topic Re: Read Table with condition in Application Development and Automation Discussions

Read Table with condition

Former Member — Thu, 09 Jul 2009 13:11:44 GMT

Hi,

can i write a Read table like for example,

read table itab into wa_itab with key matnr ne '4'.

as its giving me an error.

can suggest any other way to write the Read Table statement.

Thanks in advance.

Robert

Re: Read Table with condition

Former Member — Thu, 09 Jul 2009 13:13:17 GMT

Hi,

No it is not possible...Use Loop with Where Clause....

Re: Read Table with condition

Former Member — Thu, 09 Jul 2009 13:17:58 GMT

Hi,

READ with NE is not possible.

You will have to make use of LOOP.

Regards,

Ankur Parab

Re: Read Table with condition

Former Member — Thu, 09 Jul 2009 13:19:59 GMT

in the READ TABLE statement you can ONLY compare on equality, not on differences, unequality or ranges.

for your requirement use


Loop at itab into wa where XXX. "your criterias here
endloop.

Re: Read Table with condition

Sandeep_Panghal — Thu, 09 Jul 2009 13:20:00 GMT

No. use LOOP

Re: Read Table with condition

Former Member — Thu, 09 Jul 2009 13:21:10 GMT

Hi Robert,

Use Loop instead of Read statement.

Or declare itab1 like itab.

itab1[] = itab[].

delete itab1 where matnr ne '4'.

then loop it so that there will be less entries in table.

Regards,

Vijay

Re: Read Table with condition

Former Member — Thu, 09 Jul 2009 13:22:03 GMT

Hi,

it is not possible.

try this way..


"delete the material which is not equal to 4 ..now itab contains values matnr ne4
delete table itab where matnr ne '4'. 


or

loop at itab into wa_itab wher matnr ne '4'. 
"move to another table
endloop.

or

loop at itab into wa_itab .
if wa_itab-matnr ne '4'. 
 continue
"move to another table
else.
  delete itab index sy-tabix.
endif.
endloop.

prabhudas

Re: Read Table with condition

Former Member — Thu, 09 Jul 2009 13:22:28 GMT

Hi,

If matnr = '4', then you can write the read statement as

Read table itab into wa_itab with key matnr = '4'.

if matnr NE 4, then you may be having more than one record in itab, then read statement can't be used. Read statement can read only one record from itab. then you have to use Loop and endloop.

loop at itab into wa_itab where matnr = '4'.

endloop.

Hope this is helpful.

Regards

Ramesh.

Re: Read Table with condition

kesavadas_thekkillath — Thu, 09 Jul 2009 13:23:53 GMT

read table itab into wa_itab with key matnr ne '4'. "not possible

read table itab into wa_itab with key matnr eq '4'. "not possible

read table itab into wa_itab with key matnr = '4'. "Possible

Re: Read Table with condition

Former Member — Thu, 09 Jul 2009 13:30:12 GMT

Please press F1 on Read before posting basic questions - thread locked.

And please do not answer these sorts of questions.

Rob

Edited by: Rob Burbank on Jul 9, 2009 9:30 AM