cancel
Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos

Hi,

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

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Sairam,

why don't you just add the code for deletion of records into that user exit, so it would first delete entries and then write new ones.

Alternatively, you could use a Process Chain to trigger an event in R/3, and by that event a scheduled job would run, deleting entries from that table.

As I don't know details of the solution you're implementing, that's all I can think of now.

Cheers,

/RB

Former Member
0 Kudos

roman,

I was trying to do the first one i.e by adding delete statement in my code. How to go about triggering an event in R/3 using process chains

regards

sairam phani

Former Member
0 Kudos

Hi Sairam,

I see your question have already been answered..

cheers.

/RB