Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Reg Fun Modules

Former Member
0 Kudos

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.

5 REPLIES 5

matt
Active Contributor
0 Kudos

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.

Former Member
0 Kudos

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.

T

Former Member
0 Kudos

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 ,

GJ

Former Member
0 Kudos

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

Former Member
0 Kudos

hI,

My question is answered.

Regards

Abhilash.