7 Replies Latest reply: May 18, 2010 11:45 AM by Simran A RSS

Import Sales Order from Excel file

Huy Cao
Currently Being Moderated

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.

  • Re: Import Sales Order from Excel file
    krishna kant oza
    Currently Being Moderated

    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

  • Re: Import Sales Order from Excel file
    Jignesh Mehta
    Currently Being Moderated

    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

  • Re: Import Sales Order from Excel file
    Anurag Gupta
    Currently Being Moderated

    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

  • Re: Import Sales Order from Excel file
    Jelena Perfiljeva
    Currently Being Moderated

    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.

    • Re: Import Sales Order from Excel file
      Simran A
      Currently Being Moderated

      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

Actions