Batch update program Issue?

[Former Member]

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.

[venkateswaran_k]

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

[Former Member]

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?

[Former Member]

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.

[former_member219762]

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.

[venkateswaran_k]

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