topic Re: reg. bdc in Application Development and Automation Discussions

reg. bdc

Former Member — Wed, 11 Oct 2006 10:31:24 GMT

ive a issue reg. bdc

suppose, 1000 records are there in flat file to upload in to R/3.

in these, there are 200 error records, not in a order.. which are not uploaded

i need to upload 1000 records successfully..

can anybody please let me know..the procedure(either session or call tran. method), how we do

thanks in advance

raghavendra rao G

Re: reg. bdc

andreas_mann3 — Wed, 11 Oct 2006 10:39:58 GMT

Hi,

construct an error-process:

1) use call transaction Z123 messages into mtab...

if sy-subrc <> 0.
    append itab to errtab. "or transfer itab to errfile
   endif.

3) analyse errors, create a new file and start your report again

Message was edited by: Andreas Mann

Re: reg. bdc

Former Member — Wed, 11 Oct 2006 10:45:55 GMT

If you want to load all records once, you can't do it, because you can know the errors only after trying to load them.

So if you use CALL TRANSACTION method, you should create a BI session when CALL TRANSACTION fails, if you use the SESSION method there's no problem.

Infact in both ways you can have the session with all records not loaded and analyze it and run it manually again.

Now the problem can be if a large number of records raises errors, infact it could be hard to run the error session manualy, in this case you should generate a new file with only wrong records, correct the file and elaborate it.

I don't know which can be the best solution for you because it depend on your situations.

Max

Re: reg. bdc

Former Member — Wed, 11 Oct 2006 11:20:19 GMT

good

as per your requirement you want to upload both the error records and the correct records also, try to do the two test recordings using the correct data and the wrong data, if the recording is accepting both the dataes than there wont be any problem wheather you r using the BDC Session or CALL TRANSACTIONS. If your any of the test recordings giving you any kind of error , than dont think any of the method ll help you to get your result.

thanks

mrutyun^

Re: reg. bdc

shishupalreddy — Wed, 11 Oct 2006 11:25:30 GMT

Hi ,

It may be call transaction or session method

Check sy-subrc value if it is not equal to zero then append the record to internal table .

at last down the internal table to a file and modify them now again process the records which ever themethod is suitable for your requirement .

regards,

Re: reg. bdc

Former Member — Wed, 11 Oct 2006 12:20:34 GMT

Hi,

Use call transaction method to process all records.

Check sy-subrc, if it is not 0 send it in session method and u have to process the session manually in error mode.