topic Re: problem in select options in Application Development and Automation Discussions

problem in select options

Former Member — Wed, 25 Oct 2006 16:54:55 GMT

hi,

i am using the select options statment,if i want to bring the data in F4 for MARD-LGPBE how to bring the values,can any body tell me which function module we can use.

Thanks,

Re: problem in select options

Former Member — Wed, 25 Oct 2006 16:57:49 GMT

Hi Ram,

use At selection screen on value request statement.

regards,

Chandra.

Re: problem in select options

Former Member — Wed, 25 Oct 2006 16:59:07 GMT

Please check this link. It helps you a lot.

http://help.sap.com/saphelp_47x200/helpdata/en/9f/db9a2e35c111d1829f0000e829fbfe/frameset.htm

regards,

Chandra.

Note: Please reward if helpful.

Re: problem in select options

RichHeilman — Wed, 25 Oct 2006 17:02:27 GMT

This field appears to be free text and that you can put anything you want in it in the material master, that said, this makes for a performance problem when you are trying to do F4 help. You have to read the entire MARD table and get all of the bins and then show them in the F4. This code below will do what you want, but again, there is a performance problem. When the program starts, it gets all of the bins for the F4 help. So you may see a delay in the selection screen being thrown, in my system it takes about 7 seconds.


report zrich_0001 .

tables: mard.


data: begin of imard occurs 0,
      lgpbe type MARD-LGPBE,
      end of imard.

select-options s_lgpbe for mard-lgpbe.

initialization.

  select lgpbe into table imard from mard.

  sort imard ascending by lgpbe.
  delete adjacent duplicates from imard comparing lgpbe.


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

  call function 'F4IF_INT_TABLE_VALUE_REQUEST'
       exporting
            retfield    = 'LGPBE'
            dynprofield = 'S_LGPBE'
            dynpprog    = sy-cprog
            dynpnr      = sy-dynnr
            value_org   = 'S'
       tables
            value_tab   = imard.

start-of-selection.

Regards,

Rich Heilman

Re: problem in select options

messier31 — Wed, 25 Oct 2006 17:13:23 GMT

Hi Ram,

You can use below func module to get F4 help on select option field.

F4IF_INT_TABLE_VALUE_REQUEST F4

It returns the values selected in an internal table.

Check this example code

*GLOBAL DECLARATION

Declare your internal table say ITAB_VALUE
Populate ITAB_VALUE with values yuo want for F4 help

t_return like ddshretval occurs 0 with header line.

*CODE TO WRITTEN IN EVENT

AT SELECTION-SCREEN VALUE-REQUEST ON S_OPTION-LOW &
AT SELECTION-SCREEN VALUE-REQUEST ON S_OPTION-HIGH

call function 'F4IF_INT_TABLE_VALUE_REQUEST'

exporting

* Name of field in internal table for which F4 help will return value (in caps)

retfield = 'FIELD'

value_org = 'S'

tables

value_tab = ITAB_VALUE

return_tab = t_return

exceptions

parameter_error = 1

no_values_found = 2

others = 3.

if sy-subrc = 0.

read table t_return index 1.

s_option-low = t_return-fieldval.

endif.

Hope this helps you..let me know if u have ny prob.

Enjoy SAP.

Pankaj Singh

Re: problem in select options

Former Member — Wed, 25 Oct 2006 17:32:33 GMT

What about creating a search-help for this field ?