Need to take input data from spredsheet to sales order quantity

[Former Member]

Hii,

As per my client requirement,

they mainatain there data in excel format,this excel format comes from external souces,

they comapile all the datas and make final excel sheets,

from this excel they take data and raise the bill against that,

so they want to use this excel sheet (not whole excel sheet but final data) to automatically taken into sales order quantity,

so pls tell me is there any interface between excel sheet to sap tables.

pls help me out.

[Former Member · Accepted solution]

Excel sheet has to be converted to text tab delimited and this file can be used for creating sale order using BAPI BAPI_SALESORDER_CREATEFROMDAT2.

Regards,

GSL.

[Former Member · Accepted solution]

Hii GSL,

As you mentioned BAPI_SALESORDER_CREATEFROMDAT2.is standard one?

And who will help on this functional or Developer?

[Former Member · Accepted solution]

Functional side spec has to be written regarding the data that should be used and from ABAP side coding has to be done.

Regards,

GSL.

[Former Member · Accepted solution]

Hii,

I found the bapi which you have mentioned,i will seat with the developer & develope abap program based on my requirement.

Is this work?

[Former Member · Accepted solution]

100% it will work as we have used this concept earlier.

Regards,

GSL.

[Former Member · Accepted solution]

hii,

One only query remiang that in the excel sheet,there are more data ,bt they enter only final total data thatis in summation of all so for thsi we have to convert whole excels sheet to text format???

and we have to check the BAPI program is it????

[Former Member · Accepted solution]

The excel sheet should have all values, especially the required fields like document type, sales area, customer number, material number, quantity etc.

Regards,

GSL.