Skip to Content
author's profile photo Former Member
Former Member

Hai All

I want to convert Script data into PDF and then sent it to mail.

I have done till converting data into PDF but I am not able to send it to mail.

Anyone Please help me.

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jan 22, 2008 at 08:59 AM

    Hi,

    Check this sample code

    REPORT zzz_jaytest .

    *Types Declaration

    TYPES : BEGIN OF ty_pa0001,

    pernr TYPE pa0001-pernr,

    bukrs TYPE pa0001-bukrs,

    werks TYPE pa0001-werks,

    END OF ty_pa0001.

    *Internal Table Declaration

    DATA : i_pa0001 TYPE STANDARD TABLE OF ty_pa0001, "For pa0001 Details

    i_otf TYPE STANDARD TABLE OF itcoo, "For OTF data

    i_content_txt TYPE soli_tab, "Content

    i_content_bin TYPE solix_tab, "Content

    i_objhead TYPE soli_tab,

    *Work Area Declaration

    w_pa0001 TYPE ty_pa0001, "For pa0001 Details

    w_res TYPE itcpp, "SAPscript output

    "parameters

    w_otf TYPE itcoo, "For OTF

    w_pdf TYPE solisti1, "For PDF

    w_transfer_bin TYPE sx_boolean, "Content

    w_options TYPE itcpo, "SAPscript output

    "interface

    *Variable Declaration

    v_len_in TYPE so_obj_len,

    v_size TYPE i.

    *Constants Declaration

    CONSTANTS : c_x TYPE c VALUE 'X', "X

    c_locl(4) TYPE c VALUE 'LOCL', "Local Printer

    c_otf TYPE sx_format VALUE 'OTF', "OTF

    c_pdf TYPE sx_format VALUE 'PDF', "PDF

    c_printer TYPE sx_devtype VALUE 'PRINTER', "PRINTER

    c_bin TYPE char10 VALUE 'BIN', "BIN

    c_name TYPE string VALUE 'C:\ZZZ_JAYTEST.PDF',"Downloading

    "File Name

    c_form(11) TYPE c VALUE 'ZZZ_JAYTEST'. "Form Name

    START-OF-SELECTION.

    *Selecting the records from pa0001

    SELECT pernr bukrs werks FROM pa0001

    INTO TABLE i_pa0001 UP TO 10 ROWS.

    *Setting the options

    w_options-tdcopies = 1 ."Number of copies

    w_options-tdnoprev = c_x."No print preview

    w_options-tdgetotf = c_x."Return of OTF table

    w_options-tddest = c_locl."Spool: Output device

    *Opening the form

    CALL FUNCTION 'OPEN_FORM'

    EXPORTING

    form = c_form

    device = c_printer

    language = sy-langu

    OPTIONS = w_options

    IMPORTING

    RESULT = w_res.

    LOOP AT i_pa0001 INTO w_pa0001.

    *Writting into the form

    CALL FUNCTION 'WRITE_FORM'

    EXPORTING

    element = 'MAIN'

    window = 'MAIN'.

    ENDLOOP.

    *Closing the form

    CALL FUNCTION 'CLOSE_FORM'

    IMPORTING

    RESULT = w_res

    TABLES

    otfdata = i_otf

    EXCEPTIONS

    unopened = 1

    bad_pageformat_for_print = 2

    send_error = 3

    spool_error = 4

    codepage = 5

    OTHERS = 6.

    IF sy-subrc 0.

    MESSAGE ID sy-msgid TYPE sy-msgty NUMBER sy-msgno

    WITH sy-msgv1 sy-msgv2 sy-msgv3 sy-msgv4.

    ENDIF.

    *Converting OTF data to single line

    LOOP AT i_otf INTO w_otf.

    CONCATENATE w_otf-tdprintcom w_otf-tdprintpar

    INTO w_pdf.

    APPEND w_pdf TO i_content_txt.

    ENDLOOP.

    *Converting to PDF Format

    CALL FUNCTION 'SX_OBJECT_CONVERT_OTF_PDF'

    EXPORTING

    format_src = c_otf

    format_dst = c_pdf

    devtype = c_printer

    CHANGING

    transfer_bin = w_transfer_bin

    content_txt = i_content_txt

    content_bin = i_content_bin

    objhead = i_objhead

    len = v_len_in

    EXCEPTIONS

    err_conv_failed = 1

    OTHERS = 2.

    v_size = v_len_in.

    *Downloading the PDF File

    CALL FUNCTION 'GUI_DOWNLOAD'

    EXPORTING

    bin_filesize = v_size

    filename = c_name

    filetype = c_bin

    TABLES

    data_tab = i_content_bin.

    *The extension is put the it_mailpack-obj_name parameter of 'SO_NEW_DOCUMENT_ATT_SEND_API1'.

    Regards,

    Satish

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 22, 2008 at 09:01 AM

    Hi

    See this sample code and after that use the fun module to send the mail

    SO_NEW_DOCUMENT_ATT_SEND_API1

    REPORT zzz_jaytest .

    Types Declaration

    TYPES : BEGIN OF ty_pa0001,

    pernr TYPE pa0001-pernr,

    bukrs TYPE pa0001-bukrs,

    werks TYPE pa0001-werks,

    END OF ty_pa0001.

    Internal Table Declaration

    DATA : i_pa0001 TYPE STANDARD TABLE OF ty_pa0001, "For pa0001 Details

    i_otf TYPE STANDARD TABLE OF itcoo, "For OTF data

    i_content_txt TYPE soli_tab, "Content

    i_content_bin TYPE solix_tab, "Content

    i_objhead TYPE soli_tab,

    Work Area Declaration

    w_pa0001 TYPE ty_pa0001, "For pa0001 Details

    w_res TYPE itcpp, "SAPscript output

    "parameters

    w_otf TYPE itcoo, "For OTF

    w_pdf TYPE solisti1, "For PDF

    w_transfer_bin TYPE sx_boolean, "Content

    w_options TYPE itcpo, "SAPscript output

    "interface

    Variable Declaration

    v_len_in TYPE so_obj_len,

    v_size TYPE i.

    Constants Declaration

    CONSTANTS : c_x TYPE c VALUE 'X', "X

    c_locl(4) TYPE c VALUE 'LOCL', "Local Printer

    c_otf TYPE sx_format VALUE 'OTF', "OTF

    c_pdf TYPE sx_format VALUE 'PDF', "PDF

    c_printer TYPE sx_devtype VALUE 'PRINTER', "PRINTER

    c_bin TYPE char10 VALUE 'BIN', "BIN

    c_name TYPE string VALUE 'C:\ZZZ_JAYTEST.PDF',"Downloading

    "File Name

    c_form(11) TYPE c VALUE 'ZZZ_JAYTEST'. "Form Name

    START-OF-SELECTION.

    Selecting the records from pa0001

    SELECT pernr bukrs werks FROM pa0001

    INTO TABLE i_pa0001 UP TO 10 ROWS.

    Setting the options

    w_options-tdcopies = 1 ."Number of copies

    w_options-tdnoprev = c_x."No print preview

    w_options-tdgetotf = c_x."Return of OTF table

    w_options-tddest = c_locl."Spool: Output device

    Opening the form

    CALL FUNCTION 'OPEN_FORM'

    EXPORTING

    form = c_form

    device = c_printer

    language = sy-langu

    OPTIONS = w_options

    IMPORTING

    RESULT = w_res.

    LOOP AT i_pa0001 INTO w_pa0001.

    Writting into the form

    CALL FUNCTION 'WRITE_FORM'

    EXPORTING

    element = 'MAIN'

    window = 'MAIN'.

    ENDLOOP.

    Closing the form

    CALL FUNCTION 'CLOSE_FORM'

    IMPORTING

    RESULT = w_res

    TABLES

    otfdata = i_otf

    EXCEPTIONS

    unopened = 1

    bad_pageformat_for_print = 2

    send_error = 3

    spool_error = 4

    codepage = 5

    OTHERS = 6.

    IF sy-subrc 0.

    MESSAGE ID sy-msgid TYPE sy-msgty NUMBER sy-msgno

    WITH sy-msgv1 sy-msgv2 sy-msgv3 sy-msgv4.

    ENDIF.

    Converting OTF data to single line

    LOOP AT i_otf INTO w_otf.

    CONCATENATE w_otf-tdprintcom w_otf-tdprintpar

    INTO w_pdf.

    APPEND w_pdf TO i_content_txt.

    ENDLOOP.

    Converting to PDF Format

    CALL FUNCTION 'SX_OBJECT_CONVERT_OTF_PDF'

    EXPORTING

    format_src = c_otf

    format_dst = c_pdf

    devtype = c_printer

    CHANGING

    transfer_bin = w_transfer_bin

    content_txt = i_content_txt

    content_bin = i_content_bin

    objhead = i_objhead

    len = v_len_in

    EXCEPTIONS

    err_conv_failed = 1

    OTHERS = 2.

    v_size = v_len_in.

    Downloading the PDF File

    CALL FUNCTION 'GUI_DOWNLOAD'

    EXPORTING

    bin_filesize = v_size

    filename = c_name

    filetype = c_bin

    TABLES

    data_tab = i_content_bin.

    If you r using this function module check it once....

    call function 'CONVERT_OTF'

    EXPORTING

    format = 'PDF'

    max_linewidth = 132

    IMPORTING

    bin_filesize = v_len_in

    TABLES

    otf = i_otf

    lines = i_tline

    EXCEPTIONS

    err_max_linewidth = 1

    err_format = 2

    err_conv_not_possible = 3

    others = 4.

    Fehlerhandling

    if sy-subrc 0.

    *

    endif.

    or u can use the standard program RSTXPDFT4 to download the script into PDF format onto a particular location

    follow this link for sample program.

    http://searchsap.techtarget.com/tip/0,289483,sid21_gci1121833,00.html

    check...

    how-to-send-smart-form-via-email

    /people/pavan.bayyapu/blog/2005/08/30/sending-html-email-from-sap-crmerp

    REward points if useful.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 22, 2008 at 09:12 AM

    Hi,

    You may CONVERT_OTF_AND_MAIL_NEW.

    Regards,

    Renjith Michael.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.