bdc

[radhushankar]

Hi all can any one xplain Asynchronous processing and

Synchronous Processing in database update in BDC Session method.

Thanks and Regards,

Arun J

[Former Member]

Hi,

Synchronus data processing is that in which the program calling the update task waits for the update work process to finish the update before it continues processing.

In Asynchronus update the callng program does not wait for update work process to finish the update and continues as normal.

A BDC done with sessions is always synchronus.

A BDC with call transaction is by default asynchronus

unless you define it explicitly as

call transaction 'XXXX' ...... update 'S'.

( If you donot define update option it is defaulted to "A" ).

The update method is of importance when one transaction locks data which may be required by a subsequent transaction . The subsequent transaction will fail if data is locked from previous one. An example would be you are creating sales order for same material in succession ( with asynchronus update ). Quite likely that some of transactions would fail due to material locked.

For large volume of data Call Transaction will be faster but you have no restart capability here. Suppose from 1000 transactions 100 fails . You will have to run the BDC program again exclusing the ones which wrere successful. However with session method you have the option to process the error transactions again in SM35 . So if you are sure that errors will not occur use call transaction else use session method.

Regards

Kiran Sure

[radhushankar]

Can you send me model bdc program for session as well as call transaction method??

Thanks and Regards,

Arun Joseph

[Former Member]

Hi,

Refer the theard for session method example

https://forums.sdn.sap.com/click.jspa?searchID=10893294&messageID=3643862

Refer the theard for call transaction method example

https://forums.sdn.sap.com/click.jspa?searchID=10893319&messageID=1417493

https://forums.sdn.sap.com/click.jspa?searchID=10893319&messageID=4777023

Regards

Kiran Sure

[Former Member]

1A.Asynchronous Method:

Your program doesn't wait for the called transaction to be completed.As soon as your program calls a transaction it will start carrying out other works.This will result in faster execution.

Synchronous Method:

Your program wait for the called transaction to be completed.Unless the called transcation is completed your program wont resume processing.Processing will be slow compared to asynchrounous approach