Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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

Former Member
Not what you were looking for? View more on this topic or Ask a question