2007 Aug 14 8:32 AM
hi,
i have data in one internal table.
like
f1 f2 f 3 f4
1 20 s abc
2 20 h abc
3 30 s jkl
4 30 h jkl
5 30 h kjl
like this
in this one f2 have the s and h
and f3 have the s and h and h
i want out put only like this 5 30 h kjl.
from this table i want to remove f2 field and f4 have the same value and f3 have the value s and h
s means +
h means -
in 3rd 4th 5 th records 1 s and 2 h
1 h and s delete and i want only h recoe\rd.
2007 Aug 14 8:38 AM
Hi,
sort ITAB by ascending.
delete adjacent duplicates comparing F3.
Reward points if it is useful!!!!
Thanks
Yogesh
hi,
i have data in one internal table.
like
f1 f2 f 3 f4
1 20 s abc
2 20 h abc
3 30 s jkl
4 30 h jkl
5 30 h kjl
like this
in this one f2 have the s and h
and f3 have the s and h and h
i want out put only like this 5 30 h kjl.
from this table i want to remove f2 field and f4 have the same value and f3 have the value s and h
s means +
h means -
in 3rd 4th 5 th records 1 s and 2 h
1 h and s delete and i want only h recoe\rd.
2007 Aug 14 8:38 AM
Hi,
sort ITAB by ascending.
delete adjacent duplicates comparing F3.
Reward points if it is useful!!!!
Thanks
Yogesh
2007 Aug 14 8:39 AM
Hi,
sort ITAB by ascending.
delete adjacent duplicates from itab comparing F3.
Thanks
Yogesh
2007 Aug 14 9:36 AM
i am getting wrong.
means what i want to delete that is reamain in table but what iwant that record is deleteing.
it is wroking opposite in my case.