Ravi Sankar Venna

September 20, 2013 1 minute read

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.

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

You will have the log details as follows:

Now click on “Print” button

Now the log will shown in a report form as shown below:

You can now download the file from the menu, select: System

 List  Save  Local file as shown below:

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.

67 Comments

You must be Logged on to comment or reply to a post.

Former Member

September 20, 2013 at 6:44 am

Very useful one...Thanks for the share.

Best Regards,

Naresh K.

Ravi Sankar Venna

Blog Post Author

September 20, 2013 at 6:46 am

Thanks Naresh, much appreciated your comments.

Kind Regards,

Ravi

Former Member

October 18, 2013 at 10:56 am

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...

Ravi Sankar Venna

Blog Post Author

October 18, 2013 at 11:16 am

Hi Sharu,

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

Kind Regards,

Ravi

Ajay Maheshwari

October 18, 2013 at 11:24 am

This is Swami Ravi's ashirvadam!! Tathastu!! 🙂

Ravi Sankar Venna

Blog Post Author

October 18, 2013 at 2:22 pm

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

Really inspiring. 🙂

Kind Regards,

Ravi

Former Member

October 18, 2013 at 1:53 pm

LOL...

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

@ Ajay : Good One...

Prasad Tatikonda

September 20, 2013 at 6:44 am

Good Document Ravi Garu..

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

thanks for sharing.

Kind Regards,

prasad

Ravi Sankar Venna

Blog Post Author

September 20, 2013 at 6:46 am

Thank you Prasad, much appreciated your comments.

Kind Regards,

Ravi

Former Member

September 20, 2013 at 7:48 am

HI Ravi,

Very useful one .....

Thank you very much

Regards

Praveen

Ravi Sankar Venna

Blog Post Author

September 20, 2013 at 7:50 am

Thanks Praveen 🙂

Best Regards,

Ravi

ManiKumar Yandrapu

September 20, 2013 at 1:18 pm

Hi Ravi,

It is valuable document,thanks for sharing.

Regards

Mani

Ravi Sankar Venna

Blog Post Author

September 20, 2013 at 5:33 pm

Thanks Mani, much appreciated your comments. 🙂

Congrats on becoming Top Contributor in Financials Forum. Keep up your high spirits. 🙂

Best Regards,

Ravi

ManiKumar Yandrapu

September 21, 2013 at 7:55 am

Thanks Ravi Anna 🙂

SUNIL PILLAI

September 21, 2013 at 5:44 am

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.

Ravi Sankar Venna

Blog Post Author

September 21, 2013 at 6:01 am

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

Former Member

September 26, 2013 at 9:19 am

Thanks Ravi.

Former Member

September 26, 2013 at 11:48 am

Hello Ravi,

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

Regards,

Leelendra

Ravi Sankar Venna

Blog Post Author

September 26, 2013 at 11:58 am

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

Kind Regards,

Ravi

Sreekanta Marikeri

September 30, 2013 at 10:01 am

Thanks Ravi for sharing valuble information.

Ravi Sankar Venna

Blog Post Author

September 30, 2013 at 10:27 am

Thanks Mariks.

Jürgen Lins

September 30, 2013 at 10:59 am

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.

Ravi Sankar Venna

Blog Post Author

September 30, 2013 at 11:36 am

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

Former Member

September 30, 2013 at 11:16 am

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

Ravi Sankar Venna

Blog Post Author

September 30, 2013 at 11:39 am

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

Former Member

September 30, 2013 at 12:41 pm

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.

Ranu Eugene

September 30, 2013 at 11:29 am

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

Ravi Sankar Venna

Blog Post Author

September 30, 2013 at 11:40 am

Thanks Eugene, hope you have enjoyed the contents. 🙂

Regards,

Ravi

Ranu Eugene

September 30, 2013 at 11:43 am

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

Former Member

September 30, 2013 at 12:57 pm

Hi,

interesting and useful.

Thanks

Cheers

Ivan

Ravi Sankar Venna

Blog Post Author

September 30, 2013 at 12:59 pm

Thanks Ivan.

Former Member

October 9, 2013 at 11:44 am

Thanks Ravi for sharing this useful document. Thanks Sukant Chakraborthy

Ravi Sankar Venna

Blog Post Author

October 9, 2013 at 12:03 pm

Thanks Sukant.

Anss Shahid

