In this document, I will explain about V1, V2 and V3 updates and different update methods.
V1, V2 and V3 updates are different work processors on application server that takes the update LUW (Logistic Unit of Work) from running the program and executing it
V1 Update:
- V1 updates are processed consecutively in a single update work process on the same application server
- V1 update ensures serialization of data and it denoted primary changes that are time critical
- V1 run uses more resources when compared to V3 run
- In the figure below, when an order number is created in the tcode VA01, it goes into application tables and statistical tables in V1 update. Hence, it ensures serialization
Note: The statistical tables are BI related tables such as Delta Queue, Extraction Queue and Update tables whereas the application tables are the database tables
V2 Update:
- V2 updates are less critical secondary changes
- They are statistical changes such as result calculation
V3 Update:
- V3 updates are similar to V2 updates and specifically used for BW extractions
- Serialization is not ensured (Disadvantage)
- V3 uses less number of resources when compared to V1 update
Update Methods:
There are three different update methods. They are
- Direct Delta
- Queued Delta
- Unserialized V3 update
Note: Pre-requisites for all the data flow diagrams are
- Make sure that the RFC Connection exists between SAP ECC and SAP BI
- Delete the data in setup tables
- Direct Delta:
- In this update method, data is directly transferred to Delta Queue and application tables at same time, with every document posting
- Here, 1 document = 1 LUW (Logistic Unit of Work)
(Click on the image to enlarge it)
- By writing to delta queue with V1 posting process, serialization is ensured
- This update method is recommended for customers with few documents
- Additional monitoring of update tables or extraction queue is not required
2. Queued Delta:
- In this update method, the records are first sent to ‘Extraction Queue’ using V1 update
- From ‘Extraction Queue’, we need to send the records to ‘Delta Queue’ using collection run
- In this update method, we can collect up to 10,000 documents in one LUW
(Click on the image to enlarge it)
- By posting the documents to extraction queue using V1 update, serialization is ensured
- We can reduce the downtime by using queued delta method
3. Unserialized V3 update:
- Here, the extracted data of an application is written to update tables using V3 update
- We need to send the data from Update Tables (SM13) to Delta Queue (RSA7) using Collection Run
- In this, serialization of documents is not guaranteed
(Click on the image to enlarge it)
- Updating to a DSO with Overwrite mode is not recommended using this update method
- This is recommended when we want to send the data to info cubes or DSO’s with additive mode
Related documents:
SAP Note 505700 - LBWE: New update methods as of PI 2002.1