Defining Complex Selections

[Former Member]

Hi,

What is the difference between Sign and Option in the following link:

http://help.sap.com/saphelp_webas620/helpdata/en/9f/dba71f35c111d1829f0000e829fbfe/frameset.htm

I want to exlcude a range of values ex: exclude 20081001 to 20081020.

In this case what values I shall use for Sign and Option,

I guess OPTION should be equal to NB (Not Between)

but I am not sure about SIGN..

Can some one please help me out?

Thanks,

CD

[Former Member]

Hi ,

To exclude the range, sign should be 'E' and option 'BT'

regards,

Advait

Edited by: Advait Gode on Oct 14, 2008 3:40 PM

[Former Member]

Advait thanks for the quick reply,

Can you please explain me significance of SIGN and OPTION. I went thru the help site but not quite clear.

[naimesh_patel]

Sign Could have a value from

I - Include
E - Exclude

Options could have a value from :

EQ	equal to (= Low)
NE	not equal to (<> Low)
BT	Between lower and upper value (Low <= x <= High)
NB	Outside lower and upper value (x < Low und High < x )
CP	Contains the pattern
NP	Does not contain the pattern
LT	less than than (< Low)
LE	less than or equal to (<= Low)
GT	greater than than (> Low)
GE	greater than or equal to  (>=Low)

Combination of the Sign and Option will determine the scope for that Select Option or Range.

E.g. Sign E and Option LT means Exclude where data is less than.

Regards,

Naimesh Patel

[Former Member]

Hi,

The sign is used to Include or exclude the values which meet the criteria while selecting from the database. And the options is used as a comparison operator.

So in your case if I say that SIGN should be 'E' which means exclude and OPTION as 'BT'.

What it means is that exclude the values that are between the specified range while selecting from the database.

regards,

Advait