10-11-2006 11:31 AM
Hi
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
10-11-2006 11:39 AM
Hi,
construct an error-process:
1) use call transaction Z123 messages into mtab...
2)
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
A.
Message was edited by: Andreas Mann
10-11-2006 11:39 AM
Hi,
construct an error-process:
1) use call transaction Z123 messages into mtab...
2)
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
A.
Message was edited by: Andreas Mann
10-11-2006 11:45 AM
Hi
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
10-11-2006 12:20 PM
hi
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^
10-11-2006 12:25 PM
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,
10-11-2006 1:20 PM
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.