topic Re: LOW and HIGH fields in Application Development and Automation Discussions

LOW and HIGH fields

Former Member — Tue, 08 Jul 2008 10:48:57 GMT

Hi experts,

could you tell me a bit more about LOW and HIGH fields?

I would like to know, whether the following two rows are equal or not?

If I have LOW and HIGH it means the values beetwen the two values, doesn't it?

If I'm not filling the OPTION with BT, do the program know that it is a range beetwen the values?

SIGN OPTION LOW HIGH

I 00001000 00002000

I BT 00001000 00002000

Re: LOW and HIGH fields

Former Member — Tue, 08 Jul 2008 10:51:37 GMT

Mentioned 2 rows are not similar.

U need to mention option='BT' if u want a range between low and high..

Regards,

Aparna

Re: LOW and HIGH fields

Former Member — Tue, 08 Jul 2008 10:51:43 GMT

hiiii

yes you are right.its only a LOW HIGH values that is lower limit & upper limit only.you give it manually or in select option.its same..& you can use BT also for getting values in between that low & high value.

it will give you same result all the available values between 0000 & 0002.

regards

twinkal

Re: LOW and HIGH fields

Former Member — Tue, 08 Jul 2008 10:51:48 GMT

If I have LOW and HIGH it means the values beetwen the two values, doesn't it?

Yes..

If I'm not filling the OPTION with BT, do the program know that it is a range beetwen the values?

U'll get a short dump ...

Re: LOW and HIGH fields

Former Member — Tue, 08 Jul 2008 10:54:52 GMT

Hello

In SELECT-OPTIONS - there are no difference.

Your two rows are equal.

Re: LOW and HIGH fields

prasanth_kasturi — Tue, 08 Jul 2008 10:56:16 GMT

Hi,

YES, the two statements are same

If I have LOW and HIGH it means the values beetwen the two values, doesn't it?

Hi the ans in this case may be two types

Case 1 : if you use sign I it gets values between the low and high

case 2 : If you use sign E it gets values greater than High and lesser than low

example take low as 1 and high as 100.

then when you use I you get values from 1 to 100

when E you get values < 1 and >100

If I'm not filling the OPTION with BT, do the program know that it is a range beetwen the values?

By default option is BT

regards

prasanth

Re: LOW and HIGH fields

Former Member — Tue, 08 Jul 2008 11:10:53 GMT

Hi,

Actualy select options internaly behaves as internal table to specify the selection criteria of input value or range.

Take the answers in sequences,

1> YES, the two statements are same

2> NOT EXACTLY.If LOW and HIGH is specified all the values

which comes in between them will be counted but issue

comes in LOW and HIGH values. if you give SIGN = I

both will be included if you give SIGN = E they will not.

3> The default value of OPTION is BETWEEN. So if won't

specify any, it will take BETWEEN.

Reward if found helpful.

Anirban Bhattacharjee

Re: LOW and HIGH fields

Former Member — Tue, 08 Jul 2008 11:21:59 GMT

HI,

check this code.

if you dont mention Option "BT' or some thing else.

the program will give a dump.

RANGES: matnr FOR mara-matnr.

DATA: i_mara LIKE mara OCCURS 0 WITH HEADER LINE.

matnr-low = '111'.

matnr-high = '115'.

*matnr-option = 'BT'.

matnr-sign = 'I'.

APPEND matnr.

SELECT * FROM mara INTO TABLE i_mara

WHERE matnr IN matnr.

Re: LOW and HIGH fields

Former Member — Tue, 08 Jul 2008 11:37:28 GMT

Hi,

Whenever you want to search simple as well complex data search(range include, range exclude) , wa always prefer to use SELECT-OPTIONS.

One internal table is generated implicitly with the same data object name as the name of SELECT-OPTIONS

This internal table contains 4 columns...These are SIGN OPTION LOW HIGH

SIGN column contains:- INCLUSIVE or EXCLUSIVE

OPTION column contains:- logical expression like > , < , <>, = , >= , <= etc.

LOW column contains:- Lower Value.

HIGH column contains:- Higher Value.

Q: If I have LOW and HIGH it means the values beetwen the two values, doesn't it?

A: Yes, it is correct. But it can be INCLUDE or EXCLUDE also.

Q: If I'm not filling the OPTION with BT, do the program know that it is a range beetwen the values?

A: In case of INCLUDE you need NOT to enter BT because it is the default one. But in case of EXCLUDE you neet to enter the OPTION.

With Regards,

Rupinder

Re: LOW and HIGH fields

Former Member — Tue, 08 Jul 2008 11:45:20 GMT

Hi Mr white,

The given two rows are not equal.

Each select-option parameter is treated as

internal table with the following fields.

Sign Option Low High

I / E BT Single value High value in case of BT

I/E - Include / Excluding

Option - You can provide options like Between

(provide Low and High), Equal to (single value),

Not Equal to, Pattern (A* - Low value to B* - High value)

etc.

If you are filling the OPTION with BT, program

will consider it as EQUAL TO LOW Value only.

Re: LOW and HIGH fields

Former Member — Tue, 08 Jul 2008 11:49:31 GMT

Thanks for the answers

Re: LOW and HIGH fields

Former Member — Tue, 08 Jul 2008 11:54:24 GMT

Actually

if You provide values in low and high it will consider as BT (Between).

Sorry for the wrong input.

Re: LOW and HIGH fields

Former Member — Tue, 08 Jul 2008 12:03:29 GMT

Hi,

Yes, both the statements are same. Both brings records between LOW and HIGH.

try this example.


tables :
 spfli.
select-options:
  s_carrid for spfli-carrid.

initialization.
 s_carrid-low  = 'AA'.
 s_carrid-high = 'LH'.
 s_carrid-sign = 'I'.
*s_carrid-option = 'BT'.   
   *** "  Once uncomment the above OPTION  and check.

 append s_carrid.

 start-of-selection.
 data:
   t_spfli like standard table of spfli with header line.

  select * from spfli into table  t_spfli where carrid in
s_carrid.

loop at t_spfli.
write  :/  t_spfli-carrid,t_spfli-connid,t_spfli-cityfrom.
endloop.

Regards,

Rajitha.

Re: LOW and HIGH fields

Former Member — Wed, 10 Aug 2016 14:47:50 GMT

What to do in case of multiple select-option case??

Re: LOW and HIGH fields

Former Member — Wed, 10 Aug 2016 14:48:02 GMT

What to do in case of multiple select-option case??