Select -options Doubt!

[Former Member]

Hi!

I ve a doubt in select-options

Select_options: MAT_NO for mara-matnr.

say, i ve given MAT_NO-LOW = 1.

MAT_NO-HIGH = 100.

Then how many values will be in internal table MAT_NO, Whose fields are sign option low high.

Thanks

[kiran_k8]

100

[Former Member]

Hi!

Can u pls tell me how the internal table looks like for that

[Former Member]

When you create select-option,system creates internal table automatically.

select-options structure

select-options s_matnr for mara-matnr.

S_MATNR is internal table

structure of s_matnr :

Low - Low value

High - High value

Option - you can keep low to high as 'BT' or EQ,LE,GE

SIGN - I ( Inclusive,E EXCLUSIVE )

Reward Points if it is helpful

Thanks

Seshu

[Former Member]

Hi!

I want to know how the internal table is populated for all the data from 1 to 100

Low High Sign Option

1

like this can u display me how many entries will be there

Thanks

[Former Member]

In MAT_NO there will be just 1 row, and its field will have following values

sign I ( meaning INCLUDE )

option BT (meaning Between)

low 1 (value you entered)

high 100 (value you entered)

[Former Member]

As already mentioned, there will be only a single row with values:

Low High Sign Option

1 100

SIGN will have I (INCLUDING) default or E (Excluding). Option may have values BT (default), LT, etc..

When you use this select option for SELECTing data from table, you do the following;

SELECT * FROM table_name

WHERE fld1 IN select_option.

Now, the select option interpreted as follows: Include rows (assumind sign is I) with value of fld1 Between (assumind option is BT)select-option-low and select-option-high.

[Former Member]

Thanks