topic Re: where clause in Application Development and Automation Discussions

where clause

Former Member — Tue, 22 May 2007 21:28:51 GMT

i have an itab ITAB1 , with a field NAME which is supposed to have many A's, but

i have to report error if all entries are A's.

LOOP AT ITAB1 WHERE NAME .....................

WRITE: / 'ERROR'.

EXIT.

ENDLOOP.

what do i put in the where clause.

plz help

Re: where clause

RichHeilman — Tue, 22 May 2007 21:39:40 GMT

Try this.

data: counter type i.
data: total_lines type i.

LOOP AT ITAB1 WHERE name = 'A'.
  counter = counter + 1.
ENDLOOP.

describe table itab1 lines total_lines.

if total_lines = counter.
  write:/ 'Error'.
endif.

Regards,.

RIch Heilman

Re: where clause

Former Member — Tue, 22 May 2007 21:40:32 GMT

I did not quite get it.

Do you have to report an error if all the entries in internal table are 'A' or do you have to report an error if all the character in field NAME are 'A'?

Can you please give more details?

If you need to check whether all the entries in table are 'A' or not then you can use:

CLEAR FLAG.

LOOP AT ITAB1 WHERE NAME <b><> 'A'</b>.

FLAG = 'X'.

ENDLOOP.

IF FLAG = ' '.

WRITE 'ERROR'.

ENDIF.

Message was edited by:

Darshil Shah

Re: where clause

Former Member — Tue, 22 May 2007 21:49:03 GMT

Saritha,

This statement will work if you still need the EXIT.

READ TABLE itab1 INTO wa_itab1 WITH KEY name = 'A'.

if sy-subrc = 0.

WRITE: /'ERROR'.

endif.

Re: where clause

Former Member — Tue, 22 May 2007 21:49:22 GMT

thanks rich and darshil.

Re: where clause

Former Member — Tue, 22 May 2007 21:53:29 GMT

felip , i think you did not get my point.

your code returns sy-subrc as soon as it gets first A entry and reports error at very first entry.

but my situation was if all the entries were A's it should give error.

but anyways i got solution.

good try, thank you.