Treasury reporting with SAP Analytics Cloud (SAC)
Use the integrated data management for optimal reporting
27.06.2025 ONLINE
21.11.2025 in Düsseldorf
Special knowledge
1 day
EUR 1.750,- plus VAT.
Content
The "SAC Treasury Reporting" seminar offers you a practice-oriented introduction to the creation of SAP Treasury Reporting with the help of SAP Analytics Cloud.
We start with an introduction to the world of data in SAP Treasury. We will first give you an overview of how data is stored in SAP in general and in the relevant treasury modules. The spectrum ranges from data storage for financial transactions and payment transactions to cash and liquidity management.
Based on data storage in SAP, we discuss possible variants of data extraction and how these can be transferred to SAC, depending on the use case. We then demonstrate the different variants of SAC data connections, including import methods, in order to discuss their advantages and disadvantages.
With the data now available in SAC, we will discuss the principles of sensible data modeling. To give you a better feel for the subject matter, you will build your own treasury data model in SAC directly during the seminar.
With the data model complete, it's time to create the report. Here, too, you can "lend a hand". We use the previously created treasury data model and create an initial treasury report. Our standard report forms and best practices from numerous treasury projects serve as a guide. Finally, we give you an insight into the world of SAC formulas and scripts so that you can add your own calculations directly in SAC.
We conclude the seminar day with typical implementation pitfalls and venture an outlook on your future treasury reporting.
Our SAP Treasury seminars are held in cooperation with MMG Treasury.
Main topics
Basics
- What are the tasks of the cash manager in the company?
- What are the minimum standards to be taken into account in the organizational structure & process organization?
- What are the differences in the accounting or treasury perspective? Which business management approaches do you need to understand?
- What are the requirements vis-à-vis banks?
- What are the current trends in cash management for large and small companies?
Treasury data management in SAP and data export
- Overview of data management in SAP
- Presentation of SAP table structures according to treasury modules
- Variants of data extraction
Data import into SAC
- Options for connecting SAP systems to SAC
- Integration of treasury data via data import
- Integration of third-party tools via API
- Advantages and disadvantages of using SAP Standard
Create treasury data model in SAC
- Basics of data modeling in SAP
- Joint development of a treasury data model
- Optimization of the data model for efficient reporting
-
Create treasury reporting in SAC
- Introduction to the principles of reporting in SAC
- Joint development of our own treasury reporting system
- Data actions, scripting and formulas in SAC
- Best Practice Reporting
-
Currency translation in treasury reporting
- Understanding currency conversion in SAP
- Performing currency conversions for analyses and reports
- Consideration of exchange rates and conversion factors
Group of participants
Employees and managers from the Treasury department who are interested in the possibilities that SAP offers in the area of reporting.
Targets
Participants will learn about the application possibilities of SAP in the area of treasury reporting and see some practical examples of meaningful treasury reporting with SAP Analytics Cloud.