topic Reg Fun Modules in Application Development and Automation Discussions

Reg Fun Modules

Former Member — Tue, 15 Jul 2008 09:22:21 GMT

CONTROL_FLUSH and CLPB_IMPORT.

Could any body tell me the importance of these function modules?

In which scenario we will use these?

Thanks in advance.

Regards

Abhilash.

Re: Reg Fun Modules

matt — Tue, 15 Jul 2008 09:32:23 GMT

In the most recent versions CLPB_IMPORT - import from clipboard - is obsolete. And CONTROL_FLUSH just flushes the queue between the GUI and the Appserver.

Re: Reg Fun Modules

Former Member — Tue, 15 Jul 2008 09:39:41 GMT

Hi Matthew,

Thanx for ur update.

could u claify me one thing ,

can we use these FMs to upload data into an internal table from an XL sheet?

Regards

Abhilash.

Re: Reg Fun Modules

Former Member — Tue, 15 Jul 2008 09:50:56 GMT

Hi ,

we cant use these FMs to upload data into an internal table from an XL sheeet.if u want upload data from xl shheet means u use

GUI_UPLOAD ,

ALSM_EXCEL_TO_INTERNAL_TABLE,

Regards ,

Re: Reg Fun Modules

Former Member — Tue, 15 Jul 2008 10:09:44 GMT

Hi,

We can use 'ALSM_EXCEL_TO_INTERNAL_TABLE' function module to read a excel file to internal table.

IF p_file IS INITIAL.

    MESSAGE 'No File Name' TYPE 'E'.

  ENDIF.

  v_filename = p_file.

*Reading from Excel File into internal table it_data.

  CALL FUNCTION 'ALSM_EXCEL_TO_INTERNAL_TABLE'
    EXPORTING
      filename                = v_filename
      i_begin_col             = 1
      i_begin_row             = 2
      i_end_col               = 14
      i_end_row               = p_rows
    TABLES
      intern                  = it_data
    EXCEPTIONS
      inconsistent_parameters = 1
      upload_ole              = 2
      OTHERS                  = 3.
  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 this helps you.

plz reward if useful.

thanks,

dhanashri.

Edited by: Dhanashri Pawar on Jul 15, 2008 12:10 PM

Re: Reg Fun Modules

Former Member — Mon, 04 Aug 2008 08:58:05 GMT

hI,

My question is answered.

Regards

Abhilash.