topic Re: Regarding sorting in ALV in Application Development and Automation Discussions

Regarding sorting in ALV

Former Member — Tue, 23 Oct 2012 09:35:51 GMT

Hi Experts,

I am displaying purchase order in sort order in ALV.

when displaying in the output it is not displaying in the sort order.

This is causing issue when double clicking the purchase order to interactive list.

when i click on the first purchae order, it is displaying in the whatever there in the internal table first.

what is the cause for the problem? how i can display the output according to internal table sort order in ALV display.

Regards,

udupi

Re: Regarding sorting in ALV

former_member214709 — Tue, 23 Oct 2012 10:24:04 GMT

Dear Udupi,

Check the internal table which you have passed to the ALV Function module, that Internal table must be sorted and that too based on the PO number i think EBELN.

SORT ITAB by EBELN.

And for displaying the PO in ME23n you need to go for the SET PARAMETER ID using Sy-ucomm .

Regards

Dinesh

Re: Regarding sorting in ALV

Former Member — Tue, 23 Oct 2012 10:47:59 GMT

internal table is sorted both EBELN and EBELP.

But when dispplaying the layout in is not displaying in the sorted order.

and when user double click on the purchase order number , it is displaying in the order of the internal table.

Re: Regarding sorting in ALV

former_member214709 — Tue, 23 Oct 2012 10:53:22 GMT

Check the fieldcatalog definition where you have declared the field EBELN and the associated Table as well as the reference field in the fieldcatalog.

If everything works fine.

Then just put a break-point before the CALL FUNCTION REUSE_ALV_GRID is called as well as check the sy-ucomm and the sy-repid.

Re: Regarding sorting in ALV

rosenberg_eitan — Tue, 23 Oct 2012 11:03:11 GMT

Dear Udupi,

Can you post your code:

Are you using cl_gui_alv_grid or something else ?

Re: Regarding sorting in ALV

Former Member — Tue, 23 Oct 2012 11:26:12 GMT

CALL FUNCTION 'REUSE_ALV_GRID_DISPLAY_LVC'

EXPORTING

i_callback_program = l_repid

is_layout_lvc = ls_layout

it_fieldcat_lvc = lt_fcat

i_save = 'A'

it_sort_lvc = t_sort

i_grid_settings = ls_glay

is_variant = ls_variant

it_events = lt_events

it_event_exit = lt_event_exit

i_screen_start_column = im_screen_start_column

i_screen_start_line = im_screen_start_line

i_screen_end_column = im_screen_end_column

i_screen_end_line = im_screen_end_line

IMPORTING

e_exit_caused_by_caller = l_exit_by_caller

es_exit_caused_by_user = ls_exit_caused_by_user

TABLES

*Begin of Modification by SREDDY on 19/OCT/2010 - SAP-6910.

* t_outtab = <table>

t_outtab = it_main

Re: Regarding sorting in ALV

rosenberg_eitan — Tue, 23 Oct 2012 12:01:42 GMT

Can you show us please the code that is activate when you click on the purchae order

Re: Regarding sorting in ALV

rosenberg_eitan — Tue, 23 Oct 2012 12:24:57 GMT

Have a look at program ERPSLS_CUSTOMERS.

Note the the use of formUSER_COMMAND

Re: Regarding sorting in ALV

Former Member — Tue, 23 Oct 2012 12:45:25 GMT

FORM alv_user_command CHANGING ch_ucomm TYPE sy-ucomm
ch_selfield TYPE slis_selfield.

CHECK NOT gf_controller IS INITIAL.
CALL METHOD gf_controller->handle_user_command
    CHANGING
      ch_ucomm    = ch_ucomm
      ch_selfield = ch_selfield.

l_ehp4_active = cl_ops_switch_check=>mm_sfws_p2pse( ).
lo_const = cl_mmpur_constants=>get_instance( ).

IF i_ebeln IS INITIAL AND i_data_from_buffer IS INITIAL.
MESSAGE e015(mepo) RAISING invalid_call.
ENDIF.
IF i_bstyp IS INITIAL OR (
   i_bstyp EQ lo_const->bstyp_k AND l_ehp4_active EQ lo_const->yes ).
