We have a data load set up for datasource 3FI_SL_Z0_TT to load FI-SL data in BW at totals level.
Postings are very frequent and new document/GL line item keeps generating every few seconds in ECC.
Data load runs every 2 hours to bring the next delta from delta queue.
The issue is that BW reports are not reconciling with ECC figures that we have just before delta load triggers.
However, those transactions are pulled in next delta run. But this way, the reports could never reconcile.
My question here is how come it is not getting updated in the nearest delta run although the delta queue for FICO datasources is updated simultaneously when the transactions are created. Therefore, no such V1/V2/V3 periodic jobs as in case of LO.
This is causing issues to Business for reconciliation of reports on month end.
Please suggest me if I am missing something here or any gap in my understanding.
I would appreciate if you could provide me more information on SL delta queue update process.
Thanks in advance.