topic Parameters & select-options in Application Development and Automation Discussions

Parameters & select-options

Former Member — Thu, 31 May 2007 05:45:09 GMT

What will happen if we execute a report without giving any value in parameter in selection screen ?

What will happen if we execute a report without giving any value in select-options in selection screen ?

Re: Parameters & select-options

Former Member — Thu, 31 May 2007 06:14:24 GMT

it will take initial values for the seletion criteria and display all the values

Re: Parameters & select-options

Former Member — Thu, 31 May 2007 06:17:34 GMT

Hi Swapna ,

If it is a parameter then it will try to select all those records from the database where the feild corresponding to the parameter is blank/initial, chances are that it would not select any record.

In case of select options , it will select all records ,i.e. it will basically ignore that condition in the where clause and select data based on other conditions in the where clause.

Regards

Arun

Re: Parameters & select-options

Former Member — Thu, 31 May 2007 06:30:49 GMT

hi,

What will happen if we execute a report without giving any value in parameter in selection screen ?

it won't fetch any record. but if we give another input filed in select statement it will fetch data depending on that filed.

What will happen if we execute a report without giving any value in select-options in selection screen ?

It will fetch all tha data contained in that field.but if we give another input filed in select statement it will fetch data depending on that filed along with this one.

Re: Parameters & select-options

Former Member — Thu, 31 May 2007 09:11:11 GMT

Hi,

if parameter and sel option is not obligatory and will run report as usual.

about filtering of data , it will assume that all values are sielected so no fileter will be added.

e.g. p_para and s_selopt doesnot contin any value

then

select ..... where matnr = p_para. will NOT retun any record.

select .... whre matnr IN s_selopt . will rerutn all recors.

Jogdand M B

Message was edited by:

Jogdand M B

Re: Parameters & select-options

Former Member — Thu, 31 May 2007 09:22:45 GMT

Hi Swapna,

<b>1) What will happen if we execute a report without giving any value in parameter in selection screen ?</b>

A) It will consider parameter's intial values based on the data type

<b>2) What will happen if we execute a report without giving any value in select-options in selection screen ?</b>

A) It will consider all the entries for that field in the table

Thanks,

Vinay

Re: Parameters & select-options

Former Member — Fri, 01 Jun 2007 05:09:17 GMT

hi swapna,

if u excute parameter without giving anything in it, then it goes to database and search abt null values in the database, then output is empty,

if u excute select-options without giving anyting in it, then it goes to database and takes all records from the database, then ouptut is all avbl records in the database.

regards,

seshu.

Re: Parameters & select-options

Former Member — Fri, 01 Jun 2007 06:38:49 GMT

Parameters: It will check if there is any record which has value as INITIAL or blank

Select-options: It will consider all records. Its as good as giving no condition at all.

Regards

Navneet

Re: Parameters & select-options

Former Member — Fri, 01 Jun 2007 16:06:16 GMT

Hi Swapna

if u didnt give any value for parameter or select-option then the select query will select all all the records from the table.

if u declare these as a mandatory then u should pass value. If u didnt give any value u cannot get any value. Ur program will goes to error.

using Al selection-screen event u can validate ur Selection-screen.

need ur reward points.

Regards

Ravi

Re: Parameters & select-options

former_member480923 — Mon, 04 Jun 2007 06:22:04 GMT

Please look at the following code to understand.

REPORT  zz_session_method.

TABLES: bkpf.

SELECTION-SCREEN: BEGIN OF BLOCK b1 WITH FRAME TITLE text-001.
PARAMETERS: p_bukrs TYPE bukrs.
SELECT-OPTIONS: s_bukrs FOR bkpf-bukrs.
SELECTION-SCREEN : END OF BLOCK b1.


DATA: t_bkpf TYPE TABLE OF bkpf.

** Selection using Parameters as initial.

SELECT bukrs FROM bkpf INTO TABLE t_bkpf
             WHERE bukrs = p_bukrs.

IF sy-subrc >< 0.
** This will select only the values from BKPF where BUKRS is equal to SPACE.
ENDIF.

