Literally every week a new person posts a blog like the one above, describing how they have worked out how to export SAP data to excel in the background.In some ways that’s good, as it means there are lots of clever people out there, but it also means hundreds of people at any given time are busily re-inventing the wheel, unaware that the answer to their problem is a mouse click away.Cheersy CheersPaul. Hello,Firstly well done, an dnot trying to take anything away from your solution, but as an alternative, if you were to search for ABAP2XLS on the SCN website you might be surprised to find that it’s purpose is to create spreadsheets from SAP data, including SALV reports.I have to conclude that the knowledge sharing aspect of SCN is not working as well as it might. Variable Declaration.b.Data Selection/ALV Customizing calls.c.Call to Convert ALV Output as internal XML Format.d.E-Mail Data Declaration.e.EMail – Content Conversion/Body/Attachment CreationSend E-MailExcel Outputwe can also use TOXML method to download the content as an XLS or XML documents in Abap Web dynpro based applications.Here is the sample source code for this approach. This method will have the formatted output content as XSTRING value.Here are the steps.a. To achieve the same we can use the method TOXML of class CLSALVTABLE. Recently, have come across a requirement to send output of report developed based on SALV as an excel attachment.
0 Comments
Leave a Reply. |