Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

hi

Former Member
0 Likes
643

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.

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
623

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.

3 REPLIES 3
Read only

Former Member
0 Likes
624

Hi,

sort ITAB by ascending.

delete adjacent duplicates comparing F3.

Reward points if it is useful!!!!

Thanks

Yogesh

Read only

Former Member
0 Likes
623

Hi,

sort ITAB by ascending.

delete adjacent duplicates from itab comparing F3.

Thanks

Yogesh

Read only

0 Likes
623

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.