topic Re: SO_DOCUMENT_SEND_API1 in Application Development and Automation Discussions

SO_DOCUMENT_SEND_API1

PS_1978 — Fri, 13 Apr 2007 09:51:43 GMT

Hi,

I am using the Function Module to send email with attachment. The program is running fine and i am able to send email with the attachment successfully. There are 10 lines in the internal table, but in the attachment i can see all of them in 5 or 6 lines. I want each record in a separate line. Please suggest me how to proceed this.

Secondly with the body of the message. How can we enter the text in new line?

Regards,

Phani.

Re: SO_DOCUMENT_SEND_API1

Laxmana_Appana_ — Fri, 13 Apr 2007 09:57:53 GMT

Hi,

Check this link :

http://www.sapdevelopment.co.uk/reporting/email/emailhome.htm

Regards,

L Appana

Re: SO_DOCUMENT_SEND_API1

Former Member — Fri, 13 Apr 2007 09:58:19 GMT

check OBJ- Size .

Regards

Prabhu

Re: SO_DOCUMENT_SEND_API1

Former Member — Fri, 13 Apr 2007 10:08:09 GMT

Hai,

Coming in 5 /6 lines is due to unequal lengths of internal tbale line length and the length of line in the out put file(generalluy 255 characters) you see.

So decrease the length of line filed in the internal table in you report.

Hope you could get it after this correction.

Reward Points if it helps you.

Regds,

Rama chary.Pammi

Re: SO_DOCUMENT_SEND_API1

PS_1978 — Fri, 13 Apr 2007 10:20:36 GMT

Hi Prabhu,

As per your suggestion, i have checked the document size and corrected it. But the problem is still there.

Have a look at the code used to append the attachment table:

class cl_abap_char_utilities definition load.
constants:
    con_tab  type c value cl_abap_char_utilities=>HORIZONTAL_TAB,
    con_cret type c value cl_abap_char_utilities=>CR_LF.


  CONCATENATE 'EBELN' 'EBELP' 'AEDAT' 'MATNR'
         INTO it_attach SEPARATED BY con_tab.
*  CONCATENATE it_attach con_cret INTO it_attach.
  APPEND  it_attach.

  LOOP AT it_ekpo INTO wa_charekpo.
    CONCATENATE wa_charekpo-ebeln wa_charekpo-ebelp
                wa_charekpo-aedat wa_charekpo-matnr
           INTO it_attach SEPARATED BY con_tab.
*    CONCATENATE it_attach con_cret INTO it_attach.
    APPEND  it_attach.
  ENDLOOP.

Code for Finding Document size and filling corresponding details:

CLEAR w_doc_data.
describe TABLE it_attach LINES w_cnt.
  READ TABLE it_attach INDEX w_cnt.
  w_doc_data-doc_size =
     ( w_cnt - 1 ) * 255 + STRLEN( it_attach ).
  w_doc_data-obj_langu  = sy-langu.
  w_doc_data-obj_name   = 'SAPRPT'.
  w_doc_data-obj_descr  = ld_mtitle.
  w_doc_data-sensitivty = 'F'.
  CLEAR t_attachment.
  REFRESH t_attachment.
  t_attachment[] = pit_attach[].

Code of the FM:

CALL FUNCTION 'SO_DOCUMENT_SEND_API1'
       EXPORTING
            document_data              = w_doc_data
            put_in_outbox              = 'X'
            sender_address             = ld_sender_address
            sender_address_type        = ld_sender_address_type
            commit_work                = 'X'
       IMPORTING
            sent_to_all                = w_sent_all
       TABLES
            packing_list               = t_packing_list
            contents_bin               = t_attachment
            contents_txt               = it_message
            receivers                  = t_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.

Thanks in Advance,

Regards,

Phani.

Re: SO_DOCUMENT_SEND_API1

Former Member — Mon, 16 Apr 2007 10:44:49 GMT

describe TABLE it_attach LINES w_cnt.

READ TABLE it_attach INDEX w_cnt.

w_doc_data-doc_size =

( w_cnt - 1 ) * 1055 + STRLEN( it_attach ).

w_doc_data-obj_langu = sy-langu.

w_doc_data-obj_name = 'SAPRPT'.

w_doc_data-obj_descr = ld_mtitle.

w_doc_data-sensitivty = 'F'.

CLEAR t_attachment.

REFRESH t_attachment.

t_attachment[] = pit_attach[].

are u missing columns or rows ?

Regards

Prabhu