This website is not affiliated with, sponsored by, or approved by SAP AG.

Replicating custom tables (ztables) between ECC and CRM

CRM related discussion only

Moderators: Snowy, thx4allthefish, Lost Identity

Replicating custom tables (ztables) between ECC and CRM

Postby crmabap » Tue Jul 14, 2009 4:41 am

Hi

We need to create similar Ztables in ECC and CRM and update the records from ECC to CRM every night.Could you pls let me know step by step instructions on how to replicate data between ECC and CRM, as I am new to CRM. Thanks.
crmabap
 
Posts: 6
Joined: Tue Mar 11, 2008 1:31 am

Re: Replicating custom tables (ztables) between ECC and CRM

Postby stjacqd » Wed Jul 15, 2009 2:28 pm

Hello crmabap

I don't know much about CRM.

But if you are using Oracle database, you can write an SQL program to copy modified record from a database to another. That program can be launch from the OS at a specific time.
I know that can be done. How? that is another story.

Otherwise you can used RFC (Remote function call) to copy a ztable to another.

The questions are:
Is all the ztable has to be transfered from a system to another?
Or just modified records.

If you need to transfer only modified records, I hope that you are keeping a date stamp of the records modifications, like oracle does. Otherwise you will not be able to distingish which record to transfer.

It is not much, but I hope that will bring you to the right direction.

Regards
stjacqd
stjacqd
 
Posts: 253
Joined: Tue Oct 22, 2002 9:10 am
Location: Montreal, Qc, Canada

Re: Replicating custom tables (ztables) between ECC and CRM

Postby Harters » Fri Jul 17, 2009 8:50 am

what about tranporting the tables? I assume there is no trans link between the system so copy over the cofiles and data files and import. Need to check the domains e.t.c all exist in the target system
Regards
Harters
______________
SAP Support Ltd
sapsupport.co.uk
Harters
 
Posts: 229
Joined: Thu Feb 07, 2008 8:03 am
Location: Sitting in front of 21 SAP systems


Return to CRM :: SAP CRM

Who is online

Users browsing this forum: No registered users and 3 guests





loading...


This website is not affiliated with, sponsored by, or approved by SAP AG.