Skip to Content
0
Former Member
Dec 02, 2009 at 10:42 AM

bdc

109 Views

hi guys,

my question is,

how to capture dynamic excel sheet input using (bdc) batch data communication?

based this input perform some calculations and again send the output to excel sheet.

previously i tried transfer data from notepad to internal table using upload fm.

how to transfer dynamic input in excel sheet using bdc?

my requirement is.

i want to enter raw materials (which are fixed) based on this to get the product.

ex: product 1000 kg.(dynamic input in excel sheet)

raw material1 5.70(kg)

rawm2 7.0(kg)

1000*5.70 = ?

1000*7.0=? perform these calculations on abap program(se38) and send the output to again excel sheet.

i want steps doing this program immediately.

please help me.