topic Re: Mail Send in Application Development and Automation Discussions

Mail Send

Former Member — Mon, 22 Oct 2007 06:48:14 GMT

HI,

I am using 'SO_DOCUMENT_SEND_API1' to send a Email as excel attachment .

before entering into the FM the internal table is showing records as below

Material Number #Material Type

000010001 # ROH

But after mail triggering the excel sheet delivered all the records in one line as below.

Material Number #Material Type 000010001 # ROH

Plz provide me solution that it should display as if in the Internal Table.

Thanks in adv.

Former Member — Mon, 22 Oct 2007 07:56:29 GMT

Hi,

While giving the parameters Change the file type ' dat' or asc

bin.

Try with all the 3 options. U will get the correct output.

Assign points if useful.

Former Member — Mon, 22 Oct 2007 08:00:22 GMT

Try like this in your coding

doc_type = 'XLS'

DATA : it_xl TYPE soli_tab WITH HEADER LINE.

CONSTANTS : tab_mark TYPE x VALUE '09'. "tab character

CONSTANTS : cr_mark TYPE x VALUE '0D'. "carriage return character

CONCATENATE tab_mark 'Finished Goods' cr_mark into it_xl.

APPEND it_xl.

clear it_xl.

Then when you're ready to call the FM to send the attachment remember

for your packing list to use doc_type = 'XLS' and use a file name with a

'.xls' extension for the obj_descr. Eg:

objpack-transf_bin = 'X'.

objpack-head_start = 1.

objpack-head_num = 1.

objpack-body_start = 1.

objpack-body_num = tab_lines.

objpack-doc_type = 'XLS'.

objpack-obj_name = 'STOCK REP'.

objpack-obj_descr = 'Report.xls'.

APPEND objpack.

Regards

Pavan