topic Re: Delete Exclude values from Select Options table in Application Development and Automation Discussions

Delete Exclude values from Select Options table

Former Member — Thu, 26 Jun 2008 11:25:58 GMT

Hi All,

User will select multiple selections in Select Options including both Includes and Excludes. Now I need to capture these records into another table with only includes. For example,

Low High Sign Option

1 100 I BT

5 10 E BT

20 E EQ

50 70 E EQ

Now the new should contain Include only with 1 to 100 exluding 5 to 10,50 to 70 and 20 values.

Low High Sign Option

1 4 I BT

11 19 I BT

21 49 I EQ

71 100 I EQ

If anyone has done this kind of issue ,Please suggest me how can I achieve this or share the sample code.

Thanks,

Rajani.

Re: Delete Exclude values from Select Options table

Former Member — Thu, 26 Jun 2008 11:28:37 GMT

hi,

modify the select-option.

selop-sign = 'I'.

modify selop where sign = 'E'.

regards,

madhu

Re: Delete Exclude values from Select Options table

Former Member — Thu, 26 Jun 2008 11:28:57 GMT

Hi ,

It is a difficult option , as you dont know how the user may enter the data , he can use GT or GE or LE and other possible options .

One more question why do you want to get the inlcude range ???

Regards

Arun

Edited by: Arun R on Jun 26, 2008 5:15 PM

Re: Delete Exclude values from Select Options table

Former Member — Thu, 26 Jun 2008 11:30:38 GMT

Select Option is same as ur internal table

based on your conditions just delete entries form it.

Regards

Bikas

Re: Delete Exclude values from Select Options table

Former Member — Thu, 26 Jun 2008 11:44:13 GMT

Use

LOOP AT S_variable

IF S_variable-low = <your value> or S_variable-high= <your value>

Delete S_variable index sy-tabix.

Endif .

Endloop.

I think it will help you.

Regards,

Swarup

Re: Delete Exclude values from Select Options table

vinod_vemuru2 — Thu, 26 Jun 2008 11:54:20 GMT

Hi Rajani,

I dont understand ur problem. Once u give the include and exclude conditions like u mentioned and used in SELECT query it will take care of these things

i. e. if u give input like

Low High Sign Option

1 100 I BT

5 10 E BT

20 E EQ

50 70 E EQ

Now the select will fetch the records 1- 4 , 11-19, 21-49, 71-100.

Check this in debug mode.

Why do u want to get only the included data in to one table? If u use this select option u have only included records, correct!!!.

Thanks,

Vinod.

Re: Delete Exclude values from Select Options table

Former Member — Thu, 26 Jun 2008 12:40:33 GMT

Hi Vinod,

Thanks for the response. I have the knowledge that the select options will take care of Excludes automatically. I need this requirement for BW routine. I need to capture the includes with deletion of excludes into another internal table.

Thanks,

Rajani.