topic Re: F4 Help in Application Development and Automation Discussions

F4 Help

Former Member — Mon, 13 Apr 2009 08:51:08 GMT

Hi Friends,

I have to give F4 help option for file path parameter. Is there any way that in F4 help I can make the file type as by default excel format so that the user can always export data to an excel sheet.

Thanks in Advance,

Meenu.

Re: F4 Help

Former Member — Mon, 13 Apr 2009 08:53:55 GMT

you can use the below class

CALL METHOD cl_gui_frontend_services=>gui_upload

EXPORTING

filename = lf_file

filetype = 'EXCL'

IMPORTING

filelength = lf_filelength

CHANGING

data_tab = lt_datatab

EXCEPTIONS

OTHERS = 1.

Re: F4 Help

former_member203501 — Mon, 13 Apr 2009 08:54:51 GMT

hi do like this..

CALL FUNCTION 'F4_DXFILENAME_TOPRECURSION'

EXPORTING

i_location_flag = 'A'

I_SERVER = '?'
I_PATH =

filemask = '*.xls'

FILEOPERATION = 'R'

IMPORTING

O_LOCATION_FLAG =
O_SERVER =

o_path = filename

ABEND_FLAG =

EXCEPTIONS

rfc_error = 1

error_with_gui = 2

OTHERS = 3.

Re: F4 Help

Former Member — Mon, 13 Apr 2009 08:55:14 GMT

OOps use the method

FILE_SAVE_DIALOG

Re: F4 Help

Former Member — Mon, 13 Apr 2009 08:56:04 GMT

Hi,

Check this method CL_GUI_FRONTEND_SERVICES->FILE_OPEN_DIALOG

CL_GUI_FRONTEND_SERVICES->FILE_SAVE_DIALOG

CALL METHOD cl_gui_frontend_services=>file_save_dialog
    EXPORTING
      window_title      = 'Select archivo'
      default_extension = 'xls'
      file_filter       = '*.xls'
    CHANGING
      filename          = filename
      path              = path
      fullpath          = fullpath.

  IF sy-subrc EQ 0.
    p_file = fullpath.
  ENDIF.

  CALL METHOD cl_gui_frontend_services=>file_open_dialog
    EXPORTING
      initial_directory = directory
      file_filter       = '*.xml'    " EC-NOTEXT
      multiselection    = ' '
    CHANGING
      file_table        = filetable
      rc                = rc.
  IF rc = 1.
    READ TABLE filetable INDEX 1 INTO line.
    filename = line-filename.
  ENDIF.

Re: F4 Help

Former Member — Mon, 13 Apr 2009 08:59:30 GMT

Hi,

CALL FUNCTION 'KD_GET_FILENAME_ON_F4'

EXPORTING

PROGRAM_NAME = SY-REPID

DYNPRO_NUMBER = SYST-DYNNR

FIELD_NAME = file_name

CHANGING

FILE_NAME = FILE_NAME

EXCEPTIONS

MASK_TOO_LONG = 1

OTHERS = 2.

IF SY-SUBRC <> 0.

MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO

WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

ENDIF.

Hope it helps!!

Regards,

Pavan

Re: F4 Help

Former Member — Mon, 13 Apr 2009 09:00:07 GMT

Hi,

Use FM CALL FUNCTION 'KD_GET_FILENAME_ON_F4'


CALL FUNCTION 'KD_GET_FILENAME_ON_F4'
   EXPORTING
   PROGRAM_NAME        = SYST-REPID
    DYNPRO_NUMBER       = SYST-DYNNR
    FIELD_NAME                 = <Field-Name>
     STATIC              = 'X'
    MASK                = '*.XLS, *.xls'
    CHANGING
      FILE_NAME           = P_INPUT
 EXCEPTIONS
   MASK_TOO_LONG       = 1
*   OTHERS              = 2

Re: F4 Help

Former Member — Mon, 13 Apr 2009 09:13:12 GMT

I have used the FM :WS_FILENAME_GET for F4 help and GUI_DOWNLOAD to export data. I ahve to give user the option to specify file name and path. So while specifying the file name itself i want to make the file type option as excel format.

Re: F4 Help

Former Member — Mon, 13 Apr 2009 09:14:01 GMT

hope it will help u

AT SELECTION-SCREEN ON VALUE-REQUEST FOR PFNAME.

CALL FUNCTION 'KD_GET_FILENAME_ON_F4'

EXPORTING

STATIC = 'X'

CHANGING

FILE_NAME = PFNAME.

~linganna

Re: F4 Help

Former Member — Mon, 13 Apr 2009 09:28:48 GMT

Hi Meenu,

Try this

create parameter as below

PARAMETERS:fname LIKE rlgrap-filename DEFAULT ''.

then call the following function in your program

AT SELECTION-SCREEN ON VALUE-REQUEST FOR fname.

CALL FUNCTION 'F4_FILENAME'

EXPORTING

program_name = syst-cprog

dynpro_number = syst-dynnr

FIELD_NAME = FNAME

IMPORTING

file_name = fname.

then pass the value "fname' where required.

Regards.

Amol

Re: F4 Help

Former Member — Mon, 13 Apr 2009 09:29:56 GMT

The FM : 'KD_GET_FILENAME_ON_F4' is not taking the filename as by default excel format.

If we specify the filename.XLS then only it is working. My requirement is to take it by deafult into excel format.

Re: F4 Help

Former Member — Mon, 13 Apr 2009 09:39:31 GMT

HI,

Check these Method's

CL_GUI_FRONTEND_SERVICES->FILE_OPEN_DIALOG

CL_GUI_FRONTEND_SERVICES->FILE_SAVE_DIALOG

You can pass the extension while calling these methods and When you see the Pop-Up the File type selected will be the one you passed to these methods.

Please check my above post ..