topic Re: Select -options Doubt! in Application Development and Automation Discussions

Select -options Doubt!

Former Member — Sat, 16 Jun 2007 11:38:23 GMT

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

Re: Select -options Doubt!

kiran_k8 — Sat, 16 Jun 2007 11:44:07 GMT

100

Re: Select -options Doubt!

Former Member — Sat, 16 Jun 2007 11:46:17 GMT

Hi!

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

Re: Select -options Doubt!

Former Member — Sat, 16 Jun 2007 11:53:46 GMT

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)

Re: Select -options Doubt!

Former Member — Sat, 16 Jun 2007 11:56:08 GMT

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

Re: Select -options Doubt!

Former Member — Sat, 16 Jun 2007 12:15:05 GMT

Hi!

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

Low High Sign Option

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

Thanks

Re: Select -options Doubt!

Former Member — Sat, 16 Jun 2007 12:33:20 GMT

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.

Re: Select -options Doubt!

Former Member — Sat, 16 Jun 2007 12:47:50 GMT

Thanks