topic Re: List Output in Application Development and Automation Discussions

List Output

Former Member — Tue, 17 Apr 2007 13:00:34 GMT

Hi ,

How to send list out put directly to

1.Printer

2. Convert to PDF format

3. To Excel sheet

Kumar

Re: List Output

Former Member — Tue, 17 Apr 2007 13:04:10 GMT

Hi Kumar,

Go to System button(Alt + Y) on menu bar, there you'll find 'List' in submenu. There you can see 'Print to take a printout and you also find save for saving the list in whichever format you like.

with regards,

Jay.

Message was edited by:

Jayachandra Nagaram

Re: List Output

Former Member — Tue, 17 Apr 2007 13:06:03 GMT

1.Click on the print button in the application toolbar and provide the necessary parameters, take the help of basis team

2. run the pgm in the background, obtain the spool request and convert the spool into pdf using the program RSTXPDFT4

3.from the list output follow the menu path system -> List ->Local file

Re: List Output

Former Member — Tue, 17 Apr 2007 13:12:34 GMT

Hi ,

is there any function module available to convert report output to Pdf ?

Re: List Output

Former Member — Tue, 17 Apr 2007 13:23:33 GMT

You can use this report <b>RSTXPDFT4</b> or this custom FM


  FUNCTION Z_PDF_DOWNLOAD.
*"----------------------------------------------------------------------
*"*"Interfase local
*"  IMPORTING
*"     REFERENCE(FILENAME) TYPE  STRING
*"----------------------------------------------------------------------

    SELECT RQIDENT
    INTO (T_TSP01-RQIDENT)
    FROM TSP01
    WHERE RQOWNER EQ SY-UNAME
      AND RQCLIENT EQ SY-MANDT.
    APPEND T_TSP01.
    ENDSELECT.

    SORT T_TSP01 DESCENDING.

    CALL FUNCTION 'CONVERT_OTFSPOOLJOB_2_PDF'
         EXPORTING
              SRC_SPOOLID              = T_TSP01-RQIDENT
              NO_DIALOG                = ''
         IMPORTING
              PDF_BYTECOUNT            = NUMBYTES
              PDF_SPOOLID              = PDFSPOOLID
              BTC_JOBNAME              = JOBNAME
              BTC_JOBCOUNT             = JOBCOUNT
         TABLES
              PDF                      = PDF
         EXCEPTIONS
              ERR_NO_OTF_SPOOLJOB      = 1
              ERR_NO_SPOOLJOB          = 2
              ERR_NO_PERMISSION        = 3
              ERR_CONV_NOT_POSSIBLE    = 4
              ERR_BAD_DSTDEVICE        = 5
              USER_CANCELLED           = 6
              ERR_SPOOLERROR           = 7
              ERR_TEMSEERROR           = 8
              ERR_BTCJOB_OPEN_FAILED   = 9
              ERR_BTCJOB_SUBMIT_FAILED = 10
              ERR_BTCJOB_CLOSE_FAILED  = 11
              OTHERS                   = 12.

    IF SY-SUBRC EQ 0.

      CALL FUNCTION 'GUI_DOWNLOAD'
           EXPORTING
                BIN_FILESIZE            = NUMBYTES
                FILENAME                = FILENAME
                FILETYPE                = 'BIN'
           TABLES
                DATA_TAB                = PDF
           EXCEPTIONS
                FILE_WRITE_ERROR        = 1
                NO_BATCH                = 2
                GUI_REFUSE_FILETRANSFER = 3
                INVALID_TYPE            = 4
                NO_AUTHORITY            = 5
                UNKNOWN_ERROR           = 6.

      IF SY-SUBRC EQ 0.
        DELETE FROM TSP01 WHERE RQIDENT EQ T_TSP01-RQIDENT.
      ENDIF.

    ENDIF.

  ENDFUNCTION.

Just need to pass the save path -:)

Greetings,

Blag.