Read Excel attachment from mail

[Manohar2u]

Hi,

Will be happy to know the inputs for the below specific requirement,

Step 1 : User will get an email into SAPinbox with an excel or text file as attachment.

Step 2 : Then a background <b>(automatic)</b> program should read the mail including the attached file.

Step 3 : Program should extract and data from excel file then execute some business process.

Any inputs will be highly helpful.

Regards

Manohar

[Former Member]

Step 1:

Use function module 'SO_NEW_DOCUMENT_ATT_SEND_API1' to send mail with an attachment into SAP inbox.

Step 2:

While sending the attachment anyway the data you send in the excel is from an internal table only. Either the data is there in the excel or in the internal table.If the data is there in the excel you can always upload it into an internal table and using this data you can do the 3 step of executing the business process.

I hope it is clear.

Cheers,

Saraswathi.

[Manohar2u]

Thanks for you immediate response saraswathi.

I think am not given clear info above, but an email will from from external id, not form SAP.

[Former Member]

Hi Manohar,

The mail which comes into SAP Inbox with say .xls file, when the attachment is selected, SAP downloads that .xls file to your presentation server and the same is opened through EXCEL.

If the path and filename is fixed, you can write a program which calls FM SO_OBJECT_UPLOAD, get the data, and do the processing of the same.

Regards,

Raj

[Manohar2u]

Raj, This is a background & automatic activity, and user will not open this manually.

Meanwhile I am going thru this blog

<u>/people/thomas.jung3/blog/2004/09/09/receiving-e-mail-and-processing-it-with-abap--version-610-and-higher

Regds,

Manohar