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

how to email report ouput as attachment

Hi,

Can anybody tell me how to email report ouput as attachment.

Regards,

Soumya.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Nov 21, 2007 at 05:52 AM

    Hi

    check this

    Refer this link:

    FORM send_mail_2 USING msgid msgno msgv1.

    • mailuser oder Gruppe like sy-uname default 'Ruckerk'.

    DATA: express_hold_time LIKE sovaltime.

    DATA: text LIKE sotxtinfo.

    DATA: receiver LIKE somlreci1 OCCURS 0 WITH HEADER LINE.

    • MESSAGE ZF100 (FTP an UDB fehlgeschlagen)

    text-msgid = msgid.

    text-msgno = msgno.

    text-msgv1 = msgv1.

    text-msgv2 = ' '.

    text-msgv3 = ' '.

    text-msgv4 = ' '.

    • express_hold_time

    express_hold_time-days = 01.

    express_hold_time-h_min_sec = 240000.

    • receiver

    receiver-receiver = mreceivr.

    • Gruppe von Empfängern

    receiver-rec_type = 'C'.

    • und Expressmeldung ausgeben

    receiver-express = 'X'.

    APPEND receiver.

    CALL FUNCTION 'MESSAGE_SEND_AS_MAIL'

    EXPORTING

    msgid = text-msgid

    msgno = text-msgno

    msgv1 = text-msgv1

    msgv2 = text-msgv2

    msgv3 = text-msgv3

    TABLES

    receivers = receiver.

    IF sy-subrc <> 0.

    WRITE:/ 'hat nicht geklappt', 'SY-SUBRC =', sy-subrc.

    ENDIF.

    PERFORM print_error_report.

    • Fehlermeldung zum Abbrechen des Report's ausgeben.

    MESSAGE e398 WITH 'Jobabbruch' msgv1.

    ENDFORM. " SEND_MAIL_2

    Another Program:

    *& Report ZSENDEMAIL *

    *& *

    *&----


    *

    *& Example of sending external email via SAPCONNECT *

    *& *

    *&----


    *

    REPORT zsendemail .

    PARAMETERS: psubject(40) type c default 'Hello',

    p_email(40) type c default 'test@sapdev.co.uk' .

    data: it_packing_list like sopcklsti1 occurs 0 with header line,

    it_contents like solisti1 occurs 0 with header line,

    it_receivers like somlreci1 occurs 0 with header line,

    it_attachment like solisti1 occurs 0 with header line,

    gd_cnt type i,

    gd_sent_all(1) type c,

    gd_doc_data like sodocchgi1,

    gd_error type sy-subrc.

    data: it_message type standard table of SOLISTI1 initial size 0

    with header line.

    ***********************************************************************

    *START-OF-SELECTION.

    START-OF-SELECTION.

    Perform populate_message_table.

    *Send email message, although is not sent from SAP until mail send

    *program has been executed(rsconn01)

    PERFORM send_email_message.

    *Instructs mail send program for SAPCONNECT to send email(rsconn01)

    perform initiate_mail_execute_program.

    *&----


    *

    *& Form POPULATE_MESSAGE_TABLE

    *&----


    *

    • Adds text to email text table

    *----


    *

    form populate_message_table.

    Append 'Email line 1' to it_message.

    Append 'Email line 2' to it_message.

    Append 'Email line 3' to it_message.

    Append 'Email line 4' to it_message.

    endform. " POPULATE_MESSAGE_TABLE

    *&----


    *

    *& Form SEND_EMAIL_MESSAGE

    *&----


    *

    • Send email message

    *----


    *

    form send_email_message.

    • Fill the document data.

    gd_doc_data-doc_size = 1.

    • Populate the subject/generic message attributes

    gd_doc_data-obj_langu = sy-langu.

    gd_doc_data-obj_name = 'SAPRPT'.

    gd_doc_data-obj_descr = psubject.

    gd_doc_data-sensitivty = 'F'.

    • Describe the body of the message

    clear it_packing_list.

    refresh it_packing_list.

    it_packing_list-transf_bin = space.

    it_packing_list-head_start = 1.

    it_packing_list-head_num = 0.

    it_packing_list-body_start = 1.

    describe table it_message lines it_packing_list-body_num.

    it_packing_list-doc_type = 'RAW'.

    append it_packing_list.

    • Add the recipients email address

    clear it_receivers.

    refresh it_receivers.

    it_receivers-receiver = p_email.

    it_receivers-rec_type = 'U'.

    it_receivers-com_type = 'INT'.

    it_receivers-notif_del = 'X'.

    it_receivers-notif_ndel = 'X'.

    append it_receivers.

    • Call the FM to post the message to SAPMAIL

    call function 'SO_NEW_DOCUMENT_ATT_SEND_API1'

    exporting

    document_data = gd_doc_data

    put_in_outbox = 'X'

    importing

    sent_to_all = gd_sent_all

    tables

    packing_list = it_packing_list

    contents_txt = it_message

    receivers = it_receivers

    exceptions

    too_many_receivers = 1

    document_not_sent = 2

    document_type_not_exist = 3

    operation_no_authorization = 4

    parameter_error = 5

    x_error = 6

    enqueue_error = 7

    others = 8.

    • Store function module return code

    gd_error = sy-subrc.

    • Get it_receivers return code

    loop at it_receivers.

    endloop.

    endform. " SEND_EMAIL_MESSAGE

    *&----


    *

    *& Form INITIATE_MAIL_EXECUTE_PROGRAM

    *&----


    *

    • Instructs mail send program for SAPCONNECT to send email.

    *----


    *

    form initiate_mail_execute_program.

    wait up to 2 seconds.

    if gd_error eq 0.

    submit rsconn01 with mode = 'INT'

    with output = 'X'

    and return.

    endif.

    endform. " INITIATE_MAIL_EXECUTE_PROGRAM

    Regards

    Anji

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 21, 2007 at 05:55 AM

    Hi

    Check the FM's.

    use the fun module

    SX_OBJECT_CONVERT_OTF_PDF

    to convert to PDF and use SO_NEW_DOCUMENT_ATT_SEND_API1 fun module

    to send mail

    Check this

    data: maildata type sodocchgi1.

    data: mailtxt type table of solisti1 with header line.

    data: mailrec type table of somlrec90 with header line.

    start-of-selection.

    clear: maildata, mailtxt, mailrec.

    refresh: mailtxt, mailrec.

    maildata-obj_name = 'TEST'.

    maildata-obj_descr = 'Test'.

    maildata-obj_langu = sy-langu.

    mailtxt-line = 'This is a test'.

    append mailtxt.

    mailrec-receiver = 'your mail id'.

    mailrec-rec_type = 'U'.

    append mailrec.

    call function 'SO_NEW_DOCUMENT_SEND_API1'

    exporting

    document_data = maildata

    document_type = 'RAW'

    put_in_outbox = 'X'

    tables

    object_header = mailtxt

    object_content = mailtxt

    receivers = mailrec

    exceptions

    too_many_receivers = 1

    document_not_sent = 2

    document_type_not_exist = 3

    operation_no_authorization = 4

    parameter_error = 5

    x_error = 6

    enqueue_error = 7

    others = 8.

    • Start the send process with this code or go to transaction SCOT

    • submit rsconn01 with mode = 'INT' and return.

    Check these links too

    http://www.sap-img.com/abap/sending-email-with-attachment.htm

    http://www.erpgenie.com/abap/code/abap20.htm

    Pls. refer program:

    http://www.sapdevelopment.co.uk/reporting/rep_spooltopdf.htm

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 21, 2007 at 05:57 AM

    Hello,

    Submit the program to get output of ur program.

    send to memory.

    free memory.

    use FM LIST_TO_ASCI

    collect it.

    thru FM SO_NEW_DOCUMENT_SEND_API1

    get it.

    If it is usefull pls reward pts.

    Regards

    Srimanta

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 21, 2007 at 05:57 AM

    Hi,

    Refer this link:

    how-to-send-alv-output-by-email

    Regards,

    Omkar.

    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.