Don’t Waste Time in Testing Cycles – Automate SAP Testing with Winshuttle
By Monika Pletschke on Aug 4, 2015
How efficient is regression testing in your organization?
Due to their integrated and global nature, SAP environments require time-consuming SAP testing cycles with each major change, whether it be through a service pack upgrade, a rollout, consolidation or introduction of new functionality. This often adds an unwelcome workload to each of the functional areas, as manual testing is tedious and cumbersome.
Did you know that Winshuttle can automate these test cycles?
A test is essentially the execution of a transaction using a set of test data against a specific SAP instance. A test case can be represented in Winshuttle as an Excel template containing test data and an embedded transaction script that is executed using the provided test data.
The Excel spreadsheet above represents a unit test case for creating a purchase order. A Winshuttle Script is embedded into the spreadsheet, and executes transaction ME21N at the click of the Run button.
The results of the test are automatically recorded and written in Excel, as illustrated above. Once executed, this data file containing the results can be stored as proof of a successful test. After a Winshuttle test case is created, it can be repeated as often as required, using the Run button.
It’s possible to build an integration test string utilizing this same concept by chaining together scripts and their test data. In the following example, a spreadsheet is created with three tabs for a purchase order (ME21N), a goods receipt (MIGO) and a logistics invoice verification (MIRO).
Additional ideas that have been implemented to improve the users’ experience and testing efficiency include:
- The reference data needed for subsequent transactions is copied from the Purchase order to the Goods Receipt and Invoice tabs. The purchase order number created in the first step is copied into the goods receipt.
- Oftentimes there are discrepancies with master data between SAP systems; to overcome this, the test case provides a Vendor and Material look-up which can be refreshed from the desired SAP system via a Winshuttle Query directly into Excel.
- Excel data validation functionality has been provided in various fields.
I was able to create the above example in a matter of hours, without programming or even using LSMW. The test can now be executed by our end-users directly from Excel much faster than ever before. Our test manager will have a record of all the tests run and the test results. The next SAP regression test cycle should be a breeze…
About the author
Monika is an experienced IT professional, with more than 20 years in roles ranging from SAP consulting (MM), system analysis and design, solution architecture, integration management and project management. She has worked internationally across multiple industries including automotive, manufacturing, chemicals, energy, telecom, public sector, textiles and tertiary education. As principal solution engineer with Winshuttle since November 2013, she has presented at roadshows, webinars and user group meetings, created tailor-made product demonstrations, contributed to Winshuttle collateral, written proposals and estimated projects. She enjoys the wide range of activities working for a dynamic and growing software company and the wide exposure to diverse business challenges encountered by Winshuttle’s customers.
Questions or comments about this article?
Tweet @Winshuttle to continue the conversation!