regarding data selection

[Former Member]

Hi,

i want to select the data on material no. based and plant based. I have four plant in the form in the form of check box and i can select one plant or two plant or three or four plant at a time. So data should get retrieved according to that selected condition. how can i do that ?

[Former Member]

Hi Vishal,

Insted of check box why didnt u use select-option. in that u can select 1 or selected or all plants according to ur requirment.

Thanks & Regards.

Khan

[Former Member]

You can first copy the data into ranges,

and then use ranges in select statment.

like ,

if 1st checkbox is ticked ,you can append the value of 1st checkbox into ranges,

if two checkboxes are ticked,

then append two values.

Reward if helpful,

Regards,

Talwinder.

[Former Member]

use if condition to validate all check box whenever a check box is enabled add to an internal table (type ranges) for plant so that u cud use this suring SELECT

[Former Member]

instead of check u can go for select option.....

if ur using check box...

if checkbox = 'X'

pass plant code to a variable.

endif..

same u do for all..

and get all the plant in a variable.......

and pass it in the select statement

if it is usefull Plz Reward

Regards

Anbu

[Former Member]

Hi,

better create an internal table like select options structure(Sign,option,werks low and high ) and append the four plants to that based on check boxes and use the same in Select * IN i_werks.

Rajesh