topic Re: ALV -- sorting fields in Application Development and Automation Discussions

ALV -- sorting fields

Former Member — Wed, 08 Apr 2009 15:58:48 GMT

hi there experts...

I´m doing an alv report and I want to know if it's possible to sort the alv like I'm going to explain:

WA_SORT-SPOS = 1.
  WA_SORT-FIELDNAME = 'EKGRP'.
  WA_SORT-TABNAME = 'T'.
  WA_SORT-UP = 'X'.
  APPEND WA_SORT TO IT_SORT.
  CLEAR WA_SORT.

  WA_SORT-SPOS = 2.
  WA_SORT-FIELDNAME = 'EKNAM'.
  WA_SORT-TABNAME = 'T'.
  WA_SORT-UP = 'X'.
  APPEND WA_SORT TO IT_SORT.
  CLEAR WA_SORT.

I want to sort this two fields in order that, i just want to group the equal values of EKNAM that correspond to a single value of EKGRP nad not to group all equal values of EKNAM with diferent EKGRP values.

Output Example of what I want:

   EKGRP   |   EKNAM  |   DESC
-----------|----------|-------------
       1   |   001    | blabla1
           |----------|-------------
           |   002    | blabla2
           |          |-------------
           |          | blabla3
-----------|----------|-------------
      2    |   002    | blabla4
           |          |-------------
           |          | blalba5
           |--------- |--------------
           |   012    | blabla6

With normal sort, value 002 for EKNAM field is grouped independently from the value of EKGRP field...

Is it possible to do??

Tanks

Edited by: Hermano.Andrade on Apr 8, 2009 5:59 PM

Re: ALV -- sorting fields

Former Member — Wed, 08 Apr 2009 16:07:48 GMT

HI,

Refer to this link..https://www.sdn.sap.com/irj/scn/wiki?path=/display/abap/sortinALV

Opp's sorry it is not possible...if the value is same for the corresponding two values in the different sort column then the values are merged and displayed at first instead of showing once again if any change in the any of the values in other sort column.

Instead you can update the internal table in the same way as required and display as the output. The restriction on this you need to disable the sort buttons on the alv and no other operations to be performed.

Re: ALV -- sorting fields

Former Member — Wed, 08 Apr 2009 16:08:23 GMT

Hi Hermano,

can you try below

SORT itab by EKGRP   EKNAM ,

hope it works

Thanks!

Re: ALV -- sorting fields

Former Member — Wed, 08 Apr 2009 16:15:59 GMT

yes it is possible with the way you are trying

just maintain the sequence...

Regards,

Lalit Mohan Gupta.

Re: ALV -- sorting fields

I355602 — Thu, 09 Apr 2009 04:41:30 GMT

Hi,

Yes, you are right.

Use the code to sort output w.r.t. these two fields (based on the combination of both).

Let me know in case you have any doubts.

Regards,

Tarun

Re: ALV -- sorting fields

Former Member — Thu, 09 Apr 2009 05:37:34 GMT

hi, check this one.


Loop at itab.

AT NEW EKGRP.
FLAG = 'X'.
ENDAT.

AT NEW EKNAM.
FLAG1 = 'X'.
ENDAT.

IF FLAG ='X'.
MOVE CORRESPONDING ITAB TO WA_TAB.
APPEND WA_TAB TO ITAB1.
ELSE.
CLEAR ITAB-EKGRP.
MOVE CORRESPONDING ITAB TO WA_TAB.
APPEND WA_TAB TO ITAB1.
ENDIF.

IF FLAG1 ='X'.
MOVE CORRESPONDING ITAB TO WA_TAB.
APPEND WA_TAB TO ITAB1.
ELSE.
CLEAR ITAB-EKNAM.
MOVE CORRESPONDING ITAB TO WA_TAB.
APPEND WA_TAB TO ITAB1.
ENDIF.

ENDLOOP.