Skip to Content
0
Former Member
Jan 14, 2008 at 09:06 PM

how to handle errors in TEXT_CONVERT_XLS_TO_SAP.. FM

190 Views

I am using below FM to upload nonlegacy data contained in excel in to the internal tables. I successfully got the data in internal tables too...

How can i handle errors for this particular FM. can you give one example to handle errros for this FM..

CALL FUNCTION 'TEXT_CONVERT_XLS_TO_SAP'

EXPORTING

  • I_FIELD_SEPERATOR =

I_LINE_HEADER = 'X'

I_TAB_RAW_DATA = it_raw

I_FILENAME = p_filenm

TABLES

I_TAB_CONVERTED_DATA = it_mat_bom

  • 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.