** Selection Using Select Options as Initial.

SELECT bukrs FROM bkpf INTO TABLE t_bkpf
             WHERE bukrs IN s_bukrs.

IF sy-subrc = 0.
** This will select all the values from BKPF with out any restriction on BUKRS. 
ENDIF.

Hope this will help

Anirban M.

Re: Parameters & select-options

former_member480923 — Mon, 04 Jun 2007 06:24:59 GMT

Please look at the following code to understand.

REPORT  zz_session_method.

TABLES: bkpf.

SELECTION-SCREEN: BEGIN OF BLOCK b1 WITH FRAME TITLE text-001.
PARAMETERS: p_bukrs TYPE bukrs.
SELECT-OPTIONS: s_bukrs FOR bkpf-bukrs.
SELECTION-SCREEN : END OF BLOCK b1.


DATA: t_bkpf TYPE TABLE OF bkpf.

** Selection using Parameters as initial.

SELECT bukrs FROM bkpf INTO TABLE t_bkpf
             WHERE bukrs = p_bukrs.

IF sy-subrc >< 0.
** This will select only the values from BKPF where BUKRS is equal to SPACE.
ENDIF.

** Selection Using Select Options as Initial.

SELECT bukrs FROM bkpf INTO TABLE t_bkpf
             WHERE bukrs IN s_bukrs.

IF sy-subrc = 0.
** This will select all the values from BKPF with out any restriction on BUKRS. 
ENDIF.

Hope this will help

Anirban M.

Re: Parameters & select-options

Former Member — Mon, 04 Jun 2007 15:15:47 GMT

hi swapna,

for the both screnarios if u are not passing any value at selection-screen,if will table all the field values in the perticulat table.

see the below example.

parameter: matnr like mara-matnr.

selction-options: matnr for mara-matnr.

u r program will have MATNR at u r selction screen.

if u not giving any value in MATNR it will read all the MATNR value in MARA table.

reward if useful.

Thanks,

Madhukar.

Re: Parameters & select-options

Former Member — Wed, 13 Jun 2007 12:11:09 GMT

Hi Swapna,

Here you go..Use this code and find the differennce

*----

*-- 2) Difference between Parameters and Select options with

*-- No-Intervals and No-extension

*----

Explanation: -

1) If u dont enter any value in parameter, the system consider it as a initial value and dont retrive any records. If u dont enter any value in select-options, the system selects all values from the database.

2) The other difference is You can check a value againist a Entries against a check table with Parameter option by as " VALUE CHECK ". However it is recommended to use this only when the parameter is obligatory becuase it checks for blank entries also. This option( VALUE CHECK ) cannot be used in SELECT-OPTIONS.

( Eg:- p_matnr like mara-matnr OBLIGATORY VALUE CHECK. )

TABLES: MARA.

DATA: p_count TYPE i,

s_count TYPE i.

PARAMETERS: p_mtart like mara-mtart.

SELECT-OPTIONS: s_mtart FOR mara-mtart NO INTERVALS NO-EXTENSION.

SELECT count(*) FROM

MARA into p_count

WHERE matnr = p_mtart.

SELECT count(*) FROM

MARA into s_count

WHERE matnr IN s_mtart.

WRITE:/ p_count,

s_count.

In this output, p_count = 0.

and s_count will be total no. of records in database.

Reward points if this code is helpful.

Thanks.

Hari krishna

Re: Parameters & select-options

Former Member — Wed, 13 Jun 2007 21:12:04 GMT

Hi,

For PARAMETERS: It wont select any record.

For SELECT-OPTIONS: It will fetch all the records from the database.

Regards,

*DJ

Reward, if its useful

Re: Parameters & select-options

Former Member — Thu, 14 Jun 2007 06:30:51 GMT

hi swapna,

when u will execute a report without giving any value in parameter in selection screen it will not return any value..the output will be blank...

where as when u execute a report without giving any value in select-options in selection screen it will return all the values based on select query...

hope this will clear ur doubt...

please reward points in case useful...

regards,

prashant