Field routine error E:Relational operator "AND" is not supported.

[Former Member]

Hi,

I wrote the following field routine and i have the following error with the the logical expressions OR / AND:

E:Relational operator "AND" is not supported.

Can anybody help me with this?

DATA v_hsme type i.
    DATA v_totalinc type i.
    DATA v_hsme type i.
    DATA ROWCOUNT type i.

    describe table itab lines ROWCOUNT.

    read table itab into wa_itab

               with key incidencia = SOURCE_FIELDS-NROINCIDENCIA.

    clear v_hsme.
    clear v_hsba.
    clear v_hsmb.
    clear v_totalinc.

    If wa_itab-criticidad EQ 'Media' OR 'Baja'

    AND wa_itab-difhoras NE ''.

      v_hsme = 1.

      v_totalinc = rowcount.
   
      RESULT = v_hsme / v_totalinc.

    endif.

Regards,

Diego

[Former Member · Accepted solution]

Hi there,

You're using your operations incorrectly.

Use this instead:

DATA v_hsme type i.
    DATA v_totalinc type i.
    DATA v_hsme type i.
    DATA ROWCOUNT type i.
 
    describe table itab lines ROWCOUNT.
 
    read table itab into wa_itab
 
               with key incidencia = SOURCE_FIELDS-NROINCIDENCIA.
 
    clear v_hsme.
    clear v_hsba.
    clear v_hsmb.
    clear v_totalinc.
 
    If ( wa_itab-criticidad EQ 'Media' OR wa_itab-criticidad EQ 'Baja' ) 
    AND wa_itab-difhoras NE ''.
 
      v_hsme = 1.
 
      v_totalinc = rowcount.
   
      RESULT = v_hsme / v_totalinc.
 
    endif.

Hope this helps,

Regards,

Diogo.

[Former Member · Accepted solution]

Problem solved.

O brigado,

Diego

[Former Member · Accepted solution]

De nada (You're welcome)

[Former Member]

Hi,

Change your code part as:

If wa_itab-criticidad EQ 'Media' OR 'Baja'
 
    AND wa_itab-difhoras NE ''.

--->>>

If ( wa_itab-criticidad EQ 'Media' OR  wa_itab-criticidad EQ 'Baja' ) 
AND 
( wa_itab-difhoras NE '' ) .