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: 

Function module to upload the data from an excel file into ztable

Former Member
0 Kudos

Hi,

Can anyone suggest me a function module to upload the data from an excel file into ztable other than the function module ALSM_EXCEL_TO_INTERNAL_TABLE.

4 REPLIES 4

Former Member
0 Kudos

Hi,

Use this FM:

TEXT_CONVERT_XLS_TO_SAP

********************************************************

For example, go through tje following link:

http://www.sapdevelopment.co.uk/file/file_upexcel.htm

Thanks,

Shailaja

Edited by: Shailaja on Jul 15, 2008 10:11 AM

Former Member
0 Kudos

former_member181995
Active Contributor
0 Kudos

Welcome to SDN,

just see these report in se38 for more help.

FILA_HELP_UPLOAD_EXCEL_01              Report FILA_HELP_UPLOAD_EXCEL_01    
FILA_HELP_UPLOAD_EXCEL_03              Report FILA_HELP_UPLOAD_EXCEL_03

also you can use:

TYPE-POOLS: truxs .
DATA: it_raw TYPE truxs_t_text_data.
PARAMETER: pfile LIKE rlgrap-filename." OBLIGATORY.
 CALL FUNCTION 'TEXT_CONVERT_XLS_TO_SAP'
    EXPORTING
*     I_FIELD_SEPERATOR          =
      i_line_header              = 'X'
      i_tab_raw_data             = it_raw
      i_filename                 = pfile
    TABLES
      i_tab_converted_data       = it_excel[]
*   EXCEPTIONS
*     CONVERSION_FAILED          = 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.

Amit.

Former Member
0 Kudos

There is no any FM that ll directly load ur data to Ztable.

Instead u can do one thing u load the data into ur Internal table

And from interal Table u can load ur ztable.

use this FM for loading into IT


TEXT_CONVERT_XLS_TO_SAP

then


insert <ztable> from IT.