topic Re: Range in Application Development and Automation Discussions

Range

former_member39123 — Mon, 28 May 2007 10:02:37 GMT

Hi experts,

if I use a range and I have:

table-sign = 'E' .

table-option = 'BT' .

What means sign = E ?

BT means between ?

Thanks,

Vito

Re: Range

Former Member — Mon, 28 May 2007 10:04:32 GMT

E-Excluding(Are not acceptable in the value range, like NE - Not Equal to)

I-Including(Are acceptable in the value range, like EQ -Equal to)

Hope this will solve ur problem..

<b><u>Dont forget to reward all the useful replies</u></b>

Sudheer

Re: Range

Former Member — Mon, 28 May 2007 10:05:49 GMT

sign E means excluding option BT means between it will exclude the value of range which you have defined in low and high value from your select query (if you are using select option there).

regards

shiba dutta

Re: Range

Former Member — Mon, 28 May 2007 10:10:02 GMT

hi,

in ranges or for select options we have 4 options.

1. low -> starting value or lowest value

2. high-> endind value or highest value.

3. sign -> 'E' or 'I' : include or exclude.

i.e means that both low and high values to be included in list or exclude from list.

4. option -> bt for between

in -> range of values

like -> for strings,

.......

if helpful reward some points.

with regards,

suresh babu aluri.

Re: Range

Former Member — Mon, 28 May 2007 10:10:35 GMT

E means excluding some perticular values for that range. Suppose you want to make a range where you will select the material from 100 to 1000 but you dont want the material from 300 to 400, then the range tablewill be like following:

TABLES: LFB1.

RANGES: R_MATNR FOR MARA-MATNR.

R_MATNR-SIGN = 'I'

R_MATNR-OPTION = 'EQ'

R_MATNR-LOW = '100'

R_MATNR-LOW = '1000'

APPEND R_MATNR.

R_MATNR-SIGN = 'E'

R_MATNR-OPTION = 'EQ'

R_MATNR-LOW = '300'.

R_MATNR-HIGH = '400'

APPEND R_MATNR.

now,

select matnr from mara into it_matnr whele matnr in R_MATNR.

will select all the material from 100 to 1000 except the material fall in the range 300 to 400.

Re: Range

Former Member — Mon, 28 May 2007 11:10:53 GMT

Hi,

E stands for “exclusive” (exclusion criterion - operators are inverted)

Regards,

Bhaskar