BDC

[Former Member]

Which method in bDC is best for uploading 1 lakh records and why? What happens when current is off in middle of uploading the records and how to start uplaoding again?

[Former Member]

hi,

1) Which method in bDC is best for uploading 1 lakh records and why?

The CALL TRANSACTION method allows only a single transaction to

be processed by SAP.

Batch Input session can run the session at any time you want.hence Batch input session is better than Call transaction.

2 )

You can correct and re-execute the incorrect transactions in an "Errors" session. There are two ways to do so:

1. Re-run the session in display-all or error-display mode. These modes offer the following advantages:

- The system skips transactions that were successfully completed. Only incorrect transactions or transactions that have not been executed are run.

- You can change inputs and add missing screens interactively as incorrect transactions run. The system logs all such changes.

The following topic provides more information on using display-all mode or error-display mode to correct a transaction.

2. As an alternative, you can analyze the session to determine what the error was. With the analysis displays, you can check the screen that contained the error and the values that were entered in it. You can then correct the program that generated the session and regenerate the session.

You must ensure that the new session does not include transactions that were successfully completed. Otherwise, the updates made by the transactions will be performed again.

<b>REMOVED BY MODERATOR</b>

Regards

Siva

Message was edited by:

SivaKumar

Message was edited by:

Alvaro Tejada Galindo

Message was edited by:

SivaKumar

[Former Member]

hi harish,

Call transaction is the best way because you can collect error using BDCMSGCOLL.

Call transaction.

1) asynchronous processing

2) but it transfer small amount of data

3) processing is faster.

4) errors need to be handled explicitly

5) data is updated automatically

The most important aspects of the CALL TRANSACTION USING interface are: - Synchronous processing - Transfers data for a single transaction - Synchronous and asynchronous database updating both possible The program specifies which kind of updating is desired. - Separate LUW for the transaction The system performs a database commit immediately before and after the CALL TRANSACTION USING statement. - 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.sapbrain.com/TUTORIALS/TECHNICAL/BDC_tutorial.html

<b><REMOVED BY MODERATOR></b>

Thanks

Message was edited by:

Pattan Naveen

Message was edited by:

Alvaro Tejada Galindo