Skip to Content

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.

To report this post you need to login first.

65 Comments

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

      1. Sharvari Joshi

        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… 

        (0) 
        1. Ravi Sankar Venna Post author

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

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

          Best Regards,

          Ravi

          (0) 
  1. 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.

    (0) 
    1. Ravi Sankar Venna 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

      (0) 
  2. 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.

    (0) 
    1. Ravi Sankar Venna 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

      (0) 
  3. Dinesh Rupraj

    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

    (0) 
    1. Ravi Sankar Venna 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

      (0) 
      1. Dinesh Rupraj

        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.

        (0) 
  4. 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

    (0) 
      1. 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

        (0) 
  5. 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

    (0) 
  6. ACR RUBEN

    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

    (0) 
  7. 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.

    (0) 
  8. Ram Vusirikala

    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

    (0) 
      1. Pankaj K Agrawal

        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

        (0) 
    1. lakshmi p

      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

      (0) 
    1. Ravi Sankar Venna 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

      (0) 
  9. 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.

    (0) 

Leave a Reply