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
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

How to use fun module SAP_CONVERT_TO_XLS_FORMAT

Former Member

‎2007 Dec 26 6:06 AM

0 Kudos
464

Can any body give logic, how to use function module SAP_CONVERT_TO_XLS_FORMAT to download internal table data to Excel sheet.

Regards,

Naseer.

1 REPLY 1

Former Member

‎2007 Dec 26 6:12 AM

0 Kudos
95

hi Nasser,

This is kiran kumar.G.If we use the above function module we get the below function module.I can explain what are the neccesity parameters we have to use check it once.

FUNCTION MODULE OUTPUT:

CALL FUNCTION 'SAP_CONVERT_TO_XLS_FORMAT'

EXPORTING

  • I_FIELD_SEPERATOR =

  • I_LINE_HEADER =

i_filename =

  • I_APPL_KEEP = ' '

tables

i_tab_sap_data =

  • CHANGING

  • I_TAB_CONVERTED_DATA =

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

PARAMETERS:

I_FIELD_SEPERATOR = 'X'.

i_filename ='FILE PATH'

i_tab_sap_data = 'UR INTERNAL TABLE NAME'

Award points if helpful.

kiran kumar.G

Have a Nice Day...