redundant table over two systems

[former_member656551]

Hi,

I need to create a table in 3 diffrent systems but its data maintenance should only happen in one system.

Any suggestions on articels or info material? Or maybe anyone can discribe it to me them self?

Thanks in advance

[Abinathsiva]

Hi Nils,

Mention three different systems clearly

[geert-janklaps]

Hi,

Is there a special reason why you want to keep the data on 3 systems? Isn't it an option to create the table with table maintenance on the system where you want to maintain the data and create an RFC enabled function module to read data from that table.

In you other systems just call the RFC enabled function module to read data from the source system.

Best regards,

Geert-Jan Klaps

[former_member656551]

I need to have the data on all 3 productive systems in case one of them crashes.

These 3 systems all watch each other to make sure that everything runs fine. If one goes down the systems should give a status report wich comes from the table.

[michael_piesche]

When you talk about data maintenance, you mean that records are created, updated, deleted in one (productive) system and then those changes are distributed to the other two (productive) systems? (Just to make sure we are not talking about Dev-Qty-Prod systems 😉

Do you need to have data replicated in realtime or non-realtime? The SAP SLT Replication Server might probably be overshooting your problem 😉

I assume all three systems are SAP systems and have a way of communicating with eatch other?

• You could build your own FMs that are called by triggers (time or changepointer) that exchange the data to the other system by calling RFC FMs or sending IDOCs and building the logic in the other systems to receive the data and update the table
• You could also do a RFC_TABLE_READ call into the first system by the other systems to update the table data

But it all depends on your requirements...

[former_member656551]

Yes that is what I want. I need to have the data on all 3 productive systems.

[michael_piesche]

I need to have the data on all 3 productive systems in case one of them crashes.

These 3 systems all watch each other to make sure that everything runs fine. If one goes down the systems should give a status report wich comes from the table.

thiemannn, not sure if I totally understand, especially what system is the leading system or does each system have it’s one row with status information in the (each) table.

But the easiest would be the following:1. Create a report that does the RFC call RFC_TABLE_READ (with destination) into one or both other systems that reads the remote table data. Then store that data in your local db table.2. Create a Job start starts that report periodically 3. Depending on your requirements and your transport systems, „implement“ that report and the job also for the other systems
let me know if this solves your problem, and if not, why?

[Sandra_Rossi]

So, the topic is related to Master Data Governance.

If you don't have a dedicated software, create a custom program to replicate data. There can be so many solutions to achieve that. The solution depends on your exact requirements, how often the data is updated, maximum delay to replicate, etc.

[michael_piesche]

thiemannn, please follow up on your open question.

• comment answers or your question if there are still open issues.
• otherwise mark an answer as accepted if it helped you solve your problem
• or post an answer of yourself and accept it if you found another useful solution yourself
• or redirect your question to another question that is related and was useful to solve your problem
• in the end, close your question