selection table

[Former Member]

hi all,

can anyone tell me how to use selection table with option of NE?

I wrote a code like

L_t_RANGE-SIGN = 'I'.

L_t_RANGE-option = 'NE'.

L_t_RANGE-low = 'Y'.

But the error message says SIGN 'I' with option 'NE' is not allowed. Neigher does 'E'.

Thanks.

Linda

[Former Member]

Hi,

Try this..

L_t_RANGE-SIGN = '<b>E</b>'.

L_t_RANGE-option = '<b>EQ'</b>.

L_t_RANGE-low = 'Y'.

Thanks,

Naren

[Former Member]

thanks,

I tried. The same kind of error message. Sign 'E' with Option 'EQ' is not allowed.

[RichHeilman]

I actually don't have a problem with either. This program works really well. Run it and check the selection screen, check material, you can see the fields there in multiple selection.

report zrich_0002 .

data: iSEL TYPE TABLE OF RSPARAMS.
data: xsel type rsparams.


xsel-SELNAME = 'MATNR'.
xsel-KIND    = 'S'.
xsel-SIGN    = 'I'.
xsel-OPTION  = 'EQ'.
xsel-LOW     = '000000000040000692'.
append xsel to isel.

xsel-SELNAME = 'MATNR'.
xsel-KIND    = 'S'.
xsel-SIGN    = 'I'.
xsel-OPTION  = 'NE'.
xsel-LOW     = '000000000040000693'.
append xsel to isel.

xsel-SELNAME = 'MATNR'.
xsel-KIND    = 'S'.
xsel-SIGN    = 'E'.
xsel-OPTION  = 'EQ'.
xsel-LOW     = '000000000040000694'.
append xsel to isel.



submit RM07DOCS
        via selection-screen
                with selection-table isel
                          and return.

This program runs transaction MB51

Regards,

Rich Heilman

[Former Member]

Hi Linda,

You didnt have an option on NE for OPTION parameter to RANGES.

You can use SIGN as E(for exclusive) in the RANGES

L_t_RANGE-SIGN = <b>'E'.</b>

L_t_RANGE-option = <b>'EQ'.</b>

L_t_RANGE-low = 'Y'.

(or)

change the ranges as

L_t_RANGE-SIGN = <b>'I'.</b>

L_t_RANGE-option = <b>'EQ'.</b>

L_t_RANGE-low = 'Y'.

Use ranges in SELECT query as NOT IN cluase.

Thanks,

Vinay