where clause

[Former Member]

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

[RichHeilman]

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

[Former Member]

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

[Former Member]

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.

[Former Member]

thanks rich and darshil.

[Former Member]

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.