I want to know if there exists any BAPI go about doing the following which I am able to achieve with BDC.
There exist set of rows in a excel file with close to 120 columns.
matno1 orderqty1 unit1.....matno2 orderqty2 unit2..so on till matno20 orderqty20 unit20.
There are few columns which i dont req when i upload them..i.e i may not req 'unit' column at all when i am creating a material from the excel file.
each line item in the excel file will result in creation 20 new materials when uploaded.