Skip to Content
Author's profile photo Ravi Sankar Venna

How to download Batch Input Session Log?

There is always a requirement to download the Batch Input Session Log, but always people are roaming around how to download it. This log is particularly required when huge number of records are being posted / created through SM35 and some of the records are failed. We can see the log on the screen showing which number record is being failed, but do not know if there is any way that this log can be downloaded to a spread sheet. Even most of the consultants may not aware how this can be done. However, it is a small navigation tip helps to download this whole log.  
Now go to SM35 and select your batch job.

Click on “Log” button. (From the top 4th button from the left)
You will have the following log overview screen.

File 1.png

Select the log overview line and click on “Display” button.

You will have the log details as follows:

File 2.png
Now click on “Print” button

Now the log will shown in a report form as shown below:
File 3.png
You can now download the file from the menu, select: System
οƒ  List οƒ  Save οƒ  Local file as shown below:
File 4.png

Select “Spreadsheet” option and download to the required location on your computer.

Many consultants think that this is very easy to download. But, in reality, I asked number of times to many consultants, however, they have no clue how to download it. Hope this tip would surely be helpful.

Assigned tags

      66 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Very useful one...Thanks for the share.

      Best Regards,

      Naresh K.

      Author's profile photo Ravi Sankar Venna
      Ravi Sankar Venna
      Blog Post Author

      Thanks Naresh, much appreciated your comments.

      Kind Regards,

      Ravi

      Author's profile photo Former Member
      Former Member

      Dear Ravi,

      Indeed this very helpful... But most of the time I have faced problem where is job run for large data and in comes with around say 20 pages as output. So how can we download that ?

      When I tried with this way ( long back ) its all scattered and untidy.... Do you have any idea how can we download large data from Batch Input.

      Regards,

      Sharu... 

      Author's profile photo Ravi Sankar Venna
      Ravi Sankar Venna
      Blog Post Author

      Hi Sharu,

      If you follow this blog, then you would be able to download any number of pages, without any scattering.

      Kind Regards,

      Ravi

      Author's profile photo Ajay Maheshwari SAP Trainer
      Ajay Maheshwari SAP Trainer

      This is Swami Ravi's ashirvadam!! Tathastu!! πŸ™‚

      Author's profile photo Ravi Sankar Venna
      Ravi Sankar Venna
      Blog Post Author

      Thanks Ajay. It is always admiring thing to see your comments.

      Really inspiring. πŸ™‚

      Kind Regards,

      Ravi

      Author's profile photo Former Member
      Former Member

      LOL...

      Thanks Ravi... I will follow the guidelines... Thanks alot for help.

      @ Ajay : Good One...

      Author's profile photo Former Member
      Former Member

      Good Document Ravi Garu..

      It is very useful when we need to analyse failed batches.

      thanks for sharing.

      Kind Regards,

      prasad

      Author's profile photo Ravi Sankar Venna
      Ravi Sankar Venna
      Blog Post Author

      Thank you Prasad, much appreciated your comments.

      Kind Regards,

      Ravi

      Author's profile photo Former Member
      Former Member

      HI Ravi,

      Very useful one .....

      Thank you very much

      Regards

      Praveen

      Author's profile photo Ravi Sankar Venna
      Ravi Sankar Venna
      Blog Post Author

      Thanks Praveen πŸ™‚

      Best Regards,

      Ravi

      Author's profile photo ManiKumar Yandrapu
      ManiKumar Yandrapu

      Hi Ravi,

      It is valuable document,thanks for sharing.

      Regards

      Mani

      Author's profile photo Ravi Sankar Venna
      Ravi Sankar Venna
      Blog Post Author

      Thanks Mani, much appreciated your comments. πŸ™‚

      Congrats on becoming Top Contributor in Financials Forum. Keep up your high spirits. πŸ™‚

      Best Regards,

      Ravi

      Author's profile photo ManiKumar Yandrapu
      ManiKumar Yandrapu

      Thanks Ravi Anna πŸ™‚

      Author's profile photo SUNIL PILLAI
      SUNIL PILLAI

      In my Implementation project 2 years ago, did a good amount of roaming to find this out,  finally to get a hint about it from a comment to a question in SCN,

      Nice thought to put it as a doc This will be help full to all the new members.

      Author's profile photo Ravi Sankar Venna
      Ravi Sankar Venna
      Blog Post Author

      Hi Sunil,

      Even I have struggled and asked few of my developers and could not find a solution.

      Though this looks very simple, many people might not be knowing, this would be handy at cases.

      Kind Regards,

      Ravi

      Author's profile photo Former Member
      Former Member

      Thanks Ravi.

      Author's profile photo Former Member
      Former Member

      Hello Ravi,

      Thanks much! I had this question and glad to get the answer now.

      Regards,

      Leelendra

      Author's profile photo Ravi Sankar Venna
      Ravi Sankar Venna
      Blog Post Author

      Thanks Leelendra, glad to know you liked it and hope it would be useful to you.

      Kind Regards,

      Ravi

      Author's profile photo Mariks .
      Mariks .

      Thanks Ravi for sharing valuble information.

      Author's profile photo Ravi Sankar Venna
      Ravi Sankar Venna
      Blog Post Author

      Thanks Mariks.

      Author's profile photo JΓΌrgen L
      JΓΌrgen L

      Why dont you just click the Excel button in that screen  instead of

      List > Save > Local file ?

      you get directly a good format and do not need to amend it later.

      Author's profile photo Ravi Sankar Venna
      Ravi Sankar Venna
      Blog Post Author

      Hi Jurgen,

      It does not really matter whether it is "Local File " or "Excel File". There are number of way to download them.

      Though this is small navigation tip, many consultants not aware to be reach this screen to download. Once they reach this screen, they can download whatever be convenient format for them to download.

      Regards,

      Ravi

      Author's profile photo Former Member
      Former Member

      Good Effort Ravi,

      Just to add to your document, SAP sometimes gives a extract error in the Local file (mostly in case of Excel output) which we extract in cases where there are many columns in a table or many enries to be downloaded.

      In this case, downloading in small chunks can be helpful.

      Regards,

      Dinesh

      Author's profile photo Ravi Sankar Venna
      Ravi Sankar Venna
      Blog Post Author

      HI Dinesh,

      Once we click to download, we cannot really restrict it to small chunks. If needs to be downloaded completely, after downloading if we do not really need any data, which can anyway be deleted from the downloaded file. Whether it is local file or excel does not really make any difference in the content, however, one format looks the better than the other.

      Regards,

      Ravi

      Author's profile photo Former Member
      Former Member

      Hi Ravi,

      Thanks for your reply.

      Actually we had faced the issue while downloading the data from master table as a part of data extraction, we faced issue while downloading the table entries in a local file.

      Sometimes, even one extra line was populated between 2 records in a excel sheet, thus we had to re-extract the data from the tables with less number of entries for extraction.

      May be this is different from the explained scenerio. but wanted to share the experience during saving into local file.

      Regards,

      Dinesh R.

      Author's profile photo Ranu Eugene
      Ranu Eugene

      Hi Ravi,

      Thanks for sharing such a valuable document.

      Well I have already said in my earlier comments that whatever you write is worth reading and see I am not wrong. πŸ˜‰

      Keep up the good work buddy. πŸ™‚

      Best of Luck. πŸ™‚

      Regards

      Eugene

      Author's profile photo Ravi Sankar Venna
      Ravi Sankar Venna
      Blog Post Author

      Thanks Eugene, hope you have enjoyed the contents. πŸ™‚

      Regards,

      Ravi

      Author's profile photo Ranu Eugene
      Ranu Eugene

      As I mentioned earlier also that I seriously enjoy reading and following your contents and to be very straight,first thing what I do is look for your blogs, documents everyday coz it really gives good knowledge every time. πŸ™‚

      Thanks again for sharing and do keep motivating and keep educating us(SCN Members) with your tips. πŸ˜‰

      Best of Luck.

      Regards

      Eugene

      Author's profile photo Former Member
      Former Member

      Hi,

      interesting and useful.

      Thanks

      Cheers

      Ivan

      Author's profile photo Ravi Sankar Venna
      Ravi Sankar Venna
      Blog Post Author

      Thanks Ivan.

      Author's profile photo Former Member
      Former Member

      Thanks Ravi for sharing this useful document.  Thanks Sukant Chakraborthy

      Author's profile photo Ravi Sankar Venna
      Ravi Sankar Venna
      Blog Post Author

      Thanks Sukant.

      Author's profile photo Anss Shahid Essani
      Anss Shahid Essani

      Nice work Ravi....

      Author's profile photo Ritesh Kumar
      Ritesh Kumar

      Hi Ravi,

      This is really very helpful document for me. I remember long back i use to keep screen short of the logs when i was not knowing how to save it in excel or text format.

      This is really good πŸ™‚

      Best Wishes,

      Ritesh Kumar

      Author's profile photo Ravi Sankar Venna
      Ravi Sankar Venna
      Blog Post Author

      Thanks Ritesh for your comments.

      Kind Regards,

      Ravi

      Author's profile photo Former Member
      Former Member

      Hi Ravi,

      Though it looks simple but it is critically needed for analysis.

      It looks simple now since you have made the documentation very neatly.

      Thanks a ton. Keep rocking.

      Regards

      ACR.Ruben

      Author's profile photo Ravi Sankar Venna
      Ravi Sankar Venna
      Blog Post Author

      Thank you ACR.Ruben. πŸ™‚

      Regards,

      Ravi

      Author's profile photo Former Member
      Former Member

      Hi Ravi

         very useful document ravi..

      Thanks & Regards

      Dhanaprabu

      Author's profile photo Srinu S
      Srinu S

      Hi Ravi,

      Very helpful document. Thanks for sharing your knowledge.

      Regards,

      Srinu.

      Author's profile photo Ravi Sankar Venna
      Ravi Sankar Venna
      Blog Post Author

      Thanks Srinu, glad to know you liked the contents.

      Kind Regards,

      Ravi

      Author's profile photo Lakshmi Sama
      Lakshmi Sama

      Hi Ravi,

      Good one πŸ™‚ but i am expecting docs on FI controlling part as suits to your range.

      Thanks & Regards,

      Lakshmi S

      Author's profile photo Ravi Sankar Venna
      Ravi Sankar Venna
      Blog Post Author

      Thanks Lakshmi. Hopefully, I should find some time to write the blogs.

      Thanks once again for your cheerful words.

      Kind Regards,

      Ravi

      Author's profile photo sreehari tokala
      sreehari tokala

      Thank you Very much Ravi Sir. It's very help full. i'm adding  new things to my knowledge. your postings are giving energy to my sap Career.

      Thanks & Regards,

      Sreehari.

      Author's profile photo Diwa p
      Diwa p

      Hi Ravi,

      your an asset to scn.thanks you so much for your valuable information.

      Regards

      Diwa

      Author's profile photo Ravi Sankar Venna
      Ravi Sankar Venna
      Blog Post Author

      Thanks Diwa, much appreciated your comments.

      Kind Regards,

      Ravi

      Author's profile photo Former Member
      Former Member

      Another simple and useful tip from Ravi, Thanks.  It is interesting, still BDC is/can be used.  For example, direct update of settlement rules on WBS Element thru function modules like K_SRULE_CREATE,  does not update the system status with 'SETC' (Settlement rule created). 

      Regards

      Ram Vusirikala

      Author's profile photo Former Member
      Former Member

      Very helpful document.

      Thanks for sharing your knowledge.

      Regards,

      Shokat

      Author's profile photo Ravi Sankar Venna
      Ravi Sankar Venna
      Blog Post Author

      Thanks Shokat, much appreciated your comments.

      Kind Regards,

      Ravi

      Author's profile photo Former Member
      Former Member

      Thanks Mr.Raviji,

      Much much appreciated - the way you are helping others.

      Kind Regards

      pankaj

      Author's profile photo Ravi Sankar Venna
      Ravi Sankar Venna
      Blog Post Author

      Hi Pankaj,

      Hope you have enjoyed the document and it would be helpful to you.

      Thanks for your comments.

      Kind Regards,

      Ravi

      Author's profile photo Former Member
      Former Member

      Dear Mr. Raviji,

      It did help me a lot.

      What i have seen in SAP and in normal world, is, we don't observe small things - sometime we even blindly follow instructions only (like GPS) and don't see that another great option is sitting next to the button we click every day,

      Very glad that you showed (taught) us the button which we see everyday in our routine, still never realize the importance.

      Many Thanks once again,

      kind regards

      pankaj

      Author's profile photo Ravi Sankar Venna
      Ravi Sankar Venna
      Blog Post Author

      Thanks Pankaj.

      I am glad to know that I can even work as a GPS πŸ˜‰

      Thanks for your comments, much appreciated.

      Best Regards,

      Ravi

      Author's profile photo Former Member
      Former Member

      Good Tip πŸ˜†

      Author's profile photo Former Member
      Former Member

      Thank you for sharing... πŸ™‚

      Author's profile photo Former Member
      Former Member

      Hi Ravi,

      Nice Document.I totally agree with the words of Ranu Eugene "I seriously enjoy reading and following your contents and to be very straight,first thing what I do is look for your blogs, documents everyday coz it really gives good knowledge every time. πŸ™‚ "

      Always thanks to you for share your knowledge to SCN community.

      Thanks,

      Lakshmi

      Author's profile photo Former Member
      Former Member

      Very usefully. Thanks

      Author's profile photo Srinivas Salpala
      Srinivas Salpala

      Ravi Bhai,

      Nice document with clear understanding the process.

      Helping the forum a lot with your blogs.

      BR, Srinivas Salpala

      Author's profile photo Ravi Sankar Venna
      Ravi Sankar Venna
      Blog Post Author

      Thanks Srini,

      Honestly, I need find some time and motivation to write some more. From a long time, I have not written any blog / document πŸ™

      Hopefully, I should find some time πŸ™‚

      Best Regards,

      Ravi

      Author's profile photo Srinivas Salpala
      Srinivas Salpala

      Hope, at least with my conversation if you start focus on more blogs would be really helpful to forum. πŸ™‚

      BR, Srinivas Salpala

      Author's profile photo Sivaram V
      Sivaram V

      Hi Ravi,

      What ever blog you write's is precious, i know the importance of this log extracts majorly at the time of data loads. Thanks once again.

      Regards,

      Sivaram.

      Author's profile photo Sanil Bhandari
      Sanil Bhandari

      Hi Ravi

      I have been following your posts for four years now and every single document/post is really very useful.

      Regards

      Sanil Bhandari

      Author's profile photo Ravi Sankar Venna
      Ravi Sankar Venna
      Blog Post Author

      Thanks Sanil, great pleasure to receive such comments πŸ™‚

      BestRegards,

      Ravi

      Author's profile photo Former Member
      Former Member

      Thank you for sharing... πŸ™‚

      Author's profile photo Bohdan Petrushchak
      Bohdan Petrushchak

      Hello Ravi!

      Thank you for another good tip. I was not aware of this feature!

      Author's profile photo A K
      A K

      Very helpful.

      Thanks