October 10, 2013 at 5:29 am

Nice work Ravi....

Ritesh Kumar

October 11, 2013 at 10:19 am

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

Ravi Sankar Venna

Blog Post Author

October 11, 2013 at 11:11 am

Thanks Ritesh for your comments.

Kind Regards,

Ravi

Former Member

October 12, 2013 at 11:27 am

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

Ravi Sankar Venna

Blog Post Author

October 12, 2013 at 11:48 am

Thank you ACR.Ruben. 🙂

Regards,

Ravi

Former Member

October 13, 2013 at 5:31 am

Hi Ravi

very useful document ravi..

Thanks & Regards

Dhanaprabu

Srinu S

October 16, 2013 at 7:23 am

Hi Ravi,

Very helpful document. Thanks for sharing your knowledge.

Regards,

Srinu.

Ravi Sankar Venna

Blog Post Author

October 16, 2013 at 9:07 am

Thanks Srinu, glad to know you liked the contents.

Kind Regards,

Ravi

Lakshmi Kumari Sama

October 16, 2013 at 7:30 am

Hi Ravi,

Good one 🙂 but i am expecting docs on FI controlling part as suits to your range.

Thanks & Regards,

Lakshmi S

Ravi Sankar Venna

Blog Post Author

October 16, 2013 at 9:08 am

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

Thanks once again for your cheerful words.

Kind Regards,

Ravi

sreehari tokala

October 18, 2013 at 6:27 am

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.

Diwa p

October 18, 2013 at 11:56 am

Hi Ravi,

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

Regards

Diwa

Ravi Sankar Venna

Blog Post Author

October 18, 2013 at 2:23 pm

Thanks Diwa, much appreciated your comments.

Kind Regards,

Ravi

Former Member

October 22, 2013 at 2:12 pm

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

Former Member

October 28, 2013 at 4:58 am

Very helpful document.

Thanks for sharing your knowledge.

Regards,

Shokat

Ravi Sankar Venna

Blog Post Author

October 28, 2013 at 8:43 am

Thanks Shokat, much appreciated your comments.

Kind Regards,

Ravi

Former Member

October 28, 2013 at 5:26 am

Thanks Mr.Raviji,

Much much appreciated - the way you are helping others.

Kind Regards

pankaj

Ravi Sankar Venna

Blog Post Author

October 28, 2013 at 8:44 am

Hi Pankaj,

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

Thanks for your comments.

Kind Regards,

Ravi

Former Member

October 28, 2013 at 9:35 am

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

Ravi Sankar Venna

Blog Post Author

October 28, 2013 at 11:06 am

Thanks Pankaj.

I am glad to know that I can even work as a GPS 😉

Thanks for your comments, much appreciated.

Best Regards,

Ravi

Amala Srinivasa Rao

April 22, 2014 at 6:38 am

Good Tip 😆

Former Member

July 16, 2014 at 7:14 am

Thank you for sharing... 🙂

Former Member

July 17, 2014 at 12:00 pm

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

Former Member

July 17, 2014 at 12:19 pm

Very usefully. Thanks

Srinivas Salpala

July 17, 2014 at 12:23 pm

Ravi Bhai,

Nice document with clear understanding the process.

Helping the forum a lot with your blogs.

BR, Srinivas Salpala

Ravi Sankar Venna

Blog Post Author

July 17, 2014 at 12:38 pm

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

Srinivas Salpala

July 17, 2014 at 12:46 pm

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

BR, Srinivas Salpala

Sivaram V

July 17, 2014 at 12:42 pm

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.

Sanil Bhandari

July 18, 2014 at 4:40 am

Hi Ravi

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

Regards

Sanil Bhandari

Ravi Sankar Venna

Blog Post Author

July 18, 2014 at 7:04 am

Thanks Sanil, great pleasure to receive such comments 🙂

BestRegards,

Ravi

Former Member

July 21, 2014 at 6:47 am

Thank you for sharing... 🙂

Bohdan Petrushchak

August 19, 2014 at 1:27 pm

Hello Ravi!

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

Aaron Kitts

June 25, 2019 at 12:58 pm

Very helpful.

Thanks

Nicolas JOSEPH-CHARLES

December 17, 2021 at 3:32 pm

Hi Ravi,

Just beautiful. And invaluable.

Thanks a lot !

Nico

How to download Batch Input Session Log?

Assigned Tags