topic Re: SORTING ITAB in Application Development and Automation Discussions

SORTING ITAB

Former Member — Tue, 05 Feb 2008 09:24:25 GMT

Hi Experts,

In my Internal Table ITAB, I have 2 fields. DATE, MBLNR(material Doc. No.). I want to sort my ITAB on date as ascending order and MBLNR in Descending. Like with in a single data there must b many MBLNR. SO on a single data lets say 01.01.2008, there are 3 MBLNR No., say 4000123, 4000111, 4000222. I want it should display in below manner:

01.01.2008 4000222

01.01.2008 4000123

01.01.2008 4000111

Plz help.

Thanks.

Khan

Re: SORTING ITAB

Former Member — Tue, 05 Feb 2008 09:29:15 GMT

HI,

sort itab by DATE ascending MBLNR descending.

loop at itab.

endloop.

regards

Nicole

Re: SORTING ITAB

Former Member — Tue, 05 Feb 2008 09:31:45 GMT

write like this ...

SORT ITAB by DATE MBLNR descending.

Re: SORTING ITAB

Former Member — Tue, 05 Feb 2008 09:31:52 GMT

hi Lorenz,

I tried the same but didnt get the desired output.

Any other Suggetion,

Thanks.

Khan

Re: SORTING ITAB

Former Member — Tue, 05 Feb 2008 09:39:15 GMT

try like this.


DATA : BEGIN OF itab OCCURS 0,
       date TYPE sy-datum,
       mblnr(10),
       END OF itab.

itab-date = sy-datum.
itab-mblnr = '4000222'.
APPEND itab.

itab-date = sy-datum.
itab-mblnr = '4000223'.
APPEND itab.

itab-date = sy-datum.
itab-mblnr = '4000224'.
APPEND itab.

itab-date = sy-datum + 1.
itab-mblnr = '4000225'.
APPEND itab.

itab-date = sy-datum +  1.
itab-mblnr = '4000228'.
APPEND itab.

itab-date = sy-datum + 1.
itab-mblnr = '4000234'.
APPEND itab.

SORT itab BY date ASCENDING mblnr DESCENDING. "<<<<<<<<

LOOP AT itab.
  WRITE :/ itab-date, itab-mblnr.
ENDLOOP..

Re: SORTING ITAB

Former Member — Tue, 05 Feb 2008 09:40:22 GMT

Hi,

Try this method.

Sort itab date ascending.

move itab to itab2.

sort itab2 mblnr descending.

This should work I guess.. and the kind of output you want will be present in the other internal table itab2. Make sure the fields and their types in both the internal tables are same.

Regards.

Re: SORTING ITAB

Former Member — Tue, 05 Feb 2008 09:40:56 GMT

Hello Khan,

This is what u wanted.


DATA: BEGIN OF ITAB OCCURS 0,
        BUDAT(10),
        MBLNR TYPE MSEG-MBLNR,
      END OF ITAB.

ITAB-BUDAT = '01.01.2008'.
ITAB-MBLNR = '4000222'      .
APPEND ITAB.

ITAB-BUDAT = '01.01.2008'.
ITAB-MBLNR = '4000123'      .
APPEND ITAB.

ITAB-BUDAT = '01.01.2008'.
ITAB-MBLNR = '4000111'      .
APPEND ITAB.

ITAB-BUDAT = '02.01.2008'.
ITAB-MBLNR = '4000252'      .
APPEND ITAB.

ITAB-BUDAT = '02.01.2008'.
ITAB-MBLNR = '4000212'      .
APPEND ITAB.

SORT ITAB BY BUDAT ASCENDING MBLNR DESCENDING.

LOOP AT ITAB.
  WRITE:/ ITAB-BUDAT, ITAB-MBLNR.
ENDLOOP.

Cheers,

Vasanth

Re: SORTING ITAB

Former Member — Tue, 05 Feb 2008 09:42:57 GMT

Hi Khan

Try this

SORT ITAB by MBLNR descending.

Regards

Anbu

Re: SORTING ITAB

Former Member — Tue, 05 Feb 2008 09:44:02 GMT

Hello Khan,

You can do that by using sort statement as below.

SORT g_t_mara DESCENDING BY matnr ASCENDING ernam.

Refer to the code below.

REPORT zsample.

TABLES: mara.

SELECT-OPTIONS: s_matnr FOR mara-matnr.
SELECT-OPTIONS: s_ernam FOR mara-ernam.

DATA: BEGIN OF g_t_mara OCCURS 0,
        matnr LIKE mara-matnr,
        ernam LIKE mara-ernam,
      END OF g_t_mara.

SELECT matnr ernam FROM mara INTO CORRESPONDING FIELDS OF TABLE g_t_mara
       WHERE matnr IN s_matnr.

SORT g_t_mara ASCENDING BY ernam DESCENDING matnr.

LOOP AT g_t_mara.

  WRITE: / g_t_mara-ernam, g_t_mara-matnr .

ENDLOOP.

Plese try to give points for good answers. It seems you didn't give points to atleast one time. You will get one point if you reward points to answers.

Reward If Helpful.

Regards

Sasidhar Reddy Matli.