topic Re: ALV sort-table limits in Application Development and Automation Discussions

ALV sort-table limits

Former Member — Thu, 05 Apr 2007 14:03:56 GMT

Hi,

When using the internal table it_sort to set the sort criteria for first display for an ALV using the FM REUSE_ALV_GRID_DISPLAY, is there any limit on the number of rows in the table, that is, on the number of fields to be sorted on?

Likewise, is there any limit to the number of fields that the user can sort on in Change Layout?

I have a report in which the user can select the fields to report in the selection screen, and when a large number of fields is selected, the above sorts fail (the rows appear in the wrong order), but there's no problem with the same report for a small number of fields.

Thanks,

John

Re: ALV sort-table limits

Former Member — Thu, 05 Apr 2007 15:06:05 GMT

Hi John,

How is the response time of program when you use maximum number of fields and max. rows. Doest it slows-down considerably?

Darshan.

Re: ALV sort-table limits

Former Member — Thu, 05 Apr 2007 15:50:28 GMT

Darshan,

When reporting hundreds of columns, it does not run much slower.

John

Re: ALV sort-table limits

Former Member — Thu, 27 Sep 2007 12:54:48 GMT

The answer is simply that the field SPOS in the table IT_SORT is long enough only for values up to 99.

By the way, if you try the idea of having spos = 99 for every column after spos = 98, then that does not work.

John