VL06F Background processing plus sending Excel file by email

[Former Member]

Hello,

someone knows if it's possible on SAP ECC 6.0 to perform a job with a background processing of VL06F (or VL06L) and sending the spool on Excel format by email.

Thanks for your interest.

Best regards

[Former Member · Accepted solution]

Marco, This should be possible.

1. Create a variant for the program WS_MONITOR_OUTB_DEL_FREE.

2. Schedule a background job using SM36.

3. While scheduling the background job, use the spool list recipient option to specify the maild id where the output has to be sent.

4. If the attachment in the mail is not of type excel, go to the transaction SCOT, choose SMTP under INT.

5. use the supported address type to change the required format for the attachment.

Hope this helps.

Thanks,

Vikram.M

[Former Member · Accepted solution]

Yes, it can be an option to choose other formats (PDF, PS, PCL, TXT, RAW) but on SCOT transaction I can't choose XLS format. Do you know if it's possible to add it?

Thank you!

[deep_khanra]

This is main task of ABAP r only, but as i mentioned before this is the process..because i faced before same issue as a functinal consultant.

[neeraj_lal]

We have Zreport where we send spool in excel format as an attachement to the email id.

First we convert  spool in Xstring to have unlimited line width and then we convert Xstring to solix

FM:

'SCMS_TEXT_TO_XSTRING'

Sending new document as an attachment:

'SO_NEW_DOCUMENT_SEND_API1'

I suggest to check this issue in ABAP forum.........

Regards

[Former Member]

Hi Mark Pist

The same can be easily achieved through workflow.

Thanking you!

A M

[Former Member]

So there are no ways to send the spool on Excel format by mail, isn't it?

A M wrote:
Hi Mark Pist
The same can be easily achieved through workflow.
Thanking you!
A M

Could you please tell me how do it?

Thanks!!!

[Shiva_Ram]

I think it is not possible. Can you post this question in ABAP forum to get any other options on your requirements?

Before posting in another forum, please close this thread.

Regards,

[deep_khanra]

Hi Mark,

I want to add something with Vikram which may be helpful....

   WS_DELIVERY_MONITOR programme need set with proper variant with which variant user want to excute the report.

Then with SM36 have to schedule the job with proper  frequency basis.

Developer have to build the excel task.

M-control team have to set the job.

By SOST you able to see mail status.

note is that probably in regression server SMTP  is deactive ..so u have to check whole thing in dev server.

Thanks

Deep