topic Re: Selection screen ( search and exclude with same fields) in Application Development and Automation Discussions

Selection screen ( search and exclude with same fields)

Former Member — Fri, 22 Dec 2017 04:10:13 GMT

I am working on report, i have custom fileds for search and again same fileds for exclusion on selection screen. ( the values can be passed in range).

please tell me how can i pull the records from table by considering both search (inclusion) and excude ( same fileds defined for search and exclusion).

Thanks

Re: Selection screen ( search and exclude with same fields)

omer_sakar — Fri, 22 Dec 2017 06:40:04 GMT

Hi,

You can use "range". Check these links : https://help.sap.com/doc/abapdocu_751_index_htm/7.51/en-US/abaptypes_ranges.htm

https://archive.sap.com/discussions/thread/809563

Re: Selection screen ( search and exclude with same fields)

RaymondGiuseppi — Fri, 22 Dec 2017 10:10:55 GMT

Either merge the two ranges with some sign = 'I' (include) and 'E' (exclude) or some syntax like 'field IN irange AND field NOT IN erange'. That should be very easy?

Also

Insure user not allowed to mix I/E criteria in range/select-options with either coded check or prelimlinary use of SELECT_OPTIONS_RESTRICT
Perform some search of 'sql_cond - IN seltab' in online help or F1 help on Abap editor