End-to-End Automated Testing with SAP Solution Manager 7.1 & Worksoft Certify® at Colgate-Palmolive Company
Colgate-Palmolive is a leading global consumer products company, tightly focused on Oral Care, Personal Care, Home Care and Pet Nutrition. Colgate sells its products in over 200 countries and territories around the world under such internationally recognized brand names as Colgate, Palmolive, Mennen, Softsoap, Irish Spring, Protex, Sorriso, Kolynos, Elmex, Tom’s of Maine, Ajax, Axion, Fabuloso, Soupline and Suavitel, as well as Hill’s Science Diet and Hill’s Prescription Diet. Colgate-Palmolive operates on an SAP infrastructure that includes ERP, CRM, BI and many other SAP applications and platforms. In addition, Solution Manager is extensively used to manage the SAP systems as part of the overall governance model.
The primary goal of the project was to validate an end-to-end testing framework that included impact analysis and test management components from SAP Solution Manager coupled with test automation provided by Worksoft Certify®
To achieve the project objectives, a set of end-to-end supply, demand and finance test processes were automated using Worksoft Certify. The automated tests were then integrated into the Solution Manager Business Blueprint hierarchy with testing scenarios that included:
- Running tests directly from the business blueprint
- Scheduling tests for lights out execution
- Using Business Process Change Analyzer (BPCA) to determine test scope for risk based test planning and execution
- Using automated test repair workflows to fix damaged tests
- Passing information about systems under test as well as test data between Solution Manager and Worksoft Certify using System Data Container (SDC) and Test Data Container (TDC)
All of the functionality defined above was to be configured and tested over a two week period. The two week period also included the time required to construct the automated tests for the representative end-to-end business processes, including the test data to be used in the tests.
Project Set Up
Figure 1 below shows the Solution Manager 7.1 and Worksoft Certify components that were used in the project.
The Solution Manager 7.1 system, in turn, was connected to ERP and CRM systems in which the actual automated tests were constructed and then executed using the various scenarios outlined in the project scope.
Figure 1: System components used in the project.
- Colgate-Palmolive: Governance Team & Global Shared Services Organization (GSSO) Analysts
- Worksoft: Professional Services Organization, Engineering Organization
The table below shows the end-to-end business processes that were automated using Worksoft Certify. As illustrated, Colgate-Palmolive achieved an average of more than 90% when test processes were run in an automated mode instead of executing them manually. Extrapolating these savings over a larger set of core business processes, as well as multiplying the savings by the number of times a given process is tested, would yield a compelling return on investment (ROI).
|Function||Processes||Transactions||Steps||Manual Test Time||Worksoft Automated Test Time||Savings|
|ChaRM||Creation of SM||Znotif create||32||20 min.||90 sec.||92.5%|
|ChaRM||Display of SM||Zmonitor||15||20 min.||45 sec.||98.25%|
|Demand||SO Create, Change, Credit Release, Delivery, Invoice||VA01, VA02, VKM3, VL01N, VF01||202||30 min.||4.5 min.||85%|
|FICO||Product Costing||OKKS, CK11N, CK24, CK13N, KP27, GR55, KKS5||116||25 min.||3.5 min.||86%|
|Supply||Purchase Order, Goods Receipt||ME21N, MIGO||72||30 min.||2.5 min.||91.6%|
In addition to creating and running the automated tests from Worksoft Certify, all of the complex scenarios that included Solution Manager 7.1 and Worksoft Certify were successfully executed. These scenarios included:
- Automating TBOM creation and maintenance using Worksoft Certify automated tests
- Running BPCA analysis and then executing automated tests based on its results
- Navigating to the tests and modifying them directly from Solution Manager
- Using System and Test Data Containers to pass information to Worksoft Certify from Solution Manager
- Scheduling automated tests for lights out execution
Warren Kaufman, Director at Colgate-Palmolive stated “We are very excited about the opportunity this presents to us in regards to expediting our application development lifecycle while providing cost savings. By integrating Worksoft Certify with SAP Solution Manager 7.1, we are able to leverage our existing investment in Solution Manager with the latest test automation technology.”
Colgate-Palmolive will construct a detailed corporate-wide ROI analysis based on the results of the project; expand to critical transactions in a single landscape to develop global best practices; and then roll out the solution across the organization.
Worksoft and Worksoft Certify are registered trademarks of Worksoft, Inc. All other trademarks and names are property of their respective owners.