topic Re: batch input bdc uploading first row only in Application Development and Automation Discussions

batch input bdc uploading first row only

Former Member — Wed, 26 Nov 2008 16:22:03 GMT

hi,

i am working on a batch input bdc .when i am executing it and starting the session in sm35,there is no error log but only the first record of the flat file is getting uploaded and other records of the file are not uploaded.

what can be the reason....

Re: batch input bdc uploading first row only

BH2408 — Wed, 26 Nov 2008 16:24:39 GMT

Hi ,

Could you please provide the some sort of code.

Regards,

Bharani

Re: batch input bdc uploading first row only

Former Member — Wed, 26 Nov 2008 16:58:43 GMT

Check the Loop you are passing to the subroutines in the BDC program. I think you are not refreshing the BDCdata table..because of which only one record is getting uploaded. Refresh the BDCdata table.

Vishwa.

Re: batch input bdc uploading first row only

Former Member — Thu, 27 Nov 2008 05:58:06 GMT

Hi Mani kant,

Please check the loop, i think u have to end the loop at last itseems..

if u can provide code that will help to find the problem.

Regards,

Sudhakar Reddy.A

Re: batch input bdc uploading first row only

Former Member — Thu, 27 Nov 2008 06:06:20 GMT

hi,

i check the bdcdata table all the records of the flat file are in that table.

what can be reason.

Re: batch input bdc uploading first row only

Former Member — Thu, 27 Nov 2008 07:12:01 GMT

Hi ,

Please check the loop .

Regards,

Sudhakar Reddy.A

Re: batch input bdc uploading first row only

Former Member — Thu, 27 Nov 2008 07:12:46 GMT

first record of the flat file is geting sucess to uploaded and rest of thing not uploaded , once u can check flat file text format like tabular, do modifaction in template, or else send u r sort of code .

use in function module "format_message" .

Re: batch input bdc uploading first row only

Former Member — Thu, 27 Nov 2008 08:35:03 GMT

hai..

vishwa has given the solution for your problem.

after the call transaction stmt..

refresh your <bdcdata> table, that might be the only problem with your code.

Regards..

Sekhar

Re: batch input bdc uploading first row only

Former Member — Thu, 27 Nov 2008 08:59:15 GMT

hi,

i am working on session method and not call transaction.

before calling the function module BDC_INSERT,i have checked the BDCDATA table and it contains all the data as per the recording of the data.

Re: batch input bdc uploading first row only

Former Member — Thu, 27 Nov 2008 10:47:05 GMT

Dear Mani,

in the loop u give write statement. see wather data is coming into internal table or not.

Coment the code & give the write stse in loop.

if it's fine check weather u REFRESH internal Table !!!!

Best Regards,

Flavya

Re: batch input bdc uploading first row only

Former Member — Fri, 28 Nov 2008 06:57:45 GMT

hi ppl,

i had gone through the recording what is happening that after clicking on save the initial screen of that tcode is not coming .

is it so,that after save the initial screen should appear.

Re: batch input bdc uploading first row only

Former Member — Fri, 28 Nov 2008 07:01:32 GMT

After BDC_INSERT fm refresh the BDCDATA table.

CALL FUNCTION 'BDC_INSERT'

EXPORTING

tcode = c_pa30

TABLES

dynprotab = i_bdc_data.

refresh i_bdc_data.

Re: batch input bdc uploading first row only

Former Member — Fri, 28 Nov 2008 07:37:31 GMT

hi avinash,

i am working on session method first time.

the bdc is working fine with call transaction method .in call transaction after calling the tcode ,i am refreshing the table bdcdata and its working fine as in case of call transaction every record is uploaded individually by call transaction.

but in case of session method , i will be creating a session and then schduling it ,so do i need to refresh the bdcdata table after bdc_insert ,con in session method batch input of data takes place.

correct me if i am wrong.

Re: batch input bdc uploading first row only

Former Member — Fri, 28 Nov 2008 08:41:29 GMT

Yes, you have to refresh after the BDC_instert FM. Only then all the records in the session will be processed. Because it is running a loop...only one record is in the bdcdata at a time. If you dont refresh it..then new data wont get into the table.

SO, after BDC_insert..give "REfresh it_bdcdata" , i.e the internal table of the bdcdata.

VIshwa.

P.S: When so many members are giving similar solution, you should first try them out and then come back. Without trying it, there is no point in posting a thread here. Implement the suggestions given here.

Re: batch input bdc uploading first row only

Former Member — Fri, 28 Nov 2008 09:34:24 GMT

hi,

thanks a lot.