on 05-17-2010 7:51 AM
Dear all,
I am using SAP ECC 6.0.
Could you pls tell me how can I import Sales Order from Excel file?
Thank you very much for your help!
CH.
Hi ,
If you are trying to create a sales order from the excel file you need to use uploading programs.
You have to take help from your tech team and develop a BDC to create a sales order form excel file.
Regards,
Krishna O
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Friend,
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. .
Thanks,
Jignesh mehta
Dear Friend,
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.
Thanks,
Jignesh Mehta
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
This message was moderated.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Cao
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 .
Regards
Sim
Hi Cao,
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.
regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.