Script Logic - *SELECT with OR

[Former Member]

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!

[former_member186338 · Accepted solution]

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

[Former Member · Accepted solution]

Thanks Vadim!