Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

synchronize tables data between two systems

Former Member

‎04-14-2010 5:29 PM

0 Kudos

Hello,

How to synchronize the tables data between two systems.

In P1 system I have table A and in P2 system I have table B. Both Table A and Table B are having same structure(only table names are diffrent).

Table A will be maintained in system P1 and I need to have same data in Table B in P2 system. How can I get this?

These tables are not customizing tables

Thank you!

Best Regards,

Sasidhar Reddy Matli.

4 REPLIES 4

Former Member

‎04-15-2010 5:46 AM

0 Kudos

Use ALE-IDOCs

Regards

Vinod

SuhaSaha
Advisor
Advisor
In response to Former Member

‎04-15-2010 5:51 AM

0 Kudos

I am floored by your suggestion. I hope the OP is as enlightened, if not more, than i am.

Former Member
In response to Former Member

‎04-15-2010 6:08 AM

0 Kudos

Hi suhas,

I though it was the real time synchronization between two systems. Correct me if the solution was wrong.

Regards

Vinod

former_member418469
Participant

‎04-15-2010 5:56 AM

0 Kudos

hi

Store the data from Table A to a text file. Write a program in P2 system using GUI_UPLOAD to upload data from text file. Insert the data into table B using insert command.