How to fetch the delta records through RFC from ECC

[Bhargavakrishna]

Hi all,

we have a requirement, where we need to fetch the delta records from ECC and send it to the web service.

so how PI can fetch only the delta records from ECC info type- 28.

What are the possible ways to achieve this.

can we do it from PI or we have to develope some ABAP program to achieve this. we should fetch the data only at 10 pm every day.

please guide me..

[Bhargavakrishna]

Dear all,

Thanks for you reply..:)

[former_member201264]

Hi Bhargava,

Use the scenario as RFC to SOAP.

Steps to be done in ECC:

Write an ABAP Program to get only delta records based on a filed like FLAG in the table by using SELECT where FLAG is NULL or NO.

Fill the Internal tabale then pass to the RFC FM.

YOu can schedule this program as per your Business.

Steps to be done in PI:

Normal approch only.

Regards,

Sreeni.

[MichalKrawczyk]

Hi,

what you can do is sometimes different form what you should do

what you should do:

1. create HR master data output and set change pointers to work only with the info type you're looking for

2. schedule transaction PFAL to send IDOCs only at 10:00

this way it will be done in the standard way,

Regards,

Michal Krawczyk

[udo_martens]

Hi,

delta updates are very complex because you need to handle error situations. If once any message fails, the systems will have inconsistent data and you need pretty complexe mechanism to avoid / correct that.

You should consider a full update if the message volume allows that. Such an interface would be much more robust.

Delta update: Usually infotypes have a change date / time stamp. You need to select changed data for the last 24 hours and execute the program by a daily job.

Send the data via proxy (good performance) to PI. Best would be asynchrous (for good performance). You have to start with creating data types in PI. For the receiver side import the service wsdl to create a external def. Between msg type and ext def create a mapping.

/Udo

[gagandeep_batra]

Hi bhargava

you can go far abap proxy and batch job that trigger before 10 PM

check blow link for abap proxy:

http://www.saptechnical.com/Tutorials/XI/ABAPClientProxy/page2.htm

Regards

GAgan