Question:
Hi there,
Because we have a lot of contact persons double we want to delete the double contact's. I've created a list with all double contact persons so I have there customer numbers and there contact number (KNVK-PRSNR).
Does somebody knows a function module/bapi or other way to delete these contact persons. I've allready searched SAPFans, The internet and news groups for a solution.
A recording on the XD02 is not an option, because you can't select the contacts there by their number, only by name.
Help is needed.
Thanks for your time in advance,
Gino
Answer:
Try create an abap report with the following sample:
data: begin of itab occurs 0,
custno like knvk-pernr,
telno like KNVK-PRSNR,
end of itab.
select * from KNVK into corresponding fields of table itab.
sort itab by custno ascending.
DELETE ADJACENT DUPLICATES FROM itab.
Hope this helps.
Hi there,
Because we have a lot of contact persons double we want to delete the double contact's. I've created a list with all double contact persons so I have there customer numbers and there contact number (KNVK-PRSNR).
Does somebody knows a function module/bapi or other way to delete these contact persons. I've allready searched SAPFans, The internet and news groups for a solution.
A recording on the XD02 is not an option, because you can't select the contacts there by their number, only by name.
Help is needed.
Thanks for your time in advance,
Gino
_________________
TB
Answer:
Hi,
An ABAP on the KNVK (and ADRP, ADR6, etc) is my last option. I don't like to delete records directly from database tables. I prefer a SAP function module or BAPI, but is there is no other way ...
Thanks,
Gino