VA05 - limit of records (250 000 records)

[paweljurek]

Hi All,
I noticed that my report VA05 started to display a limited number of rows (only 250 000 records), how can I change it?

[moshenaveh]

Welcome to the SAP Community. Thank you for visiting us to get answers to your questions.

Since you're asking a question here for the first time, I'd like to offer some friendly advice on how to get the most out of your community membership and experience.

First, please see https://community.sap.com/resources/questions-and-answers, as this resource page provides tips for preparing questions that draw responses from our members. Second, feel free to take our Q&A tutorial at https://developers.sap.com/tutorials/community-qa.html, as that will help you when submitting questions to the community.

I also recommend that you include a profile picture. By personalizing your profile, you encourage readers to respond: https://developers.sap.com/tutorials/community-profile.html.

Now for some specific suggestions on how you might improve your question:

* Outline what steps you took to find answers (and why they weren't helpful) -- so members don't make suggestions that you've already tried.

* Share screenshots of what you've seen/done (if possible), as images always helps our members better understand your problem.

Should you wish, you can revise your question by selecting Actions, then Edit.

The more details you provide (in questions tagged correctly), the more likely it is that members will be able to respond.

I hope you find this advice useful, and we're happy to have you as part of SAP Community!

[RaymondGiuseppi]

You're not actually running VA05 on your screen, I suppose. Why would you need so much data (that most humans will never read, and think of the performance and resource issues)?

[Dominik_Tylczynski]

Hello

It looks like a hardcoded limit in the CL_SDOC_VIEW class, method START_OF_SELECTION:

  method start_of_selection.

    constants:
      lc_listtype type ltdxkey-type   value 'F',
      lc_no_out       type ltdxdata-param value 'NO_OUT',
      lc_valuf        type ltdxdata-param value 'VALUF'.

    data:
      ls_varkey    type ltdxkey,
      lt_dbfact    type standard table of ltdxdata,
      lt_dbfilter     type standard table of ltdxdata,
      lt_fieldlist type tdt_fieldname.

    if mo_sdoc_select_adapter is not bound.
      return.
    endif.

    ms_selcrit = is_selcrit.

    ms_selcrit-maxsel = 250000.

You may try to change it but bear in mind that it will impact performance and it is a modification to SAP standard.

Anyway, why would you want to report over 1/4 million sales orders?

Best regards

Dominik Tylczynski

[Santana_ForquestGo]

Thanks a lot for your help

[Santana_ForquestGo]

While SAP S/4HANA 1909 offers greater flexibility with fewer restrictions, SAP S/4HANA 2023 introduces certain limitations,