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.