topic Re: selection table in Application Development and Automation Discussions

selection table

Former Member — Wed, 27 Dec 2006 19:18:18 GMT

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

Re: selection table

Former Member — Wed, 27 Dec 2006 19:20:55 GMT

Hi,

Try this..

L_t_RANGE-SIGN = 'E'.

L_t_RANGE-option = 'EQ'.

L_t_RANGE-low = 'Y'.

Thanks,

Naren

Re: selection table

Former Member — Wed, 27 Dec 2006 19:23:50 GMT

thanks,

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

Re: selection table

RichHeilman — Wed, 27 Dec 2006 19:24:34 GMT

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

Re: selection table

Former Member — Wed, 27 Dec 2006 19:26:58 GMT

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 = 'E'.

L_t_RANGE-option = 'EQ'.

L_t_RANGE-low = 'Y'.

(or)

change the ranges as

L_t_RANGE-SIGN = 'I'.

L_t_RANGE-option = 'EQ'.

L_t_RANGE-low = 'Y'.

Use ranges in SELECT query as NOT IN cluase.

Thanks,

Vinay