topic Re: parameters in Application Development and Automation Discussions

parameters

Former Member — Thu, 19 Apr 2007 10:24:52 GMT

Hi Gurus ,

I have a requirement where in i have to output data using any of those Five Parameters or Select-options.

If i dont write anything in those parameters then it should give me all the values of that table or else if i write some value in some particular parameter then it should give me values of only the input value.

Please help.

Points will be given nicely.

Regards,

Roshan Lilaram.

Re: parameters

Former Member — Thu, 19 Apr 2007 10:26:54 GMT

Hi,

You have to use select-options then.

In your query just use like this

Select bla bla bla

from table A

where a1 <b>IN so_abc</b>.

so_abc is your select-options.

Cheers.

Victor

Re: parameters

Former Member — Thu, 19 Apr 2007 10:27:59 GMT

Hi as per your requirement you MUST declare the variables as SELECT-OPTIONS.

PARAMETERS will not give all the values if the PARAMETER is BLANK.

Only SELECT-OPTIONS will do so.

Then in SELECT use like this

SELECT *

from mara

into table t_mara

where MATNR IN S_MATNR....

Re: parameters

Former Member — Thu, 19 Apr 2007 10:30:08 GMT

Hi for slection options field use : in s_field

For parameter field you have to write select queries for different condition.

Thanks

Sandeep

Re: parameters

Former Member — Thu, 19 Apr 2007 10:36:08 GMT

Use select-options:

If you want to use parameter then select-option as follows:

SELECT-OPTIONS sel FOR f NO-EXTENSION NO INTERVALS.

The above statements acts as PARAMETER.

Re: parameters

Former Member — Thu, 19 Apr 2007 10:38:15 GMT

As per ur requirement you need to use select options instead of parameters bcoz if u take parameters you need to put '=' in where condition, if you dont give any values in the parameters no data will be displayed where as in select-options if you give some values in select options it will display the data which matches the condition else it will display all the values of the table.

Regards

Haritha.

Re: parameters

Former Member — Thu, 19 Apr 2007 10:39:14 GMT

Hi Roshan,

u've to use select-options for ur requirement,

u can use the select-option declarations along with the no-interval and no-extension additions to make select-options look similar to parameters and yet avail the advantage of select-option.

check these 2 links and code accordingly

http://help.sap.com/saphelp_47x200/helpdata/en/9f/dba76035c111d1829f0000e829fbfe/content.htm

http://help.sap.com/saphelp_47x200/helpdata/en/9f/dba76d35c111d1829f0000e829fbfe/content.htm

Re: parameters

Former Member — Thu, 19 Apr 2007 11:31:59 GMT

Thank you guru's.

I have another connected doubt,

NOw my query is solved using se38 but here i am doing dialog programming and there i am getting weird outputs,

I thing my select options are not being detected in the screen.

Please help me detect my select options of se38 into the screen.