topic Re: Need a function module name in Application Development and Automation Discussions

Need a function module name

Former Member — Wed, 09 May 2007 07:09:20 GMT

Hi,

I am trying to download data from a classical report using 'GUI_DOWNLOAD'.

It is downloading data fine but it is not downloading header part of the classical report.

So can any body give me the function module which will download data along with header from a classical report.

Thanx in advance

Subhani.

Re: Need a function module name

Former Member — Wed, 09 May 2007 07:12:15 GMT

Hi,

<b>RSTXTPDF4,</b> Pass the spool number of a report's output to this program to have the output converted to PDF

U can use the function module..

XXL_SIMPLE_API

XXL_FULL_API

And can download the output data into xl sheet.

Regards

Sudheer

Re: Need a function module name

Former Member — Wed, 09 May 2007 07:13:14 GMT

try these

SAP_CONVERT_TO_XLS_FORMAT Excel

-> MS_EXCEL_OLE_STANDARD_DAT Excel

-> RSPO_DOWNLOAD_SPOOLJOB Excel

RH_START_EXCEL_WITH_DATA Excel

Regards

Prabhu

Re: Need a function module name

Former Member — Wed, 09 May 2007 07:20:02 GMT

have you tried with the option FIELDNAMES in GUI_DOWNLOAD

DATA : ITAB TYPE MARA OCCURS 0 WITH HEADER LINE.
 
SELECT * INTO ITAB
         FROM MARA
         UP TO 10 ROWS.
         APPEND ITAB.
ENDSELECT.
 
DATA : BEGIN OF ITAB1 OCCURS 0,
         LINE(50) TYPE C,
       END OF ITAB1.
 
ITAB1-LINE = 'field1 description'.
APPEND ITAB1.
ITAB1-LINE = 'field2 desc'.
APPEND ITAB1.
ITAB1-LINE = 'field3 desc'.
APPEND ITAB1.
*--and so on you have to add up the records in itab1.
 
CALL FUNCTION 'GUI_DOWNLOAD'
  EXPORTING
    FILENAME                        = 'c:abc.xls'
   FILETYPE                        = 'ASC'
   WRITE_FIELD_SEPARATOR           = 'X'
* IMPORTING
*   FILELENGTH                      =
  TABLES
    DATA_TAB                        = ITAB
   FIELDNAMES                      = ITAB1

Re: Need a function module name

sreeramkumar_madisetty — Wed, 09 May 2007 07:21:03 GMT

Try for Datasets.

Regards,

Sreeram

Re: Need a function module name

sharadendu_agrawal — Wed, 09 May 2007 08:38:01 GMT

Just add the header line into the internal table using the INSERT statement and then pass the internal table to the required FM gui_download..

Sharadendu