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

Sending attachment using FM : SO_DOCUMENT_SEND_API1

Hi,

I can successfully send the attachment to the recipients using the FM SO_DOCUMENT_SEND_API1.

But if the attachemnt (.XLS) is having more than 30,000 records. I found no mails in the recipient mail box. But I can see the mails in my SAP outbox and also can see the data in the spool ( if I execute this in the background) .

The SAP outbox displays a message stating

"No mails has been sent because of huge data".

My code uses

FM SO_DOCUMENT_SEND_API1 and then there is a call to SUBMIT rsconn01 WITH mode = 'INT'

WITH output = 'X'

AND RETURN..

Suggest me what to do in this case.

Regards,

Raj.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jan 29, 2008 at 09:52 AM
    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 29, 2008 at 10:04 AM

    hi

    good

    check this code and use the function module accordingly.

    Try this sample code :-

    REPORT ZREPORT_TO_EMAIL NO STANDARD PAGE HEADING LINE-SIZE 200.

    DATA : BEGIN OF ITAB OCCURS 0,

    PERNR LIKE PA0001-PERNR,

    ENAME LIKE PA0001-ENAME,

    END OF ITAB.

    DATA: message_content LIKE soli OCCURS 10 WITH HEADER LINE,

    receiver_list LIKE soos1 OCCURS 5 WITH HEADER LINE,

    packing_list LIKE soxpl OCCURS 2 WITH HEADER LINE,

    listobject LIKE abaplist OCCURS 10,

    compressed_attachment LIKE soli OCCURS 100 WITH HEADER LINE,

    w_object_hd_change LIKE sood1,

    compressed_size LIKE sy-index.

    START-OF-SELECTION.

    SELECT PERNR ENAME

    INTO CORRESPONDING FIELDS OF TABLE ITAB

    FROM PA0001

    WHERE PERNR < 50.

    LOOP AT ITAB.

    WRITE :/02 SY-VLINE , ITAB-PERNR, 15 SY-VLINE , ITAB-ENAME, 50

    SY-VLINE.

    ENDLOOP.

    • Receivers

    receiver_list-recextnam = 'EXTERNAL-MAIL-ID@YAHOO.COM'. "-->

    • EMAIL ADDRESS

    RECEIVER_list-RECESC = 'E'. "<-

    RECEIVER_list-SNDART = 'INT'."<-

    RECEIVER_list-SNDPRI = '1'."<-

    APPEND receiver_list.

    • General data

    w_object_hd_change-objla = sy-langu.

    w_object_hd_change-objnam = 'Object name'.

    w_object_hd_change-objsns = 'P'.

    • Mail subject

    w_object_hd_change-objdes = 'Message subject'.

    • Mail body

    APPEND 'Message content' TO message_content.

    • Attachment

    CALL FUNCTION 'SAVE_LIST'

    EXPORTING

    list_index = '0'

    TABLES

    listobject = listobject.

    CALL FUNCTION 'TABLE_COMPRESS'

    IMPORTING

    compressed_size = compressed_size

    TABLES

    in = listobject

    out = compressed_attachment.

    DESCRIBE TABLE compressed_attachment.

    CLEAR packing_list.

    packing_list-transf_bin = 'X'.

    packing_list-head_start = 0.

    packing_list-head_num = 0.

    packing_list-body_start = 1.

    packing_list-body_num = sy-tfill.

    packing_list-objtp = 'ALI'.

    packing_list-objnam = 'Object name'.

    packing_list-objdes = 'Attachment description'.

    packing_list-objlen = compressed_size.

    APPEND packing_list.

    CALL FUNCTION 'SO_OBJECT_SEND'

    EXPORTING

    object_hd_change = w_object_hd_change

    object_type = 'RAW'

    owner = sy-uname

    TABLES

    objcont = message_content

    receivers = receiver_list

    packing_list = packing_list

    att_cont = compressed_attachment.

    thanks

    mrutyun^

    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.