topic Re: Range in Application Development and Automation Discussions

Range

Former Member — Tue, 20 Jan 2009 04:58:50 GMT

hello,

how can i create a FM for Seach help which in turn will take inputs as range of values? then further fillter

it by the user's selection?

Regards,

Tamanna

Re: Range

Former Member — Tue, 20 Jan 2009 05:04:02 GMT

in selection condisation u can pass the range value.

create call screen 100

PUT icon filter.

when press pass this parameters through where cluse.

Re: Range

Former Member — Tue, 20 Jan 2009 05:04:29 GMT

Hi,

Refer below links may help you.

Regards

Md.MahaboobKhan

Re: Range

former_member222860 — Tue, 20 Jan 2009 05:09:24 GMT

Hi,

you can define the ranges within the FM . sample code is here

RANGES: BELNR1 FOR BKPF-BELNR.
 REFRESH: BELNR1.

 IF NOT P_F_BELNR_HIGH IS INITIAL.
   BELNR1-LOW = P_F_BELNR_LOW.
   BELNR1-HIGH = P_F_BELNR_HIGH.
   BELNR1-SIGN = 'I'.
   BELNR1-OPTION = 'BT'.
 ELSE.
   BELNR1-LOW = P_F_BELNR_LOW.
   BELNR1-SIGN = 'I'.
   BELNR1-OPTION = 'EQ'.
ENDIF.
APPEND BELNR1.


SELECT * FROM BKPF
           INTO TABLE i_bkpf
          WHERE belnr IN belnr1.

thanks\

Mahesh

Re: Range

SuhaSaha — Tue, 20 Jan 2009 05:11:08 GMT

Hello Tamanna,

You have to create a range table for this.

Please see the thread below:

[input parameter with multiple values in function module|;

Hope this helps.

BR,

Suhas

Re: Range

Former Member — Tue, 20 Jan 2009 05:12:15 GMT

hello All,

let me more specific wit my questions..

ive created a FM which takes in various values n filters it depending on the input and outputs the correspounding entries. for this to achive i used a dynamic select query.

now i want it to further enchance by passing the input parameters as range...

please suggest how i can i achive this.

Regards

Tamanna

Re: Range

former_member222860 — Tue, 20 Jan 2009 05:16:01 GMT

Hi,

can u paste ur code here

thanks\

Mahesh

Re: Range

Former Member — Tue, 20 Jan 2009 05:17:24 GMT

hello suhas,

I made the input parameters as of type range..

but i dont know how to refine my select query to give me the result depending on th selection critetia..

Regards,

Tamanna

Re: Range

Former Member — Tue, 20 Jan 2009 05:19:47 GMT

hello ,

" Dynamic Select statement

TRY.

SELECT *

FROM vdarl

INTO TABLE l_tab_contract

WHERE (l_cond_syntax) .

CATCH cx_sy_dynamic_osql_error.

MESSAGE `Wrong WHERE condition!` TYPE 'I'.

ENDTRY.

here in l_cond_syntax im getting the values depending upon the user selection.,but i want it to work for range of values

regards,

Tamanna

Re: Range

Former Member — Tue, 20 Jan 2009 05:20:22 GMT

Hi.

If you want create serach help you can std function modules like F4IF_INT_TABLE_VALUE_REQUEST,

F4IF_DETERMINE_SEARCHHELP,

F4IF_FIELD_VALUE_REQUEST,

F4IF_INT_TABLE_VALUE_REQUEST,

'F4_SEARCH_HELP'

No need to create Z FM for that.

Regards.

Jay

Re: Range

former_member222860 — Tue, 20 Jan 2009 05:32:40 GMT

Hi,,

Let's say ur fieldname is field in ur where-clause

IF NOT field_LOW IS INITIAL AND NOT field_HIGH IS INITIAL.

    v_where = '& BETWEEN ''&'' AND ''&'' '.
    REPLACE '&' WITH key_field INTO v_where.
    REPLACE '&' WITH field_LOW INTO v_where.
    REPLACE '&' WITH field_HIGH INTO v_where.
    CONDENSE v_where.

select * into corresponding fields of table ITAB
             from (table_name)
            where (v_where).

hope u got it

thanks\

Mahesh

Re: Range

SuhaSaha — Tue, 20 Jan 2009 05:33:50 GMT

Hello Tamanna,

here in l_cond_syntax im getting the values depending upon the user selection.,but i want it to work for range of values

Can you share the code how you are populating l_cond_syntax?

BR,

Suhas