Skip to Content
avatar image
Former Member

Script Logic - *SELECT with OR

Hi,

I need to define a variable with a select instruction, using OR to filter members based on a property, like this:

*SELECT(%EQUIP_TRGRDIST%,ID,AREA_NEGOCIO,"TIPO_EQUIP='03' OR TIPO_EQUIP='04'")

However, when I tried to execute this on UJKT transaction, I got an error saying "invalid select". Then I tried to replace the OR with an AND, just to check that there wasn't an error in the instruction (although it wouldn't get the results I wanted) and it worked perfectly.

This means that OR is not supported in the *SELECT instruction?

I know I can separate this in several *SELECT to obtain the results, just wanted to check if this is in fact true!

Thanks!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Oct 21, 2015 at 11:06 AM

    Hi Lara,

    SELECT supports multiple values for the same parameter.

    You script will be:

    SELECT(%EQUIP_TRGRDIST%,ID,AREA_NEGOCIO,"TIPO_EQUIP=03,04")

    Vadim

    P.S. Please read explanation in this note: http://service.sap.com/sap/support/notes/1747581

    Add comment
    10|10000 characters needed characters exceeded