topic Re: Sort Table based on Display Variant in Application Development and Automation Discussions

Sort Table based on Display Variant

Former Member — Fri, 15 Aug 2008 09:59:19 GMT

Hi...

I want to Sort a table based on Display Variant Sort option??

Please Help????

Re: Sort Table based on Display Variant

Former Member — Fri, 15 Aug 2008 10:02:06 GMT

Hi Try this...

FM..

K_KKB_OUTTAB_SORT

To Sort Data

CALL FUNCTION 'K_KKB_OUTTAB_SORT'

EXPORTING

IT_SORT = I_SORT

TABLES

T_OUTTAB = I_MAIL_FINAL

EXCEPTIONS

SORTFIELD_NOT_FOUND = 1

OTHERS = 2.

IF SY-SUBRC <> 0.

MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO

WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

ENDIF.

Re: Sort Table based on Display Variant

ingo_barschow — Fri, 15 Aug 2008 11:13:05 GMT

Hi shashi,

in sy-slset SAP stores the name of the variant.

CASE sy-slset.
  WHEN 'TEST01'. SORT gt_itab BY x y z.
  WHEN 'TEST02'. SORT gt_itab BY y x z.
  WHEN OTHERS. SORT gt_itab.
ENDCASE.

Re: Sort Table based on Display Variant

Former Member — Fri, 15 Aug 2008 11:48:55 GMT

Thanks for your reply..

But user can create new variants too..

In that case How to get the fields which are used for sorting???

Re: Sort Table based on Display Variant

ingo_barschow — Fri, 15 Aug 2008 12:04:21 GMT

Hi Sashi,

I'm not sure understanding your needs. Maybe you have to read the SELECT-OPTIONS or using some radiobuttons / checkboxes to get the users preferences?

In other case, all known variants are stored in SAP-table VARIT, the specific field-descriptions and values you can retrieve by using function module 'RS_VARIANT_CONTENTS' (some informations are also in SAP-table VARID).

Hope it will help, otherwise try to explain what the user should do, please.

Re: Sort Table based on Display Variant

Former Member — Fri, 15 Aug 2008 16:39:17 GMT

Hmmm......