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.
AUTOMATING LINE-ITEM DATA ENTRY VIA SAPGUI
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