topic Re: Need doubt clarification in Application Development and Automation Discussions

Need doubt clarification

Former Member — Thu, 01 Nov 2007 07:03:59 GMT

Now i have a report with select-option and parameter both. My requirement is i want to change the parameter input as a select-option input(RANGE). If i modified its need any changes in select statments or not. only if i make changes in declaration area its enough or its need select statment modification also ? i have little bit confusion kindly help this.

my statement is

PARAMETERS: P_STRUCT(4) TYPE C .

SELECT-OPTIONS: S_MATNR FOR MARC-MATNR.

i want to change the parameter into select-option. Its need any select statment modification?

Thanks,

Mohana

Re: Need doubt clarification

former_member386202 — Thu, 01 Nov 2007 07:06:27 GMT

Hi,

Yes, you have to change your query according to that.

just change " where s_struct IN s_struct".

Regards,

Prashant

Re: Need doubt clarification

Former Member — Thu, 01 Nov 2007 07:07:50 GMT

hi,

you can change directly from parameters to select-options.

in select statement you need to change replace 'LIKE' with 'IN'.

No more changes are to be done anywhere else.

Re: Need doubt clarification

Former Member — Thu, 01 Nov 2007 07:08:57 GMT

Hi,

If you modify this you have to take care of select Queries and condition statements.

Instead you can do one thing, Click <b>Search Icon</b>, next to print icon.

and give P_STRUCT and click enter.

Now where ever this variable comes there will be = symbol in comparision.

Now change it to <b>IN</b>.

This will be sufficient

Re: Need doubt clarification

Former Member — Thu, 01 Nov 2007 07:09:37 GMT

yes ,

in select query you must have written

where structure = p_struct

now you need to change it to

where structure IN s_structure.

reward and close the thread if answered.

regards

taher

Re: Need doubt clarification

Former Member — Thu, 01 Nov 2007 07:25:25 GMT

Hi Mohana,

Change P_STRUCT to S_STRUCT in select-options.

In Select statement use ( IN S_STRUCT ) instead of ( = P_STRUCT).

Reward pts if usefull.

Srimanta

Re: Need doubt clarification

Former Member — Thu, 01 Nov 2007 07:35:04 GMT

Can any one plz tell if the parameter variable not a table field. But i need a range for that, so how to convert that parameter field into select-option or range input ?

plz guid me

Mohana