Error Handling BDC Session Method

[whatsap]

Hi,

When i have 10000+ transactions to be originally loaded from a flat file into the SAP using BDC session method and, of which, 3500+ transactions contains errors then, what is the best way to handle/correct/remove these errors and ensure that we have 100% data conversion achieved without duplicating any transaction?

Best Regards,

Vishwanath

[JL23]

Hard to help without knowing the transaction that you made a BDC for, and not knowing what kind of errors these are.

How many equal errors are there, how many different errors?

[whatsap]

Hi Jurgen,

The data at hand is specific to sales orders for which we are using recording on VA01 tcode to load the data into SAP. The errors encountered are largely categorized into missing inco-terms, incorrect UoMs for materials used and missing Sold-Tos in SAP.

Are these errors to be addressed manually for each errorneous transaction?

[JL23]

Yes and no, there is no automatism to process errors from batch input sessions, you need to run it foreground (errors only mode) to take care about the errors manually.

3500+ is a large number and you may need to sit for some days to get this all through.

But partially it depends on the messages. How can there be no sold-to when you process VA01? If it would be a master data issue then you cannot resolve it by processing the BDC in foreground, then you would need to maintain the customers and materials correctly and can finally just re-run the BDC again and it will process all transactions and only the others errors would remain, maybe you get new messages when the previously missing sold-to is then not maintained with Incoterms either.

Actually doing a BDC requires a bit of ABAP knowledge, and with a bit of ABAP knowledge you can validate the data when you create the batch input sessions, before you just blindly execute such a batch input session.

It is even hard now to find out which of your source data got processed and which part ended in errors. If you identify that then you can separate them in your source file and create for the faulty records a new batch input where you do validations and do eventually programmatic adjustments with defaults (or you just give this error part back to the person who gave it to you to complete it with correct information)

[kasralikarpratik]

Remove successful records from flat file and correct INCO terms in flat file and re run it. it will correct all.

[Former Member]

When i have 10000+ transactions to be originally loaded from a flat file into the SAP using BDC session method and, of which, 3500+ transactions contains errors then, what is the best way to handle/correct/remove these errors and ensure that we have 100% data conversion achieved without duplicating any transaction?

3.5K errored transactions.. hunch is this could be improper data..

Download, Sort/See Errored messages

Locate the errored pattern & fix it.

You might know this already, just again to bolster it.

SM35 ==> Choose your session ==> Log ==> Print

Download the errors to your Desktop

Hope this helps you.