CALL FUNCTION 'ME_EKKO_SINGLE_READ'
    EXPORTING
      pi_ebeln         = i_ebeln
    IMPORTING
      po_ekko          = l_ekko
    EXCEPTIONS

IF l_skip NE space.

CALL TRANSACTION l_t

ELSE.

CALL TRANSACTION l_t

ENDIF.

ELSE.

Re: Regarding sorting in ALV

Former Member — Tue, 23 Oct 2012 12:51:26 GMT

FORM alv_user_command CHANGING ch_ucomm TYPE sy-ucomm
ch_selfield TYPE slis_selfield."#EC CALLE

CHECK NOT gf_controller IS INITIAL.
CALL METHOD gf_controller->handle_user_command
    CHANGING
      ch_ucomm    = ch_ucomm
      ch_selfield = ch_selfield.

l_ehp4_active = cl_ops_switch_check=>mm_sfws_p2pse( ).
lo_const = cl_mmpur_constants=>get_instance( ).

IF i_ebeln IS INITIAL AND i_data_from_buffer IS INITIAL.
   MESSAGE e015(mepo) RAISING invalid_call.
ENDIF.
IF i_bstyp IS INITIAL OR (
    i_bstyp EQ lo_const->bstyp_k AND l_ehp4_active EQ lo_const->yes ).
   CALL FUNCTION 'ME_EKKO_SINGLE_READ'
     EXPORTING
       pi_ebeln         = i_ebeln
     IMPORTING
       po_ekko          = l_ekko
     EXCEPTIONS

isplay transaction

IF l_skip NE space.

CALL TRANSACTION l_tcode AND SKIP FIRST SCREEN.

ELSE.

CALL TRANSACTION l_tcode.

ENDIF.

Re: Regarding sorting in ALV

rosenberg_eitan — Tue, 23 Oct 2012 12:57:15 GMT

I am sorry but I am not familiar with this coding technic.

Now days we are using cl_gui_alv_grid and hotspots. it is much easier

then REUSE_ALV_GRID_DISPLAY .

Re: Regarding sorting in ALV

Former Member — Tue, 23 Oct 2012 13:04:09 GMT

Hello Udupi,

If you are not able display in sort order of PO number and item in ALV. That means I believe some where your sorting is getting overwritten by some other sort/code. Pls check that in debugging and wt are the values your passing for parameter t_sort to FM Reuse... This parameter will have effect on sort of final display of output.

I think if you sort out the first issue, then second issue will be resolved. If still problem exists for second after one sorting out first issue. Pls check the wt are the values are passing to parameter ch_selfield while calling form alv_user_command in debugging.

Pls let me know if you need any more help.

Shravan

Re: Regarding sorting in ALV

Former Member — Tue, 23 Oct 2012 13:17:01 GMT

Hi Sharvan,

Thanks for your reply.

In debugging mode, i deleted sort internal table, than also i am geting same output.

Re: Regarding sorting in ALV

Former Member — Tue, 23 Oct 2012 13:19:01 GMT

Hi Sharvan,

Thanks for your reply.

In debugging mode, i deleted sort internal table, than also i am geting same output.

Re: Regarding sorting in ALV

Former Member — Tue, 23 Oct 2012 13:22:28 GMT

I've checked your code, but it's not clear where you get the PO number (variable I_EBELN): I can't see in your form alv_user_command.

Max

Re: Regarding sorting in ALV

Former Member — Tue, 23 Oct 2012 13:31:12 GMT

Program not using AT USER_COMMAND. program populating events USER_COMMAND in the it_event in the internal table.

Re: Regarding sorting in ALV

Former Member — Tue, 23 Oct 2012 13:58:43 GMT

Hi Udupi,

Pls comment the below line of code in FM Reuse_alv...instead of deleting sort table in debugging mode.

it_sort_lvc = t_sort

Before calling this FM, sort the internal table it_main with ebeln and ebelp and let me know how it goes.

Shravan

Re: Regarding sorting in ALV

Former Member — Tue, 23 Oct 2012 14:02:36 GMT

The concept is the same where I_EBELN is from?

Max

Re: Regarding sorting in ALV

Former Member — Tue, 23 Oct 2012 18:34:20 GMT

Thanks shravan