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: 

'Message_Type_Unknown' error while uploading

Former Member
0 Kudos

Hi,

Getting 'Message_Type_Unknown' error when using 'ALSM_EXCEL_TO_INTERNAL_TABLE' function module for data upload thro' excel sheet.

Why I get this error & what need to be done to rectify it?

4 REPLIES 4

Former Member
0 Kudos

can you try this

TYPE-POOLS: truxs .

DATA: it_raw TYPE truxs_t_text_data.

PARAMETER: pfile LIKE rlgrap-filename MODIF ID sc1." OBLIGATORY.

CALL FUNCTION 'F4_FILENAME'

EXPORTING

program_name = syst-cprog

dynpro_number = syst-dynnr

field_name = ' '

IMPORTING

file_name = pfile.

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 = lt_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.

former_member184619
Active Contributor
0 Kudos

Hi Kavitha,

When you are getting this message. Have you passed the parameters like this:

CALL FUNCTION 'ALSM_EXCEL_TO_INTERNAL_TABLE'

EXPORTING

FILENAME = P_FILE "name of file

I_BEGIN_COL = 1 "Starting column

I_BEGIN_ROW = 2 "Starting row

I_END_COL = 17 "Ending coloumn

I_END_ROW = 3000 "Ending row

TABLES

INTERN = itab "Internal table

  • EXCEPTIONS

  • INCONSISTENT_PARAMETERS = 1

  • UPLOAD_OLE = 2

  • OTHERS = 3 .

Can you paste the code where you are getting the error. You can check the error details in ST22. might be you are assiging the wrong data type.

Sachin

Former Member
0 Kudos

Problem solved

0 Kudos

Hi Kavitha,

Can you please let me know how did you resolved this issue.

i am also getting the same kind of error. Working fine for some Excel files and for some excel files it is giving the same erroe 'MESSAGE UNKNOWN"

Thanks in advance.

Regards,

Lakshma.