BAPI - upload data from excel files

[Former Member]

Dear all,

in our company the sales people are using excel files to make a quotation to a customer. They have an excel file where they give the list price of the vendor, the discount , the profit so as to get the final price for the quotation.

I was wondering which will be the best way so as to upload all the data from the excel files to SAP (Quotation and then sales order) so as to save time from them? Is it BAPI my solution?

[Former Member]

Hi,

Use the below FM to read the data from the excel file and please search the SDN for more details.

ALSM_EXCEL_TO_INTERNAL_TABLE

[Former Member]

@Stilianos :

You need to understand what BAPIs do.. bapis provide you a functionality to replicate some screenflow in SAP though abap code,.. in lay man language.. like you want to create a PO, you can do it either with transaction me23n or use bapi 'BAPI_PO_CREATE1' or something..

and for uploading files from excel, as given in above answers, please find sdn you will get 5-6 FMs here atleast to just to upload data from excel to internal table. after you upload to internal table you can use some BAPI to to create/chagne sales order,quotation etc using the uploaded data...

So, BAPI is not used for data uploading .. but to replocate sap functional flow in abap.