topic Re: data range in Application Development and Automation Discussions

data range

Former Member — Fri, 03 Oct 2008 09:31:32 GMT

can we restrict the data which comes when v pres f4.

i defined a parameter,now can i define its range??

Re: data range

naveen_inuganti2 — Fri, 03 Oct 2008 09:34:01 GMT

Hi...

Yes, we can do it.

1. Some fields wil have default search help, for this you have to craete you own search by declaring paramenter with your own reference and then carete your own search help for that.

2. If it is ur own search help, no issues. you can do it at internal table level.

You have to modify the internal table of that search help by restricting the input values.

And then pass this itab to function module F4IF_INT_TABLE_DISPLAY

Thanks,

Naveen.I

Re: data range

Former Member — Fri, 03 Oct 2008 09:38:24 GMT

hi,

F4IF_INT_TABLE_VALUE_REQUEST use this fm to get f4 search help for a certain fields.

use event at selection screen on value-request for and in it select the data to be displayed in ur f4 help in a

internal table and pass it on to the above function module.

it will work...

Re: data range

Former Member — Fri, 03 Oct 2008 09:39:28 GMT

You may use * for your searching

like if i want to search material with material number starting from 1, you can type 1* in the field and press F4, then a list that are having material number starting with 1 will be shown.

Re: data range

GauthamV — Fri, 03 Oct 2008 09:40:13 GMT

hi,

yes, we can.

check this sample code.


tables: pa0000.
DATA: BEGIN OF IT_SEL OCCURS 0,
       massn LIKE pa0000-massn,"action type
       mntxt like t529t-mntxt, "action type text
       END OF IT_SEL."selection value-request

select-options :  s_pernr  for pa0000-pernr no intervals no-extension ,
                  s_massn  for  pa0000-massn  obligatory  no intervals.

at selection-screen on value-request for s_massn-low .

  REFRESH: IT_SEL.
  clear: it_sel.
  it_sel-massn = '10'.
  it_sel-mntxt = 'Retirement process'.
  append it_sel.

  clear: it_sel.
  it_sel-massn = '18'.
  it_sel-mntxt = 'Deputation Inward'.
  append it_sel.

  clear: it_sel.
  it_sel-massn = '19'.
  it_sel-mntxt = 'Deputation Outward'.
  append it_sel.

  clear: it_sel.
  it_sel-massn = '20'.
  it_sel-mntxt = 'Termination/Seperation'.
  append it_sel.

  clear: it_sel.
  it_sel-massn = '28'.
  it_sel-mntxt = 'Pre-Seperation'.
  append it_sel.

  CALL FUNCTION 'F4IF_INT_TABLE_VALUE_REQUEST'
    EXPORTING
*   DDIC_STRUCTURE         = ' '
      RETFIELD               = 'MASSN'
*   PVALKEY                = ' '
     DYNPPROG               = SY-REPID
     DYNPNR                 = SY-DYNNR
     DYNPROFIELD            = 'S_MASSN-LOW'
*   STEPL                  = 0
*   WINDOW_TITLE           =
*   VALUE                  = ' '
     VALUE_ORG              = 'S'
*   MULTIPLE_CHOICE        = ' '
*   DISPLAY                = ' '
*   CALLBACK_PROGRAM       = 'SY-REPID'
*   CALLBACK_FORM          = ' '
*   MARK_TAB               =
* IMPORTING
*   USER_RESET             =
    TABLES
      VALUE_TAB              =  IT_SEL
*   FIELD_TAB              =
*   RETURN_TAB             =
*   DYNPFLD_MAPPING        =
* EXCEPTIONS
*   PARAMETER_ERROR        = 1
*   NO_VALUES_FOUND        = 2
*   OTHERS                 = 3
            .

Re: data range

Former Member — Fri, 03 Oct 2008 10:22:02 GMT

can u ppl explain.

like field likp-vbeln

after pressing f4,it shows whole list.

what to do,if i want billing document in range 100000 to 100010 only to be shown in the list?

Re: data range

Former Member — Fri, 03 Oct 2008 10:26:35 GMT

write a select query accordind to ur requirement fetch data and fill an internal table.

and call this fm and pass this intenal table

F4IF_INT_TABLE_VALUE_REQUEST

and u get ur value request

if u have any problem calling function module tell me

read this example

i think it will help you.

parameters p(10) TYPE C.

AT SELECTION-SCREEN ON VALUE-REQUEST FOR P.

**tables vbak.

data: begin of itab occurs 0,

s type vbak-vbeln,

end of itab.

select vbeln

from vbak

into TABLE itab

WHERE VBELN BETWEEN '0000004000' AND '0000006000'.

CALL FUNCTION 'F4IF_INT_TABLE_VALUE_REQUEST'

EXPORTING

retfield = 'VBELN'

DYNPPROG = SY-REPID

DYNPNR = SY-DYNNR

DYNPROFIELD = 'P'

VALUE = SPACE

VALUE_ORG = 'S'

DISPLAY = 'F'

tables

value_tab = ITAB[].

thanks

vikalp

Edited by: vikalp on Oct 3, 2008 12:27 PM

Edited by: vikalp on Oct 3, 2008 12:28 PM

Re: data range

GauthamV — Fri, 03 Oct 2008 10:31:56 GMT

hi,

Did u really check my post.

In the same code replace pa0000 table with likp table and use your fields.

Re: data range

Former Member — Fri, 03 Oct 2008 11:30:14 GMT

thanks all of u..

but i need some to check it..

Edited by: aksh on Oct 3, 2008 7:30 AM

Re: data range

Former Member — Fri, 03 Oct 2008 11:37:12 GMT

hey gautham,

does it show the mentioned data in the list.

retirement process n all.

Edited by: aksh on Oct 3, 2008 7:39 AM

Re: data range

Former Member — Mon, 06 Oct 2008 05:28:18 GMT

hi,

if problem solved then close the thread....