Right click and copy the link to share this comment. Hi Pradeep, Thanks for your comments, Actually the data type i used is exactly what mentioned in the function itself.
Thanks for the update. Naveen George. Hi, Good one. Thanks, Naveen. Link Text. Open link in a new tab. Place this at the end of the program.
Everything is very interesting to learn and easy to understood. Now execute the program and you should see that it not only produces the 3 ALV reports but also results in an Excel spreadsheet created and mailed to the recipient email address, both in foreground and in background executions.
October 22nd, at We can certainly achieve to display the Amounts in an Accountant friendly way. The SAP provided conversion exit functions must be called individually in the programs to convert the field value internally and externally. If you see your new zlv message in the queue in a waiting status, select the row s to be dispatched, then from the menu select the command: Something similar to this: Thus it looks ugly.
Next, we need a new subroutine that can accept both a standard table of ALV report content and a description for it, and to use these to create a new Excel worksheet.
Generalize the call to conversion exit functions Well, everybody will be aware of the conversion exit functions available in SAP. October 24th, at 4: Well, everybody will be aware of the conversion exit functions available abaap SAP. You need to specify the Conversion Routine for the column where you need to formatting. October 24th, at When a job has multiple associated spool requests, then the All Spool Requests icon should also appear on this display to the right of the Spool icon:.
Then adjust the code between the report statement and the start-of-selection statement to include:. After pursuing this further I soon found that for programs producing multiple ALV tables of anap, each ALV table becomes its own independent output spool request, and the process noted above to have the output sent to convvert spool list recipient will cause only the last of these multiple output spools to be sent in an email.
In this screen next thing we will do is Executing the convertion by F8 shortcut. Online PDF conversion may take some time according to the size of the spool request you want to convert into PDF file format.
Save the PDF conversion file on your computer. Execute your ALV report. It generates Spool Request. Execute Std. Go to transaction SP02 and see the spool number which is created by time or date. Then F8 and give the file name with DOTpdf. Now go to your file and see If any query then ask me.
Can I know how did you solve your query. What logic did you apply to solve this one as first you need to create spool request and pass it to function module to convert it to PDF.
The way Dilip has suggested is not a part of coding. I thought you achieved it through coding. That link contains code for the same. By the way, there is one more way of converting any output to PDF. That is through PDF printer.
Its not allowing me to execute the Report, directly show pop-up for Print… Is this right, if not pls correct me.. There is no need to pass that parameter. In my next post I have removed that parameter. There I am displaying the ALV grid at first. Once you press it, it will again call the ALV list. Instead will create a spool request and pass it to function module to convert it to PDF.
Just refer below code. Only half part is visible in that link. CASE sy-ucomm. When I am executing above code. I am getting following message. What is the number of pages? It may be because of the large size. This is what I came to know when I searched the net for the same. The real problem is the exception Conversion not possible.
Just try doing it for small size ALV report first and check. I found out the solution for the exception. Implement the logic to submit the program and download data into PDF.
The below code has lots of steps, please try to understand based on comments provided. If the file is no so long, you can directly download the content in AL Navigate to the file. Then Open the file. In some case, the exported file is truncated.
0コメント