Automating line-item data entry for purchase orders via SAPGUI scripting

Maybe you've been copying and pasting to save some typing. But, wouldn't it be better to have the computer read the data from a source file and enter it for you? Just picture the computer enter item by item with all their respective data while you do something more productive, or talk on the phone, or just sit down and relax for a bit.

You can increase your productivity and save yourself from a lot of typing by using SAPGUI scripting. That's right! SAPGUI scripting comes in handy when you're thinking about automation. It's a great tool to emulate user interaction, enter data and perform repetitive tasks. The best part of all: SAPGUI scripting is free -- it comes with SAPGUI for Windows -- powerful and easy to use.

In this article, I will show you how to put SAPGUI scripting to work for you. For demonstration purposes, I will present you with a recent assignment I took on to help my users enter more than a hundred purchase-order line items in just a few minutes. No joke -- read on and I'll show you how it's done!

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

ABOUT THE AUTHOR:

Giovanni Davila, technical author and SAP Basis expert Giovanni Davila is an expert in SAP administration on the Windows platform. He has authored the critically-acclaimed books "SAP Basis Administration" and "SAP Basis Administration for Windows". He also wrote an article for the SAP Professional Journal titled "System Database Copies – Made Easy". Copyright 2005 TechTarget

Digg This!     StumbleUpon     Del.icio.us

RELATED CONTENT SAPscript and Smart Forms Modifying standard SAP Smart Forms for purchase orders How to solve output alignment problems with SAPscript printing Using SAP Smart Forms to change layout of Plant Maintenance How to fix Smart Forms printing double purchase orders Deriving the name of a Smart Style from a Smart Form SAP administration information for a Basis interview Transferring R/3 Admin skills to SAP NetWeaver Easier maintenance of output types, procedures, conditions, etc. Avoid printing out blank address lines in SAP Smart Forms Setting soft breakpoints in ABAP that reside in Smart Forms SAPscript and Smart Forms Research SAP Basis administration and NetWeaver administration Seven tips for simplifying SAP data archiving administration Using up-to-date SAP ABAP codes in SAP ECC 6.0 Migrating SAP Solution Manager system between Unix platforms SAP talent management FAQ: Fresh answers to frequently asked questions Collaboration a must for SAP hardware teams and software teams How to establish communication between SAP Unicode and non-Unicode systems Mission-critical SAP software demands a mission-critical hardware infrastructure In an upgrade to SAP ECC 6.0, when do integrated apps get upgraded? NetWeaver PI 7.1 easier to implement than earlier versions, SAP says SAP Software Deployment Manager vs. Java Support Package Manager SAP Basis administration and NetWeaver administration Research

RELATED GLOSSARY TERMS Terms from Whatis.com − the technology online dictionary Basis  (SearchSAP.com)

RELATED RESOURCES 2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems Search Bitpipe.com for the latest white papers and business webcasts Whatis.com, the online computer dictionary