parameters

[Former Member]

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.

[Former Member]

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

[Former Member]

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....

[Former Member]

Hi for slection options field use : in s_field

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

Thanks

Sandeep

[Former Member]

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.

[Former Member]

Hi

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.

[Former Member]

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

[Former Member]

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.