topic Re: SORT DYNAMIC INTERNAL TABLE in Application Development and Automation Discussions

SORT DYNAMIC INTERNAL TABLE

Former Member — Mon, 11 May 2009 12:51:16 GMT

Hello everybody.

How can I sort a dynamic internal table ???

The sentence sort <gt_table> by matnr werks doesn' t work... How can I do it ??

Thanks a lot.

Regards

Re: SORT DYNAMIC INTERNAL TABLE

Former Member — Mon, 11 May 2009 12:57:10 GMT

Hi,

sort <gt_table> by (field1) (field2).

Refer to this link..

Re: SORT DYNAMIC INTERNAL TABLE

former_member212005 — Mon, 11 May 2009 12:57:52 GMT

Hi, try the following link...it might be helpful!

http://sap.ittoolbox.com/groups/technical-functional/sap-dev/how-to-sort-a-dynamic-internal-table-2268207

Regards,

Vin

Re: SORT DYNAMIC INTERNAL TABLE

Pawan_Kesari — Mon, 11 May 2009 12:58:32 GMT

DATA otab TYPE ABAP_SORTORDER_TAB .

SORT <fs_tab> BY (otab).

Table ABAP_SORTORDER_TAB has fields

NAME

DESCENDING

ASTEXT

fill it accordingly

Re: SORT DYNAMIC INTERNAL TABLE

tarangini_katta — Mon, 11 May 2009 12:58:42 GMT

Hi use this.

SORT <itab> BY (MATNR) (WERKS).

look into this link also.

http://sap.ittoolbox.com/groups/technical-functional/sap-dev/how-to-sort-a-dynamic-internal-table-2268207

it will work for you.

Re: SORT DYNAMIC INTERNAL TABLE

Former Member — Mon, 11 May 2009 12:59:37 GMT

Here is an example:

PARAMETERS dbtab TYPE c LENGTH 30.

SELECT-OPTIONS columns FOR dbtab NO INTERVALS.

DATA: otab TYPE abap_sortorder_tab,

oline TYPE abap_sortorder,

dref TYPE REF TO data.

FIELD-SYMBOLS: <column> LIKE LINE OF columns,

<itab> TYPE STANDARD TABLE.

TRY.

CREATE DATA dref TYPE STANDARD TABLE OF (dbtab).

***I have assigned the value dref to internal table as follows***

ASSIGN dref->* TO <itab>.

CATCH cx_sy_create_data_error.

MESSAGE 'Wrong data type!' TYPE 'I' DISPLAY LIKE 'E'.

LEAVE PROGRAM.

ENDTRY.

TRY.

SELECT *

FROM (dbtab)

INTO TABLE <itab>.

CATCH cx_sy_dynamic_osql_semantics.

MESSAGE 'Wrong database table!' TYPE 'I' DISPLAY LIKE 'E'.

LEAVE PROGRAM.

ENDTRY.

LOOP AT columns ASSIGNING <column>.

oline-name = <column>-low.

APPEND oline TO otab.

ENDLOOP.

TRY.

SORT <itab> BY (otab).

CATCH cx_sy_dyn_table_ill_comp_val.

MESSAGE 'Wrong column name!' TYPE 'I' DISPLAY LIKE 'E'.

LEAVE PROGRAM.

ENDTRY.