Data Transfer From R/3 to CRM

[Former Member]

Hi Frens,

I have the following scenario.

There are around 100 Z tables related to Variant Configuration in R/3 server. During the initial load basis people will dump all the data to the CRM server.

Then I have to write a ABAP Program for the Delta Load.

i.e If there is any change in any table(modify,Insert,Delete),I have to track that and same shud be replicated to the CRM server. The report will be running on daily basis. I think I have to use Timestamp.Can anybody gimme the logic for this issue.

Your help is highly Appreciated.

Thanks in advance.

[Former Member]

Radhika,

I hope there is a time stamp field in most of the tables and in the tables where you don't have one, atleast there is relation to the table where there is a time stamp.

I guess time stamp is the only way.

Every end of the day, pick up the records created on that day and make an extract of the same.

Two ways of loading the same in CRM.

1. Dump the data into a file and write a program on the CRM side to pick the file and update the tables.

2. Write a RFC on CRM and call that function from your program in R/3 and this function will update the tables.

Regards,

Ravi

Note : please mark the helpful answers

[Former Member]

Thank you Ravi.

[former_member378318]

You need to use change pointers. If you use a timestamp each Z table will need to be changed to include the timestamp and this also means storing useless data. Also with a timestamp how will you know a record has been deleted, you will not. Use change pointers to record key operations insert, change and delete.

[Former Member]

as