synchronous or asynchronous update?

[Former Member]

how tables are effected by taking synchronous or asynchronous update?

[Former Member]

http://www.shef.ac.uk/psychology/gurney/notes/l5/subsection3_3_2.html

[Former Member]

Hi,

Synchronous Update – The program wait for the work process to finish the update. Commit Work and Wait.

Asynchronous updating. In this mode, the called transaction does not wait for any updates it produces to be completed. It simply passes the updates to the SAP update service. Asynchronous processing therefore usually results in faster execution of your data transfer program.

Asynchronous processing is NOT recommended for processing any larger amount of data. This is because the called transaction receives no completion message from the update module in asynchronous updating. The calling data transfer program, in turn, cannot determine whether a called transaction ended with a successful update of the database or not.

If you use asynchronous updating, then you will need to use the update management facility (Transaction SM12) to check whether updates have been terminated abnormally during session processing. Error analysis and recovery is less convenient than with synchronous updating.

Synchronous updating. In this mode, the called transaction waits for any updates that it produces to be completed. Execution is slower than with asynchronous updating because called transactions wait for updating to be completed. However, the called transaction is able to return any update error message that occurs to your program. It is much easier for you to analyze and recover from errors.

Thanks,

Kasiraman R

[Former Member]

Hi,

in synchronous updated the parent table is updated along with the child

tables and then a sy-subrc is returned. 0 fior sucessful and 4 or 8 for not

sucessful. While in asynchronous updatetion after the updation of the

parent table we get a sy-subrc return. The system is not bothered if the

child tables are updated or not.

Cheers,

Chaitanya.