topic Re: Simple question about ALV sorting in Application Development and Automation Discussions

Simple question about ALV sorting

Former Member — Mon, 13 Apr 2009 17:46:14 GMT

I retrieve data from SFLIGHT table and display it in ALV by using cl_salv_table class. I added a sorting column PRICE as follows:


 data r_salv_sort type ref to cl_salv_sorts.
 r_salv_sort = r_salv_table->get_sorts( ).
 r_salv_sort->add_sort('PRICE').

and got exception message:

Subtotals cannot be calculated on aggregatable columns

it is fine when I change from PRICE column to CONNID column.

What could be the reason for that? I just want to sort the Price column. Thanks!

Re: Simple question about ALV sorting

naimesh_patel — Mon, 13 Apr 2009 17:51:49 GMT

Check this discussion on SORT for Numeric Column:

Regards,

Naimesh Patel

Re: Simple question about ALV sorting

Former Member — Mon, 13 Apr 2009 17:53:21 GMT

HI,

Sort cannot be performed on the quantity,float and currency fields on which aggregate Function applies.

Re: Simple question about ALV sorting

Former Member — Mon, 13 Apr 2009 18:00:20 GMT

Hi,

I read the thread and it is a workaround, not a solution by the way. Move the numeric column to another non-numeric column, sort it and hide the numeric column.

I still can do the sorting via user interface by right click on the numeric column. So is there anyway to do that in code? thanks!

Best regards,

Anthony

Re: Simple question about ALV sorting

Former Member — Mon, 13 Apr 2009 18:27:03 GMT

I agree to the point mentioned by avinash !

What you can do is create a field with char attributes and assign the price value to it.

Now to sort the table you can use this field.

While displayin in ALV you can hide this field.

You can always use sort option after the output.

Regards,

Lalit Mohan Gupta.

Re: Simple question about ALV sorting

Former Member — Mon, 13 Apr 2009 20:15:00 GMT

Thanks all for your helps!

Re: Simple question about ALV sorting

naimesh_patel — Tue, 14 Apr 2009 17:56:12 GMT

We can do the sorting on the Quantity or Amount column once it ALV is displayed. Because now the control is no more with the SALV model. It is with the ALV framework.

SALV model doesn't allow the sorting on the columns on which you can perform the Agreegation.

You can save the default layout variant and then start the ALV with that variant.

Regards,

Naimesh Patel