Delta Queue in Source System

[tom_darsy]

Hello

Please can you give me some links which describes the behaviour of delta queue in source system.

I am trying to analyze whether a delta queue should be cleared before a system is restarted or not and need some links to read more about the delta queue.

Also can someone tell me the database tables for delta queue?

thanks

[Former Member]

Hi Tom,

Our basis team usually ask us to do delta queue extraction before a system re-start or during upgrade activity, Its an extra caution taken by them not to disrupt daily delta mechanism and to avoid losing any business transactions during the activity. Sometime even if you clear the delta still delta exist in LBWQ, so make sure you do delta update + repetitive delta.

Hope this helps.

[former_member21257]

Hi Tom,

Delta Queue is a central temporary repository for delta records (new and changed records) in the SAP source system.

The 3 tables that make up a Delta Queue are:

TRFCQOUT (Client Dependent pointer table per queue name and destination.

ARFCSSTATE: Link between TRFCQOUT and ARFCSDATA

ARFCSDATA: Compressed data for tRFC/qRFC

See info on this link for further information:

http://help.sap.com/saphelp_nw04/helpdata/en/6f/66bca6ae43744283d74f1e456ff6c0/content.htm

Rgds,

Colum

[tom_darsy]

So if it is temporary repository for delta records then is it necessary that we need to clear the delta queues if a source system is restarted. If we do not delete the delta queues what can be the effect?

Thanks

[Former Member]

Is the question

If I bounce BW do I need to clear the delta queues (for example for a summer time change in the next 2 weeks)?

Answer is no

If I bounce R3 do I need to clear the delta queues?

Answer is no

If I patch R3 do I need to clear the delta queues?

yes

If I patch BW do I need to clear the delta queues?

depends - but I would to mitigate the risk

[former_member181964]

Hi,

So if it is temporary repository for delta records then is it necessary that we need to clear the delta queues if a source system is restarted. If we do not delete the delta queues what can be the effect?

source system is restarted: generally production systems are not restart.

If you loose any data then you need to reint again if LO you need to fill setup tables and do it for others you need to run Init Infopackages directly in BW and then deltas will go to RSA7.

See about Delta Queue.

Data Flow from LBWQ/SMQ1 to RSA7 in ECC and Delta Extraction in BI

http://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/library/business-intelligen...

Checking the Data using Extractor Checker (RSA3) in ECC Delta Repeat Delta etc...

http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/80f4c455-1dc2-2c10-f187-d264838f21b5&override...;

https://wiki.sdn.sap.com/wiki/display/profile/Surendra+Reddy

Thanks

Reddy

[Former Member]

Hello Simon,

I just found your reply related to what to do with the delta queues...

What about an Oracle database maintenance on SAP BW?

Do I need to clear delta queues as well?

Thank you in advance,

BR David

[former_member209700]

Hi David,

Its not require to do delta clean up if data base maintenance .

I have found good document on  delta queue .Hope it will help you understand delta queue functionality.

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/40427814-376a-2c10-5589-bc1aaa669...

Thanks,

Venkat.

[Former Member]

HI delta queue nothing but a view of these tables.terms of LUW ( Logical Unit of Work ) to which a transaction id (TID) is assigned.

Host ID, Process Id and Timestamp will be saved in below tables

got to se16 give data source name check these table status ARFCSSTATE

ARFCSDATA,TRFCQOUT

thx

vij

[Former Member]

Hi Tom,

The delta queue is a data store in the source system into which data records are automatically written using an update process in the source system (such as with FI documents) or using extraction using a function module after a data request from the BW (such as LIS extraction prior to BW 2.0).

With a delta request, the data records are transferred from the Scheduler into BW.

The data is stored in compressed form in the delta queue. So if the data source supports delte update, it makes sense to use delta queue. You can access the delta queues from RSA7.

The below link will give further help:

http://help.sap.com/saphelp_nw04/Helpdata/EN/6f/66bca6ae43744283d74f1e456ff6c0/frameset.htm

http://help.sap.com/saphelp_nw70/helpdata/en/6f/66bca6ae43744283d74f1e456ff6c0/frameset.htm

-Vikram

[Former Member]

Just to clarify the FI documents are not written to the delta queue but selected at run time by the BW extractor... (FI change records are written to a bespoke BW FI table - but that is not the delta queue and it is read at run time by the extractor)

A better example is SD or MM documents which during the standard save routines - an entry is written to the BW update queue (this can be a two step operation or a single step operation)