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.