2008 May 27 6:27 AM
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 ?
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
2008 May 27 6:32 AM
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
2008 May 27 6:32 AM
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.
2008 May 27 6:32 AM
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
2008 May 27 6:34 AM
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
2008 May 27 6:36 AM
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
| User | Count |
|---|---|
| 6 | |
| 2 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |