Do not update delta pointer if not changed since the last update.

[RG24]

Hi Experts.

I have created a data source in ECC which delta is based on a time stamp field.

The data source feeds from a custom table in the same system which is updated every five minutes with IDOC information (EDIDC, EDIDS, EDID4) via custom program (job).

During pick hours this job may take up to 3 hours per execution. But usually 5 min should be enough.

In BW the delta upload is scheduled also every 5 min. However during pick hours the delta keeps running every 5 min and since it does not find any changes in the database it brings nothing from the source. However the delta pointer is updated in source system, and it will keep being updating for 3 hours more bringing no data.

Once the 3 hours job execution is finished in source system, the next delta execution works fine but with the wrong delta pointer. The problem is that during those 3 hours the delta pointer has been updated in the source system and it is skipping all records updated during those 3 hours creating a gap in the upload to BW.

Before changing the delta pointer to a "numeric" pointer, may I ask: Is there any way via user exit to control the delta pointer update in source system as saying: "if there is no change in the delta since the last update do not update data pointer". That way once the 3 hours pick are over, the next delta will pick up in the latest valid pointer without skipping records.

Thanks for your comments.

[roland_szajko]

Hi

If you are using generic delta, then the delta pointer is calculated by SAPI automatically and is updated to ROOSGENDLM by the system. You can however define safety intervals. See:

• https://help.sap.com/docs/SAP_NETWEAVER_750/ccc9cdbdc6cd4eceaf1e5485b1bf8f4b/cc3c3473cd93460b9ed506e...
• https://help.sap.com/docs/SUPPORT_CONTENT/bwdabc/3361384656.html?locale=en-US

Another options:

• Use a numeric pointer instead of a timestamp
• Use your own delta logic implemented with your own function module logic to calculate the specific delta pointer. You can use for example your own custom table to store the timestamp to rely on.

br

Roland