During Realignments - Delta update delivers inconsistent data to SAP BW

[bhat_vaidya2]

Hi,

I  did realignments of COPA data and ran successful delta load afterwards. But when I checked the extractor with KEB2 TCODE in ERP I got this message "Delta update delivers inconsistent data to SAP BW".

what is this message and is there something that I should do to ensure that my delta load is consistent.

thanks,

Bhat

[RamanKorrapati]

Hi Bhat,

Before doing realignment of COPA - Have you deleted delta pointer?

As my guess you may not. if yes then in such case we may see that message.

After realignment you might be reinited your delta - if yes then you won't get any delta issues.

Thanks

[bhat_vaidya2]

Hi,

As you mentioned, I did not delete the delta pointer. Earlier, I used to do reinit after every realignment run. But now I have written a code to set the Flag_dirty, hence realignment is no longer needed.

By the way, before realignment, what are the steps that I need to consider because business always request for frequent realignment run.

thanks,

Bhat

[mohd_abdullah]

Hi,

Have a look at this note.

392635 - Information: Sources with BW extraction from the CO-PA

It says :

• During extraction from line items, the CE4XXXX object table is read as an additional table for the initialization of the delta method and full update so that possible realignments can be taken into account. In principle, the CE4XXXX object table is not read for delta updates. If a realignment is performed in the OLTP, no further delta updates are possible as they would make the data inconsistent between OLTP and BW. In this case, a new initialization of the delta method is required.

Regards.

[bhat_vaidya2]

Hi,

I do not need to do reinitialization as I have a program that sets the flag_dirty. My delta load has been successful but I would like to know if it will cause problem later on.

thanks

Bhat