so_document_send_api1 mail pdf output problem

[Former Member]

Hi,

I am displaying clasical report with 8 cloumns and line size of output is 170 ( line size 170)

when i execute the program in background it is creating spool correctly means with out truncating the columns ( it is displaying all the eight columns in spool). i am covertng spool to pdf by using CONVERT_ABAPSPOOLJOB_2_PDF function module and sending mail by using SO_DOCUMENT_SEND_API1 function mdoule.

But when i opend the pdf attachement in mail, i am able to see only two columns in pdf document. i am not able to see all the out put 8 columns in pdf attachment .

how to convert all the coulmns to pdf and how i can able to see entire output in pdf document

please help me in this issue

Thanks in advance

raju

[Former Member]

Refer:

[Former Member]

Hi,

First Test converting the Spool to PDf using this program RSTXPDFT4. If it working fine then check you logic.

[Former Member]

raju,

please check your internal table after converting spool job to pdf.(make a gui_download) to check if your are correctly getting the data.

[venkat_o]

Hi Raju, <li> After converting PDF itab using CONVERT_ABAPSPOOLJOB_2_PDF, use SX_TABLE_LINE_WIDTH_CHANGE function module. It increases the PDF width.

     CALL FUNCTION 'CONVERT_ABAPSPOOLJOB_2_PDF'
       EXPORTING
         src_spoolid              = g_spool_no
         no_dialog                = ' '
       IMPORTING
         pdf_bytecount            = l_no_of_bytes
         pdf_spoolid              = l_pdf_spoolid
         btc_jobname              = l_jobname
         btc_jobcount             = l_jobcount
       TABLES
         pdf                      = i_pdf
       EXCEPTIONS
         err_no_abap_spooljob     = 1
         err_no_spooljob          = 2
         err_no_permission        = 3
         err_conv_not_possible    = 4
         err_bad_destdevice       = 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.

     CASE sy-subrc.
       WHEN 0.
       WHEN 1.
         MESSAGE s000(0k) WITH 'No ABAP Spool Job'.
         EXIT.
       WHEN 2.
         MESSAGE s000(0k) WITH 'Spool Number does not exist'.
         EXIT.
       WHEN 3.
         MESSAGE s000(0k) WITH 'No permission for spool'.
         EXIT.
       WHEN OTHERS.
         MESSAGE s000(0k)
            WITH 'Error in Function CONVERT_ABAPSPOOLJOB_2_PDF'.
         EXIT.
     ENDCASE.

     CALL FUNCTION 'SX_TABLE_LINE_WIDTH_CHANGE'
       EXPORTING
         line_width_src              = 134
         line_width_dst              = 255
       TABLES
         content_in                  = i_pdf
         content_out                 = l_attachment
       EXCEPTIONS
         err_line_width_src_too_long = 1
         err_line_width_dst_too_long = 2
         err_conv_failed             = 3
         OTHERS                      = 4.
     IF sy-subrc NE 0.
       MESSAGE s000(0k) WITH 'Conversion Failed'.
       EXIT.
     ENDIF.

Thanks Venkat.O