topic Re: Internal table sort problem in Application Development and Automation Discussions

Internal table sort problem

Former Member — Tue, 02 Oct 2007 09:32:33 GMT

Dear all,

I'm having a problem sorting an internal table. The table declaration is something like this

DATA: BEGIN OF ITAB OCCURS 0,

DOKNR LIKE DRAW-DOKNR,

DOKAR LIKE DRAW-DOKAR,

DOKVR LIKE DRAW-DOKVR,

DOKTL LIKE DRAW-DOKTL,

DKTXT LIKE DRAT-DKTXT,

DTCRI LIKE DRAP-DATUM,

DATA LIKE ZDMS_T_DOC-DATA,

HORA LIKE ZDMS_T_DOC-HORA,

...

END OF ITAB.

I'm trying to sort the table by doknr

SORT ITAB BY DOKNR DESCENDING.

The result after the sort command is

703000000009

2000022608

2000022607

2000022196

2000005193

100054788

100054787

10002039975

10002039968.

Thanks in advance,

sb.

Re: Internal table sort problem

Former Member — Tue, 02 Oct 2007 09:36:55 GMT

Hi Sara,

everything is correct, what's the problem - want do you want to get ?

if you want have ist the other way round you have to code.

sort itab by doknr.

regards henner

Re: Internal table sort problem

Former Member — Tue, 02 Oct 2007 09:42:08 GMT

HI,

DRAW-DOKNR is a char field, so the sort is correct, no problem.

bye

Re: Internal table sort problem

Former Member — Tue, 02 Oct 2007 09:44:47 GMT

If u want sort to work.....take a field of type N and move this value to that field and sort by that field in descending order.

U'll get required output.

Regards

Vasu

Re: Internal table sort problem

Former Member — Tue, 02 Oct 2007 09:47:05 GMT

good

rather than using one field in the sorting statement try to use two field name in the sorting statement but you have to check in the debug mode that with two field ll give you the exact output as per your requirement.

thanks

mrutyun^

Re: Internal table sort problem

Former Member — Tue, 02 Oct 2007 09:50:54 GMT

Hi Henner,

if you see the sort from CV04N, the output is different and just like I need. In fact, for a char type the result that I get is correct.

Thanks,

sb.

Re: Internal table sort problem

Former Member — Tue, 02 Oct 2007 09:54:54 GMT

Hi Vasu,

with the N type I get the following result

10002039975

10002039968

703000000009

2000022608

2000022607

2000022196

2000005193

100054788

100054787

Any idea?

Thanks,

sb.

Re: Internal table sort problem

JozsefSzikszai — Tue, 02 Oct 2007 09:56:55 GMT

hi Sara,

what is the order you want to have? Can you copy it here? Probably not everyone has data in transaction CV04N

thanks

Re: Internal table sort problem

JozsefSzikszai — Tue, 02 Oct 2007 09:59:07 GMT

Other thing I would try is :

SHIFT doknr RIGHT DELETING TRAILING SPACE (of course in a LOOP on each single line)

than the SORT

Re: Internal table sort problem

Former Member — Tue, 02 Oct 2007 10:03:44 GMT

Hi Eric,

I want something like

703000000009

10002039975

10002039968

2000022608

2000022607

2000022196

2000005193

100054788

100054787

Thanks,

sb.

Re: Internal table sort problem

JozsefSzikszai — Tue, 02 Oct 2007 10:08:08 GMT

thanks,

than check the values in debug and if they are not right aligned (in the field), than do what I suggested:

SHIFT doknr RIGHT DELETING TRAILING SPACE (of course in a LOOP on each single line)

than the SORT itab BY ... DESCENDING.

Re: Internal table sort problem

Former Member — Tue, 02 Oct 2007 10:12:25 GMT

Thank you all, problem resolved with type N.