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: 

how to upload excel spreed sheet to SAP using CATT

Former Member
0 Kudos

I am trying to up load an excel spread sheet to SAP, in the excel there is columns which contain City, telephone number etc, and there are fields in fk02 transaction which this must go into.

anyone know a step by step way of doing this

1 ACCEPTED SOLUTION

Former Member
0 Kudos

You can use FM

<b>

CALL FUNCTION 'TEXT_CONVERT_XLS_TO_SAP'

EXPORTING

  • I_FIELD_SEPERATOR =

  • I_LINE_HEADER = 'X'

i_tab_raw_data = it_type

i_filename = p_file

TABLES

i_tab_converted_data = it_itab[]

EXCEPTIONS

conversion_failed = 1

OTHERS = 2.

</b>

to download an xls-sheet into SAP

Looping on the internal table you can fill the creditors data.

regards,

Dirk.

1 REPLY 1

Former Member
0 Kudos

You can use FM

<b>

CALL FUNCTION 'TEXT_CONVERT_XLS_TO_SAP'

EXPORTING

  • I_FIELD_SEPERATOR =

  • I_LINE_HEADER = 'X'

i_tab_raw_data = it_type

i_filename = p_file

TABLES

i_tab_converted_data = it_itab[]

EXCEPTIONS

conversion_failed = 1

OTHERS = 2.

</b>

to download an xls-sheet into SAP

Looping on the internal table you can fill the creditors data.

regards,

Dirk.