BDC Updates Methods

[Former Member]

Hi All,

Can some one explain me abt the difference between

*Local

*synchronous

*Asynchronous updates in details...

why Local update is necessary...

Please specify the complete process for the Recording of all the Updates in details.

*Specify the difference between session & calltransaction methods

Thanks,

Lee

[Former Member]

Hi,

BDC:

Batch Data Communication (BDC) is the process of transferring data from one SAP System to another SAP system or from a non-SAP system to SAP System.

Types of methods :

1 .Session Method

2 . CALL TRANSACTION

3. DIRECT INPUT

Session method :

Features:

Asynchronous processing.

Synchronous Processing in database update.

Transfer data for more than one transaction.

Batch input processing log will be generated.

During processing, no transaction is started until the previous transaction has been written to the database.

CALL TRANSACTION METHOD :

This is another method to transfer data from the legacy system.

Features:

Synchronous processing. The system performs a database commit immediately before and after the CALL TRANSACTION USING statement.

Updating the database can be either synchronous or asynchronous. The program specifies the update type.

Transfer data for a single transaction.

Transfers data for a sequence of dialog screens.

No batch input processing log is generated.

For BDC:

http://myweb.dal.ca/hchinni/sap/bdc_home.htm

https://www.sdn.sap.com/irj/sdn/wiki?path=/display/home/bdc&;

http://www.sap-img.com/abap/learning-bdc-programming.htm

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

http://www.sap-img.com/abap/difference-between-batch-input-and-call-transaction-in-bdc.htm

http://help.sap.com/saphelp_47x200/helpdata/en/69/c250684ba111d189750000e8322d00/frameset.htm

http://www.sap-img.com/abap/learning-bdc-

http://www.sapbrain.com/TUTORIALS/TECHNICAL/BDC_tutorial.html

see this link

Reward points if helpful....

Cheers,

Rakesh

[Former Member]

Hi Sachin,

This is kiran kumar.G. I have to explain the differences between synchronous and asyn.

SYNCHRONOUES: when ever u execute the transaction the flat file record can be filled in database record by record while in the middle there is an error comes entire transaction is stopped.There is no updation of Database.

ASYNCHRONOUS: when ever u execute the transaction the flat file recored can be filled in database record by record while in the middle there is an error comes, the records upto to now can be processed can be updated in the database and the transaction is stopped.

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

[Former Member]

Hi,

Session Method::::::::::::::

Session method we use when there is large no of recorsd to be uploaded into database then we do recording thru SHDB tcode and provide tcode like mara.then recording takes place automatically.you just give correct data in final recording.before that you check data is creting recrod in datbase or not.

errors will be captured in session method.unless we process session in sm35 data will not be uploaded to database.

Structure BDCDAT will have values like this :

PROGRAM

DYNPRO

DYNBEGIN

FNAM

FVAL

Creating, Filling, and Closing a Batch Input Session

1. Open the batch input session using function module

BDC_OPEN_GROUP .

2. For each transaction in the session:

a. Fill the BDCDATA structure

b. Transfer to the session with BDC_INSERT .

3. Close the batch input session with BDC_CLOSE_GROUP.

CALL FUNCTION ’BDC_OPEN_GROUP’

EXPORTING

CLIENT = (in which the session is to be processed)

GROUP = (Name of the session that is to be created)

HOLDDATE = (Lock date)

KEEP = (Retain session after successful processing)

USER = (Authorizations user for background processing)

CALL FUNCTION ’BDC_INSERT’

EXPORTING

TCODE = (code of transaction to be run)

TABLES

DYNPROTAB = (BDC data structure having values

CALL FUNCTION ’BDC_CLOSE_GROUP’

EXCEPTIONS

NOT_OPEN = 1

QUEUE_ERROR = 2

A session must be closed before opening another session from the same program. A new call to BDC_OPEN_GROUP with the same session name creates a new session with the same name.

************************************************************

CALL TRANSACTION <transaction code> USING …

MODE ...

UPDATE ..

MESSAGES INTO …...

A Display all

N No display

E Display only error

S Continue processing when update is completed (synchronous)

A Continue processing immediately

L Local update

The Mode Parameter

A Display everything. All screens and the data that goes in them appears on screen. This is the default setting.

N Display nothing. All screens are processed invisibly, regardless of whether there are errors or not.

E Display errors only. The transaction goes into display mode as soon as an error in one of the screens is detected.

S Continue processing when update is completed (synchronous)

A Continue processing immediately

L Local update

The Update Parameter

A Asynchronous updating. Faster execution of batch input program but no completion message from the SAP update service.

Not suitable for large amount of data

S Synchronous updating. Called transaction returns update error message.

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.

Differences:::::::::::::::::::::::::::::::::

Mainly Call Transaction used for small sets of data because in Call Transaction we have to Handle the Processing errors explicitly. We can do this by BDCMSGCOLL structure.

In Session method seperate session will crate for errors. Calll Transaction will update the Database fastly compare with Session Method.

Regds

Sivaparvathi

Please reward points if helpful....