Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

BAPI - upload data from excel files

Former Member

‎2010 Apr 27 3:22 PM

1,719

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?

2 REPLIES 2
Read only

Former Member

‎2010 Apr 27 3:45 PM

0 Likes
751

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

Read only

Former Member

‎2010 Apr 27 3:50 PM

0 Likes
751

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