topic Re: Select options and parameter in Application Development and Automation Discussions

Select options and parameter

Former Member — Thu, 22 May 2008 08:16:15 GMT

We have a parameter and select option in Selection Screen, by using the parameter and select option in the select query, with out passing the any values to the Parameter and SO, how we will get the records?

Re: Select options and parameter

Former Member — Thu, 22 May 2008 08:19:12 GMT

Hi,

1.By defaultlt assigning the values to the selection-options and Parameters.

2.By creating the variant and executing with variant.

Regards,

Shiva kumar

Re: Select options and parameter

Former Member — Thu, 22 May 2008 08:19:18 GMT

If UR are writing a select ..

select * from <table>

where parameter <> p_param

and sel_optuions in SO.

You'll get data ...

Re: Select options and parameter

Former Member — Thu, 22 May 2008 08:20:58 GMT

hi ..

but i am not passing values in select options or parameter

Re: Select options and parameter

Former Member — Thu, 22 May 2008 08:22:32 GMT

Hi,

Without passing Parameter and SO, we can get data, mean Select query will fetch all records from particular table.

Ex.

REPORT Z_VER_RPG6.

data : begin of itab occurs 1,

kunnr type kunnr,

name1 type name1,

ladn1 type land1,

end of itab.

start-of-selection.

select kunnr name1 land1 into table itab from kna1.

loop at itab.

write:/ itab-kunnr, itab-name1, itab-ladn1.

endloop.

Regards,

Vishvesh

Re: Select options and parameter

Former Member — Thu, 22 May 2008 08:22:47 GMT

hi check this..

if the parameter is empty if will not work in the select statement..you can get the values for the select options with empty structures..

check this..

tables:mara .

data: begin of itab occurs 0,

matnr like mara-matnr,

end of itab .

parameters:p_matnr like mara-matnr.

select matnr from mara into table itab

where matnr = p_matnr.

loop at itab.

write:/ itab-matnr.

endloop.

it will not fetch data..

for select-options

tables:mara .

data: begin of itab occurs 0,

matnr like mara-matnr,

end of itab .

select-options:s_matnr for mara-matnr.

select matnr from mara into table itab

where matnr in s_matnr.

loop at itab.

write:/ itab-matnr.

endloop.

it will fetch data..

regards,

venkat

Re: Select options and parameter

former_member156446 — Thu, 22 May 2008 08:23:45 GMT

if the SO and parameters are blank all the data realted to that data element will be in

Re: Select options and parameter

Former Member — Thu, 22 May 2008 08:33:37 GMT

Hi ,

Use this statement,

Select * from <table name>

into table <internal table>

where <fieldname> in <select-option name> and

<fieldname> = <parameter name> .

Reward points if useful.

Thanks,

Khan.