Hi,
-
Material
Posting Date
Vendor
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