Skip to Content
0
Former Member
Feb 27, 2009 at 09:24 AM

Deleting duplicate records

238 Views

Hi,

Can I know is there any way to delete the duplicate recors in the internal table?

The code i'm using seem not working.Thanks.

SELECT *

INTO CORRESPONDING FIELDS

OF TABLE i_pa0009

FROM pa0001 INNER JOIN pa0009

ON pa0001pernr = pa0009pernr

WHERE bukrs IN s_ccode AND

bankn NE ''.

DELETE ADJACENT DUPLICATES FROM i_pa0009 COMPARING ALL FIELDS .

or

How can I move the company code to the i_PA0009 table with all i_PA0009 data?

SELECT bukrs pernr INTO TABLE i_tmp

FROM pa0001

WHERE bukrs IN s_ccode.

IF NOT i_tmp[] IS INITIAL.

DELETE ADJACENT DUPLICATES FROM i_comp.

SELECT * INTO CORRESPONDING FIELDS OF TABLE i_pa0009

FROM pa0009

FOR ALL ENTRIES IN i_tmp

WHERE pernr EQ i_tmp-pernr AND

bankn NE ''.

endif.