cancel
Showing results for 
Search instead for 
Did you mean: 

Check for new data in ODQ

lumirion
Participant
0 Kudos

Hello BW experts,

how to check for new (delta) data in the ODQ that has not been extracted yet?

Regards

View Entire Topic
xient
Explorer
0 Kudos

Hi Ertugrul.

Maybe you should keep an eye an the Update Mode setting, like you know from the LO Cockpit (LBWE).

Direct Delta: In case of Direct Delta LUW's (Logical Unit of Work) are directly posted to delta queue (RSA7) and we extract the LUW's from delta queue to SAP-BW by running delta loads. If we use direct delta it degrades the OLTP system performance because the LUW's are directly posted to the delta queue (RSA7), the application is kept waiting until the enhancement code is executed.

Queued Delta: In case of Queued Delta LUW's are posted to extractor queue (LBWQ). By scheduling the V3 jobs we move the documents from LBWQ to RSA7 and we extract the LUW's from delta queue to SAP-BW by running the delta loads. Queued Delta is recommended by SAP, it maintains the extractor log which is to handle the LUW's which are missed.

Unseriliazed V3 Update: In case of unserialized v3 update LUW's are posted to update queue (SM13). By scheduling the v3 job which moves the document from LBWQ to RSA7 and we extract the LUW's from delta queue to SAP-BW by running delta loads.

You can also check from transaction RSA2 in the source system the extractors. Here you can see the specific setting, e.g. for the delta extraction:

Here is also a very interesting link (I found it only in german): Der Verbuchungsprozess

Or this OSS Note: 505700

I hope this helps. Good luck!

Yavuz