topic Re: Defining Complex Selections in Application Development and Automation Discussions

Defining Complex Selections

Former Member — Tue, 14 Oct 2008 13:34:17 GMT

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,

Re: Defining Complex Selections

Former Member — Tue, 14 Oct 2008 13:39:38 GMT

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

Re: Defining Complex Selections

Former Member — Tue, 14 Oct 2008 13:44:41 GMT

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.

Re: Defining Complex Selections

naimesh_patel — Tue, 14 Oct 2008 13:51:36 GMT

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

Re: Defining Complex Selections

Former Member — Tue, 14 Oct 2008 14:12:50 GMT

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