topic Re: Parameters on selection-screen in Application Development and Automation Discussions

Parameters on selection-screen

Former Member — Wed, 04 Feb 2009 10:54:24 GMT

Hi experts,

PARAMETERS: p_bukrs LIKE bseg-bukrs.

select * from <table>

into corresponding fields of table itab

where

bukrs eq p_bukrs.

If I don't fill p_bukrs on the selection screen the selection won't find any data. Why is it?

If p_bukrs is empty it should select all the records no regarding to the bukrs, am I right?

Re: Parameters on selection-screen

Sm1tje — Wed, 04 Feb 2009 10:58:27 GMT

not in the case of a parameter, only for select options. So you are not right.

Edited by: Micky Oestreich on Feb 4, 2009 11:59 AM

Re: Parameters on selection-screen

Former Member — Wed, 04 Feb 2009 10:58:28 GMT

if you don't fill the parameters, there is no match with the query constraint

Re: Parameters on selection-screen

Former Member — Wed, 04 Feb 2009 10:59:36 GMT

Hi,

Choose else condition

that ehen not enter any paremeter than else select query will executed


select * from <table>
into corresponding fields of table itab

thanks

Arun Kayal

Re: Parameters on selection-screen

Former Member — Wed, 04 Feb 2009 11:01:42 GMT

Hi mrwhite,

Yes your right, if you dont select any value on the selection screen paramers it will fetch all the records from the table.

Thanks

Kiran

Re: Parameters on selection-screen

shishupalreddy — Wed, 04 Feb 2009 11:01:58 GMT

Hello ,

Please remember the below Points:

Paramters : If no value filled it wont select any data from the database , Even if u want the same functionality u can use Select-options with 'NO-INTERVALS' addition and use IN operator within the select .

Select-options will select all the records of the table if u wont give any input.

Regards,

Re: Parameters on selection-screen

former_member217544 — Wed, 04 Feb 2009 11:02:30 GMT

Hi,

if you want to select all the records then it should not be EQ, it must be "LIKE".


PARAMETERS: p_bukrs LIKE bseg-bukrs.

if p_bukrs is initial.
p_bukrs = '%' .
endif.

select * from <table>
into corresponding fields of table itab
where
bukrs like p_bukrs.

Regards,

Swarna Munukoti.

Re: Parameters on selection-screen

Former Member — Wed, 04 Feb 2009 11:03:38 GMT

So if I use a parameter, then I should declare it as an obligatory field or with default value.

Re: Parameters on selection-screen

Former Member — Wed, 04 Feb 2009 11:04:14 GMT

Hello ,

make select optin as follows:

select-options:p_bukrs for sy-datum no-extension no intervals.---->this will be like parameter

select * from <table>

into corresponding fields of table itab

where

bukrs in p_bukrs.

this will work.

parameter with obligatory is better

Edited by: pratyush v on Feb 4, 2009 12:09 PM

Re: Parameters on selection-screen

Former Member — Wed, 04 Feb 2009 11:10:02 GMT

Hey Mr.White ,

I am just sharing a sample code of SCARR table .

Parameter p_carrid here is not taking all the values but just the value what you give .

check this out n hope it helps!

TABLES :

scarr .

PARAMETERS :

p_carrid LIKE scarr-carrid .

TYPES :

BEGIN OF type_s_flight ,

carrid TYPE scarr-carrid ,

END OF type_s_flight .

DATA :

fs_flight TYPE type_s_flight .

DATA :

t_flight LIKE

STANDARD TABLE

OF fs_flight .

SELECT *

FROM scarr

INTO CORRESPONDING FIELDS OF TABLE t_flight where carrid eq p_carrid .

LOOP AT t_flight INTO fs_flight .

WRITE :

fs_flight-carrid .

ENDLOOP.

All the best!!

Regards,

Amuktha .

Edited by: Amuktha Naraparaju on Feb 4, 2009 12:10 PM