batch input bdc uploading first row only

[Former Member]

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....

[P561888]

Hi ,

Could you please provide the some sort of code.

Regards,

Bharani

[Former Member]

Hi

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.

[Former Member]

hi,

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

what can be reason.

[Former Member]

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

[Former Member]

Hi ,

Please check the loop .

Regards,

Sudhakar Reddy.A

[Former Member]

Hi

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" .

[Former Member]

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

[Former Member]

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.

[Former Member]

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

[Former Member]

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.

[Former Member]

HI

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.

[Former Member]

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.

[Former Member]

Hi

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.

[Former Member]

hi,

thanks a lot.