Do you have the "Analyze erroneous transactions" option
available to you on your LSMW menu ? If you don't, switch it on using the "Personal Menu" button.
Execute this option (which allows you to choose which fields you would like to display from your LSMW load) and download the results into Excel. This option is good because it only shows you the failed
transactions whereas the LSMW log shows you all transactions and you need to filter through them to find the failed ones.
If this doesn't give you what you require,then just print the logs.When you press print, the system should take you to another screen, you can download this screen to Excel using the =>System =>List =>Save option, or you can press print and download the data from your spool file.
Hope this helps.
1. go to SM35
2.select session you wnat
3.Select 'LOG' (F7) from application toolbar,
4.Select Log from Log Overview and press display(F2).
5.Do Cntrl+P or press print From ABAP list Viewer button in Menu bar.
6. it will result in ALV display of log.
7. get excel file from ALV or use List->Export->local file.
8. you can get pivot table or simple excel o/p.