Range

[former_member39123]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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.

[Former Member]

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.

[Former Member]

Hi,

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

Regards,

Bhaskar