Skip to Content
Former Member
Jun 15, 2006 at 07:26 AM

how to delete the data from SAP R/3 DB table from BW



I am facing an issue... I have populated the data into custom r/3 DB table by running a user exit.I am getting the data and loading(Full Load) it in BW ODS. But my problem is when i rerun the user exit it is giving me a short dump saying "SAPSQL_ARRAY_INSERT_DUPREC". when i delete the enteries of DB table it is working fine. But this fine in development.but i production i cannot do this.So i want to delete the DB table enteries by an ABAP program and call this ABAP program using Process chain when my ODS data LOAD is successful. How to go About this.

P.S: I want only to delete the DB table enteries not the DB table.....

Thanks and Regards

Sairam phani