TPG PSLink® is a worldwide leading middleware product for data exchange between PPM, ERP and other systems. It enables the bi-directional data exchange between Microsoft Project Server, SharePoint and many SAP modules. The product was first released more than 20 years ago. Since then, it has evolved and improved to meet industry best practices.
The integration of SAP with Microsoft Project, SharePoint and other systems is an essential factor contributing to the efficient use and acceptance of a project management solution. It ensures that staff – including project managers, team leaders and accountants – can work with the tool best suited to their job role and can always access relevant data from other systems. TPG PSLink provides multi-directional data exchange while ensuring the consistency of the data synchronized between the systems.
The Benefits of SAP Integration with Microsoft Project
TPG has a growing number of TPG PSLink® customers all over the world, ranging from small scale implementations to large global projects. What sets this integration middleware apart from other SAP integration solutions? In the past 20 years, the product has been used to manage tens of thousands of projects worth over $100 Billion dollars.
|SAP Module||Data Integration Type|
|Human Resources (HR) & CATS||- Resource Names|
- Resource Rates
- Time Entry
|Project Systems (PS)||- WBS Elements (WBS Milestones)|
- Networks (Activities, Elements, Milestones, Material Components)
|Plant Maintenance &|
Customer Service (PM & CS)
|- Functional Locations|
- Maintenance & Work Orders
- Work Scheduling Operations
- Work Centers
- Material Components
|Controlling (CO)||- Cost Elements|
- Cost Centers
- Profit Centers
- Internal Orders
- Functional Areas
- Activity Types
- Primary and Secondary Cost Planning
- Activity Allocation Documents
|Sales & Distribution (SD)||- Master Data|
- Sales Orders
- Billing Information
|Material Management (MM)||- Purchase Orders|
|Business Warehouse (BW)||- Remote execution of BW Queries|
|Project Portfolio Management (PPM)||- Projects|
- Phases, Tasks, Milestones, Checklists
One of the simplest use cases is to synchronize the top level of a project plan with SAP. This gives the controlling department a good overview, and the project manager still has a lot of freedom in planning the details in Microsoft PPM.
Depending on the requirements, it is possible to transfer any kind of structure from Microsoft PPM to SAP. In this case, country-specific tasks are transported in the second level. The transfer of further levels is possible at any time. Further aggregations via any structural characteristics or cost elements can also be configured.
As part of planning and updating the budget, it is a great help for project managers and controllers if the project data can be transferred according to the structures at the push of a button. In many companies, this has to be done monthly. The integration brings a correspondingly high ROI. This recurring benefit contributes a lot to the acceptance of an integration of Microsoft PPM with SAP.
In many companies, the actual hours worked on projects have to be billed either internally or externally. To do this, it is necessary to transfer these from the PPM system to SAP at the end of periods. In SAP, further allocation is then made to sales orders or internally between the performing and receiving cost centers. With the appropriate integration, this process can take place overnight at the end of each month. The integration provides a very high benefit thanks to fast and error-free data transfer.
If project managers also have to manage external costs in their projects, they will be happy about the automatic direct transfer of actual costs from SAP to their project. In this case, the incoming invoice values are transferred directly to the previously planned cost elements at task level in the PPM system. With this integration solution, it is possible to accelerate and simplify the communication process significantly. It ensures that project managers always have up-to-date cost information, which they urgently need to control their projects.
Importing large volumes of resource data from diverse systems into the Microsoft PPM Enterprise Resource Pool and updating this data continually is an important use case for integration. It enables reliable planning and assures the project manager that any plans made are always based on the latest data.
Data is shared cost-effectively and maintained with minimal effort. It also eliminates the additional risk of human error posed by manual duplication of the data.
“The Vaillant Group runs projects with mixed teams across various R&D sites. The correct distribution of actual work from the Microsoft PPM system into SAP company codes is handled by TPG PSLink automatically, in accordance with country specific accounting rules.The whole integrated system gives us a very deep level of insight that improves project management efficiency throughout the company.”
Jörn Fritsche, Project Manager R&D Support,
> Read whole Vaillant case study (PDF)
“By integrating Project Server with SAP using TPG PSLink, we were able to reduce the time needed for our regular budget planning from three man-weeks to one man-day.”
Helmut Kölbl, Sr. Program Manager,
> Read whole Harman case study (PDF)
“With their TPG PSLink product, TPG was able to implement all our SAP integration requirements down to the last detail.”
Dr. Klaus Schoepe, Senior Vice President Projects,
“We chose TPG for the excellent quality of their PSLink product but also due to PSLink’s very good cost-benefit ratio.”
Bill Courcha, Chairman of MAS Planning Monitoring and Control Working Group,
BAE British Aerospace
“The implementation of Microsoft Project Server and the TPG PSLink interface product has enabled us to create the right foundation for modern multi-project and resource management.”
Manuel Sachs, Project Planning Manager, BU Power Plants,
MAN Diesel & Turbo
“Lonza's new Microsoft Project Server solution with TPG PSLink for SAP integration and TPG ProjectLink for multi-project management enhancements has also made collaboration easier – especially between teams and across different projects.”
Peter Zenk, Project Leader Global EPM Implementation,
“With Project Server linked to SAP, we can gauge the financial success of projects, comparing actual with budgeted figures, and provide management with the ability to exert meaningful control.”
Jani Saarinen, Senior Manager in Research & Development,
“The TPG solution currently automates some of our manual tasks. TPG ProjectLink aggregates all our detailed Microsoft Project plans into one overall project plan. TPG PSLink then transfers its structure and deadlines to SAP. The cost and work planning data from the detailed plans are directly integrated with SAP via TPG PSLink. This combination of products has made everything easier for us.”
Reiner Schwarz, Project Planning,
Airbus Defence & Space
In May 2009, TPG PSLink® Version 2010 passed the first Custom Certification Test by SAP and obtained the title “SAP® Certified – Integration with SAP Applications”. The product was recertified three times, for the 2013, 2016 and 2019 Versions, each enhanced with additional use cases. TPG PSLink® 2019 passed the recertification in May 2019, which is valid until May 3, 2022.
The scenarios chosen for the test were not SAP standard scenarios but “Third Party Integration Scenarios”. A certification of standard interface scenarios is technically related to individual SAP modules or functional groups. Instead, the Custom Certification chosen by TPG specifies the relevant use cases from a business perspective and tests all the appropriate SAP functions across all applicable modules.
SAP specified 19 use cases for TPG PSLink with 50 BAPI functions, covering 5 SAP modules. This type of certification goes significantly deeper than the standard but covers exactly those scenarios which are relevant to our customers.
Overall, SAP has certified 19 use cases covering 50 SAP business functions, known as BAPIs. These include use cases for:
The product also underwent performance and stress tests to verify its resilience when sharing large data volumes between SAP and other systems. Find more details on this SAP page.
“We believed it was very important to include as many relevant use cases as possible,” comments Stavros Georgantzis, managing partner at TPG The Project Group. “Our customer implementations are extensive and oriented to project, resource and portfolio management processes. These require links to various SAP modules, including sales & distribution, materials management, controlling and human resources, among others. The traditional project system is usually also a part of that, although not always. The message we’re sending to our customers is that the entire range of relevant SAP integration points has been certified.”