Skip to Content

rsrt technical information Red light on structure

Hello,

I am building a report with a very large structure. I researched all the limits but i was looking at the tech information and the light is red. I can't seem to find out what red is telling me. I don't want to keep building if this means it will not work :). Any help is greatly appreciated. The bold line has a red light by it.

Statistics Number Max. InfoProviders Involved in the MultiProvider 1 FEMS Number (Selection Groups) 475 8192 Number of Elements in Structure 1 2 9999 Number of Elements in Structure 2 477 9999 Combined Number of Cells (from both Structures) 954 50000 Selection Lines 950 Columns in Memory Table SP 474 Free Chars. 13 Basic Key Figures 1 Formula Components 476 Hierarchies 1 Hierarchy Node 451 Variables 3

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    Oct 30, 2018 at 03:05 PM

    Hi Matthew,

    have a look into the SAP Community Wiki on Query Definition Limits.

    This will give an insight into the generation limits also of the ABAP report.

    'Red' in the RSRT-Technical Information can mean that the query can face performance problems during query runtime, as all the structure elements have to be filled and the properties be evaluated. So, when one record only is fetched and then filled into hundreds of structure elements it could be fast anyway. However, the more records are fetched or the more special features are used within the query, filling all the structure elements can be very slow or even run into memory issues. This has to be checked on each query, the amount of data it fetches and then system ressources it can use.

    Find more information in the SAP Community Wiki Query Performance and Memory.

    Cheers,

    Nora

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 31, 2018 at 08:48 AM

    yes, exactly, this needs to be considered the more features are used in their or it is combined with (other red or yellow lamps in technical information), the risk is higher, that your query runs into performance or memory issues...

    Cheers,

    Nora

    Add comment
    10|10000 characters needed characters exceeded