topic Re: Difference between sort function & sorting performed in ALV in Application Development and Automation Discussions

Difference between sort function & sorting performed in ALV

Former Member — Thu, 29 Oct 2009 09:55:46 GMT

Hi All,

I have a requirement where i need to match the sorted data of internal table, which is sorted by sort function, & sorted data that is sorted on screen,i.e.with ALV.

How can i acheieve that?

Thanks In Advance.

Regards,

Nidhi Kothiyal

Re: Difference between sort function & sorting performed in ALV

Former Member — Thu, 29 Oct 2009 10:22:24 GMT

Hi,

In an ALV, when we select a column and then sort, then the report is sorted based on the column selected.

Whereas in an internal table in your code you would be sorting according to some specific field.

You would ahev to ascertain as to which column is being sorted in ALV and then use similar sort statement in your code logic to get same sequence of records.

Hope this Helps!

Regards,

Mansi.

Re: Difference between sort function & sorting performed in ALV

Former Member — Thu, 29 Oct 2009 10:28:04 GMT

in the user command subroutine for that ALV..

capture the SORT command and see which field its sorting.. (you need to debug a bit for this) then sort the table sabed on that field..

one more option is data_changed event.. this captures all the changes made to your table.. track it there and update your internal table..

Re: Difference between sort function & sorting performed in ALV

RaymondGiuseppi — Thu, 29 Oct 2009 10:36:26 GMT

By default data is sorted by internal values, no problem, the exceptions come from table ASEXDOM (from release 4.7 on) - so try to change data element or domain with another which is no exception, or use a field with external values in your ALV and hide internal values.

Regards,

Raymond

Re: Difference between sort function & sorting performed in ALV

Former Member — Thu, 29 Oct 2009 11:28:27 GMT

hi,

Actually i am sorting three fields in alv, one numeric, one alphanumeric & onr character. if i sort with first two both sortings are same,, but when i sort all three the order in ALV becomes different of internal table.

any suggestion?

Regards,

Nidhi Kothiyal

Re: Difference between sort function & sorting performed in ALV

RaymondGiuseppi — Thu, 29 Oct 2009 12:00:00 GMT

So the problem is with the third field, if there is no conversion exit, did you try some SORT options that may(*) be used by ALV like STABLE or AS TEXT (language dependance)

Regards,

Raymond

(*) I'm nearly sure ALV use those options.

Re: Difference between sort function & sorting performed in ALV

Former Member — Thu, 29 Oct 2009 12:35:25 GMT

hi,

any suggestion?

can you provide some sample code!

Regards,

Nidhi Kothiyal

Re: Difference between sort function & sorting performed in ALV

RaymondGiuseppi — Tue, 03 Nov 2009 07:17:40 GMT

Look at F1 on [SORT|http://help.sap.com/abapdocu/en/ABAPSORT_ITAB_SHORTREF.htm]

SORT gt_makt STABLE " before key fields list
  BY matnr
     spras
     maktx AS TEXT. " language dependant

Regards,

Raymond