SAP GUI Scripting - Order Creation from Excel

This video provides and example of creating and order in VA01 from data stored in Excel. This is only a simple process to get the most important field of order populated, you most certainly need to enhance it to your needs.

GUI scripting allows external applications like MS Excel to connect to an existing GUI session and execute operations within the GUI. Excel does not hold and authorization and access information as it relies on you logging into SAP first.

Download the Excel file in this example from here:

All my GUI scripting files on Github (in case you cannot access the above link):

[enochhepworth]

This is a fantastic resource! Thank you so much for sharing. I only wish I'd found this video before this weekend, I just finished writing my own version of this

[AmelyHAN]

Hi Csongor, I just replicate the process and created VBA to release work orders in CO40 and CO01.. Thank you. And thanks to other comments to help me figure out the system value.

[krzysztofdabkowski]

Useful as always, I made few nice scripts in workplace thanks to your movies, many thanks ;)

[highestpoint]

well done. easy to interprete and learn from. Thank You

[riccardolore]

Hi Csongor,
I have adapted your code to my need for transaction VA01, however, I can't figure out how to go beyond 17 product lines.
When I get to the seventeenth, it just goes to the top and comes back up, like a keyboard "page down".
How could I modify the code for this need? I would have to enter orders of even 500 rows.
Thank you very much because your code has been very helpful

[Aladdin]

Hi I need help Urgently and I would really appreciate it I'm having issues with scrolling through the table to add new items while creating orders and adding items through va02 is there a way to fix this
for further clarification I have 7 available tabs or blanks to insert the material code and quantity after they are done I can not scroll down to continue adding the other items and as a result I get an
error I would appreciate your help

[katenguyen]

This video is really...really helpful for users. Thanks a lot for that. Is it possible to get you to make another video of Delivery Order Creation?

[finndethleff]

Hello Csongor, where to I find the name of the system to connect to? ("DEG210" in your case)I keep getting the error message "No active session to system XXX".Many thanks in advance!

[grivers]

Csongor, awesome stuff mate ....!Greg

[royalknight]

Can u teach on ima11 tcode... I got some error over there... I don't have basic in scripting but I still learning

[masca]

Great Job @Csongor Varga.. Didn't thought that it's possible. Tried to do it and it works fine for some orders. On others i have issues with the credit limit popup and availability control screen. Do you know how I could solve them? How can I check if the credit limit popup showes up and if the availability control window opens... Thanks a lot

[sahilhala]

Hello Cna you also advise if we cna create multiple order by this, like put all sold and ship to and running the script ones and SAP wil create all orders ? like in bulk

[sebastianvaazquez]

Hello Csongor thank you for your great video! im new making this combination of scripting and VBA and i have some doubs hope you can help me with this. 1 i put my system value but it still says : "No active session to system QAT9200, or scriptiong is not enabled". The i click "ok" and it says O bject variable or with blocj variable not set ( i have my SAP GUI Scripting API enabled and the recording scripting on)
2. the script that you uploas on your drive thoes it only works with two line items?

THANK YOU VERY VERY MUCH FOR YOUR ATTENTION AND YOUR INCREDIBLE VIDEOS

[mohammadsuheb.l]

How to set date from - to in excel and what's the code i have to add ?

[alteavanloggerenberg]

We actually encounter the credit limit error on a regular basis. We would then need to get credit limit approval from senior management, who then approve the sales order using the sales order # and then we would be able to proceed to the next step. The "On Error Resume Next" will work in this case, but we would then require a notification in the excel script stating "Credit Approval Required" so that staff know to request the approval.

[henriqueproglhof]

Great video once again. I've started watching your videos last month and it helped me a lot in my day to day tasks!
I am curious to know more about you and your career. Any videos where you talk about your personal and professional experience related to programming and opportunities there may be for us who are interested in sap gui scripting?

[andrescarphio]

Great Videos...is there possible to create a excel macro to create a PR(purchase requisiton) in SAP.

[Kashi_Gujjar_]

I want to update SAP data from excel file for tcode MSC2N where I want to update the data for certain material/batches.
I created file to Update MSC2N, but this is for one defined value only and not from excel
Can you please to create excel which can pick data and update MSC2N like Date of Manufacturing, shelf life, vendor batch, country of origin

[adilshaikh]

Hi Csongor, What if I want to add a product ID in the same T-code where some of the had already written. Basically I want to count the number of rows which has product Id in Sap already and to add this new ID from Excel to the last row....

[alteavanloggerenberg]

Hi, I have managed to get the code to work for my application on multiple line uploads. Thanks this is a great start and help.

We have to additional steps on the material code upload, which is availability check and pricing upload per line item. I have two options that I'm currently trying, 1. single line selection and then price input, after each line. 2. Complete all line uploads, select ALL and input pricing then. In both scenario's I'm hitting a wall that I'm unable to navigate. Can you possbly assist with this part? This also has another problem in the cell text format that inputs the value with comma and not dot (SAP does take comma and I cannot change the format in the cell), not sure how to navigate this issue as well. Any assistance would be greatly appreciated.