topic Re: BDC Upload. in Application Development and Automation Discussions

BDC Upload.

Former Member — Wed, 11 Apr 2007 09:59:11 GMT

Hi ,

In one interview I was asked a questin regarding BDC..

i.e. when uploading BDC of 5000 , after 1000 records due to some problem it was stop. Then what will u do ?

It it is Batch Input Session - will u delete 1000 records from flat file manually and then restart it or how can you find where it has stopped means which records ? where will u get this errors ?

If it is call transaction the what will u do ? How will u upload remaining records ?

Thanks and Regards,

Muttu.

Re: BDC Upload.

Former Member — Wed, 11 Apr 2007 10:02:41 GMT

Hi,

If it is session method you will come to know the number records correctly uploade in SM35 using

Session log.it will give the details.

If it is call transaction BDCMSGCOL will capture the message, capture those errors into an internal table and try to display them using FORMAT_MESSAGE fun module,

so that you will know the exact records uploaded, accordingly keep/modify the file and upload the remaining.

rewar points if useful

regards,

ANJI

Re: BDC Upload.

Former Member — Wed, 11 Apr 2007 10:05:54 GMT

If the records are more than 10000 the it is very difficult to find where it has stopped.

what about the flat file ? will we delete it manually or what ?

Re: BDC Upload.

Former Member — Wed, 11 Apr 2007 10:07:15 GMT

hi,

If it is Batch input session the session which is stopped due error is available in sm35 transaction under 'Incorrect' heading. u can correct the errors in the session and reexecute the session.

In case of call transaction u have to store all the erroneous records into a bdc session by checking the sy-subrc value after call transaction statement. so that u can execute bdc session later by modifying the erroneous records.

Re: BDC Upload.

Former Member — Wed, 11 Apr 2007 10:08:45 GMT

Hi,

In session method by seeing SESSION LOG u can come to know how many records were failed.

In CAll transaction by using BDCMSGCOLL structure or FORMAT_MESSAGE function module(System generated messages) only u can come to know the errors.

IN Call TRansa If u got error in 1000 record ...remaing recors will update.

IN session..once u correct the session log then only the total records will update..means once the entire session process correctly then only the updation will takes place.

Kishore.

Re: BDC Upload.

Former Member — Wed, 11 Apr 2007 10:09:12 GMT

Hi,

for example you are doing upload of customer master using XD01.

10000 records are there.

in middle it stopped.

Check the records in KNA1 table , it will give the number of records gone.

if you are not able know by above methods.

then delete those records which are gone correctly from the file. keep the remaining and do upload again.

So care has to be taken properly to keep the correct data in the files, so that they will not cause problems.

reward if useful

regards,

ANJI

Re: BDC Upload.

Former Member — Wed, 11 Apr 2007 10:14:06 GMT

Hi ,

If it is call transaction and the problem is at 150th record, then is it possible to capture the error record only .. because in 10000 records it is very diffucult to find which is 150th record and agan how will we upload ?

Re: BDC Upload.

Former Member — Wed, 11 Apr 2007 11:33:21 GMT

Hi Satyanarayana,

In any BDC program before going for actual data upload I will prefer to run a simulation BDC in the same program and generate both error and success reports in notepad so that I can understand that how could have the BDC session performed if it was really executed. Hence while handling bulk set of data we should always run the BDC in simulation mode and moniter the result. This will help us to understand the nature of data and also the performance of the BDC program.

Regards

Pulokesh

Re: BDC Upload.

Former Member — Wed, 11 Apr 2007 19:33:12 GMT

What is Simulation BDC ?

Can You Give Sample Code for that one ?

Re: BDC Upload.

Former Member — Wed, 11 Apr 2007 19:48:07 GMT

Hi,

Check the following link:

http://sap-img.com/bdc.htm

regards,

bhaskar