SAP ABAP - Email an ALV Report

In this video I show you how to write a custom ABAP program to e-mail the an ALV report as an attachment. This satisfies the need of delivering customized reporting to your internal as well as external users.
For any questions, please leave me a comment, or send me an e-mail directly: [e-mail]

[@firozkhan-n3p]

Hi Sir,
In the video, I observed that the cl_salv_table reference was used to display an email attachment in XLSX format. My question is: Can we still achieve sending an email attachment in XLSX format without using the cl_salv_table reference or calling the factory method? If possible, could you please make a small video demonstrating this?

[@Pekinceler]

thankk you. i just saw ur videos. it is very helpful.

[@feyzanur8860]

That was very helpful video for my project. Thank you!

[@shashikumar-lu4mw]

can u share source code please thank u

[@maheshnarayan844]

Where to add Commit work?

[@omarrobles7629]

Hi, this video is supper helpful, I will watch the others.
Thanks a lot for this.
I do have couple of questions:
1, right now with current code file in the mail is coming to me as .EXT, do you know how to remove that?
2, why did I had to add the commit work statement and code in the video did not needed it?
Thanks a lot again for all the help.
😁

[@DatGelika]

im getting an error that the file is not in the right format or maybe broken while trying to open the file after the sent.

[@imvision1276]

Getting an error while running 'Access using a 'ZERO' object reference is not possible.'

[@vijaysurya1254]

This video is very useful, but my requirement is report an internal table converted to PDF and sent by email. I need a program or video. Please reply to me, sir.

[@user-jq3mq6jp4p]

I know this very late comment but when tried this code I am not getting any error but when try to check in sost tcode it is not showing any commit of the email.
What might be the problem anyone any idea??

[@radouaneelmhamedi6193]

How to send the data of Table spfli to external E_Mail address, but not as excel file .The data will be displayed in body as email ? . Thanks in advance

[@itwithdustin]

Hi Radouane, you can append the table data in the e-mail text (using HTML if you wish). Just be sure to change the doc type to ‘HTM’ in cl_bcs. I’ll try to make a video on this before the week is out.

[@radouaneelmhamedi6193]

@@itwithdustin all right . thanks for your reponse

[@firozkhan-n3p]

Hi Sir,
How to add multiple recipients to send email as attachment?

[@itwithdustin]

@@firozkhan-n3p just call the add_recipient method for each recipient, or create a new message if you prefer. E-mail groups or reading SAP Distribution lists are good to consider at that point.

[@arishashahid7666]

How to use it with alv grid display

[@vishalwall]

Hi Sir... Please share your source code because i believe like me a lot of people end up typing the whole thing till we realize thats not our requirement. That way we can save time..

[@darksentinel5387]

1:23 There is no bcsy_ text ?

[@RajibHossain007]

Need to send email periodically for multiple users ... Please make a video on it. users also used that report for their general task and need to send that report 1st day of every month(Background send email)

[@itwithdustin]

Hi Rajib! I have existing videos on e-mail and background jobs, if those don’t address your specific inquiry, please feel free to elaborate, or send an e-mail to [e-mail] and I can try to help. Thanks for watching!

[@xxcc5101]

have someone the source code please

[@raheemabap4095]

Hi, how to send the top_of_page information to Excel file like TITLE INFORMATION, Date,.. in top of Excel.
please let me know .

[@itwithdustin]

So long as the top-of-page is applied before calling the to_xml method, this should be applied. Let me know if still issues exist.

[@raheemabap4095]

@@itwithdustin still facing the issue it will not capturing the excel file.

[@itwithdustin]

@@raheemabap4095 I responded to your e-mail, let’s chat there and figure out what’s causing the issue.

[@saiteja7067]

Hi,, is this possible to send data alsong with borders in excel through mail in sap

[@itwithdustin]

Hi, yes, this is possible. Check out the abap2xlsx project. They allow sending formatted spreadsheets via easy to use OO API.

[@ersinb8610]

HI
Thank you for the codes shown in the video.
However, when I run the program, it says mail sent, but SOST does not appear. Can you help with this ?

[@muhdhaziq652]

same problem

[@ersinb8610]

@@muhdhaziq652 send on commit work to use

[@maheshnarayan844]

​@@ersinb8610how to add that and where exactly?

[@xxcc5101]

hi, do you have source code please

[@xxcc5101]

can you explain this please , I can not see the email in SOST
@@ersinb8610

[@shashikumar-lu4mw]

share source code please thank u

[@itwithdustin]

Hi Shashi, all source code is shown throughout the video. Although, I do plan on creating a GitHub repo for future videos. Stay tuned, and thanks for watching!

[@suleymanhilmiyldrm2761]

I sent an email to your email adress. Please check your inbox. Thank you.

[@itwithdustin]

I replied, hope that it helped. :)

[@birdych28]

Could you also share source code with me, Thank

[@pl_swedish3729]

That was very helpful video. Share source code please - thank You.

[@xxcc5101]

hi, did you get the source code please