Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Need doubt clarification

Former Member
0 Kudos

Hi

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

1 ACCEPTED SOLUTION

former_member386202
Active Contributor
0 Kudos

Hi,

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

just change " where s_struct IN s_struct".

Regards,

Prashant

6 REPLIES 6

former_member386202
Active Contributor
0 Kudos

Hi,

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

just change " where s_struct IN s_struct".

Regards,

Prashant

Former Member
0 Kudos

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.

Former Member
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

Hi

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