topic Re: Help in Function module in Application Development and Automation Discussions

Help in Function module

Former Member — Mon, 30 Jul 2007 14:09:47 GMT

Hi All,

I want to add FILE NAME option in import parametsr in function module. I want to download the RFC FM interface Output in excel format.

Please give any sample programs.

regards,

Ajay reddy

Re: Help in Function module

Former Member — Mon, 30 Jul 2007 14:16:49 GMT

Add this import paramter to your function module.

FILENAME LIKE RLGRAP-FILENAME

Thanks

Mahesh

Re: Help in Function module

Former Member — Mon, 30 Jul 2007 14:23:36 GMT

to download to excel format. use FM gui_download

regards,

srinivas

*reward for useful answers*

Re: Help in Function module

Former Member — Mon, 30 Jul 2007 14:25:58 GMT

use function module to download file in XLS format..

SAP_CONVERT_TO_XLS_FORMAT

Reward points if useful

Regards

Prax

Re: Help in Function module

Former Member — Mon, 30 Jul 2007 14:31:37 GMT

Please give me any sample programs.

regards,

AJAy reddy

Re: Help in Function module

Former Member — Mon, 30 Jul 2007 16:20:21 GMT

PROGRAM ZSV_TEST.

Data : IT type table of kna1 initial size 0.

Select * from kna1 into table IT up to 10 rows.

CALL FUNCTION 'SAP_CONVERT_TO_XLS_FORMAT'

EXPORTING

I_FIELD_SEPERATOR =

I_LINE_HEADER = 'X'

I_FILENAME = 'C:\TEST.XLS'

I_APPL_KEEP = 'X'

TABLES

I_TAB_SAP_DATA = IT

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.

The Headings wont be downloaded. if needed then declare a internal table with character fields append the titles and then the values and call this function.

Reward if it helpful

Thanks & Regards

Senthilvel Murugesan