The data file that will be used for input must have some kind of delimiter or separator. In most cases, you will find that comma-separated variable (.CSV) files are the best choice because they can be edited in Microsoft Excel.
Requires Free Membership to View
When you register, you will start receiving targeted emails from my award-winning team of editorial writers. Our goal is to keep you informed on the hottest topics and biggest challenges faced by SAP professionals today.
Hannah Smalltree, Editorial Director
However, they also can be edited with a text editor such as
Notepad. On the other hand, you can use a flat-file and a different field delimiter (e.g. the
pipeline symbol "|").
Remember, the important thing is to make sure the correct data is in the correct columns and in the correct order.
CSV file being edited in Excel.
Flat-file separated by the | symbol.
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