topic Re: Attach XML File to email as an attachment in Application Development and Automation Discussions

Attach XML File to email as an attachment

Former Member — Thu, 05 Mar 2009 11:12:23 GMT

Hi,

Using Call transformation, I have created a XML document. Now I want to send this XML document as an attachment to a e-mail. Can anyone help me how can I achieve this?

Below is my code.

v_resstream = v_stream_factory->create_ostream_itable(

table = t_restab ).

v_resstream->set_encoding( encoding = v_encoding ).

CALL TRANSFORMATION ZSD_INVOICE_MX_DIGITAL

SOURCE OUTPUT = t_output[]

RESULT XML v_resstream.

t_output has the data and ZSD_INVOICE_MX_DIGITAL is the XSLT code where I have the XML documents template.

the XML document is in the byte format in table t_restab.

How can I attach this to the mail?

I tried as below but still it doesnt work.

LOOP AT t_restab INTO v_line.

CONCATENATE v_resstr v_line INTO v_resstr IN BYTE MODE.

ENDLOOP.

DATA: v_str TYPE string,

t_restab TYPE d_restab,

v_resstr TYPE xstring,

v_line TYPE d_line.

REFRESH: lt_objbin1, lt_record.

CLEAR: v_str, wa_record.

v_str = v_resstr.

DO.

wa_record = v_str.

APPEND wa_record TO lt_record.

SHIFT v_str LEFT BY 255 PLACES.

IF v_str IS INITIAL.

EXIT.

ENDIF.

ENDDO.

Filling all the other details here for sending the mail

lt_objbin1 = lt_record.

CLEAR: wa_objpack.

lv_lines = lv_lines + 1.

wa_objpack-transf_bin = c_x.

wa_objpack-head_start = 1.

wa_objpack-head_num = 1.

wa_objpack-body_start = 1.

DESCRIBE TABLE lt_objbin1 LINES lv_lines.

wa_objpack-body_num = lv_lines.

wa_objpack-doc_type = 'XML'.

wa_objpack-obj_name = 'text2'.

CONCATENATE p_nast-objky '_' v_kunrg '_' v_vkorg '_1'

INTO wa_objpack-obj_descr.

wa_objpack-doc_size = ressize.

APPEND wa_objpack TO lt_objpack.

APPEND LINES OF lt_objbin1 TO lt_objbin.

Calling the FM SO_DOCUMENT_SEND_API1.

I can see that in the mail, an .XML attachment is existing successfully but there is no content. It says some error while reading the file.

Can anyone help me achieve this?

Regards,

Suganya

Re: Attach XML File to email as an attachment

Former Member — Thu, 07 May 2009 06:10:25 GMT

Hi Suganya,

Could you please care to share the solution as am facing the same issue, hope you would respond.

Thanks N Regards,

Abdul.

Re: Attach XML File to email as an attachment

Former Member — Thu, 07 May 2009 06:17:34 GMT

Hello,

Check this link it is help full

https://www.sdn.sap.com/irj/scn/wiki?path=/display/abap/exportingdatatoExcel-XMLtotherescue

http://help.sap.com/abapdocu/en/ABAPCALL_TRANSFORMATION.htm

Re: Attach XML File to email as an attachment

Former Member — Thu, 07 May 2009 06:20:35 GMT

Hi Abdul,

The above code holds good except that the xstring format has to be converted to binary format..

In my code itself, after the loop , just add the below function module .. Rest of the code remains same.

clear: v_resstr, v_line.

LOOP AT t_restab INTO v_line.

CONCATENATE v_resstr v_line INTO v_resstr IN BYTE MODE.

ENDLOOP.

REFRESH: lt_objbin1.

Convert the xstring to binary

CALL FUNCTION 'SCMS_XSTRING_TO_BINARY'

EXPORTING

buffer = v_resstr

TABLES

binary_tab = lt_objbin1.

clear: lv_lines.

CLEAR: wa_objpack.

wa_objpack-transf_bin = c_x.

wa_objpack-head_start = 1.

wa_objpack-head_num = 1.

wa_objpack-body_start = 1.

DESCRIBE TABLE lt_objbin1 LINES lv_lines.

wa_objpack-body_num = lv_lines.

wa_objpack-doc_type = c_xml.

wa_objpack-obj_name = 'XMLAttachment'.

wa_objpack-obj_descr = u2018INVOICE XMLu2019.

wa_objpack-doc_size = ressize.

APPEND wa_objpack TO lt_objpack_final.

APPEND LINES OF lt_objbin1 TO lt_objbin_final.

APPEND LINES OF lt_objpack TO lt_objpack_final.

APPEND LINES OF lt_objbin TO lt_objbin_final.

APPEND LINES OF lt_objtxt TO lt_objtxt_final.

Call the FM SO_DOCUMENT_SEND_API1 to create and the send the mail to the
receivers.

Regards,

Suganya