What is Sync/Async processing and Updates in BDC's ?

[Former Member]

Hi SAP-ABAP Experts .

Please explain me about thses queries regading BDC's...

What is Sync/Async processing and Updates ? Can we visually see them ?

(1.) Session Method have Syncronous Prosessing or Asyncronous Prosessing ?

(2.)Session Method have Syncronous Update or Asyncronous Update ?

(3.)Call Transection Method have Syncronous Prosessing or Asyncronous Prosessing ?

(4.)Call Transection Method have Syncronous Update or Asyncronous Update ?

(5.)How to handle Errors in Call Transection Method through BDCMSGCOLL ?

(6.) May u plz explain me what is diffrence b/t Syncronous Prosessing and Asyncronous Prosessing ?

Which is faster ?

(7.) May u plz explain me what is diffrence b/t Syncronous Update and Asyncronous Update ?

Which is faster ?

Best Regards : Rajneesh

[Former Member]

Hi SAP-ABAP Experts .

Please explain me about thses queries regading BDC's...

What is Sync/Async processing and Updates ? Can we visually see them ?

(1.) Session Method have Syncronous Prosessing or Asyncronous Prosessing ?

(2.)Session Method have Syncronous Update or Asyncronous Update ?

(3.)Call Transection Method have Syncronous Prosessing or Asyncronous Prosessing ?

(4.)Call Transection Method have Syncronous Update or Asyncronous Update ?

(5.)How to handle Errors in Call Transection Method through BDCMSGCOLL ?

(6.) May u plz explain me what is diffrence b/t Syncronous Prosessing and Asyncronous Prosessing ?

Which is faster ?

(7.) May u plz explain me what is diffrence b/t Syncronous Update and Asyncronous Update ?

Which is faster ?

Best Regards : Rajneesh

[Former Member]

Hi Rajneesh,

If we choose the Synchronous update, then, if any changes occurs in one table it will effect the other tables which are related to that particular table.

If we choose Asynchronous update,changes only occur in one table that we are modifying.

You can see the changes in the related tables for Synchronous update and the table which you are modifying for the Asychronous update.

1. Session method has Synchronous processing.

2. Session method has Synchronous database update

3. Call Transaction method has Asynchronous processing

4. Call Transaction method has Synchronous and Asynchronous database updating

5. A batch input processing log is generated for each session for handling errors

The BDCMSGCOLL does not have the messages text. It has only the message type, number and

message parameters.You have to read the message text.

For Call Transaction method - No batch input processing log is generated.

6. Synchronous processing is slower where as the Asynchronous process is faster, as far as I think

7. Synchronous update is slower, as far as I think

Regards,

Naresh

****Please reward points if found useful

[Former Member]

Hi,

Asynchronous Update – The program does not wait for the work process to finish the update. Commit Work.

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.

Answers:

1. Session method has Synchronous processing.

2. Session method has Asynchronous database update

3. Call Transaction method has Synchronous processing

4. Call Transaction method has Synchronous and Asynchronous database updating modes.

5. A batch input processing log is generated for each session for handling errors.

The BDCMSGCOLL does not have the messages text. It has only the message type, number and

message parameters.You have to read the message text using FORMAT_TEXT and u can download .

For Call Transaction method - No batch input processing log is generated.

6. Synchronous processing is slower where as the Asynchronous process is faster.

Regards,

Shiva

[Former Member]

Hi,

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

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

one simple example : You are creating sales order from file and also you want to update header text of sales order.

when you want to update sales order header text,you need to use save_text function module ,here you need to pass sales order number.

when you use call transaction update 'A', data will update transaction level and it goes to the next record,here it will not wait for database .

when you use call transaction update 'S',data will update transaction level and it will update database then it goes next record.

if you want to update header text,then you need to use sync update

database commit -

comitt work - it will update data in database sucessfully

roll back - it will not update in database.

Regards

Kiran Sure