topic Re: sort FUNC in Application Development and Automation Discussions

sort FUNC

Former Member — Mon, 08 May 2006 10:41:16 GMT

i have itab with

werks lgort and matnr lbkum

1000 10 11111 2323

..........................

i want to get the min value of lbkum

per matnr in werks

the final list need to be like this

werks matnr lbkum

10000 11111 2

20000 11111 3

30000 11111 1

40000 22222 1

Re: sort FUNC

Former Member — Mon, 08 May 2006 10:43:50 GMT

sort itab by WERKS ascending

MATNR ascending

LBKUM descedning.

Re: sort FUNC

Former Member — Mon, 08 May 2006 10:44:30 GMT

SORT itab BY werks matnr lbkum ascending.

Re: sort FUNC

Former Member — Mon, 08 May 2006 10:45:34 GMT

sort itab by WERKS MATNR ascending

LBKUM descedning.

Re: sort FUNC

Former Member — Mon, 08 May 2006 10:46:13 GMT

Rani,

The order of LBKUM is neither in ascending / descending order in the output you have displayed.

If you can specify whether it ASC / DESC, then you can do.

SORT ITAB WERKS ASC MATNR ASC LBKUM DESC.

Regards,

Ravi

Re: sort FUNC

Former Member — Mon, 08 May 2006 10:47:47 GMT

First put lgort field at last in itab
sort itab by werks matnr lkbum

declare another itab1 with only  fields werks matnr lkbum

loop at itab.
  at new matnr.
     move-corresponding itab to itab1.
     append itab1.
     clear itab1.
endloop.

this will give u minimum lkbum per matnr per werks in itab1

<b>have u tried mine</b>

Message was edited by: Sekhar

Re: sort FUNC

Former Member — Mon, 08 May 2006 10:49:13 GMT

hi,

as far as i understand ur requirement:

sort itab by WERKS MATNR ascending

LBKUM descedning.

rgds,

latheesh

Re: sort FUNC

Former Member — Mon, 08 May 2006 10:50:49 GMT

Hai Rani

sort itab by WERKS MATNR LBKUM Asdending.

Thanks & regards

Sreenivasulu P

Re: sort FUNC

Former Member — Mon, 08 May 2006 11:00:39 GMT

i tried all the example and it not work