SORT DYNAMIC INTERNAL TABLE

[Former Member]

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

[Former Member]

Hi,

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

Refer to this link..

[former_member212005]

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-22...

Regards,

Vin

[Pawan_Kesari]

DATA otab TYPE ABAP_SORTORDER_TAB .

SORT <fs_tab> BY (otab).

Table ABAP_SORTORDER_TAB has fields

NAME

DESCENDING

ASTEXT

fill it accordingly

[tarangini_katta]

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-22...

it will work for you.

.

[Former Member]

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.