topic Re: regarding data selection in Application Development and Automation Discussions

regarding data selection

Former Member — Tue, 27 May 2008 05:27:51 GMT

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 ?

Re: regarding data selection

Former Member — Tue, 27 May 2008 05:32:16 GMT

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

Re: regarding data selection

Former Member — Tue, 27 May 2008 05:32:25 GMT

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.

Re: regarding data selection

Former Member — Tue, 27 May 2008 05:32:57 GMT

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

Re: regarding data selection

Former Member — Tue, 27 May 2008 05:34:44 GMT

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

Re: regarding data selection

Former Member — Tue, 27 May 2008 05:36:54 GMT

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