Skip to Content
avatar image
Former Member

LO-Cockpit V1 and V2 update

Hi,

Can anyone tell me what is the difference between V1 and V2 update.

I read Robert Negro's weblog and he has stated

1. The serialized V3 update can guarantee the correct sequence for the extraction data of a document only if there were no errors in the V2 update. This is because the V3 update only processes update data for which a V2 update has be carried out successfully.

Why is V3 dependent on V2, what is V2 and V1 update?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

6 Answers

  • Best Answer
    avatar image
    Former Member
    Apr 04, 2005 at 08:39 AM

    Hi,

    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 this helps,

    cheers,

    Ajay

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi ajay,

      the update tables still confuses me.But i got the confirmation rgad the V1,V2,V3 updates.

      thanks

      It would be great if you could explaination on update tables as u did for V1,V2 updates in your liesure.Would be very helpful.

      Message was edited by:

      sap novice

  • avatar image
    Former Member
    Sep 03, 2005 at 02:40 PM

    Hi Ajay

    The concept described is too good.I have been working on BW for last 6 months.Actually i am SD Functional.As per you

    Application Tables are populated in v1 work process.

    Statistics tables are populated in V2 work process after some time of V1.

    what about Update Tables.these are updated in which work process.What i feels is in V2 process.Is it right ?

    Also in LO cockpit we fill some setup tables.For eg

    Using Transaction OLI1BW for Inventory Management module

    we fill some set up tables.which are this tables.

    Are these the update tables.

    It will of great help if u clear my doubts.

    waiting for your kind reply.

    Thanks and Regards

    Raghavendra.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi raghavendra,

      Did you get answer from Ajay fro the doubts u raised.Please do let me know.

      Thanks,

      Sunny.

  • avatar image
    Former Member
    Jun 08, 2006 at 10:02 AM

    Hi,

    Difference between V1, V2 & V3 ...

    Synchronous Updating (V1 Update)-->>

    The statistics update is made synchronously with the document update.

    While updating, if problems that result in the termination of the statistics update occur, the original documents are NOT saved. The cause of the termination should be investigated and the problem solved. Subsequently, the documents can be entered again.

    Asynchronous Updating (V2 Update)-->>

    With this update type, the document update is made separately from the statistics update. A termination of the statistics update has NO influence on the document update (see V1 Update).

    Asynchronous Updating (V3 Update) -->>

    With this update type, updating is made separately from the document update. The difference between this update type and the V2 Update lies, however, with the time schedule. If the V3 update is active, then the update can be executed at a later time.

    In contrast to V1 and V2 Updates , no single documents are updated. The V3 update is, therefore, also described as a collective update.

    Thanks & Regards,

    SH

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 12, 2007 at 09:06 PM

    Hello Ajay,

    Your answers are just mind blowing and excellent. It has cleared too many concepts for me.

    Thanks a lot

    Simmi

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 13, 2007 at 04:25 AM

    Very Very useful comments from SAP GURU's

    Thanks again

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 26, 2007 at 05:45 AM

    Hi Sabrina,

    Difference between V1, V2 & V3 ...

    SYNCHRONOUS UPDATING (V1 Update):

    The statistics update is made synchronously with the document update.

    While updating, if problems that result in the termination of the statistics update occur, the original documents are NOT saved. The cause of the termination should be investigated and the problem solved. Subsequently, the documents can be entered again.

    ASYNCHRONOUS UPDATING (V2 Update):

    With this update type, the document update is made separately from the statistics update. A termination of the statistics update has NO influence on the document update (see V1 Update).

    Asynchronous Updating (V3 Update):

    With this update type, updating is made separately from the document update. The difference between this update type and the V2 Update lies, however, with the time schedule. If the V3 update is active, then the update can be executed at a later time.

    In contrast to V1 and V2 Updates , no single documents are updated. The V3 update is, therefore, also described as a collective update.

    hOPE IT HELPS U

    Regards

    Shankar

    Add comment
    10|10000 characters needed characters exceeded