topic Re: Sort internal table in Subroutine in Application Development and Automation Discussions

Sort internal table in Subroutine

Former Member — Tue, 23 Oct 2007 06:59:54 GMT

Hi,everyone.

I want to sort internal table in subroutine , but there is an error.My code is below.

TYPES: BEGIN OF TYP_SAKNR,

SAKNR LIKE ZTEFI0710-SAKNR,

END OF TYP_SAKNR.

DATA: TAB_SAKNR TYPE STANDARD TABLE OF TYP_SAKNR,

WA_SAKNR TYPE TYP_SAKNR.

START-OF-SELECTION.

PERFORM GET_SAKNR USING TAB_SAKNR.

LOOP AT TAB_SAKNR INTO WA_SAKNR.

WRITE: / WA_SAKNR-SAKNR.

ENDLOOP.

FORM GET_SAKNR USING TAB_SAKNR TYPE STANDARD TABLE.

SELECT SAKNR

FROM ZTEFI0710

INTO TABLE TAB_SAKNR

WHERE ZZEURENKETU = '2'.

SORT TAB_SAKNR BY SAKNR.

ENDFORM.

If I just write SORT TAB_SAKNR, it's ok.

Can you tell me why?And how to solve this problem?

This is an example,if in the internal table there are many fields,and I want to sort this internal table by a few fields in subroutine,what should I do?

Regards,

feng.

Re: Sort internal table in Subroutine

Former Member — Tue, 23 Oct 2007 07:05:49 GMT


TYPES: BEGIN OF TYP_SAKNR,
SAKNR LIKE ZTEFI0710-SAKNR, 
END OF TYP_SAKNR.
DATA: TAB_SAKNR TYPE STANDARD TABLE OF TYP_SAKNR,
WA_SAKNR TYPE TYP_SAKNR.

START-OF-SELECTION.
PERFORM GET_SAKNR USING TAB_SAKNR.
LOOP AT TAB_SAKNR INTO WA_SAKNR.
WRITE: / WA_SAKNR-SAKNR.
ENDLOOP.

FORM GET_SAKNR USING TAB_SAKNR TYPE STANDARD TABLE OF TYP_SAKNR. " Specify the type of Standard table as TYP_SAKNR
SELECT SAKNR
FROM ZTEFI0710
INTO TABLE TAB_SAKNR
WHERE ZZEURENKETU = '2'.

SORT TAB_SAKNR BY SAKNR.
ENDFORM.

Re: Sort internal table in Subroutine

Former Member — Tue, 23 Oct 2007 07:06:27 GMT

You need to pass the table using "Tales" key word. something like

data: wa_saknr type typ_saknr.

PERFORM GET_SAKNR tables TAB_SAKNR.

FORM GET_SAKNR tables TAB_SAKNR structure wa_saknr.

endform.

Reward if useful.

Re: Sort internal table in Subroutine

Former Member — Tue, 23 Oct 2007 07:09:17 GMT

Table category of an internal table that is managed using a table index and is always sorted according to its table key. The corresponding generic data type is sorted table.

I want to sort this internal table by a few fields in subroutine,what should I do?

It is not possible to sort the table with any other sort criteria except table key. Otherwise it will give a error. What you can do, inside the subroutine define a standard internal table with same structure and copy the sorted table to that standard table and use it.

IT_sorted_table[] = IT_standard_table[].

and use IT_standard_table[] instead of IT_sorted_table[].

Re: Sort internal table in Subroutine

Former Member — Tue, 23 Oct 2007 07:09:48 GMT

Hi Feng,

Use table type in subroutine.

Refer this code :

TYPES: BEGIN OF TYP_SAKNR,

SAKNR LIKE ZTEFI0710-SAKNR,

END OF TYP_SAKNR.

TYPES : ttyp_saknr type standard table of TYP_SAKNR.

data : TAB_SAKNR type ttyp_saknr .

FORM GET_SAKNR USING TAB_SAKNR TYPE ttyp_saknr

SELECT SAKNR

FROM ZTEFI0710

INTO TABLE TAB_SAKNR

WHERE ZZEURENKETU = '2'.

SORT TAB_SAKNR BY SAKNR.

ENDFORM.

Now it would work.

Regards,

Hemant

Re: Sort internal table in Subroutine

Former Member — Tue, 23 Oct 2007 07:10:03 GMT

If u want to sort the internal table by few fields just give

sort it_matnr by f1 f2 ... fn

where f1 , f2 ... fn are the fields on which u want to sort the internal table.

Re: Sort internal table in Subroutine

Former Member — Tue, 23 Oct 2007 07:18:00 GMT

Thanks,Prashant Patil .

I tried,but it didn't work.

Regards,

feng.