topic Re: SAP Communicate with other database for simultanious Backup in Application Development and Automation Discussions

SAP Communicate with other database for simultanious Backup

anand_sagarsethi — Tue, 22 Jun 2010 04:33:01 GMT

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

Re: SAP Communicate with other database for simultanious Backup

Former Member — Tue, 22 Jun 2010 04:59:59 GMT

Anand,

build your logic using these 3 tables

DD02L- consists of all the tables

CDHDR,CDPOS - change documents

Thanks

Bala Duvvuri

Re: SAP Communicate with other database for simultanious Backup

anand_sagarsethi — Tue, 22 Jun 2010 05:20:50 GMT

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...?