Exclude

[Former Member]

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

[Former Member]

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

[FredericGirod]

Hi,

I --> Include

E --> Exclude

BT --> Between

so just change the sign.

regards

Fred

[Former Member]

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

[rosenberg_eitan]

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.

[rosenberg_eitan]

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.

[paul_bakker2]

" 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

[Former Member]

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

[paul_bakker2]

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

[former_member202771]

Hi Bharani,

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

Thanks,

Anil

[RaymondGiuseppi]

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