topic Re: BDC in Application Development and Automation Discussions

BDC

Former Member — Thu, 17 Jul 2008 12:59:41 GMT

Hi Gurus,

Can i know when we go for call transaction & when we for Session method in real time scenarios.

What are the advantages & disadvantages of both?

Thanx & Regards,

Srinath

Re: BDC

Former Member — Thu, 17 Jul 2008 13:03:38 GMT

Hi Srinath,

Just search in SDN with keywords call transaction & Session .

Or else go to the site

[www.sap-img.com] , you can come to know clearly where to use these options while doing BDC.

Regards,

Suresh.S

Re: BDC

Former Member — Thu, 17 Jul 2008 13:06:24 GMT

Can i know when we go for call transaction & when we for Session method in real time scenarios.

What are the advantages & disadvantages of both?

When You have Large number of Data then you will go for Session method.

Error Log Will be created

we can Process the session when ever we want.

Error records processing is simple.

When you have limited data then you will go for Call Transaction method.

No log , Manually Program for Log.

Processing will be done when you execute the program.

Error records we need to pick manually based on the Call transaction messages format a report and find the error records..

Some times we fo for Combination.

That will solve both the problems.

we go for Call transaction , if any error then we add the error record to Session we process the error session later.

Re: BDC

Subhankar — Thu, 17 Jul 2008 13:06:25 GMT

Hi,

Always try to use call transaction because it is faster than session method because

while updating data into database call transcation does not check the updation but it check the success of the transaction only . where as Session method ,check the

updation of the data into database and also success of the transaction. That's the reason call transaction is faster than Session method.

Re: BDC

Former Member — Thu, 17 Jul 2008 13:26:33 GMT

THANX TO ALL.

REGARDS,

SRINATH

Re: BDC

Former Member — Thu, 17 Jul 2008 13:28:07 GMT

Hi Srinath,

Session Method:

If we are updating the data using more than one transactions which are dependable on each other, ie, one should not begin until the first one is completed, then we go for session method.

In session method the database update is synchronous which serves the above purpose.

When we have large amount of data to be processed then we go for Session Method, because here we create a session and we can run that session at any time we want.

In session method the error handling is done implicitly and only those records in which we have errors are not processed and the remaining are done.

Call Transaction:

We go for call transaction, if we want the data updation done along with the program.

In Call transaction method, the system does not wait for the updation of the first process to be completed. It goes for the second process even if the first process is completed or not.

In Call Transaction the errors are to be handled explicitly.

Hope this helps you.

Regards,

Chandra Sekhar

Re: BDC

Former Member — Thu, 17 Jul 2008 13:32:47 GMT

Hi Srinath.

I would like to suggest few references,

[SDN - Reference for call transaction and session methods with sample code|;

[SDN - Reference for best method - Call transaction and session method|;

[SDN - Reference for functionalities of Call transaction and session methods|;

[SDN Wiki - Standard Reference for BDC|https://www.sdn.sap.com/irj/sdn/wiki?path=/display/home/bdc&]

Hope that's usefull.

Good Luck & Regards.

Harsh Dave