Skip to Content
author's profile photo Former Member
Former Member

How to extract data from table for huge volume

Hi,

I have around 200000 material doc number for which need to get material number from MSEG table but while using SE16 it gives dump , i have even tried breaking it into batches of 20000 records but still SAP gives dump on executing SE16 for MSEG. Please advise if there is any alternate way to get data from SE16 table for such a large volume.

Note: In our system SE16N does not work, only SE16 is there for our SAP version.

Thanks,

Vihaan

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Mar 24, 2010 at 11:33 PM

    Vihaan,

    It is usually unprofitable to download the entire contents of a table. Better to select exactly the data you wish to see, using a transaction, a query, or a report.

    Anyhow, if your SE16 dump is due to a timeout (exceeded the interactive time limit), you can run SE16 in background. SE16>enter table>enter selection parameters

    Then Program>execute in background. In most systems, there is no time limit for background jobs.

    Rgds,

    DB49

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Vihaan,

      Yes, I understand, and the program is failing. Now we are talking about workarounds.

      You could change your selection criteria from 5000 indivual mat doc numbers to a range of doc numbers,or a series of ranges of doc numbers. You could try wildcards. You will get more records than you need, but you can then externally filter the results once the program has successfully completed and you have the downloads.

      Also, as another workaround method, have you tried MB51? If you could somehow coax the results you wish out of this transaction, you could avoid having to create a custom z program report.

      Rgds,

      DB49

  • Posted on Mar 24, 2010 at 11:13 PM

    do you get dumps while executing SE16 on table MSEG, or do you get the dump because you entered 20000 document numbers into the multiple selection ?

    in case of multiple selections you probably have to go down to about 1000 as maximum.

    What does the dump tell you about the reason? timeout?

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Jurgen,

      Thanks for your reply.

      I am getting Dump when i enter more than 5000 records as input parameter in MSEG, if I put more than that then it gives dump as "ABAP runtime errors SAPSQL_STMNT_TOO_LARGE ".

      I understand that I can extract data restrciting 5000 every time but I have around 250000 material docs so that means if we consider batches of 5000 I need to run the step more 50 times--> 50 excel files. I wanted to avoid that as that is going to take lots of my time.

      Any suggestion, please help.

      Also wanted to highlight that apart from Material Doc number I am entering Plant (8 plants) and Mvt type (14 mvt type) also as input parameter.

      Regards,

      Vihaan

      Edited by: Vihaan on Mar 25, 2010 12:30 AM

  • author's profile photo Former Member
    Former Member
    Posted on Oct 25, 2010 at 06:14 PM

    done

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.