Skip to Content
-1

How many records can be displayed?

Hi,

I would like to ask if someone knows how many records can be displayed from alv report with internal tables?

I made an alv report and when I run it in Development it is OK.In productive the records are about 1700000 and I cannot run it. Is there any limitations in report with internal tables?

Thank you in advance.

Add comment
10|10000 characters needed characters exceeded

  • "cannot run" but what happens exactly? short dump in ST22? what does it say?

  • I would like to thank you all of you that answered me. The purpose of requirement is to check the amount of each document number/GL account and ledger for a year. Finally,they run it per semester in quality system and next to production system.

  • With 1.7 Million records, no-one is going to be able to check that amount of data. The requirement still makes no sense. Is someone really going to sit at a screen and go through every one of those 1.7 million records and check the amounts are correct? Or print off 17'000 pages of report?

    It just isn't feasible.

    For that reason, I'm closing this question. I don't think anything useful can be added.

Further commenting has been locked.
  • Get RSS Feed

6 Answers

  • Mar 01 at 08:31 AM

    Christina - 1.7 Mio records in an ALV sounds like way too much data for anything considered a meaningful selection. Who is going to look at or work with them? So, instead of trying to get them to display, how about restricting your selection to something managable?

    Add comment
    10|10000 characters needed characters exceeded

    • You are merely stating a requirement. You are not answering Bärbel's question.

      As a developer, if you get requirements that don't make sense, you have a responsibility to push back. It makes no sense to have a report with 1.7 million records displayed on it. There is no feasible use for that amount of data in a report.

      You should add a check to your selection screen so that if certain criteria are not filtered on, an error (or warning) message is displayed.

  • Mar 02 at 01:02 PM

    Who asked this to you, ask for actual purpose, no human will read so many records, look more like an export than a report. You could consider building a file for FTP by package or, if available, fulfill the requiremenr in BW or BI...

    Also there are limitation in your system to protect other users performance, so you go for a dump for lack of memory or time out (ask basis, but don't expect too much)

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 01 at 10:44 AM
    Add comment
    10|10000 characters needed characters exceeded

  • Mar 01 at 04:48 AM
    -1

    hi

    maybe that is depend upon memory space of internal table in production system.

    check with basis people for increase memory space of internal table and then try.

    Add comment
    10|10000 characters needed characters exceeded

    • I have down voted this answer for two reasons:

      1. The immediate cause is lack of memory, but the solution is simply to not select so much data

      2. No half-way sane basis team is going to increase memory allocation for a report that cannot even be used in an sensible manner.

      When answering questions, please consider the wider implications. Otherwise you lead the OP down a false route, which is not helpful.

  • Mar 02 at 08:00 PM

    Although i'm not familiair with your system (Hana DB?), maybe you could try to use a CDS view and access the data with IDA?

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 03 at 06:06 AM

    A SAP system has a certain amount of memory available and allocated to a user's session. The limit on the size of an internal table is that amount of memory.

    Add comment
    10|10000 characters needed characters exceeded