topic Parameters in Application Development and Automation Discussions

Parameters

Former Member — Wed, 11 Apr 2007 09:27:52 GMT

Hi,

I have 4 parameters in the selection screen.All of which are not abligatory.

Here I have to include these parameters in the select statement depending on the data in the parameters.

If the parameters have no data the I have to write the select with out the parameters in the select statement.

If I consider the IF ENDIF or the CASE ENDCASE options, I would have to write 16 conditions which would effect the program efficiency very badly.

Is there any other way in which this problem can be resolved??

Please Help.

Thanks,

Supriya Manik

Re: Parameters

Former Member — Wed, 11 Apr 2007 09:30:52 GMT

Hi,,

Use select-options...with addition no-intervals.

this will force select-option to behave as a parameter on the screen..

when the user enters any thing it acts like a parameter else like a select-option.

select-options: s_vbeln for vbak-vbeln no-intervals.

santhosh

Re: Parameters

Former Member — Wed, 11 Apr 2007 09:35:46 GMT

Hi,

Select options with no-interval would be the best thing for your case.

Regards,

Nidhya

Re: Parameters

Former Member — Wed, 11 Apr 2007 09:37:39 GMT

Actually the four parameters data which I am refering to come from the Wepage,where we capture the data and get it to the RFC.Hence they have to be treated as parameters.

Re: Parameters

Former Member — Wed, 11 Apr 2007 09:38:13 GMT

I feel the solution given by Kaushal should hold true but in case you dont want to change it to select-option than you can use the below logic.

ranges : r_param1 for param1.

refresh r_param1.

if param1 is not blank

move param1 to r_param1-low.

move 'EQ' to r_param1-sign.

move 'I' to r_param1-option.

append r_param1.

endif.

Similary code for the other parameters (please check the values for sign and option)

your select statement

SELECT * FROM TABLE WHERE

FIELD1 in R_PARAM1 and

field2 in r_param2 etc

Regards

Anurag

Re: Parameters

Former Member — Wed, 11 Apr 2007 09:38:54 GMT

also use the no extension addition along with no intervals, which makes select-options look very much like parameter declaration.

Re: Parameters

Former Member — Wed, 11 Apr 2007 09:40:07 GMT

declare ranges

and populate them when u have a value from web page and leave them blank when u have no value.

santhosh

Re: Parameters

Former Member — Wed, 11 Apr 2007 09:40:16 GMT

while passing to RFC u can pass them as s_field1-low , will that not work as a parameter??

Re: Parameters

Former Member — Wed, 11 Apr 2007 09:43:13 GMT

hi supriya,

SELECTION-SCREEN BEGIN OF BLOCK b1 WITH FRAME TITLE text-001.

SELECT-OPTIONS : SO_SELECT FOR MARA-MATNR NO INTERVALS.

SELECTION-SCREEN END OF BLOCK b1 .

use select-options with no intervals...

now in ur select query

SELECT ....

FROM <TABLE>

INTO <INTERNAL TABLE>

WHERE <FIELD> IN <SO_SELECT>

so u dont hv to use numerous if...endif conditions nor case...endcase....even tough the select option is empty...and obligatory....

hence , select option with no intervals acts as a parameter.

I hope ur problem is solved...

reward points if useful...

regards,

Ginni...

Re: Parameters

Former Member — Wed, 11 Apr 2007 09:49:06 GMT

hi,

Even though its a parameter u internally build the select option table ..

for ex :

if the parameter u r passing is 1000 for company code.

then

u can use like this

types : begin of ty_company_code

comp_code_sign type SIGN,

comp_code_opt type option

comp_code_low type bukrs,

comp_code_high type bukrs,

end of ty_company_code.

data : it_company_code type table of ty_company_code,

wa_company_code type ty_company_code.

wa_company_code-comp_code_sign = 'I'.

wa_company_code-comp_code_option = 'EQ'.

wa_company_code-comp_code-low = '1000'.

append wa_company_code to it_company_code.

like this u can build the select option internal table for four paramaters

and use it in query like

select * from <tbname> where bukrs in it_company_code.

thanking you