topic Problem with sorting using ALV List in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/problem-with-sorting-using-alv-list/m-p/7238821#M1526006 <HTML><HEAD></HEAD><BODY><P>Hi Experts,</P><P></P><P>I need help in sorting my output by their company code. Once this is sorted, the records in different company code will sorted by their cost center. The expected output is like below:</P><P></P><P>Company A</P><P>-</P><HR originaltext="----------------" /><TABLE><TBODY><TR><TD><P>Pernr</P></TD><TD><P>Kostl</P></TD></TR></TBODY></TABLE><P>-</P><HR originaltext="----------------" /><TABLE><TBODY><TR><TD><P>1000</P></TD><TD><P>0001</P></TD></TR></TBODY></TABLE><P>-</P><HR originaltext="----------------" /><TABLE><TBODY><TR><TD><P>1002</P></TD><TD><P>0001</P></TD></TR></TBODY></TABLE><P>-</P><HR originaltext="----------------" /><TABLE><TBODY><TR><TD><P>total</P></TD><TD><P>2</P></TD></TR></TBODY></TABLE><P>-</P><HR originaltext="----------------" /><TABLE><TBODY><TR><TD><P>Pernr</P></TD><TD><P>Kostl</P></TD></TR></TBODY></TABLE><P>-</P><HR originaltext="----------------" /><TABLE><TBODY><TR><TD><P>1001</P></TD><TD><P>0002</P></TD></TR></TBODY></TABLE><P>-</P><HR originaltext="----------------" /><TABLE><TBODY><TR><TD><P>total</P></TD><TD><P>1</P></TD></TR></TBODY></TABLE><P>-</P><HR originaltext="----------------" /><P></P><P>Company B</P><P>-</P><HR originaltext="----------------" /><TABLE><TBODY><TR><TD><P>Pernr</P></TD><TD><P>Kostl</P></TD></TR></TBODY></TABLE><P>-</P><HR originaltext="----------------" /><TABLE><TBODY><TR><TD><P>1005</P></TD><TD><P>0006</P></TD></TR></TBODY></TABLE><P>-</P><HR originaltext="----------------" /><TABLE><TBODY><TR><TD><P>total</P></TD><TD><P>1</P></TD></TR></TBODY></TABLE><P>-</P><HR originaltext="----------------" /><P></P><P></P><P>As of the moment I'm using the code below but the sorting is still a mess.</P><P></P><P> wa_sort-fieldname = 'BUKRS'.</P><P> wa_sort-group = '*'.</P><P> wa_sort-up = 'X'.</P><P> APPEND wa_sort TO it_sort.</P><P></P><P> wa_sort-fieldname = 'KOSTL'.</P><P> wa_sort-subtot = 'X'.</P><P> wa_sort-up = 'X'.</P><P> APPEND wa_sort TO it_sort.</P><P></P><P>Another question, how can the records be hidden and only the show the row of the subtotals and grand total?</P><P></P><P>Hope you can answer my questions. Thanks <SPAN __jive_emoticon_name="happy"></SPAN></P><P></P><P>Regards,</P><P>Rare</P></BODY></HTML> Fri, 17 Sep 2010 12:37:27 GMT Former Member 2010-09-17T12:37:27Z Problem with sorting using ALV List https://community.sap.com/t5/application-development-and-automation-discussions/problem-with-sorting-using-alv-list/m-p/7238821#M1526006 <HTML><HEAD></HEAD><BODY><P>Hi Experts,</P><P></P><P>I need help in sorting my output by their company code. Once this is sorted, the records in different company code will sorted by their cost center. The expected output is like below:</P><P></P><P>Company A</P><P>-</P><HR originaltext="----------------" /><TABLE><TBODY><TR><TD><P>Pernr</P></TD><TD><P>Kostl</P></TD></TR></TBODY></TABLE><P>-</P><HR originaltext="----------------" /><TABLE><TBODY><TR><TD><P>1000</P></TD><TD><P>0001</P></TD></TR></TBODY></TABLE><P>-</P><HR originaltext="----------------" /><TABLE><TBODY><TR><TD><P>1002</P></TD><TD><P>0001</P></TD></TR></TBODY></TABLE><P>-</P><HR originaltext="----------------" /><TABLE><TBODY><TR><TD><P>total</P></TD><TD><P>2</P></TD></TR></TBODY></TABLE><P>-</P><HR originaltext="----------------" /><TABLE><TBODY><TR><TD><P>Pernr</P></TD><TD><P>Kostl</P></TD></TR></TBODY></TABLE><P>-</P><HR originaltext="----------------" /><TABLE><TBODY><TR><TD><P>1001</P></TD><TD><P>0002</P></TD></TR></TBODY></TABLE><P>-</P><HR originaltext="----------------" /><TABLE><TBODY><TR><TD><P>total</P></TD><TD><P>1</P></TD></TR></TBODY></TABLE><P>-</P><HR originaltext="----------------" /><P></P><P>Company B</P><P>-</P><HR originaltext="----------------" /><TABLE><TBODY><TR><TD><P>Pernr</P></TD><TD><P>Kostl</P></TD></TR></TBODY></TABLE><P>-</P><HR originaltext="----------------" /><TABLE><TBODY><TR><TD><P>1005</P></TD><TD><P>0006</P></TD></TR></TBODY></TABLE><P>-</P><HR originaltext="----------------" /><TABLE><TBODY><TR><TD><P>total</P></TD><TD><P>1</P></TD></TR></TBODY></TABLE><P>-</P><HR originaltext="----------------" /><P></P><P></P><P>As of the moment I'm using the code below but the sorting is still a mess.</P><P></P><P> wa_sort-fieldname = 'BUKRS'.</P><P> wa_sort-group = '*'.</P><P> wa_sort-up = 'X'.</P><P> APPEND wa_sort TO it_sort.</P><P></P><P> wa_sort-fieldname = 'KOSTL'.</P><P> wa_sort-subtot = 'X'.</P><P> wa_sort-up = 'X'.</P><P> APPEND wa_sort TO it_sort.</P><P></P><P>Another question, how can the records be hidden and only the show the row of the subtotals and grand total?</P><P></P><P>Hope you can answer my questions. Thanks <SPAN __jive_emoticon_name="happy"></SPAN></P><P></P><P>Regards,</P><P>Rare</P></BODY></HTML> Fri, 17 Sep 2010 12:37:27 GMT https://community.sap.com/t5/application-development-and-automation-discussions/problem-with-sorting-using-alv-list/m-p/7238821#M1526006 Former Member 2010-09-17T12:37:27Z Re: Problem with sorting using ALV List https://community.sap.com/t5/application-development-and-automation-discussions/problem-with-sorting-using-alv-list/m-p/7238822#M1526007 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P> I think as per your requirement you should use alv_tree, so that you can hide the other fields and show sorted data as requireed by you.</P><P></P><P></P><P></P><P>Thanks,</P><P>Anmol</P></BODY></HTML> Fri, 17 Sep 2010 12:48:02 GMT https://community.sap.com/t5/application-development-and-automation-discussions/problem-with-sorting-using-alv-list/m-p/7238822#M1526007 Former Member 2010-09-17T12:48:02Z