Real-Time Automated Cash Flow Management for CPI Property Group Using SAP Datasphere and SAP Analytics Cloud

Using SAP Datasphere and SAP Analytics Cloud, we enabled CPI Property Group to build a real-time liquidity management platform based on the direct method. The solution automatically classifies cash flow positions and identifies links between bank transactions and accounting documents across the group’s hybrid IT landscape, providing a unified foundation for operational cash flow management.

A Solution for a Complex Hybrid IT Landscape

CPI Property Group, one of Europe’s leading commercial real estate companies, operates an extensive portfolio of entities across the continent. While SAP S/4HANA Cloud Public Edition serves as the group’s primary transactional ERP system, the holding structure also includes numerous companies running on non-SAP ERP solutions. This creates a complex hybrid IT landscape for financial reporting and liquidity management.

To support treasury operations and investment management effectively, CPI Property Group required a level of analytical detail that standard transactional systems do not provide out of the box.

Challenges

The key challenge was assigning cash flow positions based on a unique combination of parameters, including G/L account, material, project type, and loan type.

However, bank payment documents often lack links to the original business attributes—such as the specific WBS element of a CAPEX project. As a result, when bank transactions were matched with accounting records, valuable analytical detail was frequently lost.

Solution

To address this challenge, we developed an Advanced Derivation Engine in SAP Datasphere. This custom-built logic automatically assigns cash flow positions based on predefined combinations of G/L accounts, projects, and materials.

The solution also incorporates Multi-level Matching (Levels 1–10), an intelligent algorithm that identifies relationships between bank transactions and the original accounting documents across multiple matching levels, restoring the analytical context that would otherwise be lost.

In addition, bulk payments are automatically broken down into their underlying business items using split and VAT allocation logic, including the calculation of VAT components. This provides the customer with a clean and accurate view of liquidity.

The results are delivered through interactive reports in SAP Analytics Cloud, allowing users to dynamically switch reporting hierarchies and perform detailed drill-down analyses, from consolidated figures down to individual payment documents with full traceability back to the original invoice.

Business Benefits

The new solution provides CPI Property Group with complete transparency into actual cash flows and enables users to trace the origin of every payment.

It also delivers detailed visibility into cash flows related to CAPEX projects through links to WBS elements and project types, while clearly identifying transactions associated with financing activities.

At the same time, the solution eliminates manual data consolidation in Excel and significantly reduces the effort required to trace and reconcile payments within the accounting system.

The architecture has been designed for scalability, enabling newly acquired companies or rollout entities to be connected quickly and efficiently. It is therefore well prepared for future expansion into additional regions, as well as for the planned adoption of machine learning to forecast cash flows based on historical payment patterns.

You can find details about the project in this PDF document.

About CPI Property Group a.s.

CPI Property Group is a leading European real estate group focused on long-term investment, management, and development of properties. Its portfolio primarily includes office, residential, and retail assets located in key Central European cities, particularly in Germany, the Czech Republic, and other countries in the region.

The group manages a large and diversified real estate portfolio with a strong emphasis on stable returns and sustainable growth. Supported by a strong capital base, strategic management, and deep local expertise, CPI Property Group ranks among the most significant players in the European real estate sector and continues to expand its presence across the continent.