Yes you can upload multiple Sales Orders from a single excel file. I have personally done this...
BDC involves recording the transaction & writing a ABAP code. Kindly ask your ABAP person to do the needful.
Also for basic information refer here (& subsequents links therein...)
Hope this helps. .
Yes you can create Sales Order thru Excel files thru BDC.
I was involved with a client who had 300 - 500 line items in each Sales Order. So we gave a excel format to them to fill in the Sales Order details.
Subsequently user called BDC T-Code & uploaded the Sales Order in system.
Kindly consult with your ABAP person & he can create a BDC for this...
Hope this helps.
U can use standard BAPI for this.
salesorder_createfromdat1 or salesorder_createfromdat2.Just ask ur ABAPER to use any of the above BAPI.
Multiple Sales orders each having multiple line items can be created from a single xls file.
But u need to work with ur ABAPER to fix the format & sequence in which data should be put in the xls file.
There is no "magic wand" for this. If you want to upload just a few orders - don't bother, type it by hand. If you need to do this regularly, suggest an investment in third-party software, such as Winshuttle (Transaction Shuttle). Custom development is also an option, of course, but that's another story.
There are 2 answers to your question
1- To do a recording without going to an ABAPer please run transaction SHDB and create a new recording , it will ask you to input the sales order transaction VA01 and follow the steps for 1 SO , after you have done that save the recording and run the same recording for all your SO's maintained in Excel in ONE run itself ,
2 - If you use the BAPI BAPI_SALESORDER_CREATEFROMDAT1 going to Xsaction SE37 it will ask you to input all your SO manually in the table which is tedious
I suggest you go for the Recording as mentioned in my point 1 , Let me know if this was useful .