Step 6: Automate the VBS script creation

Hate manual data entry work? How about a typing in a few hundred line items in purchase orders with descriptions like "BOWMA-TORQ HX HD CAP SCR 1/2-13X1-1/2"? If the items do not exist as material numbers, you have no choice but to type their description by hand ... Except, of course, if you automate it with a smart SAPGUI script. Veteran Basis guru Giovanni Davila walks you through the process in this handy step-by-step guide. This is part 6.

Now, it's time to automate the creation of the VBS script itself.
A new script will be created for every P.O.
We need to read the line-item data file and make a VBS script that the user can execute.
Every user needs to upload the data and, in turn, generate a VBS script.

I wrote the ABAP program found in this article to address this specific need. The program reads an input [line-item] data file from the user's PC and it converts it into a VBS script. The program prompts the user for the filenames, the field delimiter and the number of maximum visible line items.

As mentioned earlier, the number of visible line items plays an important role in the script generation.

The program is designed to accept a minimum of two visible line items and a maximum of five. Remember that this value is dependent on the user's screen and video resolution.

CLICK HERE TO VIEW THE ABAP PROGRAM.


AUTOMATING LINE-ITEM DATA ENTRY VIA SAPGUI

 Home: Introduction
 Step 1: Setting the stage
 Step 2: Activating SAPGUI scripting
 Step 3: Preparing the input data file
 Step 4: Recording the data entry
 Step 5: Analyzing the VBS script
  Step 6: Automating the VBS script creation
 Step 7: Running the VBS script program generator
 Step 8: Playing the VBS script to enter the line items
 Step 9: Troubleshooting
 Review: Conclusion and more resources
This was first published in August 2005

Dig deeper on SAPscript and Smart Forms

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

SearchManufacturingERP

SearchOracle

SearchDataManagement

SearchAWS

SearchBusinessAnalytics

SearchCRM

SearchContentManagement

SearchFinancialApplications

Close