cancel
Showing results for 
Search instead for 
Did you mean: 

V1, V2, V3 UPDATIONS DATA

Former Member
0 Kudos

hi

friends h r u,

i want some and details information on the V1, V2, V3 UPDATE USED IN EXTRICATION

thanks in advances

regards

shafeeq ahmed

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

V1 - Synchronous update

V2 - Asynchronous update

V3 - Batch asynchronous update

These are different work processes on the application server that takes the update LUW (which may have various DB manipulation SQLs) from the running program and execute it. These are separated to optimize transaction processing capabilities.

Taking an example -

If you create/change a purchase order (me21n/me22n), when you press 'SAVE' and see a success message (PO.... changed..), the update to underlying tables EKKO/EKPO has happened (before you saw the message). This update was executed in the V1 work process.

There are some statistics collecting tables in the system which can capture data for reporting. For example, LIS table S012 stores purchasing data (it is the same data as EKKO/EKPO stored redundantly, but in a different structure to optimize reporting). Now, these tables are updated with the txn you just posted, in a V2 process. Depending on system load, this may happen a few seconds later (after you saw the success message). You can see V1/V2/V3 queues in SM12 or SM13.

V3 is specifically for BW extraction. The update LUW for these is sent to V3 but is not executed immediately. You have to schedule a job (eg in LBWE definitions) to process these. This is again to optimize performance.

V2 and V3 are separated from V1 as these are not as realtime critical (updating statistical data). If all these updates were put together in one LUW, system performance (concurrency, locking etc) would be impacted.

Serialized V3 update is called after V2 has happened (this is how the code running these updates is written) so if you have both V2 and V3 updates from a txn, if V2 fails or is waiting, V3 will not happen yet.

BTW, 'serialized' V3 is discontinued now, in later releases of PI you will have only unserialized V3. (This is explained nicely in the weblog).

hope it helps.

Regards

Answers (4)

Answers (4)

Former Member
0 Kudos

Hi,

LO-Cockpit: https://websmp201.sap-ag.de/~form/sapnet?_FRAME=CONTAINER&_OBJECT=011000358700009421482000E

/people/happy.tony/blog/2006/11/24/gist-of-lo-cockpit-delta

Regards

Happy Tony

Former Member
0 Kudos

Difference Between V1 V2 V3 updates

•<b> V1 Update:</b> It is a Synchronous update. Here the Statistics update is carried out at the same time as the document update (in the application tables).

• <b>V2 Update:</b> It is an Asynchronous update. Statistics update and the Document update take place as different tasks. don’t need scheduling

• <b>Serialized V3 Update:</b> The V3 collective update must be scheduled as a job (via LBWE). Here, document data is collected in the order it was created and transferred into the BW as a batch job. The transfer sequence may not be the same as the order in which the data was created in all scenarios. V3 update only processes the update data that is successfully processed with the V2 update.

Former Member
0 Kudos

Hi,

And also you can see a ppt :

https://websmp106.sap-ag.de/~sapidb/011000358700005772172002

With rgds,

Anil Kumar Sharma .P

Former Member
0 Kudos

Hi,

Check this post. Excellent explanantion by Ajay.

you can also check out Roberto's weblog here:

/people/sap.user72/blog/2004/12/23/logistic-cockpit-delta-mechanism--episode-two-v3-update-when-some-problems-can-occur

/people/sap.user72/blog/2005/01/19/logistic-cockpit-delta-mechanism--episode-three-the-new-update-methods

/people/sap.user72/blog/2005/02/14/logistic-cockpit--when-you-need-more--first-option-enhance-it

/people/sap.user72/blog/2005/04/19/logistic-cockpit-a-new-deal-overshadowed-by-the-old-fashioned-lis

Bye

Dinesh