Sort

Hi,

-

---

Material

Posting Date

Vendor

Mat.Doc.No

Bal.Qty

-

---

ID0169164

07.08.2004

IC-KIT

412783

4.000

ID0169164

07.08.2004

IC-KIT

412784

8.000

ID0169164

16.08.2004

IC-KIT

413064

14.000

ID0169164

16.08.2004

IC-KIT

413065

34.000

ID0169164

19.08.2004

IC-KIT

413162

14.000

ID0169164

20.08.2004

IC-KIT

413171

24.000

ID0169164

20.08.2004

IC-KIT

413172

34.000

ID0169164

08.11.2004

IC-KIT

413761

80.000

ID0169167

16.08.2004

IC-KIT

413064

20.000

ID0169167

16.08.2004

IC-KIT

413065

60.000

ID0169167

19.08.2004

IC-KIT

413162

20.000

ID0169167

20.08.2004

IC-KIT

413171

40.000

ID0169167

20.08.2004

IC-KIT

413172

60.000

I want to sort the above one in such a way that when I delete the adjacent duplicates after sorting the internal table should contain only

ID0169164

08.11.2004

IC-KIT

413761

80.000

ID0169167

20.08.2004

IC-KIT

413172

60.000

ie.Material with the latest budat and mblnr and its corresponing bal quantity.

sort itab by matnr budat ascending.

delete adjacent duplicates from itab comparing lifnr matnr.

is not giving me the result.Can anyone here please let me where I am going wrong.

Thanks,

K.Kiran.

Edited by: Kiran K on Jan 21, 2008 5:39 AM