topic delete adjacent duplicates in Application Development and Automation Discussions

delete adjacent duplicates

Former Member — Tue, 16 Oct 2007 21:39:39 GMT

hi ,

please correct the following code...

1.if not t_knvv is initial.

2.sort t_knvv by kunnr eikto.

3.delete adjacent duplicates from t_knvv comparing kunnr eikto.

4.select bukrs eikto

5.from lfb1

6.into table t_lfb1

7.for all entries in t_knvv

8. where eikto = t_knvv-eikto.

9.endif.

t_knvv has 2 flds kunnr,eikto and has one row of data( i can see this when i debug in line 1). now when i press F5 and see the value of t_knvv-eikto in lline 8 , it is showing null and i dont get any selection into table t_lfb1.

i dont understand what is wrong..please correct this..

Thanks,

Challa.

Re: delete adjacent duplicates

Former Member — Tue, 16 Oct 2007 21:42:41 GMT

Here is the updated code.

2.sort t_knvv by kunnr eikto.

3.delete adjacent duplicates from t_knvv comparing kunnr eikto.

1.if not t_knvv[] is initial.

4.select bukrs eikto

5.from lfb1

6.into table t_lfb1

7.for all entries in t_knvv

8. where eikto = t_knvv-eikto.

9.endif.

Check above code. Also as you are using FOR ALL ENTRIES, also populate LIFNR into table T_LFB! in order to get all unique entries.

Hope this helps.

ashish