SAP Communicate with other database for simultanious Backup

[anand_sagarsethi]

Hi,

I have to write a program or function module in abap which should be called everytime whenever SAP executes an insert/update/ delete/modify statement. Or I can say when ever it changes any table contents.

The scenario is : I have created a replica of the database tables in different database running on different host machine. That database can be oracle or MySql. What I need is whenever somebody executes the project I need what ever data in table is getting inserted i need to copy the same data and place in other database .

Any Help how to do it..

Regards

Anand Sagar

[Former Member]

Anand,

build your logic using these 3 tables

DD02L- consists of all the tables

CDHDR,CDPOS - change documents

Thanks

Bala Duvvuri

[anand_sagarsethi]

Hi Bala,

I want it to be in different database which SAP is not configured with, but called for specific tables only.

I want synchronous update in another attached database. To tell you in figure what I actually need is

SAP - - - - - - MySQL/ Oracle

SAP DB

Everything synchronous.. SAP responsibility to update the SAP database, I need when ever it tries to update the SAP DB specific tables I want synchronous update on MySQL/ Oracle . these are not configured with SAP. May I write a program calling SAP which will call whenever SAP goes for insert/update/delete and how...?