Block document when filling setup table

[Former Member]

hi experts :

I have a question about blocking document ,do we have to block the document when filling the setup table and when doing initial extracion both ? or just filling the setup table?this confuess me .

in experiance ,how long will it take to fill the setup table if the total records reaches about 5 million .

thank you in advance

cindy

[Former Member · Accepted solution]

It is not required to block documents while populating the setup tables(Though you would miss out a couple of documents that gets into your transaction tables at the time of executing run on setup table)...

At the time of initial extraction, yes it is required to hold off documents getting posted into R/3 tables.

[Former Member]

Dear SDBI,

can u please explain more on early delta initialization...?

Regards,

Mahendra

[Former Member]

With early delta initialization, you have the option of writing the data into the delta queue or into the delta tables for the application during the initialization request in the source system. This means that you are able to execute the initialization of the delta process (the init request), without having to stop the updating of data in the source system. You can only execute an early delta initialization if the DataSource extractor called in the source system with this data request supports this.

Extractors that support early delta initialization were delivered with Plug-Ins as of Plug-In (-A) 2002.1.

You cannot run an initialization simulation together with an early delta initialization.

[Former Member]

Thank you for your reply:)

[Former Member]

Hi

Transaction data tables -> setup table -> delta queue -> BW system

Early delta init writes the data directly to delta queue

Transaction data tables -> delta queue -> BW system

Regards

N Ganesh

[Former Member]

Hi

We have to block document posting whenever we fill setup table

Setup table contains all the transaction data to be updated from which init is extracting data

When users are posting documents, we may miss some data while filling up or doing extraction.That may cause inconsistencies in later deltas

We have Early delta initialization option for specific extractors which can run even without blocking document posting

Regards

N Ganesh

[Former Member]

Hi,

It is recommended to fill the setup table after logging off all the transaction users, preferably during nights (basically you will have to take a down time of the R/3 system). if you have taken a down time then it is not necessary to block documents, since there would be no users posting transactions.

The blocking would be useful if you are trying to fill the setup table during the day time and there is possibility that users could post some documents. However by blocking documents, this would prevent the users from posting / creating documents and this could hamper the normal business (like creating billing documents, orders etc).

if you are doing the filling up at night after taking down time then the approx time could be 1 hour(my guess) again this could depend on the application servers, RAM etc. However if you are trying to do it during the peak hours, i.e when the users are doing transaction(which is not recommended), then it is very difficult to estimate the time.

Assign points if useful.

Regards

Venkata Devaraj