topic Re: Exclude in Application Development and Automation Discussions

Exclude

Former Member — Thu, 16 Oct 2014 06:11:36 GMT

Hi Everyone,

This is my code, I need to exclude my select options

ranges : v_dat for *****

v_dat-sign = 'I'.

v_dat-option = 'BT'.

V_dat-low = '00000000'.

v_dat-high = sy-datum-days.( days(03) default '01').

append v_dat.

select * from table

into coress field of table itab

where date in v_dat.

If i use this condition i am getting values....but if i use sign I or option EQ...in case all the values r selected........but for abv condition exclude selection is not wrking

Re: Exclude

FredericGirod — Thu, 16 Oct 2014 06:14:17 GMT

Hi,

I --> Include

E --> Exclude

BT --> Between

so just change the sign.

regards

Fred

Re: Exclude

Former Member — Thu, 16 Oct 2014 06:32:37 GMT

I have tried that but in output all the vales r fetched....not from the ranges given

Re: Exclude

rosenberg_eitan — Thu, 16 Oct 2014 07:26:58 GMT

Hi,

Just to eliminate potential problem .

Is field date was added after there were some data in the table ?

Do a test and try:

select * from table

into corresponding field of table ITAB

where

date in v_dat or

date EQ null or

date EQ space .

Regards.

Re: Exclude

rosenberg_eitan — Thu, 16 Oct 2014 07:36:18 GMT

Your post title is misleading .

You use 'I' sign and you call it exclude .

Next time call the post something like "Range selection does not work as expected"

Regards.

Re: Exclude

paul_bakker2 — Thu, 16 Oct 2014 09:36:58 GMT

" in case all the values r selected........but for abv condition exclude selection is not wrking "

Are the vowels missing on your keyboard?

It's not clear to me what you are saying here - what does your SELECT resolve to, what values are you actually getting, and what are you expecting?

Friendly tip: If you want quick, good quality answers you should spend a bit of time composing a legible question.

cheers

Paul

Re: Exclude

Former Member — Thu, 16 Oct 2014 10:16:01 GMT

Sorry for my words.....actually .......if i use sign 'E' in case the excluded values bt 00000 and sy-datum-days only i am getting......if iam having 10 values in my range....and in that 5 th value iam giving in the select option ]X[ exclude range in case ......not the given value is printing but all the value as usuall

Re: Exclude

paul_bakker2 — Thu, 16 Oct 2014 22:14:48 GMT

Much better but I'm sorry, that's still not clear (to me anyway). Try using sentences!

How about an example, with actual dates.

cheers

Paul

Re: Exclude

former_member202771 — Fri, 17 Oct 2014 02:30:11 GMT

Hi Bharani,

For exclude, values need to be fed in exclude tab of selection parameter.

Thanks,

Anil

Re: Exclude

RaymondGiuseppi — Fri, 17 Oct 2014 13:37:32 GMT

In a range/select-options

Use SIGN I to include, E to exclude
There is an implicit OR between every I include and a AND for every E Exclude (with a NOT) and a AND between two group
An E BT A B is not equivalent to a I NB A B, first will exclude [A, B] from selection, second will add [-∞,A] and ]B,+ ∞] to selection

Regards,

Raymond