Skip to Content
avatar image
Former Member

Upload Sales order item from excel to SAP in VA01 thru frontend

Hi,

I am a front end user.

SAP version 710.

we enter sales order thru frontend in VA01 in SAP. The data is stored in excel.

Currently the following is performed.

Open VA01. In transaction entry screen ,

Copy from Excel & Paste In SAP the following

SAPID of the Customer

PO No.

PO Date

Then copy and paste the line items from excel block by block i.e. depending on no. of line items seen in SAP per screen, copy that many lines from excel and Paste in SAP.

Then select next block and

SAVE the order.

In excel there are many orders of different customers.

I know litte bit of VBA.

Can this be automated somehow.

Pl. help.

Thanks

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Jan 04, 2011 at 07:28 AM

    Hi Suhas,

    to automate the work in the SAP, it requires e.g. SAP GUI Scripting.

    1. Please check whether your client is allowed to SAP GUI Scripting. (ALT / F12 -> Options -> Scripting -> Enable Scripting)

    2. There should be only an indicator for Enable Scripting.

    3.The other two indicators by Notify When ... should be inactive.

    4.You would then be able to record a SAP GUI script. (ALT / F12 -> Script Recording and Playback... -> red dot)

    5.Please record all that to what you have to do it manually for first record in Excel.

    6.Stop recording (record and playback -> yellow dot)

    7.Please then present the results here in the forum for your script.

    8.Present us also your Excel sheet with some rows.

    Unfortunately I have no access to the VA01 transaction. But you can already read a lot in advance on the following link.:

    transferring-data-from-excel-to-sap

    Regards,

    ScriptMan

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 06, 2011 at 06:04 PM

    HI

    you can use BDC methodoligies like session method or call transaction to upload the data.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 10, 2011 at 02:31 PM

    Hi Suhas,

    You could do this with SAP tools like LSMW or eCATT which let you record the VA01 and then upload from CSV file formatted in the right way.

    There are some third-party tools that specialize in that. For example, take a look at [Winshuttle|http://www.winshuttle.com] which is more flexible and where there is even an Excel add-in to upload the Sales Order from Excel to SAP.

    Hope this helps.

    Vikram

    Add comment
    10|10000 characters needed characters exceeded