bdc

[Former Member]

i want to know abt BDC call transcation method.

[Former Member]

Hi manjeet,

This is kiran kumar.G.I will explain the call transaction method.And also i will send the differences between call trans and session method check it once..

CALL TRANSACTION:

This is an asynchronous method of transfering data into database.That means if u are having 100 records in flat file .After the sending of 56 th record there is and error in 57 th record then the transaction is stopped there and the first 56 records are updated in the database.where as in session method no record is updated until all records are processed.In this call transaction method u need handle errors explicitly okk..

DIFFERENCE BT SESSION AND CALL TRANSACTION.

CALL TRANSACTION:

1. only synchronous updation

2. errors can handled

3. faster

4. less amount of data

5. updation takes place during program execution .

6.At a time we can process only one TRANSACTION.

SESSION METHOD:

1. Only synchronous updation.

2. Error log is created.

3. slower.

4. Huge Amount of data is Transfer.

5. Updation takes place once the session being created .

Award points if useful.

kiran kumar.G

Have a Nice Day..

[Former Member]

hi manjeet,

Capturing errors in call transaction method.

IN CALL TRANSACTION TO CAPTURE THE ERRORS WE SHOULD PERFORM THE FOLLOWING.

FIRST ME MUST DECLARE AN INTERNAL TABLE WITH THE STRUCTURE OF BDCMSGCOLL TABLE.

THEN WHILE WRITING THE CALL TRANSACTION STATEMENT WE SHOULD PUT THE 'E' MODE FOR CAPTURING ALL THE ERRORS.

THEN FINALLY THE CAPTURED ERRORS MUST TO SENT TO THE INTERNAL TABLE WHICH WE DECLARED IN THE BEGINNING WITH BDCMSGCOLL BY USING THE FUNCTION MODULE "FORMAT_MESSAGE"

AND THUS THE ERROR MESSAGES WILL BE SENT TO THE INTERNAL TABLE WHICH WE DECLARED AT THE BEGINNING.

Session method: The records are not added to the database until the session is processed. sy-subrc is not returned. Error logs are created for error records. Updation in database table is always Synchronous.

Call Transaction method: The records are immediately added to the database table. sy-subrc is returned to 0 if successful. Error logs are not created and hence the errors need to be handled explicitly. Updation in database table is either Synchronous or Asynchronous.

Follow the link for complete program step by step.

http://www.sapdevelopment.co.uk/bdc/bdc_call.htm

Hope this is helpful, Do reward.