topic Re: Batch update program Issue? in Application Development and Automation Discussions

Batch update program Issue?

Former Member — Thu, 27 Jun 2013 08:17:31 GMT

Hi Experts,

I have a requirement for uploading bulk amount of data from a flat file to SAP system.The file contails large amount of data so I decided to go for BDC.Now I wanted to know

1 ) whether I should go for Call Transaction method or Session method?

2) Suppose when I am doing the batch update an error occurs at particular record (say 69 th record) I wanted to know how many records will get updated in the database when I go for Call transaction and Session method?

3) How can I populate the BDCMSGCOLL Internal table. Will it contain Error Documents or Error messages?

Regards,

Alexander.

Re: Batch update program Issue?

venkateswaran_k — Thu, 27 Jun 2013 08:27:02 GMT

You can track the results of the BDC run.

Example

call transaction <Your Tcode> using bdc_tab mode 'S' update 'S'

messages into messtab.

The internal table messtab contains all the Error and Wrning messages. You can read after the execution of BDC

Let me know if you need any further information

REgards

Venkat

Re: Batch update program Issue?

Former Member — Thu, 27 Jun 2013 08:35:26 GMT

Hi Alexander,

Can you please tell which transaction/master data are you trying to upload. Apart from BDC there are other methods like BAPIs(robust error handling), LSMW etc.

The choice of conversion tool should be taken based on -

*) Kind of error handling expected.

*) Execution Time.

*) Log Files required or not.

*--> More over BDC is highly dependent on screen flows and configuration dependent.

BR.

Re: Batch update program Issue?

former_member219762 — Thu, 27 Jun 2013 11:19:27 GMT

Hi,

If time is not constraint then it is better to go session method because it has inbuilt error handling.

If there is error

In session------that record stored in error session and process continue to next record

so it won't stop processing

In call transaction in asynchronous mode it is same as above.

But in Synchronous mode we can control the flow by query sy-subrc.

Regards,

Sreenivas.

Re: Batch update program Issue?

Former Member — Fri, 28 Jun 2013 05:00:44 GMT

Thanks Venakat for your response.

The following are my concerns when using BDC.

1) When using BDC Call transaction method if an Error occurs at a particular line whether updation will stop there.i.e Will it start processing the next line in the excel.if the rest of the lines are processed then what will my Error table contain?

2)In the message tab whether I will get all Error Document Details. i.e I have gone through the structure of BDCMSGCOLL and it does not have any fields to hold the values.Correct me if Iam wrong?

3)What is the advantage of using Asynchronous update over Synchronous update in BDC Call Transaction?

Re: Batch update program Issue?

venkateswaran_k — Fri, 28 Jun 2013 06:48:42 GMT

Hi Alexander,

First, The format of calling BDC transaction - the parameter mode decides....

call transaction <Your Tcode> using bdc_tab mode 'S' update 'S' - will continue processing even though the errors are there,

if you put mode 'E' - It will stop when error occurs

if you put mode 'A' - it is a foreground processing - that user can see the bdc execution in

foreground and user has to press enter every time

if yu put 'S' - it is a background and it will process fully

Second, you have to process the messtab to get the eror message.. using message type ad message number, messsage id, you can get thedescription by calling BAPI

    CALL FUNCTION 'BAPI_MESSAGE_GETDETAIL'
      EXPORTING
        ID                 = mid
        NUMBER     = mnr
*       LANGUAGE   = SY-LANGU
        TEXTFORMAT = temp
      IMPORTING
        MESSAGE    = msg.

Regards,

Venkat