wat is synchronous, asynchronous & local mode of update in BDC plz help

[Former Member]

wat is synchronous, asynchronous & local mode of update in BDC .

plz explain each of them

[former_member635028]

hi,

here you are specifying mode in which you execute transaction

A is all screen mode. All the screen of transaction are displayed.

N is no screen mode. No screen is displayed when you execute the transaction.

E is error screen. Only those screens are displayed wherein you have error record.

Here you are specifying update type by which database table is updated.

S is for Synchronous update in which if you change data of one table then all the related Tables gets updated. And sy-subrc is returned i.e., sy-subrc is returned for once and all.

A is for Asynchronous update. When you change data of one table, the sy-subrc is returned. And then updating of other affected tables takes place. So if system fails to update other tables, still sy-subrc returned is 0 (i.e., when first table gets updated).

Regards,

Sreevani

[Former Member]

Hi,

Please refer the link,

Regards,

Hema.

• Reward points if it is useful.

[Former Member]

A Asynchronous updating. In this mode, the called transaction does not wait for any updates it produces to be completed( does not wait till the update in database is complete either it is successful or un successful). 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.

S 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.

L Local updating. If you update data locally, the update of the database will not be processed in a separate process, but in the process of the calling program. (See the ABAP keyword documentation on SET UPDATE TASK LOCAL for more information.)

reward if it is helpful..

sai ramesh.

[Former Member]

Hi,

Local update is the one which is confined to a particular application server,where the BDC program is running.

Where as Asynchronous and Synchronous upadates are not confined to a particular Application server,they can be on different application servers depending upon Workload .

Asynchronous update does not take care of updation of child tables,it takes care of only parent table updation.It is faster process.

Synchronous update takes care whole the updation of child tables and parent table.It is slower process compared to Asynchronous.

--Seshu

Reward if helpful.